Old

Today, 02:59 AM





WHT Addict








 

Join Date: Dec 2012


Posts: 126






Question



Sorry, if I posted this in the wrong section.

I have a WordPress site which has a 400MB size of the DB. I want to import this to phpmyadmin but the max allowed size is 50MB, how can I import them?

Currently i am in shared hosting.

















Old

Today, 03:03 AM








Hey,

Is it shared hosting, or do you have SSH access?

















Old

Today, 03:08 AM





Web Hosting Master








 

Join Date: Sep 2010

Location: /usr/bin/fail


Posts: 819














__________________
? JAXVPS Web Hosting Solutions – http://www.jaxvps.com
? Offering Premium SSD Shared, Reseller, and VPS Hosting Since 2010
? VPS servers available in both Jacksonville and Chicago locations

















Old

Today, 03:16 AM





Newbie








 

Join Date: Apr 2013


Posts: 20







You can break up the database into 8 parts and import each separately.

Or, you can explore reducing the size of the database. This plugin can reduce the size of the database if, for example, you have revisions on or a lot of comments in the spam queue:

https://wordpress.org/plugins/wp-optimize/

















Old

Today, 03:21 AM





Customer Love Specialist










 

Join Date: Nov 2011

Location: 127.0.0.1


Posts: 2,938









You can upload the DB to a downloadable location and provide the link to your web host and ask them to dump it for you. Most will do it gladly.























Old

Today, 05:17 AM





Newbie








 

Join Date: Sep 2013


Posts: 11









Clearly the simplest way is to use big dump. Just upload the script use it and delete it again.

















Old

Today, 05:26 AM





cPanel is your friend










 

Join Date: Jul 2002

Location: World Wide Web


Posts: 1,459







Quote:



Originally Posted by Host4Geeks-Kushal
View Post

You can upload the DB to a downloadable location and provide the link to your web host and ask them to dump it for you. Most will do it gladly.


+1
This is the best advice to follow.







__________________
? Michael Vlastos
? HostWired.com – Innovative Hosting Solutions since 2005 | cPanel, Softaculous
? Personalized support | No site suspensions | No overloaded servers | Green Hosting
? Multiple Backups | Average Response Time: 20 min | Toll Free: 1-855-ECO-HOST

















Old

Today, 06:08 AM





Web Hosting Master








 

Join Date: Apr 2011

Location: Toronto, ON


Posts: 4,171







Quote:



Originally Posted by Host4Geeks-Kushal
View Post

You can upload the DB to a downloadable location and provide the link to your web host and ask them to dump it for you. Most will do it gladly.


+2

The easiest option as a shared client.

Also as a shared customer, most of the “tricks of the trade” options won’t be available to you due to restrictions.


















Reply












Posting Rules

You may not post new threads

You may not post replies

You may not post attachments

You may not edit your posts


HTML code is Off






This entry passed through the Full-Text RSS service — if this is your content and you’re reading it on someone else’s site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers.

Source