New answers tagged mysqldump
Sounds like a broken mysql upgrade. I would suggest to try : mysql_upgrade -u root -h localhost -p --verbose --force and then /etc/init.d/mysql restart Finally, try again :)
It is not possible to estimate the storage required for the live database without knowing anything about the indexes in use. Each index is essentially a map, and the more "keys" to the map, the more storage space is required for that map. Cardinality of the index (the data "shape", essentially number of unique "keys" and how they map on to rows containing ...
You are redirecting the wrong way. Your command, as written, writes stdout of the mysql process to your .sql file. Give that angle brace a 180 degree spin and give 'er another try.
'performance_schema' is a virtual database so you don't have to backup it (see http://dev.mysql.com/doc/refman/5.5/en/performance-schema.html ) to skip it in your backup script use it like this: #!/bin/sh BAK=/var/backups/mysql/ DATE=$(date +%Y-%m-%d) MYSQLPATH=/var/lib/mysql/ for i in /var/lib/mysql/*/; do if [ $i != "$MYSQLPATH"'performance_schema/' ...
Top 50 recent answers are included