« | Home | »

Backup mysql with many tables >1000

By Robin | juli 7, 2007

When your mysql has many tables you could get an error of LOCK TABLES to solve this you can try two things:

1) use the option –skip-lock-tables in mysqldump

2) edit /etc/my.cfg and add following line under category [mysqld]: open_files_limit=16384

After 2 restart mysql!

Topics: Linux | No Comments »