GoFuckYourself.com - Adult Webmaster Forum - View Single Post - Moving MySQL DBs from one server to another

Babaganoosh · 10-01-2002, 11:40 AM

It depends on the size of your DB. If you have a DB that is small, you may be able to use phpMyAdmin to move the database. Otherwise, you can use phpMyAdmin to export the data (save it as a file), FTP the .sql file to the new server, then log in to the new server and type

/path/to/bin/mysql -u $mysqlusername -p$mysqlpassword $mysqldatabasename < $file.sql

I have done it a few zillion times so if you need some help, drop me a line and I will see what I can do.

10-01-2002, 11:40 AM
Babaganoosh ♥♥♥ Likes Hugs ♥♥♥ Industry Role: Join Date: Nov 2001 Location: /home Posts: 15,841	It depends on the size of your DB. If you have a DB that is small, you may be able to use phpMyAdmin to move the database. Otherwise, you can use phpMyAdmin to export the data (save it as a file), FTP the .sql file to the new server, then log in to the new server and type /path/to/bin/mysql -u $mysqlusername -p$mysqlpassword $mysqldatabasename < $file.sql I have done it a few zillion times so if you need some help, drop me a line and I will see what I can do. __________________ I like pie.