如何在codeigniter中将mysql数据库转换为现有项目中的mongodb

Question

i have completed a project in codeigniter with mysql database but now i want to move mysql to non sql database mongodb. i have found some driver of mongodb in codeigniter but their query structure is different. I have also use custom sql query in that project like

 $sql = "SELECT * FROM table_name"; 

 $this->db->query($sql);

i want use mongodb in this existing project without change any database query. Please help how i will be able to do that.

Answer 1

You could use some command to dump mysql data to csv:

mysql -u [USERNAME] -p [DBNAME] -e "SELECT * FROM table_name;"|sed "s/'/\'/;s/\t/\",\"/g;s/^/\"/;s/$/\"/;s/
//g" > result_csv.csv

Then just use mongoimport:

mongoimport --db mongodb_name --collection mongo_collection --headerline < result_csv.csv

UPD:
Instead of querying mysql server with mysql command you could use:

mysqldump -u username -p -t  -T/path/to/directory dbname table_name --fields-terminated-by=','

But, in this case you must remember that /path/to/directory must be writable by mysql process, and, as I remember, you don't need --headerline option in mongoimport command