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]