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,
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
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
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
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
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
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
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
'
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
:
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
10 matches
Mail list logo