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
I do a mysqldump but it slams my server with 100% cpu and im sure it clogs up my I/O
database backup
- Thread starter antoniofalconx11426
- Start date
ssh would be the best option by far
You will be prompted for your database password, so have it ready
Code:
mysqldump -u username -p dbname > db_dump_filename.sql
username -> your mysql username
dbname -> database namethats 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
the server cpu hits 100% and i/o gets clogged and my site is essentially is down for awhile running the command
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.
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.