Current time: 04-24-2014, 06:33 AM Hello There, Guest! (LoginRegister)

Post Reply 
MySQL migrate DB
06-28-2005, 01:40 PM
Post: #1
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!
Find all posts by this user
Quote this message in a reply
06-28-2005, 02:21 PM
Post: #2
MySQL migrate DB
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
Visit this user's website Find all posts by this user
Quote this message in a reply
06-28-2005, 08:36 PM
Post: #3
MySQL migrate DB
Thanks for the info Jeff! I'll try it out soon. You support guys rock!
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump: