how to restore database in mysql using command line

You can use the MySQL command line to back up and restore the database. The following describes how to use the MySQL command line to implement this function for your reference. You can use the MySQL command line to back up and restore the database.

MySQL command line Export Import database, database backup restoreMySQL command line export database:1. Go to the Bin folder in the MySQL directory: cd MySQL to the Bin folder directoryAs I entered the command line: CD C:\Program files\mysql\mysql

MYSQL command line Import and Export Database details, mysql command line Import and Export Mysql command line import database: 1. The. SQL file to be imported is moved to the binfile, which is convenient.2. Step 1 of the above-mentioned export3.

On the MySQL database backup and restore method, here is the first to refer to the Backup tool: Mysqlhotcopy, using the Mysqlhotcopy tool for quick backup, then data restore, using the MySQL command restore, and finally need to export the database

1. Various usage instructionsA. The simplest usage:[database name[dump file] The above command backs up the specified database to a dump file (dump file), such as:> Test. DumpThe generated Test.dump file contains the Build Table statement (the

Restore a database: mysql-h localhost-u root-p123456 wwwBacking up a database: mysqldump-h localhost-u root-p123456 www > d:\www2008-2-26.sqlWhere www is the database nameThe following is a test in the program$command = "Mysqldump–opt-h $dbhost-u

MySQL command line Export Database, mysql command line Export MySQL command line to export the database:1. Go to the bin folder under the MySQL Directory: directory from cd MySQL to the bin folderFor example, if the command line I entered is cd C: \

First, the common operation: Back up the entire database Format:MYSQLDUMP-H host name-P Port-u username-p password (–database) database name > filename. sqlMysqldump-h{hostname}-p{port}-u{username}-p{password} {DatabaseName} > {backupfile.sql}For

MySQL command line Export Database: 1, enter the bin folder under the MySQL Directory: the directory from cdMySQL to the bin folder, as shown in the command line I entered: cdC: programFilesMySQLMySQLServer4.1bin (or directly add the directory to

MySQL command line export database: 1, go to the Bin folder in the MySQL directory: cd MySQL to the Bin folder directory as I entered the command line: CD C:\Program files\mysql\mysql Server 4.1\bin ( or add the directory directly to the Windows