mysql db backup and restore

: #mysql-U root-p >use school;>insert into info (name,score) values (test02,90);>quit//完成数据插入 #mysqladmin-U root-p flush-logs//refresh generate MySQL Incremental backup log file#cd/usr/local/mysql/data/#ls//binary log has been generated When the worker inadvertently removes t

improve its completion speed. Description: The--copy-back option of the Innobackupex command is used to perform a recovery operation, which performs the recovery process by copying all data-related files to the MySQL server DataDir directory. Innobackupex backup-my.cnf to get information about the DataDir directory. ⑧ officially starts restoring incremental backups ⑨ restarting the binary log and verifying

is very useful for beginners. 　　 After installing the environment, you can directly download mysql workbench from the mysql official website. After installation, open it and you will see the following interface. The first item is for visual SQL editing and query, the second item can be used for visual mysql database design, and the third item is Green Circle.

This article describes how to import, export, and restore a MySQL database. For more information about MySQL database operations, see the following, it can be divided into two situations: virtual host and server. Virtual host 1. through PHPMyAdmin's import and export function, this software generally only supports export of several megabytes of data, and too muc

We will certainly encounter the backup database in the course of running the project, restore the database situation, we generally use two ways to deal with:1. Import and export backup data using into outfile and load data infileThe advantage of this method is that the exported data can be self-defined format, and the export is pure data, there is no table inform

MySQL Backup restore summaryIf operating system error number in a file operation occurs when backing up the database. This error indicates that too many files are open.Solution Ulimit-n 1048576You can then make a backup of the database1. IntroductionThe tool used is xtrbackup the tool is open source and very powerful,

MySQL Data backup and restore original sticker: http://www.cnblogs.com/kissdodog/p/4174421.html. Data backup　　1. Backup with mysqldump commandThe mysqldump command backs up the data in the database into a text file. The structure of the table and the data in the table are st

user revokes the specified user's database permissions, the user can still connect to the MySQL server after revoking permissions, but the corresponding database operation is forbidden, the statement format is as follows:Revoke permissions list on database name. Table name from user name @ Source AddressFor more information on MySQL statements, refer to the MySQL