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
Most Popular Articles
How to create my MySQL database?
After you are done with the database creation you can use the phpMyAdmin tool to manipulate the...
MySQL Database info: username, password, hostname, database name
Your MySQL database username - is the same as your Control Panel username. our MySQL database...
MySQL administration with phpMyAdmin
MySQL administration with phpMyAdmin NOTE: If You Have Purchased Hosting From Us Your...
MS Access
MS Access is typically used in conjunction with Windows servers running a MSSQL database. We do...
Maximum number of databases per hosting account
By default our hosting accounts come with a maximum of 50 databases per account. If for any...
