Post reply

MySQL database issue

  • July 12, 2016 at 11:47 am

    #327854

    I need help to restore a mysql database. I'm using cpanel and phpmyadmin.I see not restore function in phpmyadmin.

  • July 12, 2016 at 12:11 pm

    #1889689

    FrankKelly (7/12/2016)

    I need help to restore a mysql database. I'm using cpanel and phpmyadmin.I see not restore function in phpmyadmin.

    I'm sorry, this forum is specialized in Microsoft SQL Server, so you might not get the best advice in here.

    Try checking http://forums.mysql.com/ or at http://www.stackoverflow.com

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • July 19, 2016 at 12:09 pm

    #1890927

    Do You want a database restore from a backup? or a database corruption fix?

    For the first case, you need a backup file generated before. if it's a mysqldump backup,

    you need to execute the command line:

    mysql -u root -p databasename < backupfilename

    For the second case, you can execute the database/ table repair command:

    REPAIR TABLE tbl_name [, tbl_name] ... [QUICK|EXTENDED]

    Example

    REPAIR TABLE table1, table2, table3 EXTENDED

    It only works if you have the proper rights in that database.

    If this method doesn't work then only try to recover the data by using MySql Recovery Toolbox. It is a qualitative tool that may help you. http://www.oemailrecovery.com/mysql_recovery.html

  • July 19, 2016 at 12:14 pm

    #1890928

    You can still read this resource for more information on your issue.

    http://www.sqlservercentral.com/Forums/Topic1618894-2893-1.aspx

  • July 21, 2016 at 1:27 pm

    #1891444

    Thank you all for your advice! The issue has been resolved.

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

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