Jump to content

MySQL Backup using PDO


mongoose00318

Recommended Posts

You can still trigger backups whenever you want, it's just the PDO is the wrong tool for the job. 

Backups for mysql are typically done by using the mysqldump program to generate a SQL script containing all the database content.  You would just need to execute this whenever you want a backup made.

If your DB gets large, the a backup using mysqldump could take a while to run.  There are other backup methods that could be explored then.

Link to comment
Share on other sites

@kicken How would I active a shell script through PHP if I wanted to trigger the backup based on certain events that happen?

@benanamen Audit Logging looks really interesting. I'd probably need something that parses the logs and makes it easier to search them, etc...something like Monyog? I'm not too familiar with a lot of these more advanced performance and logging features of MySQL. Any additional advice would be welcome!

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.