Improve company productivity with a Business Account.Sign Up

x
?
Solved

mysql import

Posted on 2009-06-28
4
Medium Priority
?
663 Views
Last Modified: 2012-08-13
I am using phpmyadmin latest ...

I have a sql file of 60 mb.

When i try to import i get this error please advice...
Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 58493491 bytes) in D:\xampp\phpmyadmin\libraries\zip_extension.lib.php on line 27

Open in new window

0
Comment
Question by:jack_
  • 2
3 Comments
 
LVL 14

Expert Comment

by:profya
ID: 24731057
0
 
LVL 14

Accepted Solution

by:
profya earned 2000 total points
ID: 24731063
You can also look as this: http://drupal.org/node/76156
It advices you to increase memory allocated for PHP to 16M.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
Article by: Tammy
MySQLTuner is a script written in Perl that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability. The current configuration variables and status data is retrieved and presented in a brief forma…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

587 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question