What's new

[REQUEST] database in mysql

orangutitan

New member
Joined
May 23, 2016
Posts
3
I have worked in MySQL 5.7 database of almost half a day, then minimized it, a couple of hours rest, when I came back I saw that the program does not respond, restarted it, and application refused to open the database and generates an error 1016.

Give a hint who knows what can be done?
 

Laxer

Administrator
Staff member
Joined
Feb 20, 2012
Posts
3,893
Location
Portland, OR
Since you are worrying about data loss is it correct that you were using transactions?

If not, everything is updated and saved instantly so you should have no data loss.

If you were, there is a recovery log and you can decide the best course of action: MySQL :: MySQL 5.6 Reference Manual :: 14.16.1 The InnoDB Recovery Process

Note: Assuming you were following ACID you shouldn't have any data loss regardless. You might have to rerun the last script you were running as the changes might have been reverted but, there shouldn't be any damage.

If the scripts you were running were not atomic they may have only partially ran. If this is the case you will have to do a bit of damage control. (Either revert and rerun everything or alter your update/insert/delete statement to check to see if it has already been changed)

Hope that helps.
 

orangutitan

New member
Joined
May 23, 2016
Posts
3
Laxer, thank you very much, but InnoDB recovery process could restore only the part of data, no more.
 

aftend89

Member
Joined
Jun 1, 2016
Posts
6
I have worked in MySQL 5.7 database of almost half a day, then minimized it, a couple of hours rest, when I came back I saw that the program does not respond, restarted it, and application refused to open the database and generates an error 1016.

Give a hint who knows what can be done?
Try to open database in another version of MySQL, in case it won't help, then you may use next command:

mysqladmin --defaults-file=/usr/local/mysql/my.cnf --user=root --password shutdown
mysqlbackup --defaults-file=/usr/local/mysql/my.cnf \
--backup-dir=/export/backups/full \
copy-back


When nothing helps when apply to Recovery Toolbox for MySQL, this solution has demo, you may try it on hxxps://mysql.recoverytoolbox.com
 
Last edited by a moderator:
Top