Ben
Ben

Reputation: 2564

Php myadmin import data take too long

I have a csv db file. 5 columns, 3,321,986 rows, filesize-199M

I try to import into mysql database (php myadmin)

It's been 4 hours already and it's still importing.

Why does it take so long to import, is this normal?

Upvotes: 1

Views: 2857

Answers (2)

throrin19
throrin19

Reputation: 18207

It's normal with PHPMyAdmin. Phpmyadmin must translate csv into SQL language and insert this with php functions. It's so long, memory expansive and it depends on the server.

Be careful, if max_execution_time in your php configuration is too short, the import may be interrupted.

Upvotes: 1

Plamen Nikolov
Plamen Nikolov

Reputation: 2733

The import speed depends on the server itself and its connectivity speed.

You can try to chunk the import to several files for example 10 files about 19M each and see if there is a problem with your CSV format at all.

Upvotes: 0

Related Questions