How do I migrate data from another database to MySQL

Migrating data from another database to MySQL can be done in several ways, depending on the source of the data. Below, you'll find a simple example of how to do this using PHP and the MySQLi extension. This example assumes you are transferring data from a PostgreSQL database to a MySQL database.

Example Code

<?php // Source PostgreSQL Database Credentials $pg_host = "your_pg_host"; $pg_db = "your_pg_database"; $pg_user = "your_pg_user"; $pg_pass = "your_pg_password"; // Target MySQL Database Credentials $mysql_host = "your_mysql_host"; $mysql_db = "your_mysql_database"; $mysql_user = "your_mysql_user"; $mysql_pass = "your_mysql_password"; // Connect to PostgreSQL Database $pg_conn = pg_connect("host=$pg_host dbname=$pg_db user=$pg_user password=$pg_pass"); if (!$pg_conn) { die("Could not connect to PostgreSQL: " . pg_last_error()); } // Connect to MySQL Database $mysql_conn = new mysqli($mysql_host, $mysql_user, $mysql_pass, $mysql_db); if ($mysql_conn->connect_error) { die("Connection failed: " . $mysql_conn->connect_error); } // Query data from PostgreSQL $result = pg_query($pg_conn, "SELECT * FROM your_table"); if (!$result) { die("Error in query: " . pg_last_error()); } // Insert data into MySQL while ($row = pg_fetch_assoc($result)) { $sql = "INSERT INTO your_mysql_table (column1, column2) VALUES ('". $row['column1'] ."', '". $row['column2'] ."')"; if (!$mysql_conn->query($sql)) { echo "Error: " . $mysql_conn->error; } } // Close connections pg_close($pg_conn); $mysql_conn->close(); ?>

Keywords: migrate data MySQL PostgreSQL database migration PHP

Related Questions

How do I avoid rehashing overhead with std::set in multithreaded code?

How do I find elements with custom comparators with std::set for embedded targets?

How do I erase elements while iterating with std::set for embedded targets?

How do I provide stable iteration order with std::unordered_map for large datasets?

How do I reserve capacity ahead of time with std::unordered_map for large datasets?

How do I erase elements while iterating with std::unordered_map in multithreaded code?

How do I provide stable iteration order with std::map for embedded targets?

How do I provide stable iteration order with std::map in multithreaded code?

How do I avoid rehashing overhead with std::map in performance-sensitive code?

How do I merge two containers efficiently with std::map for embedded targets?