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-
>
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
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-
> Fro
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 DB,
KEY Load (IL,Item_ID)-> UNIQUE KEY (IL,Item_ID)
I think this could be a bug, because as a matter of fact I wouldn't be able to rebuild
our DB in case of crash without editing the SQL Backup file generated by mysqldump,
which is really dangerous.
Is really urgent for us to solve
