migrating databases

CloudedVision · Apr 2nd, 2008, 00:41

i need to migrate a database from my local machine to my server. Only problem is that the MySQL migration thing only transfers the rows, not the tables. How do I migrate the tables. (Rows don't matter, I don't have any anyways)

saltedm8 · Apr 2nd, 2008, 01:27

http://www.mysql.com/products/tools/migration-toolkit/,

i think you need to sign up to get it, but it should be what you are after

CloudedVision · Apr 2nd, 2008, 02:37

thats what i was using, but for some reason it tries dropping all the tables on the target that are supposed to be migrated to the target machine. Since the tables don't yet exists on the target machine, it gets errors for all of them.

Any reason why?

CloudedVision · Apr 2nd, 2008, 22:55

figured out what was wrong. i was on a shared server so all the databases had to start with the prefix "otherroad_"

So after trying to find MySQL query browser's seemingly nonexistant rename database feature, I google, got some quick and dirty method that completely erased my data. After recovering it, I finally created the correctly named database and did a mysql dump via command line to the new database. Then I was able to successfully migrate the database.

All that work for a couple of tables.