News: We have a frontpage

New to maxcoderz forum? Go here first!

Moderator: MaxCoderz Staff

User avatar
kv83
Maxcoderz Staff
Posts: 2735
Joined: Wed 15 Dec, 2004 7:26 pm
Location: The Hague, Netherlands
Contact:

Post by kv83 »

hmmm... we still get some db error's and it seems that some posts have been dissapeared :( I repaired the post table, but don't whether that'll do it or not. let's hope so.
Image
User avatar
benryves
Maxcoderz Staff
Posts: 3087
Joined: Thu 16 Dec, 2004 10:06 pm
Location: Croydon, England
Contact:

Post by benryves »

Do you back up the database (I mean you, personally, not your host)?
It's fairly trivial to do; if you have MySQL installed locally, you can do this:

mysqldump -uusername -ppassword -hhost databasename > backup.sql

Restoring it is simple:

mysql -uusername -ppassword -hhost databasename < backup.sql

You can write a basic batch script (.cmd file) that uses the time as the filename, and then add that batch script as a scheduled task to automatically run on an hourly/daily/weekly backup.
User avatar
kv83
Maxcoderz Staff
Posts: 2735
Joined: Wed 15 Dec, 2004 7:26 pm
Location: The Hague, Netherlands
Contact:

Post by kv83 »

I do backup it once a week.
Image
Andy_J
Calc Master
Posts: 1110
Joined: Mon 20 Dec, 2004 10:01 pm
Location: In the state of Roo Fearing
Contact:

Post by Andy_J »

benryves wrote:Do you back up the database (I mean you, personally, not your host)?
It's fairly trivial to do; if you have MySQL installed locally, you can do this:

mysqldump -uusername -ppassword -hhost databasename > backup.sql

Restoring it is simple:

mysql -uusername -ppassword -hhost databasename < backup.sql

You can write a basic batch script (.cmd file) that uses the time as the filename, and then add that batch script as a scheduled task to automatically run on an hourly/daily/weekly backup.
Any sane webhost wouldn't allow remote MySQL access...
ImageImage
Image
Post Reply