HiveBrain v1.2.0
Get Started
← Back to all entries
snippetsqlMinor

How to backup live mysql database?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
databaselivemysqlhowbackup

Problem

I have 12 GB MySQL InnoDB Database with around 800 queries per second. No sooner I start 'mysqldump' over it to make backup I start getting '503' on my website.

How do I make backup of my live database without affecting the site performance?

Solution

try the following command since the database size is not small:

mysqldump -u USER -p --single-transaction --quick --lock-tables=false --all-databases (or) DATABASE | gzip > OUTPUT.gz

Code Snippets

mysqldump -u USER -p --single-transaction --quick --lock-tables=false --all-databases (or) DATABASE | gzip > OUTPUT.gz

Context

StackExchange Database Administrators Q#84223, answer score: 6

Revisions (0)

No revisions yet.