Christopher Juckins

SysAdmin Tips, Tricks and other Software Tools

User Tools

Site Tools

Trace:
exporting_importing_database_tips

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
exporting_importing_database_tips [2008/08/08 14:56] – juckinsexporting_importing_database_tips [2025/03/20 18:30] (current) – juckins
Line 1: Line 1:
 +==== Database Import-Export Tips ====
 +
 Use phpMyAdmin to export databases. \\ Use phpMyAdmin to export databases. \\
  
Line 13: Line 15:
 /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 /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.1218221784.txt.gz · Last modified: 2008/08/08 14:56 by juckins