Urgent: Any way to undelete data?

[LondonBoy]

Hi,

I have some data that was accidentely deleted in mysql.

Is there any way I can retrieve it?

[eak]

do you host the server your self or do you pay someone to do it?
if you pay for hosting, they may have a backup system. You would need to
contact them.

[LondonBoy]

ok thanks

on another note, perhaps i should be creating another thread but..
i did a search and didn't find anything

what's the best way to back up your mysql database?
Is it backing up the database itself or doing an complete backup of the server itself.

What is normally done to a daily backup?

thanks

[eak]

MySQLdump is what you want to look at.
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

[guelphdad]

also look into mysqlhotcopy it will allow you to copy your data from a running database. to get an accurate copy of your database using mysqldump you must stop the server.