How can I upload a MySQL database larger than 50mb?

Avatar
  • updated
  • Answered

Hello,

I'm trying to Import a SQL db into my DB

Although my exported file is 61mb and the max allowed is 50mb

Any suggestions? Is this something you guys can do on your end?

Duplicates 3
i am enable to import database because its size maxi 50mb then i have allowed how to increase its size
How do I import a large database to my account?
I am moving drupal site from bluehost and if am not having success restoring the database (160MB). Using mysql command line restoring backup I get :
ERROR 2006 (HY000) at line 16686: MySQL server has gone away

MySQL Administrator ends up hanging or just crashes. I tried PHPMyAdmin and it is not up to doing it as the timeouts occur. Any suggestions? I am using Business Hosting Account.
Import large SQL DATABASE
I've tried to use your guide on How to upload a database that's larger than 50mb, but i'm having some problems. First where is the php.ini file? second the newly installed phpmyadmin doesn't see the databases that I've created. would you please make a more detailed guide on this matter?
Avatar
anonymous
  • Answered
Avatar
Scott
Hello egoomni, Sorry to hear you are having trouble with your large database import. What type of problems were you having during the import? Was there any error message given? I have seen large databases up to around 1GB import in this manner, so other than taking a longer time, there should not be any errors normally. Is the database even larger than that? As for your php.ini file. It should be in your public_html folder. If it is missing, then the account will use the default server php.ini file. If you decide you need to adjust any settings, simply contact Live Support and they will be happy to place a copy of the server file in your account so you can alter any settings you need. Kindest Regards, Scott M
Avatar
Tim S.
  • Answered

Hi timothy,


Thanks for posting your question. I'm more than happy to assist you. There's a 50MB limit on MySQL databases so you can only restore the database using SSH. We're more than happy to do it for you, though.


You can upload the SQL backup to your hosting account, then open a ticket to our support department using the AMP interface.


I hope this helps! If you need further assistance, please feel free to contact us.


Thanks!


Tim S