zeldor.biz

Linux, programming and more

Copyright © 2023
Log in

MySQL Dump

October 11, 2011 by Igor Drobot Leave a Comment


Collection of some MySQL commands, very useful to create and restore MySQL-Backups.
[Read more…]

Filed Under: Debian, Linux, MySQL Tagged With: MySQL, MySQL Backup, MYSQL Dump, mysqldump, mysqldumper

MySQL: Error 1016 when using LOCK TABLES

August 8, 2011 by Igor Drobot 2 Comments

I run a nightly mysqldump of all my databases and one of them has over 500 tables, mysqldumper bring me a error while processing this huge database: [Read more…]

Filed Under: Linux, MySQL Tagged With: MySQL, mysqldump, single-transaction, skip-lock-tables