MySQL is a popular database system that allows you to create internal tables and fields to store data.

What is a database and what's it for? Basically, a database is used to quickly store or retrieve any sort of data. For example, most message boards use MySQL databases to store and retrieve all usernames, passwords, profiles, messages, etc. Without a database, it would have to create thousands of individual text files which could get messy.

Drop A Database

mysqladmin -u USERNAME -p drop DATABASE

Create A Database

mysqladmin -u USERNAME -p create DATABASE

Import Backup Data

mysql -u USERNAME -p DATABASE < FILENAME.sql

Backup Database

mysqldump -u USERNAME -p DATABASE > FILENAME.sql

• How to check MySQL version
• MySQL Linux Commands
• Optimizing MySQL Table
• Repair Corrupted MySQL Table
• Repair MySQL Table with myisamchk