1. dump all database into backup file<\/p>\n
mysqldump –opt \u00a0–all-databases > \/tmp\/databkup<\/p>\n
(–opt includes lock table option)<\/p>\n
2. dump several databases<\/p>\n
mysqldump –opt\u00a0–databases db1 db2 db3 > \/tmp\/databkup<\/p>\n
3. dump single table<\/p>\n
mysqldump –opt db1 table1\u00a0> \/tmp\/databkup<\/p>\n
Touble shooting
\nError: Access denied for user x@y to database z when using lock tables
\nmysqldump -u username -p database –single-transaction >dump.sql<\/p>\n
User tar to back up db<\/p>\n
mysql>\u00a0FLUSH TABLES WITH READ LOCK;<\/p>\n
(This will lock the db so it won’t be updated by other threads. Write threads by other process will wait till the lock is released)<\/p>\n
#tar cvzf \/var\/tmp\/datadump.tgz \/var\/lib\/mysql\/*<\/p>\n
mysql>\u00a0UNLOCK TABLES;<\/p>\n
1. dump all database into backup file mysqldump –opt \u00a0–all-databases > \/tmp\/databkup (–opt includes lock table option) 2. dump several databases mysqldump –opt\u00a0–databases db1 db2 db3 > \/tmp\/databkup 3. dump single table mysqldump –opt db1 table1\u00a0> \/tmp\/databkup Touble shooting Error: … Continue reading