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