Mysql database backup mysqldump
The mysql database server needs to be backed up recently. The following problems are solved in sequence.
1.
[SQL] mysqldump-uroot-proot tms> tms_201505133 SQL
[Err] 1064-You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqldump-uroot-proot tms> tms_20150520. SQL 'at line 1
The mysqldump command cannot be executed in navicat or mysql, but can only be executed in the mysql/bin directory:
F: \ mysql-5.6.14-winx64 \ bin> mysqldump-uroot-p test> test_20150521. SQL
Enter password:
OK
2.
F: \ mysql-5.6.14-winx64 \ bin> mysqldump-uroot-p test> test_20150521. SQL;
Enter password:
Mysqldump: Got error: 1049: Unknown database 'test; 'when selecting the database
The cause of the error is that ">" no space is added before and after the symbol. Remove it.
3. Common backup import commands
Export:(Entire database)Mysqldump-u root-p database> data. SQL(Single table)Mysqldump-u root-p database tablename> data. SQLImport:mysql -u root -p database < data.sql