CODEWITHSUNDEEP
mysqlsql-servercsvphpmyadmin
Malek Zarkouna
Malek Zarkouna

Reputation: 988

Convert CSV into MYSQL file

I have exported the csv file from SQL SERVER database which contains 24K records. I want to convert the csv into an .sql file i have tried phpmyadmin (timeout error) and online converters but all them failed :

<b>Fatal error</b>:  Allowed memory size of 67108864 bytes exhausted (tried to allocate 75 bytes) in <b>/mounted-storage/home85/sub007/sc60314-GZFW/typexpert.net/csv2sql/parsecsv.lib.php</b> on line <b>426</b><br />

What will be the best alternative ?

NOTE: None of the previous posts resolved my issue .

this a screen of result i get after import the insert script .sql from SSMS :

enter image description here

I got loading issue (timeout)

Upvotes: 1

Views: 283

Answers (1)

Remco K.
Remco K.

Reputation: 717

Your PHP script has not enough memory it can use. That depends on your server and settings. If your server has enough you can easily add more memory to phpmyadmin by changing the settings in the phpmyadmin folder. You can use different methods:

changing in htaccess (for apache):

php_value memory_limit 2G

changing in php:

ini_set('memory_limit', '2G');

changing in user.ini (for plesk users)

memory_limit = 2G

Upvotes: 1

Related Questions