Differences

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

--- exporting_importing_database_tips [2008/08/08 14:55] – juckins
+++ exporting_importing_database_tips [2025/03/20 18:30] (current) – juckins
@@ Line 1: / Line 1: @@
+==== Database Import-Export Tips ====
 Use phpMyAdmin to export databases. \\
@@ Line 10: / Line 12: @@
 . You might need to restart the mysql database server with this command (note max_allowed_packet setting):
 <code>
-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
+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>