Are binary logs enabled for mySQL? (accidental database deletion)

[gotskott]

I was wondering if binary logs are turned on for mysql databases at bluehost? Apparently I accidentally deleted a database today, so contacted support, and they said the most recent daily backup was April 1st. :eek: Obviously very downheartening.

If binary logs are enabled, though, I think I'd be able to get a list of changes I made since April 1st and reinstate them once the database is restored. Is this possible or am I out of luck?

[charlesgan]

:( the last site backup is 1st april??

ok, seem like there is nothing you can do to restore it.
unless you do your own site backup. i do this once a week.

[gotskott]

:( the last site backup is 1st april??
The last daily was April 1st, yeah. The last full backup, apparently, was September 2006.

ok, seem like there is nothing you can do to restore it.
unless you do your own site backup. i do this once a week.
Yes, I think I'll start doing that too. For some reason, I figured that BH was doing weekly full backups and daily incremental backups.

So, no binary logs?

On the positive side, I still had some of the wiki pages open in my browser, so I was able to get a snapshot of some of the data I lost. A little bit anyway.

[felgall]

Web hosts do backups for their own purposes. If they happen to have a backup that matches your requirements then you will be extremely fortunate as even where they do have a backup at an appropriate date it may be in a format that would require restoring everything on the server rather than just the files you want and so would not be usable to restore just the files you want.

You should always perform your own backups of your site for your own purposes. I have a mostly static site and have multiple complete copie of all of the static pages on my own computer and perform database backups every few weeks (the database content doesn't change very frequently so this is sufficient for my purposes).

[TaraAthan]

I was wondering if binary logs are turned on for mysql databases at bluehost?

This question was never answered directly. Does anyone know if binary logs are enabled? I am trying to set up incremental backups and as I understand it, binary logs are required in order to do this (using mysqldump).

[fseyferth]

from http://dev.mysql.com/doc/refman/5.0/en/binary-log.html



Running the server with the binary log enabled makes performance about 1% slower. However, the benefits of the binary log for restore operations and in allowing you to set up replication generally outweigh this minor performance decrement.

would bluehost consider turning it on?

regards, friso

[Early Out]

would bluehost consider turning it on?You'd have to ask BH. This is a user-to-user forum, so we don't know.

[cade]

Bluehost doesn't run MySQL's binary log feature. The performance toll generally isn't worth it (MySQL estimates it at 1%, but it is usually greater in large multi-user setups). Bluehost is usually looking for ways to speed up MySQL, not slow it down.