How to Back Up a Joomla Database Manually

Identify the database Joomla uses

Confirm the database configured for the site before exporting anything. configuration.php contains the connection settings, so handle it securely. On accounts with several databases, verify the selected database contains the expected Joomla tables.

Choose a reliable export method

Shared hosting commonly provides phpMyAdmin or a similar database manager. Shell users can use the appropriate database command-line tools. Choose a method that can export the complete database and that you know how to restore.

Export every Joomla and extension table

Export table structure and data for the whole database. Do not select only familiar core tables: third-party extensions often depend on their own tables and can lose settings or business data if those tables are omitted.

Coordinate with the file backup

For an active site, create the database dump and filesystem archive close together or use a consistency method supported by the database/hosting platform. The goal is a recovery set whose files and database represent the same site state.

Protect the dump

A production database may contain user information, email addresses, tokens, configuration values and extension data. Transfer the dump to protected off-server storage and remove temporary copies from public locations.

Perform basic validity checks

Confirm the dump is not empty, can be opened in the expected format, and contains table definitions and data for representative Joomla tables. Keep the database engine/version information when it could matter during restoration.

Test an import safely

The best verification is importing the dump into a disposable or staging database and confirming the expected tables and records appear. Never test restoration by overwriting the only live production database.


Need More Help with Joomla?

Still having trouble? Open a support ticket with QuantaCade Support and we'll be happy to help where we can.

Support priority is given to QuantaCade products, services, and customers. However, we're also happy to assist fellow Joomla users with general Joomla questions and troubleshooting when possible.

QuantaCade is an independent Joomla extension developer and is not official Joomla support. Some issues involving third-party extensions, hosting environments, server configurations, or other systems outside our development control may be beyond what we're able to resolve.

Open a Support Ticket