Eric,
Monday, June 03, 2002, 1:49:24 AM, you wrote:
EF> I didn't get that deeply into why exactly, but it seems that when I removed
EF> the mysql database from the file, that the rest went fine with
EF> mysql -u -p <dumpfile
If you use -A option for mysqldump, mysqldump makes backup of all
databases including database 'mysql'. If you don't want to make backup
of database 'mysql' use -B option for mysqldump. Look at:
http://www.mysql.com/doc/m/y/mysqldump.html
EF> I got an error about the column_prv field already existing I believe. Sorry,
EF> I should have been much more specific. I appreciate your answering even
EF> though I was vague.
EF> I think mostly I learned my lesson, and I should export one database at a
EF> time, with --tab=
EF> Thanks,
EF> Eric
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
