Hello.
> Yesterday I try to migrate a database from mysql version is '4.1.5-gamma' to > mysql version 3.23.45 using mysqldump: >................................................. > loki# mysqldump clasificados > /usr/backup/clasificados.sql You should remove column and table options. Some of them are new in 4.1 and aren't present in 3.23. Perform a dump using --compatible=mysql323 command line option. If it doesn't help, specify the necessary options manually (like --compatible=no_table_options,no_field_options --skip-opt). See: http://dev.mysql.com/doc/mysql/en/mysqldump.html Migrating from 4.1.x to 3.23.x usually isn't a good idea. Why don't you want to use the latest release (4.1.14 now)? [EMAIL PROTECTED] wrote: > 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. > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
