Import data into the database from an external file

tad · October 7, 2011, 7:28pm

Hi

I want to import data into my database(Mysql) using an external file. I have gone through many posts but have not come up with any solution.

Please help me.

Thanks

dniznick · October 8, 2011, 2:47am

http://www.dbforums.com/php/1216671-php-mysql-load-data-file.html

Take look and see if that helps.

itmagetan · October 8, 2011, 10:05am

What type of your external file? if possible make it CSV or Excel then just import it using phpMyAdmin importer.

tad · October 8, 2011, 5:11pm

Thanks dniznik and itmagetan.

The external file could any generic form. It could be SAS or Access also. Till now i am able to find script for csv files only. I have not yet tried phpmyadmin importer.

outrage · October 9, 2011, 10:50pm

There is no way to simply import data from an arbitrary file within Yii, or any other framework I would imagine.

Externally you could use something like Navicat (paid version) which will accept many different formats and allow you to map source fields to destination fields within your db.