And from the MySQL docs: ------clip-------- MySQL Version 3.23 supports tables of the new MyISAM type and the old ISAM type. You don't have to convert your old tables to use these with Version 3.23. By default, all new tables will be created with type MyISAM (unless you start mysqld with the --default-table-type=isam option). You can convert an ISAM table to MyISAM format with ALTER TABLE table_name TYPE=MyISAM or the Perl script mysql_convert_table_format. ------/clip-------
You could install this "halfway house" version or just get hold of the perl scripts 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: 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]
