-
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.
-
-
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.
-
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.
-
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.
-
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.
-
It's too late to recover deleted data, maybe help if same thing happens again.
-
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.
-
Originally Posted by skhanal
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.
-
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
-
Forum Rules
|
|