InMotion Hosting Support Center

Error importing large database - Fatal error: memory limit exceed

Category: Databases

JuanReyes
Asked:
2013-08-25 6:32 pm EST

Hits: 1,496
Hi everybody,

The exact error I get while in myadmin php is this..

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 60616901 bytes) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/import.lib.php on line 290

I found these possible solutions..
one says Running a script like BIgDump.
or changing memory limits as admin.

but before attempting anything like this I thought it wise to seek out some expert guidance from you fine people.

link1
http://www.bluehostforum.com/showthread.php?31041-Importing-large-database-in-PHPMyAdmin
-------------------
link2
http://www.bluehostforum.com/showthread.php?12598-MySQL-error

I dont plan on keeping both databases running for long. I'm just testing some modifications and I usually do that on a clone of my live site.
once im totally done, my clone with its new mods becomes my live site and the old site is erased.

Just incase resource consumption is a particular concern for you guys.

I appreciate any help you guys can lend to this delema.

Cordially,

Juan Reyes

You must login before you can ask a follow up question.

You must login before you can submit an answer.

OTHER ANSWERS

0

John-Paul
Staff
17,070 Points
2013-08-26 10:53 am EST
Hello Juan,

Thank you for your question. By default, you can only import a database to us that is under 50MB. If you need to upload a larger database, we have a workaround that is explained in this helpful article.

If you have any further questions, feel free to post them below.
Thank you,

-John-Paul

You must login before you can post a comment about this answer.

Like this Question?

Support Center Login

Social Media Login

   
Social Login Joomla

Related Articles

It looks like there are no related articles.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!