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