Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2010

    Unanswered: restore database

    i am new to MySql i had taken a backup from a database 1 and unfortunately i restored it in other database 2 i don't have a backup of database 2 how can i restore or recollect the previous data for the database 2 any help thanks in advance
    WiTh Tnks & ReGaRdS

  2. #2
    Join Date
    Sep 2009
    San Sebastian, Spain
    Did the previous backup drop each of the tables and recreate them or drop the database and recreate it? If this happened then there is not hope of getting your data back. However, if it simply added data to the database you may try to find differences in the data between the same tables in database 1 and database 2. However, this might still not return all of your data.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    Follow me on Twitter

Posting Permissions

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