03 10:19 PM
> To: Henrik Schmiediche; 'Andrew 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
"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 mys
2003年 7月 24日 木曜日 04:05、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&#
ndrew 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 cur
pts and run 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:
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
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
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
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 on
