mysql

To back-up use the mysqldump command. For example:

mysqldump -Qq -hdb28.pair.com -uzrtch_2 -p zrtch_mykb > my-dump-mykb.sql

To upload use the mysql command. For example:

mysql -hDBSERVER -uzrtch_26 -p zrtch-espanaviva dump-espanaviva-13OCT07.sql

On the mysql command line:

The following two commans are useful to determine current connections:

•   SHOW STATUS WHERE `variable_name` = 'Threads_connected';

•   SHOW PROCESSLIST;

Centos prompt

You may update the mysql configuration which is located under /etc/my.cnf.

Two variables you may like to review are:

mysql -u root -p     
mysql> CREATE DATABASE testing;
mysql> GRANT ALL PRIVILEGES ON testing.* TO test_user@localhost IDENTIFIED BY 'test_pass';