mysql database table corruption

  • 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!

  • 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)
    Intro to Tally Tables and Functions

  • 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
  • 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/[/url]

    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.

  • This was removed by the editor as SPAM

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply