Moving MySQL Databases
When you move MySQL databases as described here, make sure you don’t move the ib_ files, but also make sure to move the ib files, like ibdata1. Also, move the mysql subdirectory into the new location. Just did this – worked great. Now I have RAID5’d databases. I was doing this to convert an SQLite version of my Amarok database to a MySQL implementation. cd ~/.kde/share/apps/amarok && sqlite3 collection.db .dump | grep -v “COMMIT;” | grep -v “BEGIN TRANSACTION;” | [...]
