Re: Transfert Data from one DB to another
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 mysqldump utility: http://www.mysql.com/doc/m/y/mysqldump.html Look at replication: http://www.mysql.com/doc/R/e/Replication.html DB If someone have some fonctions names that can help me ... DB Thanks in advance -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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
RE: Transfert Data from one DB to another
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, 2002 10:31 AM To: [EMAIL PROTECTED] Subject: Transfert Data from one DB to another Hi all, i've got a problem, i need to transfert some data from one database to the same database but on a différent mysql server. I think i can't do that easily via command line, so i'll try to make a C script to do that. If someone have some fonctions names that can help me ... Thanks in advance - 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
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
RE: Transfert Data from one DB to another
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
RE: Transfert Data from one DB to another
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