How to import a large database in CSV format?

Question

PHP

The table contains ~250.000 rows and weighs ~50MB.
Editing php.ini and my.ini didn't lead to anything.
It was not possible to import both on the local computer and on the hosting the registry.

Answer 1

Have you tried this? https://medium.com/@sanathkumar/import-large-csv-f...

Answer 2

work with the file line by line