Menu
Community /Pin to ProfileBookmark
@NogDogSep 23.2010 — #If the same database connection [i]and[/i] the same database user can access both databases, then it can be done completely via SQL, probably a single query.@NogDogSep 23.2010 — #If the same connection/user, you should be able to do something like:
If separate connections/users are required, then you'd either have to query the first DB, save the results into an array, then use that array for inserting into the 2nd DB; or perhaps you could use the DBMS command line functions to create a SQL file, then load that file into the second DB.
Data from one database and insert into a new database
Can someone show me a php script that will query a db then place the results into a different database.
Sign in
to post a comment4 Comments(s) ↴
0
@NogDogSep 23.2010 — #If the same database connection [i]and[/i] the same database user can access both databases, then it can be done completely via SQL, probably a single query.0
@NogDogSep 23.2010 — #If the same connection/user, you should be able to do something like:[code=php]
$connx = mysql_connect('localhost', 'dbuser', 'dppassword') or die(mysql_error());
$sql = "
INSERT INTO database2.table_name (fld1, fld2, fld3)
SELECT fld1, fld2, fld3 FROM database1.table_name
";
$result = mysql_query($sql) or die(mysql_error());
[/code]If separate connections/users are required, then you'd either have to query the first DB, save the results into an array, then use that array for inserting into the 2nd DB; or perhaps you could use the DBMS command line functions to create a SQL file, then load that file into the second DB.