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.