Christopher Juckins

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

==== Database Import-Export Tips ====

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):
<code>
su - mysql
/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
</code>

SQL statement to show all users on the system: \\
<code>
mysql> SELECT * from mysql.user;
</code>