Import Data From Mysql to Mongodb With Ezsql Class

by admin admin Date: 11-04-2013


This simple php class to demonstrate how to import data from a MySql database to a Mongodb with out complications. 




// It uses the ezsql database class from Justin Vincent: 
// http://justinvincent.com/ezsql
include_once "ezsql/shared/ez_sql_core.php";
include_once "ezsql/mysql/ez_sql_mysql.php";
          
class mongodb_importer
{
    public $user;    
    public $pass;    
    public $databse;    
    public $server;    
    public function import($table_name,$mongo_db)
    {
        $db = new ezSQL_mysql($this->user,$this->pass,$this->database,$this->server);
            
        $m = new Mongo();
        $mongo_db = $m->selectDB($mongo_db);
        $collection = new MongoCollection($mongo_db, $table_name);
        $res = $db->get_results("select * from ". $table_name);
        $i = 0;
        foreach($res as $r)
        {
            $i++;
            $collection->insert($r);    
        }
        return $i;
    }
}
?>


And here it is an example about how to use this!

    // create a new object
    $importer = new mongodb_importer();
    
    // set your Mysql information
    $importer->database = "my_databse";
    $importer->pass = "my_secret_password";
    $importer->user = "my_user_name";
    $importer->server = "localhost";
    
    // import the data
    $count = $importer->import("user","new_db");
    
    // print the result
    echo "Imported " . $count . " records.";
?>
 
by admin admin Date: 11-04-2013 hits : 2012