Backing up and restoring a MySQL database from the command line

. Shell into your box as root, then:
mysqldump -a -u USERNAME -p DATABASE > FILENAME.mysql

You will be prompted for your database password and then the DATABASE will be dumped to a plain-text file called FILENAME.mysql.
The resulting file, FILENAME.mysql, is a full backup with which you can fully restore your database in case of problems.

Restoring via the command line
1. Drop the database
mysqladmin -u USERNAME -p drop DATABASE

2. Recreate the database
mysqladmin -u USERNAME -p create DATABASE

3. Import the backup data
mysql -u USERNAME -p DATABASE < FILENAME.mysql

  • Email, SSL
  • 0 Kunder som kunne bruge dette svar
Hjalp dette svar dig?

Related Articles

MySQL will not start, “MySQL File ‘/usr/share/mysql/charsets/?.conf’ not found” in error log.

The most common cause for this error, is a failed downgrade of MySQL from 4.1 to 4.0.  Many...

Finding what packages are installed on a Linux system

For distributions that use RPM format packages, use the command: $ rpm -qa You may want to...

Manage Query Cache

You can check whether the query cache is present in your MySQL server using the following...

Export the data from different tables in our shared SQL environment?

Using Enterprise Manager Expand SQL Server group Expand the server name Expand Databases...

Execute a SQL script (.sql file) on MsSql Server database

To execute a .sql file, you need to open the “Query Analyzer” Start -> Programs ->...