Re: a mysqldump question

2005-09-01 Thread Gleb Paharenko
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: 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

a mysqldump question

2005-08-31 Thread mbeltran
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