Bash Script to Check, Repair, Optimise and Backup MySQL database
I have a VPS (Virtual Private Server) and I have just move another domain (steakovercooked.com) onto this. I find it useful to have a script that can automatically check, …
Category: database
How to Create a Page of Archives (Summary) for All WordPress Posts/Pages using PHP?
September 23, 2014
database, implementation, php, programming languages, web programming, wordpress
2 Comments
I have just created two summary pages for my two blogs: https://helloacm.com/archives-of-pagesposts/ and http://www.codingforspeed.com/archives-of-pagesposts/. In both pages, all articles (including pages) are sorted by months. The number of comments …
How to Revive Old Posts using PHP and Crontab
September 22, 2014
beginner, code, code library, database, implementation, php, programming languages, sql, web programming, webhosting, wordpress
No Comments
Suppose you have quite a number of decent posts in your blog and you are wondering that if there is a way to post to twitter/facebook (or other social …
Duplicate a MySQL table – Copy Table / Duplicate Database / PHP Script
August 31, 2014
database, DevOps, php, PHP, programming languages, sql, SQL, tricks, web programming
15 Comments
Suppose if you want to copy a Table to another, this can be done in MySQL with two steps. The first one is to copy the table structure, and …
How to Fix MySQL Crash due to OOM Error?
August 23, 2014
apache server, database, DevOps, mysql, MySQL, tricks, Virtual Private Server, webhosting
No Comments
MySQL server stopped due of out of memory exception on Ubuntu VPS As you may know, my three websites are hosted on a VPS starter package from QuickHostUK – …