hello peter,
I used this command to dump the data bases
mysqldump -u root -p [database] > [filename.sql]
and for restoring i used
mysql -uUSERNAME -p newdbname < /path/to/dump.sql
with all databases i got this kind of errors in different lines:
ERROR 1062 (23000) at line 377726: Duplicate Entry 'anychars' for key 2
<br><br><br>>From: "Peter Normann"
<[EMAIL PROTECTED]><br>>To: "'yousef albarak'"
<[EMAIL PROTECTED]>,<mysql@lists.mysql.com><br>>Subject:
RE: how do i solve this problem?<br>>Date: Sun, 7 Aug 2005 00:15:10
+0200<br>>MIME-Version: 1.0<br>>Received: from ns2.normann.com
([213.150.43.3]) by mc9-f37.hotmail.com with Microsoft
SMTPSVC(6.0.3790.211); Sat, 6 Aug 2005 15:13:57 -0700<br>>Received:
(qmail 28884 invoked from network); 6 Aug 2005 22:13:56
-0000<br>>Received: from unknown (HELO pete) (213.150.43.6) by 0 with
SMTP; 6 Aug 2005 22:13:56 -0000<br>>X-Message-Info:
JGTYoYF78jE3gaqpW0efowpiwFez1prXm+3jKup1Uzs=<br>>X-Mailer: Microsoft
Office Outlook, Build 11.0.6353<br>>X-MimeOLE: Produced By Microsoft
MimeOLE V6.00.2900.2670<br>>Thread-Index:
AcWaxT4JENlylcVPQUCkNiDdzMvnVAADrODg<br>>Return-Path:
[EMAIL PROTECTED]<br>>X-OriginalArrivalTime: 06 Aug 2005 22:13:57.0748
(UTC) FILETIME=[23FD6340:01C59AD4]<br>><br>>Sounds like you are trying
to import records already present on server B.<br>><br>>You might want
to add drop table in your dump...<br>><br>>Something
like:<br>><br>>mysqldump --complete-insert --extended-insert
--add-drop-table<br>><databasename><br>><br>>Peter
Normann<br>><br>>yousef albarak wrote:<br>> > hi,<br>> > I
am try to restore many databases from server A to<br>> > server B,but
when with every database i got this error(s)<br>> > mysql error:
Duplicate entry '65535' for key 1<br>> ><br>> > mysql error
number: 1062<br>> ><br>> > It happen with all databases in
different lines.<br>> ><br>> > Is there any solution for this
errors?<br>> ><br>> > Regards,<br>> > Yousef<br>>
><br>> >
_________________________________________________________________<br>>
> Express yourself instantly with MSN Messenger! Download<br>> >
today it's FREE!<br>> >
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/<br>><br>
_________________________________________________________________
Don't just search. Find. Check out the new MSN Search!
http://search.msn.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
