The mysqldump you use doesn't include the "create databease" so you'll need to create the henrik DB on the new install. If you keep running it over and over, it will keep inserting the same records over and over again and you'll end up with duplicates. The thing to do is start with an empty db (call it whatever you like) and run the restore just once. This should give you a nice clean backup restore to then do whatever you want with...
Andrew -----Original Message----- From: Henrik Schmiediche [mailto:[EMAIL PROTECTED] Sent: Wednesday 23 July 2003 21:07 To: Andrew Braithwaite; 'Mysql' Subject: RE: Re-attaching DB to mysql Thanks for the reply. I started a mysql v3 on a new system with the old "backup" data directory and type: mysqldump -p henrik > henrik.sql This dumps the DB? To restore, I move henrik.sql to the current 4.0.14 server and type: mysql -p henrik < henrik.sql except it complains the DB does not exists. I can create the DB in Mysql 4 and then restore (and it works), but it is not clear to me I will have restored everything properly. Sincerely, - Henrik -----Original Message----- From: Andrew Braithwaite [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 2:59 PM To: 'Henrik Schmiediche'; 'Mysql' Subject: RE: Re-attaching DB to mysql Hi, If that backup uses the old ".ISD & .ISM" architecture then I would install an old version of MySQL, copy these files into the data dir of that installation and mysqldump them to a file ready for import into your new MySQL v4 install. I'm not aware of any scripts to just munge the old style data into the new but I'm happy to be corrected on that! Cheers, Andrew -----Original Message----- From: Henrik Schmiediche [mailto:[EMAIL PROTECTED] Sent: Wednesday 23 July 2003 20:05 To: Andrew Braithwaite; 'Mysql' Subject: RE: Re-attaching DB to mysql Copy of the data files :-( - Henrik -----Original Message----- From: Andrew Braithwaite [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 2:04 PM To: 'Henrik Schmiediche'; 'Mysql' Subject: RE: Re-attaching DB to mysql Is the backup a mysqldump or a copy of the data files? Andrew -----Original Message----- From: Henrik Schmiediche [mailto:[EMAIL PROTECTED] Sent: Wednesday 23 July 2003 19:48 To: 'Mysql' Subject: Re-attaching DB to mysql Hello, I have a backup of a mysql v3.0.18 DB. I need to extract one of the DB's from that backup and place it into my current production v4.0.14 mysql DB. Can this be done? How? Sincerely, - Henrik -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
