RE: MYSQL freezing

You could use something like : mysqldump -Q --opt -F --all-databases -h serverName -u root --password=yourpasswd /some/where/backup.sql It generates a SQL commands file able to completely rebuild the DB, e.g. after a mysql_install_db command. Ciao, Stefano -Original Message- From:

RE: shell script to backup

You could use something like : mysqldump -Q --opt -F --all-databases -h serverName -u root --password=yourpasswd /some/where/backup.sql It generates a SQL commands file able to completely rebuild the DB, e.g. useful after a mysql_install_db command. Ciao, Stefano -Original Message-

RE: backup

Try useing something like : mysqldump -Q --opt -F --all-databases -h serverName -u root --password=yourpasswd /some/where/backup.sql It generates a SQL commands file able to completely rebuild the DB, e.g. useful after a mysql_install_db command. Ciao, Stefano -Original Message-

RE: MySQL dump/recovery - no bug at all

Thank you very much for your quick and accurate responses. I tried to dump with the -Q (--quote-names) and it perfectly works. I'm not completely sure I understood what Tod Harter meant in his mail, because I set up an 'automated' backup process, and if I would ever need to recovery our main