Solved

mysql import

Posted on 2009-06-28
4
645 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
4 Comments
 
LVL 14

Expert Comment

by:profya
ID: 24731057
0
 
LVL 14

Accepted Solution

by:
profya earned 500 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
 
LVL 21

Expert Comment

by:theGhost_k8
ID: 24733556
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

705 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now