EmailDiscussions.com  

Go Back   EmailDiscussions.com > Discussions about Email Services > The Technical Zone...
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
Stay in touch wirelessly

The Technical Zone... The Geeky forum... Use this forum to discuss technical aspects of email, from authentication protocols to encryption.

Reply
 
Thread Tools
Old 27 Jun 2017, 01:28 AM   #1
archibald
Junior Member
 
Join Date: Jun 2017
Posts: 3
MySQL files

After a server issue, my client has restored the MySQL files before their issue, but MySQL is having problems bringing their database back up. (i'm waiting for more information as the exact nature of the issue)

I have the ibdata1 ib_logfile0, and ib_logfile1files, and all the .frm and .ibd files for all the tables. I can open the database using Navicat, but when trying to open individual tables the first attempt shuts down the MySQL service and after restarting it, table access attempts returns a message that the table doesn't exist.

I've uploaded the section of the error log from my last attempt to access the database.

I've contacted percona and am aware of their tools, and services, but was hoping someone could give me a little more insight to my issue, and if there is a way to restore this database that isn't a major time consuming pain in the butt.

Thanks,

Server issue specifics:

The server crash was the result of a power surge, which took out the SATA and RAID controllers. It also completely damaged one drive (there were 2 drives mirrored in RAID1 as dynamic disks). The other drive was only partially damaged, and it is from this drive that we extracted the files that we have from the mysql data directory (that is the "afriplexqms" directory you're seeing).

However, we also have a manual backup set, which is in the root of the D:\IRENE\TLM folder (in the form of 342 .sql files).

http://www.filedropper.com/mysql-error-logq4
archibald is offline   Reply With Quote

Old 27 Jun 2017, 08:09 PM   #2
archibald
Junior Member
 
Join Date: Jun 2017
Posts: 3
Can anyone help me here?
archibald is offline   Reply With Quote
Old 28 Jun 2017, 12:06 AM   #3
mahony
Junior Member
 
Join Date: Jun 2017
Posts: 2
When the DB was "restored," Did the user restore from the filesystem backups?

If you have the SQL files dumps, you should try restoring that data on a separate system where you can install MYSQL if not installed and restore them from the sql dumps.

Hopefully, you have the DB/table create as part of the SQLs and the sql backups are recent enough.

The only time a filesystem mysql backup will be valid is when mysql is not running when the backup is taken/made/created.
mahony is offline   Reply With Quote
Old 28 Jun 2017, 12:07 AM   #4
mahony
Junior Member
 
Join Date: Jun 2017
Posts: 2
If you have no opportunity to do recovering files that way, then I can advise to try some mysql database recovery tool as MySql Recovery Toolbox and restore file using this tool and think you will be able to save your base. http://www.oemailrecovery.com/mysql_recovery.html
mahony is offline   Reply With Quote
Old 28 Jun 2017, 04:32 AM   #5
archibald
Junior Member
 
Join Date: Jun 2017
Posts: 3
I am very grateful for your advice. Thank you very much!
archibald is offline   Reply With Quote
Reply


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +9. The time now is 03:50 PM.

 

Copyright EmailDiscussions.com 1998-2013. All Rights Reserved. Privacy Policy