Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2010
    Location
    ISHHHH
    Posts
    130

    Unanswered: restore database

    hi,
    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
    mAtHuKuMaLi

  2. #2
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    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)
    http://www.it-iss.com
    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
  •