Christopher Juckins

SysAdmin Tips, Tricks and other Software Tools

User Tools

Site Tools


exporting_importing_database_tips

This is an old revision of the document!


Use phpMyAdmin to export databases.

On new machine, make sure database does not exist.

On original machine, select database which you wish to export.

1. First export just the "Structure" of the database. Choose all options except "Add DROP TABLE". Save as export file.
2. Then export just the "Data" as an SQL statement. Make sure all tables are selected. Don't choose complete inserts or extended inserts. Save as export file.
3. On target machine, import Structure file first. Then go to database, and import Data file.
4. You might need to restart the mysql database server with this command (note max_allowed_packet setting):

mysql     7297  7227  0 18:40 pts/1    00:00:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --max_allowed_packet=32M --socket=/var/lib/mysql/mysql.sock
exporting_importing_database_tips.1218221755.txt.gz · Last modified: 2008/08/08 14:55 by juckins