Re: Re-attaching DB to mysql

2003-07-24 Thread Egor Egorov
Henrik Schmiediche [EMAIL PROTECTED] wrote: 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. 3.0.18? Are you sure? Can this be done? How? How did you make a backup? If you use mysqldump,

Re: Re-attaching DB to mysql

2003-07-24 Thread Nils Valentin
Braithwaite'; 'Mysql' Subject: Re: Re-attaching DB to mysql Hi Hendrik, not sure if you have already received an answer, so please ignore if you are already back on track ;-) I did not find which OS you are using , but under Linux/Unix you would need to change the ownership back to the user

Re-attaching DB to mysql

2003-07-23 Thread Henrik Schmiediche
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

RE: Re-attaching DB to mysql

2003-07-23 Thread Andrew Braithwaite
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

RE: Re-attaching DB to mysql

2003-07-23 Thread Henrik Schmiediche
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

RE: Re-attaching DB to mysql

2003-07-23 Thread Andrew Braithwaite
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

RE: Re-attaching DB to mysql

2003-07-23 Thread Henrik Schmiediche
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

RE: Re-attaching DB to mysql

2003-07-23 Thread Andrew Braithwaite
the mysql_convert_table_format script You've got me interested now - I should be doing real work instead... :) Andrew -Original Message- From: Andrew Braithwaite Sent: Wednesday 23 July 2003 20:59 To: 'Henrik Schmiediche'; 'Mysql' Subject: RE: Re-attaching DB to mysql Hi, If that backup uses the old .ISD

RE: Re-attaching DB to mysql

2003-07-23 Thread Andrew Braithwaite
' 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

Re: Re-attaching DB to mysql

2003-07-23 Thread Nils Valentin
: 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