Re: transferring mysql database

Thanks for all the replies, I didn't realize that it was this easy. Sorry, I also didn't realize that there was a mysql list - I'll be sure to post there next time. Thanks again! -Doug Jon Haworth wrote:

Hi Doug,

was wondering if it were possible to transfer a mysql database setup on one server to another without having to re-setup all the entire database. if so, how?

Dump the schema of the database to a file, and then import it on the new server. If you use phpMyAdmin, there are built-in features for doing this. I can't remember offhand what the actual query is to get MySQL to show the schema, but I'm sure someone on the MySQL list would know (hint, hint) Cheers Jon