Upload large sql file

You can make a work around to get your database uploaded from your cPanel without contacting support. Softaculous has the ability to install PhpMyAdmin on a subdomain on your account. Installing PhpMyAdmin on a subdomain will allow you to change the php. The following steps will explain how to do this. All shared accounts have the ability to use Softaculous. PhpMyAdmin is available in your Softaculous program for install.

The following will show you how to install it. Save the file. Make the php. You will now be able to use your Softaculous installed PhpMyAdmin to upload a database larger than 50mb. Step 2 link is dead. Step 3 and 4 are not current either. Hello and thanks for contacting us.

I recommend you try using phpMyAdmin or contact Live Support. Softaculous uses the server-wide PHP version. You would need root access to be able to change that for Softaculous to install phpMyAdmin through this method. In this case, you will need to install phpMyAdmin manually. Once PhpMyAdmin has been installed on the subdomain, I can access it by opening the subdomain in my browser, but what account shoudl I use to log into phpMyAdmin, this is not clear from your article?

The newly installed phpMyAdmin for your domain does not follow the 50MB limit for importing databases. You can simply import the new file within phpMyAdmin and it should work, even if it is over 50MB.

Thank you for the response Does it mean that after changing my domain nameserver, and when my website will load from inmotion, then I have to access my new phpmyadmin from mydomain. Using a utility such as BigDump to split the files before uploading. We cannot support this or any third party applications, but are aware of users having success with it.

If you have shell command line access, use MySQL to import the files directly. Working from inside the phpmyadmin console, go to the new database and import. You will now see an additional option to upload files from that folder. Chose the correct file and be a little patient. It works. I have had difficulty importing an. I simply took off the password before I exported the. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 8 years, 10 months ago. Active 3 months ago. Viewed k times. Improve this question. Peter Mortensen Anil Anil 2, 5 5 gold badges 24 24 silver badges 28 28 bronze badges.

You will have to import it in the command line — Ibu. Never go with UI. Add a comment. Active Oldest Votes. Improve this answer. Jk1 Ibu Ibu But i've never used mysql command line in my laptop. I always use MySQL workbench. Is there a way to launch mysql command line from workbench? Looks like a good excuse to start learning it, you don't need to be an expert to use it, all the stuff you can do on workbench work just fine on the command line — Ibu.

Thanks for your reply. And i knew that i don't need to be an expert to use it. Earlier i've used putty to connect to the server and connected to mysql shell using the command mysql -h hostname -u username -D databasename -p. And now, i'm trying to connect to my own laptop but couldn't. Otherwise i am good. Thanks again. This way may cause errors.

HenryJahja 2 2 gold badges 4 4 silver badges 14 14 bronze badges. Megan Squire Megan Squire 6 6 silver badges 18 18 bronze badges. If you like the above tutorial, then share it with your friends and if you have any queries then write to us.

I had to move my WordPress website to another server and my DB was too large. With this solution, I could move my website. So thanks for writing it. Start A Blog Resources Deals. Use a plugin to compress the database size. Split the database SQL file into smaller parts and import all the files one by one. SQL Dump Splitter. The following two tabs change content below.