MySQL Reference Guide

MySQL is used by the DCL system on mail2. This is a quick reference guide for MySQL.

Create Database

[vwpoint@mail2 ~]$ mysqladmin -u root create gnwdcl

Logging In

Logging in to the DCL database:

[vwpoint@mail2 ~]$ mysql gnwdcl -u dcl -p
Enter password: 

The password for the DCL database is: tweety3

View Tables

To display all the tables in the database:

mysql> show tables; 

Backup Export

To export the database for backups:

mysqldump -u dcl --password=tweety3 --tab=/data/dcl_backup/ --opt gnwdcl 

MySQL Reference (last edited 2008-08-21 05:12:05 by Eric)