« Could not bind 0.0.0.0:443 | Home | Fedora Core 2 repository »
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 »