Mysqldata warehouse contains many types of mysqldata warehouse. Next we will introduce the tool and directly back up data in mysql.exe.
Mysql tutorial database tutorial backup method
There are many types of mysqldata warehouse backups. Next we will introduce the tool and directly back up data in mysql.exe.
I. the php tutorial myadmin is the simplest,
1. Open your phpmyadmin
2. Click the database or table to be backed up.
3. Select export. The database or data backup is complete.
Ii. Land country Backup System
1. The method is simple. Download one from the Internet and go to production to view the instructions.
Iii. mysql backup commands
1. e:> cd xamppmysqlbin
E: xamppmysqlbin> mysql-u root-p
Again, the root in the uplink is my mysql user name, and the command line prompts:
Enter password:
Then enter your mysql password:
Enter password :****
Then press Enter.
: Mysql> use testdb;
Then press enter, and the following will appear:
Database changed
Mysql>
Enter the location of your mysql database file. For example, if your mysql file is in d: test. SQL
In this case, enter source d: test. SQL as follows:
Database changed
Mysql> source d: test. SQL
Then press enter, and there will be many:
Query OK, 0 rows affected (0.00 sec)
Query OK, 5000 rows affected (1.55 sec)
: Mysql> use testdb;
Then press enter, and the following will appear:
Database changed
Mysql>
Enter the location of your mysql database file. For example, if your mysql file is in d: test. SQL
In this case, enter source d: test. SQL as follows:
Database changed
Mysql> source d: test. SQL
Then press enter, and there will be many:
Query OK, 0 rows affected (0.00 sec)
Query OK, 5000 rows affected (1.55 sec)