Backing up and Restoring Large WordPress Databases

In a previous article we saw how to manually back up a WordPress website. In particular, we saw how to backup a database, and how to restore it.

However, when we try to restore a database, a problem can occur, not discussed in the previous article. What about big databases? There's always a limit in the allowed files uploads, especially when we talk about importing a database dump, and there's always a risk of exceeding this limit. But there is a way to easily backup and restore large WordPress databases.

In this article I'll cover how to restore big database dumps with a useful tool called BigDump. Essentially, BigDump is a PHP script that allows you to import a database dump as big as you want, even if your upload limit is low. Note that BigDump is released under the GNU GPL 2 license.

After restoring a big database dump with BigDump, I'll show you how to automatically generate these dumps thanks to a WordPress plugin named WP-DBManager, because you don't have time to waste manually backing up your database every day!

Generating a BigDump-ready Database Dump

I've already covered how to back up a WordPress database in the previous article, so we won't describe how to do that again. However, there's something you should know if you want to use BigDump.

In practice, BigDump splits your file into as many files as necessary for your server to allow the import, and sometimes the split can cause trouble - if you use extended inserts that allow you to optimize your SQL queries by merging several INSERT queries into one.

Continue reading %Backing up and Restoring Large WordPress Databases%

by Jérémy Heleine via SitePoint

Functional Programming, Distributed Databases, JSON-Patch and More!

This article is a review of the WebCampZG conference. All images are taken from WebCampZg’s official and Facebook page.

This weekend, Chris Ward (the mobile channel editor at SitePoint) and me attended Webcamp ZG, the annual international web-oriented conference in Zagreb, Croatia.

The conference is a two day event, each day spearheaded by a keynote type of talk before diving into the bulk of the content. The schedules of both days contained plenty of breaks with food, drinks and snacks scattered throughout, providing for both energy and excellent socialization and networking contexts.

The two main tracks were sponsored by two companies: Intercom and Reversing Labs, and while each had a sponsored talk slot, neither disappointed. The two tracks were also identified by their sponsors’ logo, so visitors could easily redirect themselves into the appropriate hall.

Continue reading %Functional Programming, Distributed Databases, JSON-Patch and More!%

by Bruno Skvorc via SitePoint

Kickstarting Your Creative Career

Why Native Advertising is Hotter Than Jennifer Lawrence

You’re more likely to complete NAVY SEAL training, survive a plane crash, win the lottery and do a slew of other ridiculously uncommon things than you are to click a banner ad.

To be specific, the average banner ad click through rate (CTR) is a measly .1%.

According to a LinkedIn Marketing Solutions study, 70% of individuals want to learn about products through content rather than through traditional advertising.

We’re in the middle of an eyeball war for dominance in the attention share of Internet browsers, and banner ads are definitely losing to something known as native advertising and sponsored content or paid posts.

Continue reading %Why Native Advertising is Hotter Than Jennifer Lawrence%

by Lauren Holliday via SitePoint

How to Monitor Docker-Based Applications Using New Relic

The Beginners Guide to WooCommerce: Order Reports - Part 3

How to Run an Instagram Influencer Campaign

Do you want to generate leads from Instagram? Have you considered reaching out to influencers? An influencer campaign is an effective way to promote your business and generate leads by leveraging the audience of another Instagram account. In this article you’ll discover how to run an influencer campaign on Instagram. #1: Reach Out to the Right […]

This post How to Run an Instagram Influencer Campaign first appeared on Social Media Examiner.
Social Media Examiner - Your Guide to the Social Media Jungle

by Stefano Mongardi via Social Media Examiner