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`,`precioU nitario`,`precioUnitarioVenta`,`totalValorizado`,` xtraTextUnoArticulo`,`xtraNumDosArticulo`,`idLinea Categoria`,`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`,`precioU nitario`,`precioUnitarioVenta`,`totalValorizado`,` xtraTextUnoArticulo`,`xtraNumDosArticulo`,`idLinea Categoria`,`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:dr_pompeii@yahoo.com]
> 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`,`precioU nitario`,`precioUnitarioVenta`,`totalValorizado`,` xtraTextUnoArticulo`,`xtraNumDosArticulo`,`idLinea Categoria`,`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-mysql...p16185833.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/mysql?unsub=r...logicworks.net
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=lists@nabble.com
>
>
>

--
View this message in context: http://www.nabble.com/doubt%3A-mysql...p16188637.html
Sent from the MySQL - General mailing list archive at Nabble.com.