This works perfect. Thanks !
Hi,
1) try this: GRANT SELECT, RELOAD ON *.* to dump@%
IDENTIFIED BY password;
2) in the backup file insert this line above all: SET
FOREIGN_KEY_CHECKS = 0; ... and all will be ok!
regards
I have 2 questions concerning mysqldump.
1) What grants does the user
, it causes some headache. Is there a manner in which this
can be avoided ?
I'm using mySQL 3.23.53 on a Windows 2000 environnement.
thanks in advance,
Glenn Ticket
-
Before posting, please check:
http://www.mysql.com/manual.php