Is there a way to copy all the data in a mysql database to another? (phpmyadmin)

Question

I want to copy all the tables, fields, and data from my local server mysql to my hosting sites mysql. Is there a way to copy all the data? (It's only 26kb, very small)

Answer 1

Have a look at

Copying MySQL Databases to Another Machine

Copy MySQL database from one server to another remote server

Answer 2

In phpMyAdmin, just export a dump (using the export) tab and re-import it on the other server using the sql tab.

Make sure you compare the results, I have had phpMyAdmin screw up the import more than once.

If you have shell access to both servers, a combination of

mysqldump -u username -p databasename > dump.sql

and a

mysql -u username -p databasename < dump.sql

on the target server is the much more fast and reliable alternative in my experience.

Answer 3

If you have the same version of mysql on both systems (or versions with compatible db file sytsem), you may just copy the data files directly. Usually files are kept in /var/lib/mysql/ on unix systems.