RE: Transfert Data from one DB to another

2002-04-04 Thread BD
CTED]] >Sent: Thursday, April 04, 2002 11:15 AM >To: [EMAIL PROTECTED] >Subject: Re: Transfert Data from one DB to another > > >Yes but in fact i forgot to say that i have to change a value of a column, >Ex dump all data from table where category = 2 and >insert all thi

RE: Transfert Data from one DB to another

2002-04-04 Thread Gurhan Ozen
to copy it into an sql file and load it in your other database. Does this help? Gurhan -Original Message- From: David BORDAS [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 11:15 AM To: [EMAIL PROTECTED] Subject: Re: Transfert Data from one DB to another Yes but in fact i for

Re: Transfert Data from one DB to another

2002-04-04 Thread David BORDAS
Yes but in fact i forgot to say that i have to change a value of a column, Ex dump all data from table where category = 2 and insert all this data into the other mysql with category = 4 and not 2 I think with too connection i can select all data then insert in new server ben delete on the old ser

RE: Transfert Data from one DB to another

2002-04-04 Thread Gurhan Ozen
IS it something that you can get the data with mysqldump into an sql file and then load it into the database you want it to be transferred to? If yes you can do it all in the command line. Gurhan -Original Message- From: David BORDAS [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04,

Re: Transfert Data from one DB to another

2002-04-04 Thread Egor Egorov
David, Thursday, April 04, 2002, 6:30:39 PM, you wrote: DB> i've got a problem, i need to transfert some data from one database to the DB> same database but on a différent mysql server. DB> I think i can't do that easily via command line, so i'll try to make a C DB> script to do that. Look at my