How to Backup WordPress Files and Databases

Two Databases Exchanging Data

While most website owners know how important it is to regularly update their website files and databases, many people neglect it due to the time, work, and technical know-how involved in doing so.

This article provides a how to guide for performing WordPress backups of your database and website files. No matter what your technical aptitude, our easy-to-follow instructions have you covered.

Why Backups Matter for WordPress Websites

Backups are the safety nets for WordPress websites and they play an important role in preventing data loss and ensuring website security. Without a reliable strategy, your site can face irretrievable data loss by way of site crashes, hacks, or even just updates that don’t go as planned.

Backing up your WordPress site ensures that, in the event of such disruptions, you can easily restore your website to its previous state. For an effective disaster recovery, you need a recent copy of your website files, which means you must export your site up regularly.

Pressable’s automatic backup feature is a hassle-free solution designed to give you peace of mind. For sites hosted on Pressable, manual exports of site files are performed overnight any time changes are made to the site. Moreover, Pressable offers automatic hourly database storage, which is extremely valuable for busy e-commerce sites where data changes frequently.

However, some scenarios may necessitate a manual backup. Whether it’s for extra precaution before an software update or for personal assurance, the ability to manually export a copy of your WordPress site remains a valuable skill.

In the following sections, we will guide you through the manual backup process, as well as suggest a few plugin options for non-Pressable users.

Manual Database Backup: A Step-by-Step Guide

Manual backups ensure you have a recent snapshot of your site that can be restored if needed. Let’s walk through the process of manually backing up a WordPress database with Pressable, covering both database and file system backups.

Manual backups can be useful for site owners in many circumstances. For example, it’s wise to perform this process ahead of major updates or changes, such as making modifications the WordPress core, updating important plugins, or changing your website’s theme. You should also run a backup ahead of migrating your site to another service so you have a copy you can restore should anything go wrong.

You should also export your site after you make major modifications, such as rehauling landing pages or adding a significant amount of new blog content or multimedia files. This way you know for sure your hard work is saved in multiple places and you won’t inadvertently lose your progress.

Finally, recovering from security incidents or vulnerabilities is another good reason to protect your data. If you’ve just removed malware from your website, you’re in a perfect position to save and store a clean version of your website. You may also want to run more frequent backups in times of heightened security risk, such as an unsuccessful cyberattack.

Think carefully about where and how you store your site files. If backups are included as part of a hosting plan, or you use a service to run backups, then the secondary version of your data will live on a server owned by the service in question. However, you may want to consider saving a version of your website to another location, such as to an external hard drive or secondary cloud storage. This way, you have an extra layer of security should you encounter an issue accessing your digitally stored files when trying to fix your site.

Backing Up a Website Using Pressable’s On-Demand Backups

Here are instructions for manually backing up your website using Pressable’s dashboard, as well as how to export your database and website files manually using Pressable and an SFTP client.

  1. Log into your my.pressable.com dashboard and select the website you want to backup.
  2. Next, select “Manage Data” → “On-Demand Backups”
  3. If you manage multiple websites, be sure you’ve selected the site you want to backup.
  4. Pressable allows users to create and store three “on-demand” backups, so if you’ve reached your limit you’ll need to delete an older site backup.
  5. There are two separate on-demand options that include the WordPress filesystem and the WordPress database. For a full-site backup, you’ll need to export both.
  6. Click the button for the backups you want to run.
  7. When the backup is ready, it will appear in the “On-demand backups for this site” section.

Screenshot of on-demand backups section in the MyPressable Control Panel.

Manually Backing Up Your Database on Pressable Using phpMyAdmin

  1. Log into your my.pressable.com dashboard, select the website whose database you’d like to backup, and select the “phpMyAdmin” icon.
  2. Click on the “Export” tab at the top of the page.
  3. Select your export method. In most cases, “quick” will do, however, if you need to fine-tune your export options you can do so by selecting “custom.”
  4. Save your exported file in a manner that makes it easy to find and identify later. For example, you may decide to save all backup files on a single external hard drive so you know exactly where backups are.

phpMyAdmin Database Export

