Top "Mysqldump" questions

Skip or ignore definers in Mysqldump

I was wondering if I can prevent mysqldump inserting this commands /*!50017 DEFINER=`root`@`localhost`*/ Or if I have to do …

mysql mysqldump database-backups

mysqldump | mysql yields 'too many open files' error. Why?

I have a RHEL 5 system with a fresh new hard drive I just dedicated to the MySQL server. To get …

mysql mysqldump rhel

Adding the time to mysqldump cron job?

The following works: /usr/bin/mysqldump -u[username] -p[password] --all-databases --single-transaction > /home/[domain]/public_html/backups/full_backup_`…

unix cron mysqldump cron-task

How to restore data from MYSQL dump without any duplicate key errors?

Everytime I try restoring the dump, I get : ERROR 1062 (23000) at line 10297: Duplicate entry 'spaß' for key 'PRIMARY' I am …

mysql mysqldump mysql-error-1062

mysqldump without "CREATE ALGORITHM" and "DEFINER"

In my database backups and export I get something like the following: /*!50001 DROP TABLE `vTime`*/; /*!50001 DROP VIEW IF EXISTS `vTime`*/; /*!50001 …

mysql mysqldump database-backups