Preserved Topic: Backup MySQL

My host doesn't have a backup button... or anything.... I'm trying to backup the database of my forum.. any clues?

KARN: Do you have access to something like cron?

___________________
Emps

FAQs: Emperor

install phpmyadmin, if you haven't already.
Choose 'dump database', 'structure and data', 'complete inserts' and the like. store the resulting file somewhere.
voila. backup.

so long,

Tyberius Prime

Hi KARN,

If you have shell access you can use the following commands to backup/restore your MySQL database:

Backup: mysqldump --add-drop-table -uUSERNAME -pPASSWORD DB > backup.txt
Restore: mysql -uUSERNAME -pPASSWORD DB < backup.txt

You can gzip backup.txt and download it to a safe place.

Regards,
Charlie

Also check with your host. Most do regular tape backups with snapshots of sites. Like with any type of system you'll lose the newest data but I bet they do have some sort of redundancy built in.

Most backup systems don't require any sort of manual hits. That's leaving too much to chance.



.:[ Never resist a perfect moment ]:.

No I don't have shell access... I'll try the other options and see how it plays out...

It's too bad you don't have shell access. I have a neat little shell script that runs via cron. It connects to MySQL, dumps the file to a gziped file above doc root, and sets permissions. I've actually got a newer version of the same script that emails the file to me as well.

But phpmyadmin will allow you to do it manually, which sounds like the only way you're going to get it to work.