Re: doubt: mysqldump in linux like windows

2008-03-21 Thread dr_pompeii
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

RE: doubt: mysqldump in linux like windows

2008-03-20 Thread Rolando Edwards
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

RE: doubt: mysqldump in linux like windows

2008-03-20 Thread dr_pompeii
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 /*!4 ALTER TABLE `articulo` DISABLE KEYS */; INSERT INTO `articulo`

Re: doubt: mysqldump in linux like windows

2008-03-20 Thread Moon's Father
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