{"id":88,"date":"2015-03-15T04:48:24","date_gmt":"2015-03-14T17:48:24","guid":{"rendered":"https:\/\/4it.com.au\/kb\/?post_type=article&p=88"},"modified":"2022-12-02T11:38:58","modified_gmt":"2022-12-02T00:38:58","slug":"how-to-import-a-large-sql-database-on-a-shared-web-host-like-hostgator","status":"publish","type":"article","link":"https:\/\/4it.com.au\/kb\/article\/how-to-import-a-large-sql-database-on-a-shared-web-host-like-hostgator\/","title":{"rendered":"How to import a large SQL database on a shared web host like Hostgator"},"content":{"rendered":"

Moving a large WordPress Multisite Database to Hostgator Shared Hosting<\/h3>\n

Recently we were faced with the challenge of moving a large WordPress Multisite from Amazon EC2 over to another shared web host with CPanel on it. We knew this was going to be a problem as quite often shared web hosts have an upload limit for SQL databases – In this case it was 50MiB. \u00a0The size of the file we were trying to import was 264MiB when zipped.<\/p>\n

So how did we overcome this limitation? \u00a0We can’t use the shell being shared hosting. \u00a0We used an open source PHP program aptly named “Big Dump”. \u00a0I know there’s certain images that spring to mind \u00a0when you first hear of this program. Luckily when I got to the website to download the file we were presented with an image of a piece of earthmoving equipment – Thank heavens for that!<\/p>\n

\"bigdump\"<\/a><\/p>\n

What this software promises to do is upload chunks of the SQL database at a time (default is 3000 lines) to avoid the PHPMyadmin import limit and it does just that!<\/p>\n

All you need to do is download and follow the instructions on the Big Dump Page located\u00a0here<\/a>. \u00a0It’s quite simple really.<\/p>\n

    \n
  1. Upload the SQL database and Big Dump script to a folder on your website (make sure you transfer the files using ASCII or binary when it says to)<\/li>\n
  2. Edit the file with your database details<\/li>\n
  3. Run the PHP Script<\/li>\n<\/ol>\n

    We did come across one problem though, we still hit a resource limit. \u00a0All we did in this change the settings to pause for 5 seconds in between each 3000 lines and we were good to go. \u00a0Essentially we uploaded our 264MiB file in under an hour and it works perfectly.<\/p>\n

    <\/div>","protected":false},"excerpt":{"rendered":"

    Moving a large WordPress Multisite Database to Hostgator Shared Hosting Recently we were faced with the challenge of moving a large WordPress Multisite from Amazon EC2 over to another shared web host with CPanel on it. We knew this was going to be a problem as quite often shared web hosts have an upload limit […]<\/p>\n","protected":false},"author":1,"featured_media":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","article-category":[256],"article-tag":[33,204,203,205,32],"class_list":["post-88","article","type-article","status-publish","format-standard","hentry","article-category-uncategorized","article-tag-hostgator","article-tag-import-database-mysql-wordpress","article-tag-import-large-database-mysql","article-tag-mysql-import-large-database-file","article-tag-php"],"yasr_visitor_votes":{"stars_attributes":{"read_only":false,"span_bottom":false},"number_of_votes":3,"sum_votes":13},"_links":{"self":[{"href":"https:\/\/4it.com.au\/kb\/wp-json\/wp\/v2\/article\/88","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/4it.com.au\/kb\/wp-json\/wp\/v2\/article"}],"about":[{"href":"https:\/\/4it.com.au\/kb\/wp-json\/wp\/v2\/types\/article"}],"author":[{"embeddable":true,"href":"https:\/\/4it.com.au\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/4it.com.au\/kb\/wp-json\/wp\/v2\/comments?post=88"}],"version-history":[{"count":0,"href":"https:\/\/4it.com.au\/kb\/wp-json\/wp\/v2\/article\/88\/revisions"}],"wp:attachment":[{"href":"https:\/\/4it.com.au\/kb\/wp-json\/wp\/v2\/media?parent=88"}],"wp:term":[{"taxonomy":"article-category","embeddable":true,"href":"https:\/\/4it.com.au\/kb\/wp-json\/wp\/v2\/article-category?post=88"},{"taxonomy":"article-tag","embeddable":true,"href":"https:\/\/4it.com.au\/kb\/wp-json\/wp\/v2\/article-tag?post=88"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}