You are loading all databases, but the security database (mysql) is already there. Assuming you are starting with nothing and restoring all databases that the server knows about, one method that works is to start the server with --skip-grant-tables, then load the dump file, then flush privileges. This will restore the security settings. At least, it works for me. (I have --add-drop-tables when I dump; presumably it would work to drop or delete the mysql database manually.)
There's also a -o switch in the mysql client which says only update one database. I haven't succeeded in making it work. > Date: Sun, 02 Jun 2002 18:49:24 -0400 > To: Benjamin Pflugmann <[EMAIL PROTECTED]> > From: Eric Frazier <[EMAIL PROTECTED]> > Subject: Re: mysqldump -A >dump.txt > > Hi, > > I didn't get that deeply into why exactly, but it seems that when I removed > the mysql database from the file, that the rest went fine with > mysql -u -p <dumpfile > > I got an error about the column_prv field already existing I believe. Sorry, > I should have been much more specific. I appreciate your answering even > though I was vague. > > I think mostly I learned my lesson, and I should export one database at a > time, with --tab= > > > Thanks, > > > Eric > > At 01:52 AM 6/3/02 +0200, Benjamin Pflugmann wrote: > >Hi. > > > >Which version of mysqldump did you use and what error message do you > >get? > > > >I have never used mysqldump this way but from what I read in the help > >of mysqldump 3.23.31, mysqldump should insert the necessary SQL > >statements regarding changing and creating the databases (if they do > >not already exist). > > > >Bye, > > > > Benjamin. --------------------------------------------------------------------- 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
