Import error in phpMyAdmin/Win7: Allowed memory size ...

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Import error in phpMyAdmin/Win7: Allowed memory size ...

Postby janowicz » 27. March 2010 11:21

Hi all

I've installed newest xampp on a new laptop and am getting db import 'maxed-out' type errors when importing a db which is only 8kb - here's my setup and the error msg:

OS: Windows 7 Home Premium - 64 bit
Xampp: xampp-win32-1.7.3
Xampp install location: C:\XamppServer\ ...

I'm importing the DB dump via phpMyAdmin

Error message:
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 8358 bytes) in C:\XamppServer\xampp\phpMyAdmin\libraries\sqlparser.lib.php on line 342

****************
I've checked php.ini and all max limits are set to 128M but the DB is only 8k.
A guess is that it's an OS issue - Windows 7 Home Premium is 64 bit (apparently!) but this flavour of xampp would appear to be 32 bit, if the name is anything to go by.

Any help here would be much appreciated. ( btw, I did search the forum before posting but couldn't get an answer which worked)

Thanks in advance!
janowicz
 
Posts: 8
Joined: 08. July 2008 12:33

Re: Import error in phpMyAdmin/Win7: Allowed memory size ...

Postby Nobbie » 27. March 2010 13:01

janowicz wrote:I'm importing the DB dump via phpMyAdmin


What kind of DB dump is it?
Nobbie
 
Posts: 8772
Joined: 09. March 2008 13:04

Re: Import error in phpMyAdmin/Win7: Allowed memory size ...

Postby janowicz » 27. March 2010 15:18

Sorry for the delay - it's a totally bog standard phpmyadmin dump from a 1and1 server.

The web server db is php4 but i've imported it into xampp running php5 loads of times previously on a different box running running XP.
janowicz
 
Posts: 8
Joined: 08. July 2008 12:33

Re: Import error in phpMyAdmin/Win7: Allowed memory size ...

Postby janowicz » 28. March 2010 13:24

janowicz wrote:The web server db is php4 ...

I meant, of course, that the server db dump is MySQL 4, not php4 :wink: and it is from from phpMyAdmin - and that I have previously imported on a Win XP system into xampp running MySQL 5 with no problems.
Thanks
janowicz
 
Posts: 8
Joined: 08. July 2008 12:33

Re: Import error in phpMyAdmin/Win7: Allowed memory size ...

Postby janowicz » 31. March 2010 16:19

Anyone ... please?
janowicz
 
Posts: 8
Joined: 08. July 2008 12:33


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 65 guests