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