Results 1 to 2 of 2

Thread: Can we restore mysql dropped database? how?

  1. #1
    Join Date
    Dec 2006

    Question Can we restore mysql dropped database? how?


    I am using mysql 5 and accidnetly i dropped a database.unfortunately i dont have any backup,

    Is it possible to recover that datbase.
    I am using windows.

  2. #2
    Join Date
    Oct 2008

    Recover dropped Database

    ye there is two way of restoration:

    1. backup files from your database

    2. binary logs, which files are in form of <host_name>-bin.00001
    by every update on your database the extension will be incremented
    by 1. then the greatest value is the latest one.

    binary logs save the all statements that have effect on change of
    database like insert, delete, etc. but you should be careful in executing
    binary log and delete the drop statements in case of existent.

    binary logs are accessible only in case of active status, its means is it
    must be active before dropped database.

    the command for database recovery with using binary log is:

    mysqlbinlog the_log_file > update.sql

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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