mysql ...corrupt DB what are the options and what prevention for the future. - GoFuckYourself.com

longdongsilver · 11-18-2008, 12:58 PM

Ok it seems my stxt database has some kind of corruption that the host says can't be fixed. Even the old backups will not restart for some reason, apparently corrupt too.

What can be done aside from deleting entire thing and starting again?
what can be done to prevent it just all happening all over again?
Is mysql prone to this kind of thing happening?

what other gallery rotator scripts (that dont use mysql) are available?

woj · 11-18-2008, 01:05 PM

you probably need a new host, not a new script...

who do you host with now?

AnniKN · 11-18-2008, 01:09 PM

I can try and fix your database, if you have a dump hit me up. (No charge)

Fortress-Jay · 11-18-2008, 01:51 PM

What you need is real time hot backups of your mysql database so if it gets corrupted you can roll back to minutes or hours before the corruption.

rowan · 11-18-2008, 01:55 PM

The only time I've had corruption issues with mysql is when there's been a violent shutdown, in other words something like an operating system panic or a lockup, which means any pending data hasn't been fully written out to the file system. On reboot the OS fixes up the file system as best as it can but that often does result in a loss of some data, and not always just the stuff that was sitting in RAM waiting to be flushed to disk.

I agree with woj, sounds like your host wasn't really on top of things (assuming they manage your server), unless the corruption has been around for long enough that all of the non corrupt backups have rotated out.

longdongsilver · 11-18-2008, 02:12 PM

thanks for helpful replies, you guys are correct i got it going again.

The guys at stxt really do know their stuff and once i forwarded their step by step guide to the host regarding how to fix a mysql database with innodb errors. It all started working again fine. The host it seems was just trying to restart mysql from an old backed up version but they were not deleting the innodb files first ....or something like that.

However it does seem mysql with any script is open to fucking up now and then so a more regular db backup have been scheduled.

longdongsilver · 11-18-2008, 02:13 PM

Quote:

Originally Posted by AnniKN

I can try and fix your database, if you have a dump hit me up. (No charge)

also a very big thanks to you for this offer, that was very kind of you. thanks

Godsmack · 11-18-2008, 03:20 PM

Resolved, thanks for the kind words!

u-Bob · 11-18-2008, 04:38 PM

who's the host?

dready · 11-18-2008, 05:03 PM

Backups.

AnniKN · 11-18-2008, 05:14 PM

Glad to hear it's working again

and no prob! always glad to help

Owen Pierce · 11-19-2008, 02:06 AM

Heh yeah, anything can corrupt. backups are crucial.
one backup option would be to setup a master/slave setup on mysql. then you get instant backups to any slave(s) you have setup. And of course if those are on different machines, you can take advantage of that whole situation for speed.
but yeah, multiple computer backups are the bare minimum.

