> How to import large size of DB in phpmyadmin ? | Top Web Hosting Offers – Coupons, Offers, Reviews, Discounts, Deals for Web Hosting.
Host Unlimited Websites. Starting @ Rs.59

How to import large size of DB in phpmyadmin ?

Posted by Bot on March 9th, 2014 Posted in Offers

Big on Hosting. Unlimited Space & Unlimited Bandwidth













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

Posted in Offers Tags: , , ,
«
»
You can skip to the end and leave a response. Pinging is currently not allowed.

Leave a Reply

CAPTCHA

*

Top Web Hosting Offers