List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:October 8 2001 6:35pm
Subject:Re: problems with backup/restore
View as plain text  
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

Thread
problems with backup/restoreChristian Dechery8 Oct
  • Re: problems with backup/restoreGerald Clark8 Oct
    • Re: problems with backup/restoreChristian Dechery9 Oct