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 : 2045