Recently I got a task that imports the database of agencies into WordPress site. At first, it looks easy, turnover it took me a lot of time, for stupid.
The database has 250.000 records, and a standard shared hosting can’t effort to complete the importing in 1 SQL command.
WP All Import – First approach, stupids begin
It’s not the first time I use WP All Import, but yes, very first time to import 250.000 records into WordPress.
At first, it took me about four days to importing all the content. But I don’t have that amount of time, and I have to keep my browser, my computer runs all four days long.
So I think if there’s a way, effortless to run it, without computer run, or browser opening all the time.
Yes, schedule with the cronjob.
Cronjob Nightmare, Uptimerobot rise
On WP All Import has a guide to using cronjob of your cPanel to run the import easily. But when I follow, there’s no effect on that; the cronjob didn’t run.
But wait, the import link that WP All Import gave just a link that we can send HTTP request, and it will return the little snippet information of that cronjob. So I think how about if we can send PING every 5 minutes to that processing link?
I came up with UptimeRobot; it’s simply fit my need: send ping request every (minimum) 5 minutes. That’s it.
And voila, here’s my result
It just saved my time a lot.
Hope that will help you somehow.