MySQL migrate DB

Typically when I migrate a database, I just copy the enitre thing over to the proper directory. The dreamhost database system seems pretty convoluted. Does anyone know if this is possible or have any suggestions on how to migrate existing data over? Thanks!

> Typically when I migrate a database, I just copy the enitre thing over to
> the proper directory. The dreamhost database system seems pretty
> convoluted. Does anyone know if this is possible or have any suggestions
> on how to migrate existing data over? Thanks!

Our system is actually pretty typical for a shared hosting setup, really. It sounds like you may be more used to having your own server, or having access to dedicated hardware. We can't allow customers to have direct access to MySQL data files as they are A) shared between customers, meaning that you'd have access to other peoples' files too and B) are on another server entirely (one that is dedicated to nothing else other than serving MySQL databases).

Probably what you want to do is export your existing database using 'mysqldump' and then re-import it.

http://dev.mysql.com/doc/mysql/en/mysqldump.html

Be sure to supply the '-h' flag and your database hostname. A common error occurs when people don't do this and end up attempting to connect to a database server on the same machine that doesn't exist.

- Jeff @ DreamHost
- DH Discussion Forum AdminEdited by Jeff @ DreamHost on 06/28/05 02:22 PM (server time).

Thanks for the info Jeff! I'll try it out soon. You support guys rock!