Hi all
Yesterday I try to migrate a database from mysql version is '4.1.5-gamma' to
mysql version 3.23.45 using mysqldump:
in the source server I executed:
loki# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1955 to server version: 4.1.5-gamma-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use clasificados
Database changed
mysql> show tables;
++
| Tables_in_clasificados |
++
| ad |
| advertiser |
| advertisers|
| banners|
| category |
| favourites |
| payment|
| picture|
| template |
| user |
++
10 rows in set (0.00 sec)
mysql> show create table banners;
+-
+---
---+
| Table | Create Table
|
+-+-
-+
| banners | CREATE TABLE `banners` (
`bid` int(11) NOT NULL auto_increment,
`del` int(11) default NULL,
`cid` int(11) default NULL,
`btype` int(11) default NULL,
`filename` varchar(155) default NULL,
`goto_url` varchar(255) default NULL,
`status` int(11) default NULL,
`hits` int(11) default NULL,
`days` int(11) default NULL,
`y_day` int(11) default NULL,
`clicks` int(11) default NULL,
`added` varchar(8) default NULL,
`run_for_days` int(11) default NULL,
`run_for_hits` int(11) default NULL,
`run_for_clicks` int(11) default NULL,
`run_in_group` int(11) default NULL,
PRIMARY KEY (`bid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
+-+-
-+
1 row in set (0.00 sec)
mysql> quit
Bye
loki# mysqldump clasificados > /usr/backup/clasificados.sql
loki# ls -la /usr/backup/
total 5588
drwxr-xr-x 2 root wheel 512 Aug 30 16:06 .
drwxr-xr-x 19 root wheel 512 Aug 30 16:00 ..
-rw-r--r-- 1 root wheel 975599 Aug 30 16:05 clasificados.sql
loki# file *
clasificados.sql: UTF-8 Unicode text, with very long lines
On the target server i eexecuted this:
#/usr/local/mysql/bin/mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3816508 to server version: 3.23.45
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> create database clasificados;
Query OK, 1 row affected (0.01 sec)
mysql> quit
Bye
# /usr/local/mysql/bin/mysql clasificados < clasificados.sql
ERROR 1065 at line 7: Query was empty
# vi clasificados.sql
"clasificados.sql" Line too long
-- MySQL dump 10.7
--
-- Host: localhostDatabase: clasificados
-- --
-- Server version 4.1.5-gamma-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,
FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE="NO_AUTO_VALUE_ON_ZERO" */;
--
-- Table structure for table `ad`
--
DROP TABLE IF EXISTS `ad`;
CREATE TABLE `ad` (
`siteid` int(11) NOT NULL auto_increment,
`del` int(11) default NULL,
`sitetitle` varchar(100) default NULL,
`sitedescription` text,
`sitedate` varchar(10) default NULL,
`sitecatid` int(11) default NULL,
`sitehits` int(11) default NULL,
`sitevotes` double(6,2) default NULL,
`sitevoters` int(11) default NULL,
`sitevoters_ip` varchar(20) default NULL,
`custom_field_1` varchar(50) default NULL,
`custom_field_2` varchar(50) default NULL,
`custom_field_3` varchar(50) default NULL,
`custom_field_4` varchar(50) default NULL,
`custom_field_5` varchar(50) default NULL,
`custom_field_6` varchar(50) default NULL,
`custom_field_7` varchar(50) default NULL,
`custom_field_8` varchar(50) default NULL,
`picture` int(11) default NULL,
`img_stored` varchar(70) default NULL,
`datestamp` varchar(8) default NULL,
`f1` varchar(50) default NULL,
`f2` varchar(50) default NULL,
`f3` varchar(50) default NULL,
`f4` v