Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


Best backup solution for MySQL databases?
New on LowEndTalk? Please Register and read our Community Rules.

All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.

Best backup solution for MySQL databases?

drdrakedrdrake Member
edited May 2016 in Help

Hi, i am using a few web apps on my VPS (apache + php +mysql/mariadb). What backup solution do you use? I am looking for simple ways to securely backup my files and databases.
I want to backup the databases in this format:
backup-date-time.tar

and inside it should have all databases in separate files and not all in one file.

I know I can backup files with scp.

Thanks. :)

edit: verifying backups are fine and not corrupted would be great to have as an option

Comments

  • Give a shot http://link.xvapps.com/Dbbackupsol

    Or write your own php script simple php script.

  • drdrakedrdrake Member

    @vishalpatelz said:
    Give a shot http://link.xvapps.com/Dbbackupsol

    Or write your own php script simple php script.

    I was checking that out. It seems good.
    What does backup rotation mean? Sorry for my ignorance.

  • vishalpatelzvishalpatelz Member
    edited May 2016

    @Arjon said:

    @vishalpatelz said:
    Give a shot http://link.xvapps.com/Dbbackupsol

    Or write your own php script simple php script.

    I was checking that out. It seems good.
    What does backup rotation mean? Sorry for my ignorance.

    I guess scheduling.

  • LiteServerLiteServer Member, Patron Provider

    Mysqldump in combination with a script that takes care about rotation?

  • miTgiBmiTgiB Member

    https://sourceforge.net/projects/automysqlbackup/

    I've used this for at least 5 years now

    Thanked by 1Ndha
  • raindog308raindog308 Administrator, Veteran

    The DBA in me was forced to change this title because it irritated me.

    MySQL is SQL, but not all SQL (or even the vast majority of it) is MySQL.

    Thanked by 1vedran
  • raindog308raindog308 Administrator, Veteran

    Arjon said: edit: verifying backups are fine and not corrupted would be great to have as an option

    I'm thinking the only way to verify a mysql dump is to restore it into a database. One interesting take might be to use MySQL's blackhole engine on a separate instance and do a test restore into that. That would tell you if the mysqldump file has any errors, but not consume space to do a full restore.

    Of course if your data is only a few gigs or less, you could probably just do the full restore to verify.

  • drdrakedrdrake Member

    @raindog308 said:

    Arjon said: edit: verifying backups are fine and not corrupted would be great to have as an option

    I'm thinking the only way to verify a mysql dump is to restore it into a database. One interesting take might be to use MySQL's blackhole engine on a separate instance and do a test restore into that. That would tell you if the mysqldump file has any errors, but not consume space to do a full restore.

    Of course if your data is only a few gigs or less, you could probably just do the full restore to verify.

    I remember reading a solution on /r/sysadmin but i can't remember the name of the tool unfortunately. Is there any way to automate what you are saying?

  • drdrakedrdrake Member

    @miTgiB said:
    https://sourceforge.net/projects/automysqlbackup/

    I've used this for at least 5 years now

    Yeah it seems to be good. I think i might use this.

  • msg7086msg7086 Member

    I would set up another tiny server running as a replication slave, then doing backup on the slave server.

Sign In or Register to comment.