Or have mysql do an UpdateLog and setup a cron to process those queries into a backup database (prolly should be myisam if it's on the same computer, so that its not in the innodb file). and clear the log. Cuz that baby will get HUGE

11-18-2008, 12:58 PM	#1
longdongsilver Confirmed User Join Date: Aug 2003 Posts: 378	mysql ...corrupt DB what are the options and what prevention for the future. Ok it seems my stxt database has some kind of corruption that the host says can't be fixed. Even the old backups will not restart for some reason, apparently corrupt too. What can be done aside from deleting entire thing and starting again? what can be done to prevent it just all happening all over again? Is mysql prone to this kind of thing happening? what other gallery rotator scripts (that dont use mysql) are available?

11-18-2008, 01:05 PM	#2
woj <&(©¿©)&> Industry Role: Join Date: Jul 2002 Location: Chicago Posts: 47,882	you probably need a new host, not a new script... who do you host with now? __________________ Custom Software Development, email: woj#at#wojfun#.#com to discuss details or skype: wojl2000 or gchat: wojfun or telegram: wojl2000 Affiliate program tools: Hosted Galleries Manager Banner Manager Video Manager Wordpress Affiliate Plugin Pic/Movie of the Day Fansign Generator Zip Manager

11-18-2008, 01:09 PM	#3
AnniKN Confirmed User Industry Role: Join Date: Feb 2008 Location: South of the border Posts: 1,682	I can try and fix your database, if you have a dump hit me up. (No charge) __________________ StraponCash \| HDPays Need affordable Photo Retouching, Video Editing, Design, Coding, Writing or Data Entry? 435-155-252

11-18-2008, 01:51 PM	#4
Fortress-Jay Registered User Join Date: Jul 2007 Location: NJ Posts: 29	What you need is real time hot backups of your mysql database so if it gets corrupted you can roll back to minutes or hours before the corruption. __________________ Jay Silver Owner \| 103463692 \| jason [at] fortressitx.com __________________________________________ FortressITX Experience what FULLY MANAGED really means!! Ask about our BONDED!! 2gbps multi-switch servers!!

11-18-2008, 03:20 PM	#8
Godsmack Confirmed User Industry Role: Join Date: Apr 2004 Location: The Netherlands Posts: 4,525	Resolved, thanks for the kind words! __________________ Download the much improved Free Tube Script adult/mainstream tube solution for FREE!

11-18-2008, 01:55 PM	#5
rowan Too lazy to set a custom title Join Date: Mar 2002 Location: Australia Posts: 17,393	The only time I've had corruption issues with mysql is when there's been a violent shutdown, in other words something like an operating system panic or a lockup, which means any pending data hasn't been fully written out to the file system. On reboot the OS fixes up the file system as best as it can but that often does result in a loss of some data, and not always just the stuff that was sitting in RAM waiting to be flushed to disk. I agree with woj, sounds like your host wasn't really on top of things (assuming they manage your server), unless the corruption has been around for long enough that all of the non corrupt backups have rotated out.

11-18-2008, 02:12 PM	#6
longdongsilver Confirmed User Join Date: Aug 2003 Posts: 378	thanks for helpful replies, you guys are correct i got it going again. The guys at stxt really do know their stuff and once i forwarded their step by step guide to the host regarding how to fix a mysql database with innodb errors. It all started working again fine. The host it seems was just trying to restart mysql from an old backed up version but they were not deleting the innodb files first ....or something like that. However it does seem mysql with any script is open to fucking up now and then so a more regular db backup have been scheduled.

11-18-2008, 04:38 PM	#9
u-Bob there's no $$$ in porn Industry Role: Join Date: Jul 2005 Location: icq: 195./568.-230 (btw: not getting offline msgs) Posts: 33,063	who's the host?

11-18-2008, 05:03 PM	#10
dready Confirmed User Industry Role: Join Date: Oct 2002 Location: Toronto, ON Posts: 5,247	Backups. __________________ ICQ: 91139591

11-18-2008, 05:14 PM	#11
AnniKN Confirmed User Industry Role: Join Date: Feb 2008 Location: South of the border Posts: 1,682	Glad to hear it's working again and no prob! always glad to help __________________ StraponCash \| HDPays Need affordable Photo Retouching, Video Editing, Design, Coding, Writing or Data Entry? 435-155-252

11-19-2008, 02:06 AM	#12
Owen Pierce Registered User Join Date: Dec 2007 Posts: 95	Heh yeah, anything can corrupt. backups are crucial. one backup option would be to setup a master/slave setup on mysql. then you get instant backups to any slave(s) you have setup. And of course if those are on different machines, you can take advantage of that whole situation for speed. but yeah, multiple computer backups are the bare minimum. Or have mysql do an UpdateLog and setup a cron to process those queries into a backup database (prolly should be myisam if it's on the same computer, so that its not in the innodb file). and clear the log. Cuz that baby will get HUGE __________________ Models/Agency search: http://strongthread.com