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 ...?
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!!!
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
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.
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)
One of the best option which i frequently use is rebasedata, they allow around 200 MB (CSV to MySQL, which I tested) in their free plan.
Checkout yourself here https://www.rebasedata.com/convert-csv-to-mysql-online
Use https://csvtosql.com online CSV to SQL converter tool. Paste your CSV lines and Convert them to SQL queries. Then you can save them in a SQL file or directly run them on SQL console on phpmyadmin
You can do this easily using sqlizer.io. Here's a screenshot:
Just select "Comma Separated Values" for the file type and upload your file. It will analyse the data and generate an SQL script containing an appropriate CREATE TABLE statement, and a lot of INSERT statements.
(Disclaimer: I help run SQLizer)
Go to ..\xampp\php\php.ini
and change following...
php_value upload_max_filesize xxxxM //file size
php_value post_max_size xxxxM
php_value max_execution_time xxxx
php_value max_input_time xxxx
put xxxx your desire value 1M = 1mb
You most restart your server after changing...
