Convert CSV file To Mysql (.sql) database file?

Question

I am using : WampServer 2.2, Apache Version :2.2.21, PHP Version : 5.3.8, MySQL Version :5.5.16, PhpMyadmin Version: 3.4.5...

I have face Problem Of Importing CSV file-(size 13MB*), Error File is Too large... phpMyadmin allow only 2MB file size ...

So Separate files with 1.83MB file size...then also it does not work ???

And also tell me , How to automatic create table through CSV file ...?

Answer 1

Why dont you try to import file using MySQL Console?
I think, you will not face any problem this way. You will not need to split the file into chunks. Just take care of syntax.

load data infile 'c:/filename.csv' into table tablename fields terminated by ',';

For details about syntax, refer Load Data Infile on official documentation.
For example, refer this and this.

Hope it helps!!!

Answer 2

LOAD DATA INFILE 'your.csv' INTO TABLE android_dev FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 ROWS;

include the csv file in your database folder,i.e., <root>\mysql\data\DATABASE_NAME

Answer 3

I'd suggest you look at Data Transformer (disclaimer - I'm its developer). It can convert CSV/JSON/XML to SQL. The generated SQL contains "insert" statements for each line and a "create table" statement.

The app works offline and your data never leaves your computer.

You can get it from the Mac App Store or the Microsoft Store.

Answer 4

How to automatic create table through CSV file ...?

I wrote a csv2mysql command. It scans the entier CSV file to determine appropriate column types and outputs a CREATE TABLE statement and (optionally) INSERT INTO statements for the data.

It's at https://github.com/artfulrobot/csv2mysql (you can just download the bin/csv2mysql executable (Linux) or you can run the main csv2mysql.php file if you download the source and run composer install)