database backup

[antoniofalconx11426]

I have a massive database and i was wondering how to effeciently back it up

I do a mysqldump but it slams my server with 100% cpu and im sure it clogs up my I/O

 

[ysmods]

ssh would be the best option by far

mysqldump -u username -p dbname > db_dump_filename.sql

username -> your mysql username
dbname   -> database name

You will be prompted for your database password, so have it ready

 

[antoniofalconx11426]

thats what i use but it creates the problem i mentioned.

the server cpu hits 100% and i/o gets clogged and my site is essentially is down for awhile running the command

 

[ysmods]

There is no better way of doing it, SSH is by far the best way.

Only way of reducing strain on the main web server would be to have a second/seperate database only server, with RAID10 array, so you always have a backup drive if ever the main disk fails.