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