Re: Some way/tool to do this with database scripts backups

2008-04-11 Thread dr_pompeii
hello let me explain me more think a table how this case cliente is customer/client in english Field Type Null Key Default Extra --- --- -- -- idCliente varchar(11) NO PRI

RE: Some way/tool to do this with database scripts backups

2008-04-06 Thread dr_pompeii
Hello Martijn thanks so much for your reply pls read this carefully ok for instance i already know how use mysqldump, so i can get A.sql , something like this insert into person(id,name,age,sex ) VALUES (01, jesus, 33, male ), insert into person(id,name,age,sex ) VALUES (02, michael, 17,

Some way/tool to do this with database scripts backups

2008-04-04 Thread dr_pompeii
Hello guys if i have for example a simple table call person with 'id' and 'name' how columns i can do a backup and get some file (A.sql) with all the inserts statements here, all fine but how i can do this? for each insert statement generated in A.sql create a new B.sql, with update

Re: doubt: mysqldump in linux like windows

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

doubt: mysqldump in linux like windows

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

RE: doubt: mysqldump in linux like windows

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

how: many-to-many with LEFT JOIN

2008-03-10 Thread dr_pompeii
Hello guys before to a last doom requeriment, i used to work with this type of relation ArticuloNoAuto (english ArticleNoCar like MotorCycle or Motor) and CabeceraComprobanteVenta (like a header of Receipt of some sell SalesReceiptHeader) so 1 CabeceraComprobanteVenta can [b]sell/contain