Jump to content

Database Restore.


Recommended Posts

  • Administrator

Hey all,

Unfortunately during development today we ran into an issue that caused us to restore to a backup from 12 PM EST.

 

All posts and replies are gone after that time and will need to be recreated. I apologize and we're working on steps for this to never happen again.

Thank you for understanding. 

  • Like 6

"Just remember: when something breaks, kick it as hard as you fucking can"

-Trent Reznor
Support Me (Via Patreon)

Link to comment
Share on other sites

I'm a DBA, but I mostly specialize in MS SQL and Oracle.

I'm guessing this site is running MySQL since MS SQL and Oracle licenses are expensive. Especially Oracle.

 

Anyway,

Sounds like you guys don't have binary logs turned on?

Backup file + logs = can roll forward the backupfile with log files to any point in time you want after the backup was taken.

 

https://dev.mysql.com/doc/refman/5.6/en/point-in-time-recovery.html

Link to comment
Share on other sites

  • Administrator

I'm a DBA, but I mostly specialize in MS SQL and Oracle.

I'm guessing this site is running MySQL since MS SQL and Oracle licenses are expensive. Especially Oracle.

 

Anyway,

Sounds like you guys don't have binary logs turned on?

Backup file + logs = can roll forward the backupfile with log files to any point in time you want after the backup was taken.

 

https://dev.mysql.com/doc/refman/5.6/en/point-in-time-recovery.html

We had to delete the server image and use a server image backup. A few important tables were dropped :( and we didn't have a regular mysql backup for them. 

"Just remember: when something breaks, kick it as hard as you fucking can"

-Trent Reznor
Support Me (Via Patreon)

Link to comment
Share on other sites

Uh. If I'm reading this right, it sounds like your not backing up the entire database? You're just backing up certain tables then?

 

Assuming mysql:
mysqldump --all-databases > dump-$( date '+%Y-%m-%d_%H-%M-%S' ).sql -u (USERNAME) -p(PASSWORD)
 

That command should backup the entire database.

 

OFC your sysadmin/dba equivilent will probably wanna read up on it before doing anything: https://dev.mysql.com/doc/refman/5.6/en/mysqldump.html

Link to comment
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
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  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.

Loading...
×
×
  • Create New...

Important Information

By using this site, you agree to our Guidelines. 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. - Privacy Policy