Learn More
Resend Email
1
ThatDannyBoy
6y

What would you guys use to backup multiple mysql databases incrementally without root access. I've been just exporting the db through PMA but I'm switching everything to a version controlled system and would like to do the same for our databases.

Oh yeah and the reason I don't have root is we have cloud hosting which doesn't provide root access. I can't even run Yum.

Edit: grammar

question

help

version control

databases

backup
Favorite
Ranter
Comments
  • 1
    6y
    I’m assuming PHP here?

    You could write a cron to do an export and write to disk outside of the public_html dir, are you tracking schema changes only or all data?
  • 0
    6y
    @C0D4 well data is probably good enough but it'd be nice to track schema changes too
  • 1
    6y
    If memory serves correctly, mysqldump does not require root out of the box. Plenty of documentation on it, plus you can run it in Cron.
  • 0
    6y
    I've got mysqldump setup where it performs a weekly backup of all the databases and discards any backups older than 2 months.

    I'll probably play with this more in the future but for now each backup creates a folder named the current date and time. Any valid dates older than 2 months are removed.
Related Rants
devRant © 2021 Hexical Labs LLC
Privacy Policy  |  Terms of Service
Add Comment