Sched­ule backups of web­sites

The most com­mon way to auto­mat­ic­ally run scripts at sched­uled times is through cron. For example, you can use cron to make sched­uled web requests to a spe­cif­ic URL on your web­site. This is a reli­able way to per­form peri­od­ic work, such as mail­ing users or gen­er­at­ing reports. Word­Press and Drupal have imple­men­ted sys­tems that…

How to upload web­site backups to Drop­box

See more info here Drop­box Upload­er is a BASH script which can be used to upload, down­load, delete, list files (and more!) from Drop­box, an online file shar­ing, syn­chron­iz­a­tion and backup ser­vice. It’s writ­ten in BASH script­ing lan­guage and only needs cURL. You can take a look to the GiHub pro­ject page. Why use this…

Add Word­Press users via MySQL

INSERT INTO ‘[databasename]‘.‘wp_users‘ (‘ID‘, ‘user_​​login‘, ‘user_​​pass‘, ‘user_​​nicename‘, ‘user_​​email‘, ‘user_​​url‘, ‘user_​​registered‘, ‘user_​​activation_​​key‘, ‘user_​​status‘, ‘display_​​name‘) VALUES (‘4’, ‘name’, MD5(‘password’), ‘Isaac Rayner’, ‘isaac.​rayner@​gmail.​com’, ‘http://​wiki​.onlin​enow​.co​.nz’, ‘2016−10−21 00:00:00′, ”, ‘0’, ‘Isaac Rayner’);   INSERT INTO ‘[databasename]‘.‘wp_usermeta‘ (‘umeta_​​id‘, ‘user_​​id‘, ‘meta_​​key‘, ‘meta_​​value‘) VALUES (NULL, ‘4’, ‘wp_​​capabilities’, ‘a:1:{s:13:“administrator”;s:1:“1”;}’);   INSERT INTO ‘[databasename]‘.‘wp_usermeta‘ (‘umeta_​​id‘, ‘user_​​id‘, ‘meta_​​key‘, ‘meta_​​value‘) VALUES (NULL, ‘4’, ‘wp_​​user_​​level’, ‘10’);   NOTE:…