mysql database table corruption

• sigmarforseth

  SSC Enthusiast

  Points: 119

  More actions

  March 1, 2015 at 10:59 am

  #295587

  Today when I opened MySQL database and I couldn't see very important table which were present/created about couple months ago. Yesterday I worked on it.

  Do you have some suggestions, how to get my table back?

  Thanks for help!

• Jeff Moden

  SSC Guru

  Points: 1004615

  More actions

  March 1, 2015 at 4:48 pm

  #1781000

  Only one way that I know of... restore from backup.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  March 2, 2015 at 2:03 am

  #1781043

  I would suggest you post this on a MySQL forum. This site is for MS SQL Server.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• nicolaspruefer

  SSC Enthusiast

  Points: 107

  More actions

  March 2, 2015 at 3:04 pm

  #1781233

  you should follow two steps:

  Create an appropriately named database on the target machine Load the file using the mysql command:

  $ mysql -u [uname] -p[pass] [db_to_restore] < [backupfile.sql]

  Have a look how you can restore your tut_backup.sql file to the Tutorials database.

  $ mysql -u root -p Tutorials < tut_backup.sql

  To restore compressed backup files you can do the following:

  gunzip < [backupfile.sql.gz] | mysql -u [uname] -p[pass] [dbname]

  If you need to restore a database that already exists, you'll need to use mysqlimport command. The syntax for mysqlimport is as follows:

  mysqlimport -u [uname] -p[pass] [dbname] [backupfile.sql]

  Or make use of Repair Toolbox for MySQL

  Demo version is here-: http://www.sql.repairtoolbox.com/%5B/url%5D

  Moreover, visit next resource: http://www.filerepairforum.com/forum/databases/databases-aa/mysql/1474-mysql-table-unclosed-or-crashed - where a proper solution can be found.