Jump to content
mongoose00318

MySQL Backup using PDO

Recommended Posts

The best way to do DB backups is not with PDO. What you want to do is write a shell script that acts directly on the DB and set up a CRON job to run it at whatever intervals.

Share this post


Link to post
Share on other sites

@benanamen Okay, I was only asking because somethings there are events that happen in the software where I would want a DB backup triggered before any alteration of the data is allowed. I would want regularly timed backups as well; as you suggested above.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

You may also want to look into Temporal Data Tables or Audit Logging depending on your specific needs.

Share this post


Link to post
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!

Share this post


Link to post
Share on other sites
2 hours ago, mongoose00318 said:

How would I active a shell script through PHP

exec()

Share this post


Link to post
Share on other sites

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.