Backing up large databases

Hey,
What's the best way to dump a huge database? Our server tends to crash at the very end of dumping... our site isn't too huge, but still pretty big (360,000+ posts). I haven't been experimenting too much simply because of not wanting to crash the site if I mess it up
- Jesse

[Erwin]

Originally Posted by Wynand

i'm letting my database back-up automatic. CRONTAB in SSH makes it automatic and removes the old ones. Every hour a backup (when forum get's bigger, possibly every minute..) and a delete of the backup of 2 days ago

Just a littel linux knowlegde :banana:

Won't work for large databases.

[Wynand]

Originally Posted by Erwin

Won't work for large databases.

:surprised:

In what way won't it work?

[Marco van Herwaarden]

I doubt that if your database is getting really big, you can afford to create a backup every minute.

More likely will be that the interval between backups will be increased when database grows.