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. http://www.kwinternet.com/eric (250) 655 - 9513 (PST Time Zone) "Inquiry is fatal to certainty." -- Will Durant --------------------------------------------------------------------- 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