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, male

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 stateme

Re: doubt: mysqldump in linux like windows

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

RE: doubt: mysqldump in linux like windows

2008-03-20 Thread dr_pompeii
27;','0.00','300','14'); INSERT INTO `articulo` VALUES ('1-P0001','CASCOS DE MOTOS HONDA','0.00','0.00','0.00','0.00','','0.00','300','10'); i need like the

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` (`idArticulo`,`descripcion`,`stockactual`,`precioUnitario`,`precioUnitarioVenta`,`totalValor

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 one