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
mysqldump -u username -p dbname > db_dump_filename.sql
username -> your mysql username
dbname -> database name