MySQL Commands (1)

- Create a database: mysql> create database [databasename];
- List all databases: mysql> show databases;
- Use another database: mysql> use [db name];
- Show all tables in DB: mysql> show tables;
- Show field formats: mysql> describe [table name];
- Delete a database: mysql> drop database [database name];
- Delete a table: mysql> drop table [table name];
- Dump all databases for backup: -u root -p --opt >/tmp/alldatabases.sql
mysqldump -u username -ppassword –all-databases > dump.sql
- Dump one database for backup:
-u username -p --databases databasename >/tmp/databasename.sql
ysqldump -u username -ppassword database_name > dump.sql
Export A MySQL Database Structures Only
mysqldump -u username -ppassword –no-data database_name > dump.sql
Backup Only Data of a MySQL Database
mysqldump -u username -ppassword –no-create-info database_name >dump.sql
- Dump a table from a database:

-c -u username -p databasename tablename > /tmp/databasename.tablename.sql
- Restore database (or database table) from backup:

-u username -p databasename < /tmp/databasename.sql