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

  • 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?

JT S.
  • Answered
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
Tim S.

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. This can be accomplished by emailing [email protected]


In the email be sure to include the file name and where it is located as well as your cPanel username. Also, for security purposes you'll need to provide the last four digits of the credit card on file or the current AMP password.


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


Thanks!


Tim S