Results 1 to 2 of 2

Thread: mysql database recovery in wampserver2

  1. #1
    Join Date
    Sep 2015
    Posts
    1

    mysql database recovery in wampserver2

    some how mysql database in wamp server 2 got replaced by older database and i am unable to restore the database to the location (before being replaced by old data) from the latest backup i have . is there any way i can restore the data to my required position.

    any way except restoring it from backup sql file as its corrupt.

  2. #2
    Join Date
    Sep 2015
    Posts
    1
    Repairing tables with mysqlcheck or another variant to learn helpful topics about mysql databases

    https://social.msdn.microsoft.com/Fo...=sqldataaccess
    http://www.sqlservercentral.com/Foru...94-2893-1.aspx


    The mysqlcheck command-line utility can be used while the server is running, and, like all the methods of repair, only works with MyISAM tables. The syntax is:
    %mysqlcheck -r sports_results fixtures -uuser -ppass
    sports_results.fixtures OK
    You can also repair multiple tables in a database, by listing them after the database name, or all tables in a database by just passing the database name, for example:
    %mysqlcheck -r sports_results fixtures events -uuser -ppass
    sports_results.fixtures OK
    sports_results.events OK

    %mysqlcheck -r sports_results -uuser -ppass
    sports_results.fixtures OK
    sports_results.events OK
    ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •