WTB method of backing up a large forum database?

[DoctorX]

Hello,
is there any good way to backup a large forum databse?


thanks

 

[what4]

I would recommend mysql dumper works great for me

 

[sloddl]

for mysql use bigdump i think that it's the best and easiest way.

 

[XSLTel]

mysql -u username -p password database-name > database-name.sql | gzip -9 database-name.sql

if you have SSH of course

 

[Tango]

http://www.wjunction.com/showthread.php?t=68088

 

[DoctorX]

I would recommend mysql dumper works great for me

mysql dumper cause freezing of my server maybe cause my db is large.

for mysql use bigdump i think that it's the best and easiest way.

i didn't use this script before, i'll try it.

mysql -u username -p password database-name > database-name.sql | gzip -9 database-name.sql

if you have SSH of course

does this method valid for forum database with utf encode?
or it may cause a problem?

thanks

 

[ladykiller88]

Backup via SSH valid for all encode

 

[edwart]

Big dump has always worked for me so has SSH

 

[Cheetah]

if you got root access. then locate mysql folder and take a copy of all *.MYI files in it.
if u want, u can gzip entire folder content. going for mysqldump is bad idea as it will take more time and more resource

 

[ThreeNF]

buy a backup server, contact your provider

 

[DoctorX]

thank you all.
i'll try to use the ssh method.

regards.

 

[rapidleech]

maybe i'm not remembering correctly but i thought BigDump was useful only for large database import, not for export. Use mysqldumper for export.