Differences

This shows you the differences between two versions of the page.

--- exporting_importing_database_tips [2008/08/08 14:54] – created juckins
+++ exporting_importing_database_tips [2025/03/20 18:30] (current) – juckins
@@ Line 1: / Line 1: @@
-Use phpMyAdmin to export databases.
+==== Database Import-Export Tips ====
-On new machine, make sure database does not exist.
+Use phpMyAdmin to export databases. \\
+On new machine, make sure database does not exist. \\
+On original machine, select database which you wish to export. \\
+. First export just the "Structure" of the database.  Choose all options except "Add DROP TABLE".  Save as export file. \\
+. 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. \\
+. On target machine, import Structure file first.  Then go to database, and import Data file. \\
+. 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>
-On original machine, select database which you wish to export.
-. First export just the "Structure" of the database.  Choose all options except "Add DROP TABLE".  Save as export file.
-. 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.
-. On target machine, import Structure file first.  Then go to database, and import Data file.