mysql数据自动备份,大家一般怎么弄?
PHPz
PHPz 2017-04-17 14:17:47
0
2
671
PHPz
PHPz

学习是最好的投资!

reply all(2)
黄舟

How to prepare:

  1. Cold standby
    db shut down & cp data files (no one should use them now)

  2. Hot backup
    mysqldump (the most common), there are many tools, the subject can search.

  3. Create a slave and perform real-time backup through mysql synchronization mechanism. Of course, you can only have one backup.

Where to backup:
To prevent misoperation, you can backup it locally.
To prevent the server from being bombed, you can back it up in the same computer room and in different machines
To prevent the computer room from being bombed, you can back it up in different computer rooms in the same city
In order to prevent large-scale disasters, remote computer room backup can be performed

Peter_Zhu

Use the mysqldump that comes with the client, write sh under Linux, use crontab, and write bat under windows to use the system scheduled task, and save it to the local specified directory.
Or get an ftp and transfer it to other machines after exporting. Off-site backup is safer. There is the ftp command under cmd, and there are ftp and lftp under linuxshell, both of which can access ftp.
The server I manage does this. I don’t know if there is any other better way.

Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template