The recent work often need to back up the MySQL database on the remote server to the local computer, a direct backup of the MySQL data directory, but because of different coding reasons often arise. Later, my friend recommended me to use a very
(This example is based on the Freebsd/linux implementation, the Windows environment please make the appropriate changes)An important mission of configuration management is to ensure the security of the data, to prevent the server should be hard disk
MySQL backup script and mysql script. MySQL backup script, mysql script mysqlbackup. php :? Php backup mysqlset_time_limit (0); date_default_timezone_set (PRC); configuration $ configsarray (host1array (localh MySQL backup script, mysql
(The example in this article is implemented based on FreeBSD/Linux, and you need to modify it on your own in the Windows environment)An important mission of configuration management is to ensure data security and prevent the catastrophic
MySQL backup script and mysql script
Mysqlbackup. php:
array ('localhost', 'root ', 'root', array (), // empty to back up all databases; otherwise, back up these databases 'd:/xampp/mysql/bin/mysqldump ', // backup tool dirname (_ FILE __).
The article introduced two kinds of database record code, one is our PHP write common database backup class, the other is for Linux friends to provide an automatic timing backup MySQL database code, the need for students can refer to.
Save the
XtrabackupXtrabackup is a free database hot backup software Percona open source, which can back up non-blocking database of InnoDB database and XTRADB storage engine (also need to add a table lock for MyISAM backup);The mysqldump backup method is a
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.