Christopher Juckins

SysAdmin Tips, Tricks and other Software Tools

User Tools

Site Tools


exporting_importing_database_tips

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
exporting_importing_database_tips [2008/08/08 14:55]
juckins
exporting_importing_database_tips [2008/08/09 18:10] (current)
juckins
Line 10: Line 10:
 4. You might need to restart the mysql database server with this command (note max_allowed_packet setting): 4. You might need to restart the mysql database server with this command (note max_allowed_packet setting):
 <code> <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> </code>
 +
 +SQL statement to show all users on the system: \\
 +<code>
 +mysql> SELECT * from mysql.user;
 +</code>
 +
  
exporting_importing_database_tips.1218221755.txt.gz · Last modified: 2008/08/08 14:55 by juckins