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
Managed Databases
Every way to get a database on NewHost: a database plan for standalone MySQL or PostgreSQL databases, databases included with every app plan, MySQL with web hosting and MS SQL with Windows hosting. Each database gets its own user and a strong generated password.
Database plans offer the engines listed on each plan; app databases use the engines your app's server offers. MS SQL comes with Windows hosting.
Each database gets its own user and a generated strong password, shown once. Reset it whenever you need a new one.
Database plans back up each database automatically, daily or weekly as the plan says. Restore or download a backup yourself, or copy backups to your own storage.
Databases run on NewHost's servers in South Africa, close to your apps and visitors.
If a renewal goes unpaid the database user is locked, the data is kept, and paying unlocks it with the same password.
Move to a bigger plan at once (you pay the difference for the rest of the period); a smaller plan applies at renewal.
Create databases on your app's server from the app's page, using the engines that server offers.
PHP and WordPress websites on NewHost web hosting create MySQL databases in their hosting account, up to the hosting plan's limit.
Web hostingASP.NET sites on NewHost Windows hosting create MS SQL databases from the site's page, up to the Windows plan's number.
Windows hostingEvery database has its own user with a generated strong password that NewHost shows once. Reset it from the dashboard at any time; a reset ends connections that use the old password.
The dashboard shows the host, port, database name and user, and a ready connection URL to put in your app's environment variables.
Each database on a plan is backed up between 01:00 and 05:00, daily or weekly as the plan says, and kept for its number of days. Back up on demand too, restore a backup yourself, download it, or copy backups to your own S3, FTP or SFTP storage.
Pick a database plan and name your first database and its engine.
The database is created as soon as the invoice is paid; open Databases to see its password, once.
Use the host, port, user and password in your app's settings. Add more databases up to your plan's number.
Database plans list their engines: MySQL / MariaDB and PostgreSQL, and MS SQL Server on the MS SQL plans when they are listed on this page. App databases use the engines your app's server offers. MS SQL Server also comes with Windows hosting, and MySQL with web hosting.
On NewHost's Windows servers with Microsoft SQL Server, in South Africa. Each database gets its own SQL login that owns that database only and can't see other databases. Connect over TCP with SQL Server Authentication and Encrypt=True; the dashboard shows .NET, Node.js and SSMS examples. The SQL Server version and edition depend on the server: ask support before relying on edition-specific features.
It's shown once: when you create a database, or, for the first database of a new plan, the first time you open it on the Databases page. Store it in your app's environment variables. Lost it? Reset the password to get a new one.
Use the host, port, database name, user and password shown in the dashboard; the dashboard also shows them as a connection URL. Put them in your app's environment variables rather than in your code.
Every app plan includes databases next to your apps too: 1 on Starter, 3 on Developer, 10 on Business and 40 on Agency.
Database plans are backed up automatically, daily or weekly as the plan says, and kept for the plan's number of days. Restore or download a backup yourself from the database's Backups page on the Databases page.
The plan becomes past due, and 7 days after the renewal is due it is suspended: the database users (MS SQL Server: the logins) are locked so connections stop, and your data is kept. Paying the invoice unlocks them with the same passwords.
For MySQL and PostgreSQL it is the plan's allowance across all its databases: if they grow past it we may ask you to move to a bigger plan; nothing is deleted. Each MS SQL Server database is capped at the plan's storage by SQL Server itself.
Use the host and port shown in the dashboard. If a connection from outside NewHost is refused, contact support before relying on it: remote access is set per server.
Yes. An upgrade applies at once and you pay only the difference for the rest of your period; a cheaper plan applies at your next renewal. Your databases stay.
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, choose a plan and your database is created as soon as the invoice is paid, with its own user and automatic backups.