Not the answer you need?
Register and ask your own question!

Restoring database in standalone in server

percona_binupercona_binu EntrantLegacy User Role Beginner
Hi,

I am trying to restore the database in standalone server for percona backup but I am getting Innodb is corrupted error. I havecopied all the logs and configurationto the the standalone server but I am still getting error. Is there any procedure to restore the database standalone server. If so could you please post it here.

[ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html for information about forcing recovery.

Thank you,

Comments

  • vaibhav_upadhyay40vaibhav_upadhyay40 Contributor Current User Role Patron
    edited June 11
    Please mention below details, it will help you to get an answer faster.
    Source MySQL database version 
    Target MySQL database version
    Steps with command performed while taking backup.
    Backup file transfer/copy command 
    OS details of database servers (source and target database server)
    Restoration steps details with command
    Backup tool version  (both Source and Target server)


Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.