You did not specify a database.
Christian Dechery wrote:
> I have problems with mysqldump, its generated output and then loading
> this dump into mysql again...
>
> it seems to me that mysql is completely crazy...
>
> mydb already exists with all the tables with data and everything... it's
> perfect...
>
> look at this, I have this command:
> mysqldump -h myhost --user=myuser --password="mypass" --add-drop-table
> --result-file="somfile.sql" mydb
>
> and it generates the dump perfectly into somefile.sql...
>
> but now I do something like:
> mysql -h myhost --user=myuser --password="mypass" -e "source
> somefile.sql" mydb // right? - WRONG!
>
> when I do this, it gives me hundreds of error messages like :
>
> ERROR 1051 at line 11 in file: '08-10-~3.sql': Unknown table agio'
> ERROR 1050 at line 12 in file: '08-10-~3.sql': Table agio already exists
> ERROR 1062 at line 27 in file: '08-10-~3.sql': Duplicate entry '1' for
> key 1
> ERROR 1051 at line 34 in file: '08-10-~3.sql': Unknown table cavalo'
> ERROR 1050 at line 35 in file: '08-10-~3.sql': Table cavalo' already exists
>
> I assure you all that ALL tables exists... another detail... in the .sql
> file there's a 'DROP ..' before each create right?
> so what I think its happening is... the DROP command isn't "finding" the
> table, then the CREATE tells me that the table already exists and
> obviously none of the INSERTS work...
>
> I'm sure this is a bug right?
> _________________________________
> .. Christian Dechery - CTO
> ... WebDeveloper @ Webstyle!
> ... http://www.webstyle.com.br
> ... http://www.tanamesa.com.br
>
>
> ---------------------------------------------------------------------
> 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 <mysql-thread87368@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Gerald L. Clark
gerald_clark@stripped
