Moving Database

[ixora]

I have a Message Board (Vanilla) on a website which is moving to another host.

What is involved in moving the data base to the new server? When I installed Vanilla there were several details, paths etc.. that are particular to the current host. Does the Message Board have to be reinstalled but with the data base already in place?

[Phill Pafford]

is the host moving or are you moving to a new host?

[chazzy]

as long as you keep most of the database configuration the same, it should be as simple as exporting the current data and then importing to the new host. there are many tools around to help with this, and more likely than not your host has provided you with one (such as phpmyadmin for mysql).

of course, this can't account for changes in the host string, database users, etc.

[ixora]

I must move the website to a new host. The current host is not responding by email or phone or help desk to any issues. Scary. I have a good relationship with GoDaddy and will persuade my "client" go there.

Yes, the current host via c-panel provides "phpmyadmin for mysql" and I have used php/mysql on another occasion (very basic and small.). But this database is not one of my creation. I can see it but I don't understand what I am looking at.

Chazzy says: "of course, this can't account for changes in the host string, database users, etc. " How would I do this? Even if I manage to "export/import" ... meaningless phrases with no concrete images? I'm way over my head.

[chazzy]

i really can't say much other than to make sure you test your new site thoroughly before you make the switch over so that the changes are seamless.