At 10:43 AM 4/4/2002, you wrote:
>Hi david,
>Just create another table in your database with the structure and data of
>the table. See "CREATE TABLE ... SELECT ..." syntax at :
>http://www.mysql.com/doc/C/R/CREATE_TABLE.html for this task.
>
> Then update all the category values from 2 to 4 in that table. Use
>mysqldump to copy it into an sql file and load it in your other database.
> Does this help?
>
>Gurhan
Gurhan,
Actually you don't even need to dump the data (if you have a
connection to both databases). You can try something like:
create table database2.mytable select * from database1.mytable where .... ;
Then count the records that were transferred and if they compare to the
original table, delete the rows from the original table.
Brent
>-----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 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 server
>with a C script but'll not be very efficient ... and not easy to make it
>working
>
><<
>Look at mysqldump utility:
> http://www.mysql.com/doc/m/y/mysqldump.html
>
>Look at replication:
> http://www.mysql.com/doc/R/e/Replication.html
> >>
>i know mysqldump but in this case, i think this can't help me.
>
>Replication ? i don't know, i'll have a look
>
>
>Thanks
>David
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
