Top Web Hosting Offers – Coupons, Offers, Reviews, Discounts, Deals for Web Hosting.

Coupons, Offers and Reviews on Shared, Reseller, Unlimited, Unmetered, Dedicated, VPS Web Hosting.

How to import large size of DB in phpmyadmin ?

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

Today, 02:59 AM

WHT Addict

Join Date: Dec 2012

Posts: 126

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.

Today, 03:03 AM

Hey,

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

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

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/

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.

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.

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

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.

Today, 06:08 AM

Web Hosting Master

Join Date: Apr 2011

Location: Toronto, ON

Posts: 4,171

Quote:

Originally Posted by Host4Geeks-Kushal

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.

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: com, DB, FAQ, someone

You can skip to the end and leave a response. Pinging is currently not allowed.