php runtime error memory size exhausted

Question

When I import mysql.sql.zip file,I got following errors

<br /> <b>Fatal error</b>: Allowed memory size of 134217728 bytes exhausted (tried to allocate 128974893 bytes) in <b>C:\xampp\phpMyAdmin\export.php</b> on line <b>133</b><br />

Your file is too big. Also, that's a Fatal error, not a Syntax error. There's a huge difference. — gen_Eric, Commented Jun 10, 2013 at 14:56
how are you trying to import that file? are you using some GUI (phpMyAdmin) ?? how big is the file? — PachinSV, Commented Jun 10, 2013 at 14:58
@PachinSV: I'd assume so, since the error is from phpMyAdmin\export.php. — gen_Eric, Commented Jun 10, 2013 at 14:58
That's a PHP runtime error, not a MySQL syntax error. You'll find hundreds of dupes here. — Álvaro González, Commented Jun 10, 2013 at 15:01

PachinSV · Accepted Answer · 2013-06-10 15:04:07Z

0

If the file is too big, you should import it using the console.

First extract the .sql file and if the scripst creates the database use this command

mysql -u myUserName -p < file.sql

Or if the database already exists use this one:

mysql -u myUserName -p databaseName < file.sql

I'm assuming that the user "myUserName" has a password that's why I added the -p.

answered Jun 10, 2013 at 15:04

PachinSV

3,7782 gold badges32 silver badges41 bronze badges

Add a comment |

Stefano L · Accepted Answer · 2013-06-10 14:59:48Z

-1

Extract the file and try to split it in 2 parts and import each part separately. There should be more than one query in it, so you should be able to split it easily

answered Jun 10, 2013 at 14:59

Stefano L

1,5922 gold badges16 silver badges42 bronze badges

Add a comment |

Collectives™ on Stack Overflow

php runtime error memory size exhausted

2 Answers 2

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Your Answer

Sign up or log in

Post as a guest

Related