1. #1

    database in mysql

    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?


    • Ad Bot

      advertising
      Beep.

        
       

  2. #2
    Laxer's Avatar
    Join Date
    Feb 2012
    Location
    Portland, OR
    Posts
    3,859
    • specs System Specs
      • Motherboard:
        GIGABYTE GA-Z97MX
      • CPU:
        Intel 4690K @ 4.6Ghz
      • Memory:
        Corsair Vengeance Pro 16GB @ 2666Mhz
      • Graphics:
        2x Sapphire 7970s
      • Hard Drives:
        2x Corsair Force 3GT 120GB (RAID 0) + 2x Western Digital Red 3TB (RAID 1)
      • Disk Drives:
        LG Black 10X Blu-ray Burner
      • Power Supply:
        CORSAIR 950HX
      • Case:
        Corsair 350D
      • Cooling:
        Corsair H100i
      • Display:
        3 x 22" Samsung 1080p Displays
      • Operating System:
        Windows 8 Pro x64

    Re: database in mysql

    I'm assuming you have the community server version installed?

    I would backup the temp files: MySQL :: MySQL 5.7 Reference Manual :: B.5.3.5 Where MySQL Stores Temporary Files

    Close it and see if it restores it.

    What are you worried about? Loss of data(in the tables), loss of the scripts you were writing?

  3. #3

    Re: database in mysql

    Quote Originally Posted by Laxer View Post
    I'm assuming you have the community server version installed?

    I would backup the temp files: MySQL :: MySQL 5.7 Reference Manual :: B.5.3.5 Where MySQL Stores Temporary Files

    Close it and see if it restores it.

    What are you worried about? Loss of data(in the tables), loss of the scripts you were writing?
    That's right
    I closed it, but no result
    For me more important is data

  4. #4
    Laxer's Avatar
    Join Date
    Feb 2012
    Location
    Portland, OR
    Posts
    3,859
    • specs System Specs
      • Motherboard:
        GIGABYTE GA-Z97MX
      • CPU:
        Intel 4690K @ 4.6Ghz
      • Memory:
        Corsair Vengeance Pro 16GB @ 2666Mhz
      • Graphics:
        2x Sapphire 7970s
      • Hard Drives:
        2x Corsair Force 3GT 120GB (RAID 0) + 2x Western Digital Red 3TB (RAID 1)
      • Disk Drives:
        LG Black 10X Blu-ray Burner
      • Power Supply:
        CORSAIR 950HX
      • Case:
        Corsair 350D
      • Cooling:
        Corsair H100i
      • Display:
        3 x 22" Samsung 1080p Displays
      • Operating System:
        Windows 8 Pro x64

    Re: database in mysql

    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.

  5. #5

    Re: database in mysql

    Laxer, thank you very much, but InnoDB recovery process could restore only the part of data, no more.

  6. #6

    Re: database in mysql

    Quote Originally Posted by orangutitan View Post
    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 niemiro; 06-07-2016 at 04:04 PM. Reason: Removed hyperlinking

Similar Threads

  1. mysql cannot connect
    By Temmu in forum Programming
    Replies: 4
    Last Post: 10-19-2013, 07:46 AM
  2. MySQL not submitting?
    By Tekno Venus in forum Programming
    Replies: 1
    Last Post: 10-08-2013, 06:35 PM

Log in

Log in