insert 100000+ Record in MySql

Question

I am trying to insert record on mySql Database table....i have 80k record on CSV file.so, i created a insert into query. when i am trying to fire query on browser(localhost/myphpadmin) it's show me "FATAL" error for the Time Out....so, how can i insert whole data on table?

When I Immport Text File

Error:

Fatal error: Maximum execution time of 300 seconds exceeded

This question is either `Too Localized` or `Not a Real Question`. Please check the FAQ for help on asking good questions. Thank you! — , Apr 12 '13 at 05:54
Not sure about the actual syntax, but I know in phpMyAdmin you need to use the `LOAD DATA` option for importing big spreadsheets. — Marty, Apr 12 '13 at 05:58

score 2 · Answer 1 · edited May 23 '17 at 12:28

2

since you are running it on localhost .. why don't you run the whole sql file in the mysql db itself using the following syntax

mysql -u USERNAME -p -h localhost YOUR-DATA-BASE-NAME-HERE < YOUR-.SQL.FILE-NAME-HERE

Also for executing large queries in phpmyadmin you can visit this previous post.. how to import a very large query over phpmyadmin?

edited May 23 '17 at 12:28

Community

1
1

answered Apr 12 '13 at 06:14

AurA

12,135
7
46
63

plz ans my Question after My Edit !!! – D J Apr 12 '13 at 09:01
@DJ I have added more content and might prove helpful to you. – AurA Apr 12 '13 at 09:48

score 0 · Answer 2 · answered Apr 12 '13 at 05:53

0

Insert into table values (row1 values),(row 2 values), .... Err etc

answered Apr 12 '13 at 05:53

exussum

18,275
8
32
65

1

it will work for the 1k or 2k but not for the 80k records. – Kvadiyatar Apr 12 '13 at 06:12

insert 100000+ Record in MySql

2 Answers2