Results 1 to 10 of 10

Thread: recove the delete data

  1. #1
    Join Date
    Jul 2003
    Posts
    421

    recove the delete data

    Daer all,
    our db is mysql install on solaris, someone delete it, is taht possible to recove it ?
    ________
    Extreme Vaporizer
    Last edited by sql; 03-06-2011 at 02:11 AM.

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932

  3. #3
    Join Date
    Sep 2002
    Posts
    5,938
    Deleted db or deleted data in the db? Restoring from backup is the only way if deleted db.
    Last edited by rmiao; 12-29-2009 at 11:53 AM.

  4. #4
    Join Date
    Jul 2003
    Posts
    421
    not, for a lot of reasons , but I hear something like binary -log , but I couldn't found it
    please help!
    ________
    Orlando
    Last edited by sql; 03-06-2011 at 02:12 AM.

  5. #5
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Binary log cotains transactional details, and it is not required to be enabled. It may not be turned on.

    You can't read a binary log.

  6. #6
    Join Date
    Jul 2003
    Posts
    421
    Than , how can I turn it on? if my db is install on solaris 10?
    ________
    Hawaii Medical Marijuana
    Last edited by sql; 03-06-2011 at 02:12 AM.

  7. #7
    Join Date
    Sep 2002
    Posts
    5,938
    It's too late to recover deleted data, maybe help if same thing happens again.

  8. #8
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    There is an utility to read binary log if you have it

    http://dev.mysql.com/doc/refman/5.1/en/mysqlbinlog.html

    You need to modify your mysql ini file with

    --log-bin[=base_name]

    then restart it.

  9. #9
    Join Date
    Jul 2003
    Posts
    421
    Quote Originally Posted by skhanal View Post
    There is an utility to read binary log if you have it

    http://dev.mysql.com/doc/refman/5.1/en/mysqlbinlog.html

    You need to modify your mysql ini file with

    --log-bin[=base_name]

    then restart it.
    thank you, but I need to mysql.ini lpcal.
    my db is install on
    /opt/mysql/mysql
    ________
    Toyota Fchv Specifications
    Last edited by sql; 03-06-2011 at 02:12 AM.

  10. #10
    Join Date
    Nov 2013
    Posts
    5
    With all respect, I use a database recovery software and ever works fine.

Posting Permissions

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