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: localhost Database: 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` varchar(50) default NULL, `f5` varchar(50) default NULL, `f6` varchar(50) default NULL, `f7` varchar(50) default NULL, `f8` varchar(50) default NULL, `f9` varchar(50) default NULL, `f10` varchar(50) default NULL, `f11` varchar(50) default NULL, `f12` varchar(50) default NULL, `f13` varchar(50) default NULL, `f14` varchar(50) default NULL, `f15` varchar(50) default NULL, `ad_username` varchar(50) default NULL, `valid` tinyint(4) default NULL, `expire_days` int(11) default NULL, `sold` tinyint(4) default NULL, `notify` int(11) default NULL, `is_special` int(11) default NULL, PRIMARY KEY (`siteid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `ad` -- /*!40000 ALTER TABLE `ad` DISABLE KEYS */; LOCK TABLES `ad` WRITE; What should I do for solve this problem?. Thanks in advance. Best regards. Mario. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
