Can you help!! I have two databases on one MySql sever and I would like to transfer certain information from one databases to another. I want to transfer, record by record, from a particular table, after examining the record. How can I open the two databases at the same time? The only way I am able to do this is by
1. opening one database - 2. read a record from a particular table - 3. close the database - 4. examine the records - 5. open the other database - 6. save information and close. 7. repeat the process for all the records. I am worried that this may be in efficient. It there another I could do it? Fred Kamwaza --------------------------------------------------------------------- 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