Re: Migration Scheme - from one mysql DB to another mysql DB

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Rob's approach is what I use as well, if faced with this issue. It's quick and simple to do.

Bastien

Sent from my iPod

On Mar 13, 2010, at 12:47 PM, Robert Cummings <robert@xxxxxxxxxxxxx> wrote:

MEM wrote:
Hello all,
If possible, I would like to ask and have your help about the methods and
procedures that should exist to accomplish the following task:
I need to grab some data from one mySQL database with some specific table and field names, to another mySQL database with specific table and field
names. The destination database tables are empty.
What is a common procedure to do on those cases? Is there any? Several? What
are the most common?
If I need to be more specific in order to benefit from your help, please,
let me know.

If it's the same server just different databases, then MySQL allows queries between databases and you could do it in a single query. Something like the following:

INSERT INTO DB1.TABLE1 ( field1, field2, field3 ) SELECT field1, field2, field3 FROM DB2.TABLE1;

Cheers,
Rob.
--
http://www.interjinn.com
Application and Templating Framework for PHP

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux