CODEWITHSUNDEEP
mysql
user172697
user172697

Reputation: 155

mysql backup issue

I've performed 

mysqldump -uroot --add-drop-table --default-character-set=latin1 dbname >/backup/new.sql

DB 7GB issue it take tooo much and the output is still 0 size , and mysqladmin processlist show

| 8219 | root | localhost | dbname | Query   | 1413 |       | LOCK TABLES `wp_10000_comments` READ /*!32311 LOCAL */,`wp_10000_links` READ /*!32311 LOCAL

Any clue whats goin on ? logs show nothing

Upvotes: 0

Views: 116

Answers (1)

baklarz2048
baklarz2048

Reputation: 10938

as mysqlroot mysql>kill 8219;

You should dump backup on slave becouse your primary database can't handle it. If you use innodb try XtraBackup http://www.percona.com/software/percona-xtrabackup/

Upvotes: 1

Related Questions