Import of MySQL 3.23 DB in MySQL 5

Please refer to the following information for exporting it properly (which can be done ONLY at the 3.23 server), and converting it to applicable format for MySQL 5 import.

Also note that before exporting you MUST convert the tables to MyISAM engine.

On the OLD system:

1: Dump out the tables

$ mysqldump --add-drop-table --add-locks --all --quick --lock-tables mydatabase > mydatabase.sql

2: Convert from Latin1 character encoding to UTF8

$ iconv -f latin1 -t utf8 < mydatabase.sql > mydatabase\_utf8.sql

3: Update auto\_increment SQL definitions

$ sed -e "/auto\_increment/ s/DEFAULT '0'//" database\_utf8.sql > mydatabase\_utf8\_filtered.sql

4: Transfer the file to the new system

On the NEW system:

5: Create a SQL header lines with this content into a file called 'sql\_headers'.:

set names utf8; drop database if exists mydatabase; create database mydatabase\_inv character set utf8; use chem\_mydatabase

6: Remove the leading comments on the SQL file
Strip everything down to the first real SQL statement.

`-- MySQL dump 8.22
--
-- Host: localhost Database: mydatabase

---

-- Server version 3.23.54

--
-- Table structure for table 'table1'
--`

7: Load the SQL into your database

cat sql\_headers mydatabase\_utf8.sql | mysql -u root -p