WTB method of backing up a large forum database?

[DoctorX]

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


thanks

DoctorX Reviewed by DoctorX on 10th Apr 2011. WTB method of backing up a large forum database? Hello, is there any good way to backup a large forum databse? thanks Rating: 5

[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

[Gavo]

http://www.besthostingforums.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

[vgnheart]

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