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 Korisnici koji smatraju članak korisnim
Je li Vam ovaj odgovor pomogao?

Related Articles

Manage Query Cache

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

Connect to my MSSQL database via Enterprise Manager?

To connect to your MSSQL database using Enterprise Manager, please perform the following: 1....

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

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

Change the DNS servers for the network interfaces on Windows server

In Network Connections, right-click the local area connection, and then click Properties. In...