I have 2 questions concerning mysqldump. 1) What grants does the user need to have to perform a dump: if I want to create a user which is only used to perform database dumps (in scripts), which priviliges does it need ?
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). This is easily fixed for a small database (with a few cut and pastes), but is the database gets complex, 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 (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
