
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.
__________________ ? 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
|
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
You can skip to the end and leave a response. Pinging is currently not allowed.