How can I upload a MySQL database larger than 50mb?
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?
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?
Replies 3
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
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
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.