Merge Two MySql databases

[Turnkey_Websites]

Hello,

I have two databases on my website lebphoto.com with the same tables. One with a 1665 members and the other with 33 members, I want to merge them together. is there a way other than typing each records by myself or ask the members to register again?

Thank you

[iamthwee]

you can use sql language to do that.

Just make sure you insert them into the correct tables.

[arty56]

Create 2 db connection scripts
connect.php and dbconnect.php
Create 1 script called
create-new.php
Below is the connect.php
<?php
// this is connect.php
// connect to the 33 member database

$host = "localhost"; // Database server
$user = "Database username"; // Database username
$pass = "Database password"; // Database password
$db = "Database name"; // Database name
$db1=mysql_connect("$host","$user","$pass");
mysql_select_db("$db");
$ok = mysql_select_db("$db");
if (!ok)
{
die("" . mysql_errno().":".mysql_errno()."");
}
?>
Below is the dbconnect.php <?php
// this is dbconnect.php
// connect to the 1665 member database
$host = "localhost"; // Database server
$user = "Database username"; // Database username
$pass = "Database password"; // Database password
$db = "Database name"; // Database name
$db1=mysql_connect("$host","$user","$pass");
mysql_select_db("$db");
$ok = mysql_select_db("$db");
if (!ok)
{
die("" . mysql_errno().":".mysql_errno()."");
}
?>
Below is the create-new.php <?php
// 33 members database
include("connect.php);
// for this demo we'll use customer as the table name
// replace the field names with the correct fields from your database table

$sql = "SELECT * FROM customer";
$sql1=mysql_query($sql) or die("Couldn't select customer!");
while($row = mysql_fetch_array($sql1))
{
$ID = stripslashes($row['ID']); // replace the field names only
$MembersID = stripslashes($row['MembersID']); // replace the field names only
$fname = stripslashes($row['fname']); // replace the field names only
$lname = stripslashes($row['lname']); // replace the field names only
$email = stripslashes($row['email']); // replace the field names only
// 1665 members database
include("dbconnect.php);
$insertmember="insert into customer (ID, MembersID, fname, lname, email) values ('$ID', '$MembersID', '$fname', '$lname', '$email')";
//registering member in database
$insertmember2=mysql_query($insertmember) or die("Could not insert customer");
// do not uncomment code below.
//$ID = mysql_insert_id();
echo "Insert $fname $lname Completed Successfully";
}// Closes While statement
?>
Basically you are connecting to the database with the 33 members and as long as the table and field structure is identical you can then just open a connection to the database containing the 1665 members and append the 33 members to that db.

When completed you will have 1 db with 1698 members.

Have fun.
Arty.