Back Up MySQL and PostgreSQL - mysqldump and pg_dump Guide
Back up and restore MySQL and PostgreSQL databases with mysqldump and pg_dump, keep passwords out of scripts, schedule backups and test your restores.
· 5 min read
Automation & Scheduled Tasks
Automate the routine work. Call a URL or deploy an app on a cron schedule or once at a set time, see every run's result, deploy on every push, and have NewHost notify your own systems when something happens.
Five-field cron schedules or a single run at a set time, in South African time (Africa/Johannesburg).
GET or POST to an https address, with a 30-second timeout; the status code and the start of the response are kept.
Redeploy one of your NewHost apps nightly, weekly or whenever you need it.
Every run's time, result, duration and output, kept as long as your plan says.
Connect GitHub once and every push deploys, with deployment statuses on your commits; GitLab via a signed webhook per app.
Signed events for app, deployment, domain, database, payment and subscription changes, retried with back-off when your endpoint fails.
Call https://your-app.co.za/api/cron every 15 minutes to send reminders, sync stock or clear caches.
Deploy a static or ISR site at 02:00 every night so it picks up new content from your CMS.
POST to an endpoint on the 1st of the month to e-mail last month's report.
Deploy a release or call a webhook once, at the exact time of a launch or sale.
Choose Call a URL or Deploy app, then a schedule or a one-off time.
NewHost runs it on schedule and records the result of every run.
See each run's status, duration and output; run it now, pause or delete it any time.
It depends on your allowance: every 5 minutes at most with a NewHost app plan, and as often as each automation plan says (down to every minute). One-off tasks run once at the time you choose.
Call a public https URL with GET or POST (for example your app's cron endpoint), or deploy one of your NewHost apps. Automation plans list the task types they include.
App plans include up to 50 tasks, every 5 minutes at most, with unlimited runs. An automation plan adds more frequent runs and longer run history, and gives scheduled tasks to accounts without an app plan.
Each time a task runs, successful or failed. Plans with a monthly number of runs count them per calendar month in South African time; when they are used up, further runs are skipped until the next month or an upgrade.
As long as your plan says: 7 days with an app plan, and each automation plan's number of days.
A call waits up to 30 seconds. The run is recorded as failed with the HTTP status or what went wrong, and the next run happens on schedule.
South African time (Africa/Johannesburg): "0 2 * * *" runs at 02:00 in South Africa.
Each delivery includes an X-NewHost-Signature header: an HMAC-SHA256 of the timestamp and body using your endpoint's secret.
Back up and restore MySQL and PostgreSQL databases with mysqldump and pg_dump, keep passwords out of scripts, schedule backups and test your restores.
· 5 min read
Connect a Node.js app to PostgreSQL the production way - connection strings, the pg Pool, SSL, environment variables, migrations and common mistakes.
· 5 min read
How to use an AI API from South Africa and pay in rand - prepaid credits vs your own provider key, invoices, usage tracking and POPIA points to check.
· 6 min read
Sign up and create tasks that call your URLs or deploy your apps on a timetable, with the result of every run recorded.