Hello
>>the process of the restore is painful.
i see
even in windows, i dont know why made the backup in that way,
(i dindt change any option to make the backup in the mysql administrator)
if you say that the restore would be painful
thank for your time
Moon's Father wrote:
>
> 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
>
>
--
View this message in context:
http://www.nabble.com/doubt%3A-mysqldump-in-linux-like-windows-tp16185833p16199520.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]