Backing Up Your WordPress Website Files Using SFTP

  1. Set up SFTP for your Pressable site if you haven’t already done so.
  2. Connect to your site’s files using the SFTP client of your choice. We recommend using FileZilla or Cyberduck SFTP clients.
  3. Select the site files you want to backup, and save them in a clearly labeled, easy-to-find manner similar to your database backup.

Locating SFTP Login Details

WordPress Plugin Options

If you’re not using Pressable and you don’t have the tech know-how to manage backups on your own, you’re going to need a good WordPress plugin. These backup plugins automate the backup process for you, as well as provide opportunities to manually export your site as needed.

However, it’s important to be aware of potential downsides. Some plugins might impact your website’s performance during the backup process, especially if your site is large or contains a lot of data. Belowe are a few plugins we recommend for users who need a solid export solution.

Jetpack Security

Jetpack Security simplifies backups and restoration with its VaultPress feature, allowing one-click actions for both tasks.

Beyond backups, Jetpack Security delivers a suite of tools to enhance your site’s safety, including a website firewall, spam protection, malware scanning, and a 30-day activity log, ensuring comprehensive protection and easy recovery options.

UpdraftPlus

UpdraftPlus is available in both free and premium versions, catering to a wide range of backup needs. The free version includes scheduled backups, storage on remote services like Dropbox and Google Drive, and restoration capabilities.

The premium upgrade introduces incremental backups, additional file and database backup options, and automatic backups following WordPress, plugin, or theme updates. It also allows restoring a backup from other plugins, enhancing its utility and flexibility.

BlogVault

BlogVault is a premium service offering a 7-day free trial. It supports daily scheduled backups, unlimited manual backups, multi-site backup features, and a built-in staging environment.

With additional benefits like website monitoring and an activity log, BlogVault is designed for robust site management and protection.

Pressable Is a Piece of Cake for Peace of Mind

There are several challenges associated with managing backups and restoring your site if you don’t use a managed service like Pressable. For starters, manual website restoration can take considerable time, especially for larger sites or websites that lost significant data.

Users with limited tech expertise may find the process intimidating, as there is a high risk of errors. Even if no issues arise, the process itself can still cause significant stress.

Pressable offers an effortless, reliable means of restoring your site from automatic and on-demand backups. While manual restoration via SFTP remains an option, Pressable simplifies the process with its automatic restoration tool, designed to save time, minimize stress, and guarantee efficiency.

Steps for automatic restoration with Pressable:

  1. Login to my.pressable.com to access your site’s dashboard.
  2. Navigate to Manage Data → Restore Site
  3. Select the Filesystem and Database backup you’d like to restore.
  4. Click the “Restore” button.

Pressable Restore Website Function

And it’s as simple as that!

During restoration, your site will enter maintenance mode, meaning it will be temporarily inaccessible to visitors. This can cause website interruptions, and the length of time your site will stay in maintenance mode varies based on several factors, but it’s mainly down to your website’s size.

Generally speaking, you can expect your site to be down anywhere from a few minutes to several hours. If possible, plan restorations during low-traffic periods to minimize impact on site visitors.

Remember: A website restoration is an irreversible action, so make sure it’s 100% necessary to prevent accidental data overwrites.

Secure Your WordPress Website With Pressable

Keeping your WordPress site safe by regularly backing up your database and files is a must for dealing with the uncertainties of the online world. The convenience of automatic backups, whether through a dedicated plugin or a comprehensive hosting service like Pressable, cannot be overstated.

Don’t let the fear of data loss or site downtime hold you back. Get started with Pressable today and invest in the peace of mind that comes with knowing your WordPress site is protected.

Varsha Adusumilli

A dedicated WordPress user since 2007, Varsha has witnessed the platform’s growth and transformations firsthand. With a Masters’ in Computer Science and experience as a web designer/developer, Varsha possesses a strong foundation in various web development technologies. Her entrepreneurial spirit and freelance background further honed her ability to think creatively and deliver results. This deep understanding, coupled with her technical skills and customer-centric approach, makes her a great part of the Pressable Team. Her genuine desire to help others and her knack for finding solutions make her a customer success rockstar.

Related blog articles