recove the delete data

Daer all,
our db is mysql install on solaris, someone delete it, is taht possible to recove it ?
________
Extreme Vaporizer

Do you have a backup?.

Deleted db or deleted data in the db? Restoring from backup is the only way if deleted db.

not, for a lot of reasons , but I hear something like binary -log , but I couldn't found it
please help!
________
Orlando

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

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.

Quote:

---

Originally Posted by skhanal

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

With all respect, I use a database recovery software and ever works fine.