RE: mysqldump questions

2003-01-23 Thread Glenn Ticket
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

mysqldump questions

2003-01-22 Thread Glenn Ticket
, 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