Perform backup automatico Mysql

Asked

Viewed 2,695 times

1

I am using Mysql as DBMS, and when searching the internet a way to create a routine backup found that the old versions had a tool that no longer exists in the newer versions, I believe that those who use Mysql did not stay in the old versions.

I wonder if today there is a correct way to create this routine of backup or not each one makes a way.

mysql mysql-workbench backup

2 answers

2


"Mysql Workbench is a query client and tool for modeling and very good at it - the goal is not to perform server tasks - which is server work. You can run manual backups using Workbench, but I’m guessing that’s not your long-term goal.

There are many ways you can perform backups. Take a look here for 10 of them. Some of the solutions are OS dependent basically, you have more options if you are on Linux /*Nix than on Windows (which is yours? ). Also, it depends on whether your tables are Innodb or Myisam (I hope it’s Innodb!).

Two other (Open Source) backup solutions not mentioned in the post above are from Percona Xtrabackup which may be cron’d or Zmanda’s (which was mentioned in High Performance Mysql book by Schwartz et al.). Another solution would be Mydumper - again a tool supported Percone (except this also handles Myisam tables).

If you’re familiar with * Nix and file systems, then maybe an LVM solution might be good for you? Try here .

I advise you to study the available solutions and do some tests and see which one best meets your needs."

*Sometimes it is necessary to seek a little more! Hug. Original text

  • I use Windows.

  • then you can try one of these programs, or perform manually Server/Export or Server/Back Up e Recovery and create a configuration on my.cnf

0

You can use this Python script that I created, it backs up all databases.

Download it, run a chmod +x backup_mysql.py and put in the folder /usr/local/bin/

  • 2

    Is there any way you can put the codes here too? This way will happen some problem and this link no longer exists, the answer is not invalid. It reviews everything you posted.

  • Nilton, reviewing some of his publications, noticed several with the same format, and converted them to comments. If you edit them to make them more complete, don’t forget to signal them so a moderator can evaluate them and restore the answers. Thank you

  • All right, put the code here of the script gets very large and always I update this script, it is very rare I delete my own scripts because they do depart from various projects.

Browser other questions tagged mysql mysql-workbench backup

You are not signed in. Login or sign up in order to post.