What's new

problem with the MYSQL database

  • Thread starter edwardcarr
  • Start date
  • Views 1,450
edwardcarr

edwardcarr

Newbie
Messages
1
Reaction score
0
Points
35
Sin$
0
Hello,

I work with the mysql database for a couple of months now could not open it, because there was an error: “Incorrect key file for table: '...'. Try to repair it”

Who can tell how open the database?

Thanks to all.
 
Space

Space

PlayStation 4 ✔
Messages
2,784
Reaction score
1,697
Points
665
Sin$
0
This is a sign of a corrupt Data Base this means doing 2 things
Exporting the information that is not corrupt or
Locating the /tmp folder and moving it to a location with bigger server storage.

Hope this helped :smile:
 
thomasbates

thomasbates

Newbie
Messages
1
Reaction score
0
Points
35
Sin$
0
To fix this do the following please or in case it isn’t enough for your mysql database restoration, then I would advise you to learn helpful threads dedicated to solving MySQL issues


http://community.office365.com/en-us/f/172/p/266451/815406.aspx

https://social.msdn.microsoft.com/F...ow-to-fix-my-sql-database?forum=sqldataaccess

https://www.repairtoolbox.com/mysqlrepair.html Repair Toolbox for MySQL – in case you can’t get back mysql database, you may apply this one solution


Force InnoDB Recovery

  1. Stop mysqld and back up all files located in the /var/lib/mysql/ directory:
  2. # /etc/init.d/mysqld stop
  3. # mkdir /root/mysql_backup
  4. # cp -r /var/lib/mysql/* /root/mysql_backup/
  5. Add the option innodb_force_recovery to the [mysqld] section in /etc/my.cnf. This option will allow you to start mysqld and create a database dump.
  6. #/etc/my.cnf
  7. [mysqld]
  8. innodb_force_recovery = 4
NOTE: You can increase the option to five or six until you receive a proper dump.

  1. Start the mysqld service:
  2. # /etc/init.d/mysqld start
  3. Dump all databases:
  4. # mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` -A | sed '1i\SET FOREIGN_KEY_CHECKS = 0;' > /root/dumpall.sql
If the dump fails with an error that reads:

Incorrect information in file: './psa/APSApplicationItems.frm' when using LOCK TABLES"`

... then you need to increase innodb_force_recovery and try to dump the databases again. If you are not able to dump the databases, try using method II ("Copy table content") or III ("Restore from the backup") below.

  1. Remove all files from /var/lib/mysql/ except the mysql folder:
  2. # rm -rf `ls -d /var/lib/mysql/* | grep -v "/var/lib/mysql/mysql"`
  3. Remove the innodb_force_recovery option from the /etc/my.cnf file and restart mysqld:
  4. # /etc/init.d/mysqld restart
  5. Check the /var/log/mysqld.log for any errors.
  6. Restore the databases from the dump:
# mysql -uadmin -p`cat /etc/psa/.psa.shadow` < /root/dumpall.sql
 
Top Bottom
Login
Register