If you skip the extend insert during mysqldump ,the process of the restore
is painful.
On Fri, Mar 21, 2008 at 5:05 AM, dr_pompeii <[EMAIL PROTECTED]> wrote:
>
> Hi Rolando
>
> thanks for the reply
> it works, thanks,
>
> new command used
>
> mysqldump --opt --skip-extended-insert --password=XXX --user=root somedb >
> /home/Someuser/somepath/A.sql
>
> but i see one difference
>
> from windows
>
> /*!40000 ALTER TABLE `articulo` DISABLE KEYS */;
> INSERT INTO `articulo`
>
> (`idArticulo`,`descripcion`,`stockactual`,`precioUnitario`,`precioUnitarioVenta`,`totalValorizado`,`xtraTextUnoArticulo`,`xtraNumDosArticulo`,`idLineaCategoria`,`idMedida`)
> VALUES
> ('00001-15W40','ACEITE EXTRAVIDA X GLN
> 15W40','0.00','0.00','0.00','0.00','','0.00','300','11'),
> ('00001-P0001','CASCOS DE MOTOS
> HONDA','0.00','0.00','0.00','0.00','','0.00','300','10'),
> ('00001-P0003','LLANTAS DUNLOP LT
> 265/75R216','0.00','0.00','0.00','0.00','','0.00','300','10'),
> ('00001-P0014','POLOS
> HONDA','0.00','0.00','0.00','0.00','','0.00','300','10'),
>
>
> now with the new command already shown
> i have this way
>
>
> LOCK TABLES `articulo` WRITE;
> /*!40000 ALTER TABLE `articulo` DISABLE KEYS */;
> INSERT INTO `articulo` VALUES ('00001-15W40','ACEITE EXTRAVIDA X GLN
> 15W40','0.00','0.00','0.00','0.00','','0.00','300','11');
> INSERT INTO `articulo` VALUES ('00001-CHA01','KIT CHACARERO AZUL
> (GDFGO,PORTAF,LLANT-DEL/POST)','0.00','0.00','0.00','0.00','','0.00
> ','300','14');
> INSERT INTO `articulo` VALUES ('00001-P0001','CASCOS DE MOTOS
> HONDA','0.00','0.00','0.00','0.00','','0.00','300','10');
>
>
> i need like the windows way, thats mean,
> for the first line for insertion before to insert all rows
> i need
>
> INSERT INTO `articulo`
>
> (`idArticulo`,`descripcion`,`stockactual`,`precioUnitario`,`precioUnitarioVenta`,`totalValorizado`,`xtraTextUnoArticulo`,`xtraNumDosArticulo`,`idLineaCategoria`,`idMedida`)
> VALUES
>
>
> i tried adding --disable-keys but wierd and undesired results
>
> regards
>
>
> Rolando Edwards-3 wrote:
> >
> > Use --skip-extended-insert as another mysqldump option
> >
> > -----Original Message-----
> > From: dr_pompeii [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, March 20, 2008 2:43 PM
> > To: mysql@lists.mysql.com
> > Subject: doubt: mysqldump in linux like windows
> >
> >
> > Hello guys
> >
> > i have this situation
> > in widnows with the mysql administrador i make backup
> > i saw in the x.sql these lines for example
> >
> >
> > /*!40000 ALTER TABLE `articulo` DISABLE KEYS */;
> > INSERT INTO `articulo`
> >
> (`idArticulo`,`descripcion`,`stockactual`,`precioUnitario`,`precioUnitarioVenta`,`totalValorizado`,`xtraTextUnoArticulo`,`xtraNumDosArticulo`,`idLineaCategoria`,`idMedida`)
> > VALUES
> > ('00001-15W40','ACEITE EXTRAVIDA X GLN
> > 15W40','0.00','0.00','0.00','0.00','','0.00','300','11'),
> > ('00001-CHA01','KIT CHACARERO AZUL
> > (GDFGO,PORTAF,LLANT-DEL/POST)','0.00','0.00','0.00','0.00','','0.00
> ','300','14'),
> > ('00001-P0001','CASCOS DE MOTOS
> > HONDA','0.00','0.00','0.00','0.00','','0.00','300','10'),
> > ('00001-P0003','LLANTAS DUNLOP LT
> > 265/75R216','0.00','0.00','0.00','0.00','','0.00','300','10'),
> > ('00001-P0014','POLOS
> > HONDA','0.00','0.00','0.00','0.00','','0.00','300','10'),
> >
> >
> > see pls that each row is written in a unique of line of text
> >
> > now in linux with command in a terminal i do in this way my backups
> >
> >
> > mysqldump --opt --password=XXX --user=root somedb >
> > /home/Someuser/somepath/A.sql
> >
> >
> > the backup is done but in this way
> >
> > /*!40000 ALTER TABLE `articulo` DISABLE KEYS */;
> > INSERT INTO `articulo` VALUES ('00001-15W40','ACEITE EXTRAVIDA X GLN
> > 15W40','0.00','0.00','0.00','0.00','','0.00
> ','300','11'),('00001-CHA01','KIT
> > CHACARERO AZUL
> > (GDFGO,PORTAF,LLANT-DEL/POST)','0.00','0.00','0.00','0.00','','0.00
> ','300','14'),('00001-P0001','CASCOS
> > DE
> >
> > how you can see, all the rows appear in one line,
> > dangeous, i dont want this behaviour when i open this file in windows
> tell
> > me if i try to save this file i will missing some values or rows
> > and in linux the gedit dies :(
> >
> > after to read this
> > http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html mysqldump
> > i tried in this way
> >
> >
> > mysqldump --opt --extended-insert--password=XXX --user=root somedb >
> > /home/Someuser/somepath/A.sql
> >
> > with the same undesired results
> >
> > how i can resolve this??
> >
> > thanks in advanced
> > --
> > View this message in context:
> >
> http://www.nabble.com/doubt%3A-mysqldump-in-linux-like-windows-tp16185833p16185833.html
> > Sent from the MySQL - General mailing list archive at Nabble.com.
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/[EMAIL PROTECTED]
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
> >
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/doubt%3A-mysqldump-in-linux-like-windows-tp16185833p16188637.html
> Sent from the MySQL - General mailing list archive at Nabble.com.
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
I'm a mysql DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn
