Error importing large database - Fatal error: memory limit exceed

Category: Databases

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

Hits: 1,201
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

johnpaulb-imhs1
Staff
10,994 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?

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!