DreamHost Forum
MySQL migrate DB - Printable Version

+- DreamHost Forum (https://discussion.dreamhost.com)
+-- Forum: Web Development (/forum-18.html)
+--- Forum: Software Development (/forum-3.html)
+--- Thread: MySQL migrate DB (/thread-26290.html)



MySQL migrate DB - eneries - 06-28-2005 01:40 PM

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!


MySQL migrate DB - Jeff @ DreamHost - 06-28-2005 02:21 PM

Quote: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 Admin


MySQL migrate DB - eneries - 06-28-2005 08:36 PM

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