Quick wins for a faster PC:
Repair Windows errors before they cause bigger problemsFix Now →Scan for outdated or missing drivers - takes under a minuteDriver Scan →Some links on this page are affiliate links: if you buy through them we may earn a commission, at no extra cost to you.
The safest manual WordPress database backup is a complete SQL export made before upgrades, migrations, or other risky changes. Use phpMyAdmin if you have hosting-panel access, mysqldump over SSH for repeatable command-line backups, or WP-CLI from the WordPress installation directory. Store the export away from the web server and verify that it can be restored.
What a WordPress database backup includes
A database export contains database data such as posts, pages, comments, users, and settings. It does not include your themes, plugins, media in wp-content/uploads, wp-config.php, or other site files. WordPress.org describes a complete site backup as two parts: the database and the files.
Back up at regular intervals and before upgrades, migrations, domain changes, or major configuration work. A database dump alone cannot rebuild a site whose files are missing.
Recommended Free Tools
Identify the correct database first
- Open the site’s
wp-config.phpfile. - Record
DB_NAME,DB_USER,DB_PASSWORD, andDB_HOST. - Confirm that the database belongs to the site you intend to back up; a hosting account may contain several databases.
- Note the table prefix, such as
wp_. Installations often use a custom prefix, and every table with that prefix must be included.
Do not paste the password into logs, screenshots, or support tickets. When a command-line tool asks for it, enter it at the password prompt.
#1 Best Overall
- Easily store and access 2TB to content on the go with the Seagate Portable Drive, a USB external hard drive
- Designed to work with Windows or Mac computers, this external hard drive makes backup a snap just drag and drop
- To get set up, connect the portable hard drive to a computer for automatic recognition no software required
- This USB drive provides plug and play simplicity with the included 18 inch USB 3.0 cable
- The available storage capacity may vary.
Method 1: Export with phpMyAdmin
phpMyAdmin is usually the most accessible manual method when your host provides it.
- Sign in to your hosting control panel and open phpMyAdmin.
- Select the WordPress database in the left navigation. Match it to
DB_NAMEfromwp-config.php. - Open the Export tab.
- Choose Quick for a normal export of all tables, select SQL as the format, and click Go.
- Save the downloaded
.sqlfile with a date and site identifier, for exampleexample-2026-09-30.sql.
Choose Custom instead of Quick when you need to select particular tables or adjust export options. For a recoverable site backup, export all WordPress tables rather than only the posts table.
Rank #2
- Easily store and access 5TB of content on the go with the Seagate portable drive, a USB external hard Drive
- Designed to work with Windows or Mac computers, this external hard drive makes backup a snap just drag and drop
- To get set up, connect the portable hard drive to a computer for automatic recognition software required
- This USB drive provides plug and play simplicity with the included 18 inch USB 3.0 cable
- The available storage capacity may vary.
Method 2: Create a dump with mysqldump over SSH
If your host provides shell access, run mysqldump with the host, username, and database name from your hosting account or wp-config.php:
The Tool Desk
Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →Outbyte PC Repair FREERepair Windows errors before they cause bigger problemsFix Now →mysqldump --add-drop-table -h db01.example.net -u dbusername -p dbname > blog.bak.sqlEnter the database password when prompted. The --add-drop-table option makes the dump remove same-named tables before recreating them during a restore.
Rank #3
- Easily store and access 1TB to content on the go with the Seagate Portable Drive, a USB external hard drive.Specific uses: Personal
- Designed to work with Windows or Mac computers, this external hard drive makes backup a snap just drag and drop. Reformatting may be required for Mac
- To get set up, connect the portable hard drive to a computer for automatic recognition no software required
- This USB drive provides plug and play simplicity with the included 18 inch USB 3.0 cable
- The available storage capacity may vary.
Compress after the export
gzip blog.bak.sqlThis produces blog.bak.sql.gz. For a streaming compressed export that avoids leaving an uncompressed intermediate file, use:
mysqldump --add-drop-table -h db01.example.net -u dbusername -p dbname | gzip > blog.bak.sql.gzThe WordPress handbook also documents bzip2. gzip is generally faster for large databases, while bzip2 may produce a smaller archive; use whichever your server and restore workflow support.
Rank #4
- Easily store and access 4TB of content on the go with the Seagate Portable Drive, a USB external hard drive.Specific uses: Personal
- Designed to work with Windows or Mac computers, this external hard drive makes backup a snap just drag and drop
- To get set up, connect the portable hard drive to a computer for automatic recognition no software required
- This USB drive provides plug and play simplicity with the included 18 inch USB 3.0 cable
- The available storage capacity may vary.
Method 3: Export with WP-CLI
From the WordPress installation directory, run:
wp db dump backup.sqlWP-CLI reads DB_HOST, DB_NAME, DB_USER, and DB_PASSWORD from wp-config.php, then runs a database dump. You can choose another destination filename, include specific tables with --tables, exclude tables with --exclude_tables, and pass valid mysqldump flags when your environment requires them. WP-CLI documents this command as exporting the database to a file or to standard output.
Store and verify the backup
- Keep the export off the web server, such as on an external USB hard drive or portable SSD.
- Maintain a second copy in another location to protect against server, disk, theft, or accidental-deletion failures.
- Check that the file exists and has a plausible size. An uncompressed SQL dump should open as readable text containing SQL statements; a compressed archive should decompress successfully.
- For a production site, test-import the dump into a staging database before depending on it for disaster recovery. This confirms that the file is usable without replacing the live site’s data.
No universal retention period or storage capacity is specified by the WordPress handbook, so choose a schedule that reflects how often the site changes and how much loss you can tolerate.
Best Value
- [Upgraded Version] - This external hard drive features a mirrored logo stripe combined with a striped anti-slip design, and the rounded corners of the casing make it easier to grip. The stripes also have a heat dissipation function, ensuring stable and fast data transfer.
- 【Ultra-thin and quiet】 - The motherboard adopts JMicron 578 noise-free solution, giving you a quiet working environment. Lightweight and portable size designed to fit in your pocket for easy portability.
- 【Ultra-Fast Data Transfers】 - Pairing this external hard drive with JMicron 578 solution USB 3.0 and USB 2.0 interfaces enables blazing-fast data transfer. It boasts theoretical read speeds of up to 125MB/s and write speeds of up to 103MB/s.
- 【Plug and Play】 - With no software to install, just plug it in and the drive is ready to use.The hard disk chip is wrapped with an aluminum anti-interference layer to increase heat dissipation and protect data.
- 【What You Get】 - 1 x Portable Hard Drive, 1 x USB 3.0 Cable, 1 x User Manual, Gift-type shell packaging ,Three-year manufacturer's warranty and free technical support services.
Restore a database with phpMyAdmin
- Create or select the destination MySQL or MariaDB database.
- Open phpMyAdmin and select that destination database.
- Choose Import.
- Browse to the
.sqlfile, or to an archive format supported by your host, confirm the SQL format, and run the import. - Confirm that the expected WordPress tables, including the site’s actual table prefix, appear afterward.
An import replaces the destination database contents with the state captured in the dump. Any changes made after the backup can therefore be lost. Make a separate backup of the destination before importing if it contains data you may need.
Restore from the command line
Decompress a gzip archive first:
gzip -d blog.bak.sql.gzThen import the SQL file:
mysql -h mysqlhostserver -u mysqlusername -p databasename < blog.bak.sqlEnter the password at the prompt. Verify the destination database and credentials carefully: the command writes directly to the database named in databasename.
Moving the site to another domain
After importing into a different domain, update WordPress’s siteurl and home values in the wp_options table as needed. For all other URL changes, use WordPress-aware search-and-replace tooling so serialized data is handled safely. A plain text replacement can corrupt serialized values and leave the migrated site partially broken.
Which manual method should you use?
| Method | Access required | Best fit | Control |
|---|---|---|---|
| phpMyAdmin | Hosting-panel access | Visual, occasional exports | Quick or Custom table and format options |
| mysqldump | SSH or another shell | Large databases and scripts | Command-line flags, compression, and automation |
| WP-CLI | Shell access and a WordPress installation | WordPress-aware workflows | Table inclusion or exclusion plus mysqldump options |
Command-line exports are usually more practical for large databases when browser upload or download limits interfere. phpMyAdmin is easier when you do not have SSH; WP-CLI is convenient when you already administer the site from its installation directory.
Quick Recap
Common problems and checks
- Wrong database selected: compare the database name and table prefix with
wp-config.phpbefore exporting or importing. - Permission or connection errors: recheck
DB_HOST, username, password, and database privileges; do not assume the host islocalhost. - Browser limits or timeouts: use
mysqldumpor WP-CLI, especially for a large database. - Missing content after recovery: remember that SQL contains database data only; restore the matching themes, plugins, uploads, and other WordPress files as well.
- Broken links after a domain move: update
siteurlandhome, then perform a serialization-safe URL replacement.
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
