Search & Replace
update tablename set field = replace(field,'search_for_this','replace_with_this');
Never been to TextSnippets before?
Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world (or not, you can keep them private!)
About this user
Sasha http://nothing-less.net
How To Fix MySQL Error 28
MySQL: 1030: got error 28 from server handler
Delete anything that�s not supposed to be there.
Stop all databases:
Then fix tables:
Check each letter for errors:
Repair where necessary:
Turn everything back on:
cd /tmp df -i /tmp df -h /tmp
Delete anything that�s not supposed to be there.
Stop all databases:
/etc/rc.d/init.d/chkservd stop /etc/rc.d/init.d/mysql stop
Then fix tables:
cd /var/lib/mysql
Check each letter for errors:
myisamchk -cs a*/*.MYI
Repair where necessary:
myisamchk -r a*/*.MYI myisamchk -r b*/*.MYI myisamchk -r c*/*.MYI myisamchk -r d*/*.MYI myisamchk -r e*/*.MYI myisamchk -r f*/*.MYI myisamchk -r g*/*.MYI myisamchk -r h*/*.MYI myisamchk -r i*/*.MYI myisamchk -r j*/*.MYI myisamchk -r k*/*.MYI myisamchk -r l*/*.MYI myisamchk -r m*/*.MYI myisamchk -r n*/*.MYI myisamchk -r o*/*.MYI myisamchk -r p*/*.MYI myisamchk -r q*/*.MYI myisamchk -r r*/*.MYI myisamchk -r s*/*.MYI myisamchk -r t*/*.MYI myisamchk -r u*/*.MYI myisamchk -r v*/*.MYI myisamchk -r w*/*.MYI myisamchk -r x*/*.MYI myisamchk -r y*/*.MYI myisamchk -r z*/*.MYI
Turn everything back on:
/etc/rc.d/init.d/chkservd start /etc/rc.d/init.d/mysql start