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 --- Glenn Ticket <[EMAIL PROTECTED]> ha scritto: > > 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 > ______________________________________________________________________ Yahoo! Cellulari: loghi, suonerie, picture message per il tuo telefonino http://it.yahoo.com/mail_it/foot/?http://it.mobile.yahoo.com/index2002.html --------------------------------------------------------------------- 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
