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 need to have to perform >> a dump ? >> >> 2) I'm using innoDB tables to be able to use foreign >> keys. Unfortunatly mysqldump seems to dump the >> tables in alphabetical order, which results in error >> when one tries to restore a database from this dump >> (due to references to tables which don't exist yet). --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php