Shulou(Shulou.com)05/31 Report--

This article mainly explains "the backup and restore command of mysql under win system". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Now let the editor take you to learn the backup and restore command of mysql under the win system.

Suppose mysql is installed on c: disk, the user name of mysql is root, the password is 123456, the database name is database_name, the backup database is stored under the root directory of d: disk, and the backup database name is backup20070713.sql (20070713.sql is the backup date)

Back up the database:

Dump-uroot-p123456 database_name > d:/backup20070713.sql

Restore the database:

Delete the original database, establish the database, and import the backup database.

Mysqladmin-uroot-p123456 drop database_name

Mysqladmin-uroot-p123456 create database_name

Mysql-uroot-p123456 database_name

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.