I'm trying to import a large SQL database using phpMyAdmin (through XAMPP) but I keep getting the following error

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 239357 bytes) in C:\xampp\phpMyAdmin\libraries\sqlparser.lib.php on line 331

Does anyone know how I can increase the memory size? I looked in sqlparser.lib.php on line 331 and found the following code:

PHP Code:

$pos    = $GLOBALS['PMA_strpos'](' ' . $sql, $quotetype, $oldpos + 1) - 1; 


I don't have a clue how I can fix it. Originally it told me to look at a different file on line 246, although I can't remember the filename! But it still didn't seem that I could edit that line in order to solve my problem.

You can increase it with php.ini file.

Look at the line:

memory_limit = 16M      ; Maximum amount of memory a script may consume (16MB)

Change it to whatever you want.

I've tried that but still no luck! I edited the php.ini file in 'C:\xampp\apache\bin' to 100M and yet I still get the same error, saying that the allowed memory size is '33554432'

I'm not sure, but I think there's an option when importing with phpMyAdmin to only run a few of the queries and then stop. Then you can start over again, starting at the point where to stopped earlier.

I've never done it myself but I remember seeing such an option.