{"id":2225,"date":"2024-09-17T22:56:36","date_gmt":"2024-09-17T17:56:36","guid":{"rendered":"https:\/\/thebeehost.com\/wiki\/?p=2225"},"modified":"2024-09-18T22:25:22","modified_gmt":"2024-09-18T17:25:22","slug":"backing-up-and-restoring-your-wordpress-website-manually","status":"publish","type":"post","link":"https:\/\/thebeehost.com\/wiki\/backing-up-and-restoring-your-wordpress-website-manually\/","title":{"rendered":"Backing Up and Restoring Your WordPress Website Manually"},"content":{"rendered":"<div id=\"bsf_rt_marker\"><\/div><p><span style=\"font-weight: 400;\">Is your website prepared for the unexpected? With WordPress powering over 40% of all websites, it\u2019s a prime target for hacking attempts, unauthorized access, accidental deletion, or technical failures. But don\u2019t worry! In this guide, we\u2019ll cover the methods to create and restore backups, providing step-by-step instructions and making it easy for you to protect your data\u2014regardless of your technical expertise.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">TheBeeHost customers also benefit from our free JetBackup service, offering automatic backups and a simple restoration process. However, for those who prefer more manual control or an added layer of protection, this guide will walk you through how to effectively manage your own backups.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">By the end of this post, you\u2019ll have the tools and knowledge to keep your WordPress website safe, reliable, and operational at all times.<\/span><\/p>\n<h3><b>What is a WordPress Backup?<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">A WordPress backup is a secure copy of all the important elements that make up your website, allowing you to recover from unexpected data loss or system failures. This backup includes two important components:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>The Files<\/b><span style=\"font-weight: 400;\">: These are the static elements of your website, including themes, plugins, and media uploads, as well as the core WordPress files that are responsible for your site&#8217;s functionality and appearance.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>The Database<\/b><span style=\"font-weight: 400;\">: This stores all the dynamic content, such as posts, pages, comments, user data, and site configurations. Without the database, your site would lack the information that gives it structure and purpose.<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">Regularly backing up both components ensures you can fully restore your site if anything goes wrong, whether from data corruption, hacking, or a plugin conflict.<\/span><\/p>\n<h3><b>Manual Backup Method: Step-by-Step Guide<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Backing up your WordPress website manually is a reliable way to maintain full control over your site\u2019s data and ensure that everything is stored securely.<\/span><\/p>\n<h3><b>Backing Up Website Files<\/b><\/h3>\n<h4><b>cPanel File Manager<br \/>\n<\/b><\/h4>\n<p><span style=\"font-weight: 400;\">To back up your website files through cPanel, follow these detailed steps:<\/span><\/p>\n<ol>\n<li><span style=\"font-weight: 400;\"> Access your cPanel hosting account by navigating to <code>https:\/\/yourdomain.com:2083\/<\/code>.\u00a0\u00a0<\/span><\/li>\n<li><span style=\"font-weight: 400;\"> Once in cPanel, navigate to the <\/span><b>Files<\/b><span style=\"font-weight: 400;\"> section and click on <\/span><b>File Manager<\/b><span style=\"font-weight: 400;\">.<img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-2287\" src=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/cP-File-Manager.webp\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/cP-File-Manager.webp 1920w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/cP-File-Manager-300x169.webp 300w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/cP-File-Manager-1024x576.webp 1024w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/cP-File-Manager-768x432.webp 768w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/cP-File-Manager-1536x864.webp 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/span><\/li>\n<li><span style=\"font-weight: 400;\">In the File Manager, open the domain\u2019s <\/span><b>public_html<\/b><span style=\"font-weight: 400;\"> directory, which contains all the files for your website.<img decoding=\"async\" class=\"aligncenter size-full wp-image-2290\" src=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/domainpublic_html.webp\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/domainpublic_html.webp 1920w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/domainpublic_html-300x169.webp 300w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/domainpublic_html-1024x576.webp 1024w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/domainpublic_html-768x432.webp 768w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/domainpublic_html-1536x864.webp 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/span><\/li>\n<li><span style=\"font-weight: 400;\">Select all the files in the <\/span><b>public_html<\/b><span style=\"font-weight: 400;\"> folder. You can do this by clicking the <\/span><b>Select All<\/b><span style=\"font-weight: 400;\"> button at the top or manually selecting files with <code>Ctrl + Click (Windows)<\/code> or <code>Command + Click (Mac)<\/code>.<br \/>\n<img decoding=\"async\" class=\"aligncenter size-full wp-image-2230\" src=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Select-All-Files.webp\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Select-All-Files.webp 1920w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Select-All-Files-300x169.webp 300w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Select-All-Files-1024x576.webp 1024w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Select-All-Files-768x432.webp 768w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Select-All-Files-1536x864.webp 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/span><\/li>\n<li><span style=\"font-weight: 400;\">After selecting the files, right-click and click on <\/span><b>Compress<\/b><span style=\"font-weight: 400;\">.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2232\" src=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Compress.webp\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Compress.webp 1920w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Compress-300x169.webp 300w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Compress-1024x576.webp 1024w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Compress-768x432.webp 768w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Compress-1536x864.webp 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/span><\/li>\n<li><span style=\"font-weight: 400;\">Choose the <\/span><b>Zip Archive<\/b><span style=\"font-weight: 400;\"> option and name your compressed file <code>(e.g., files-backup-15-09-2024.zip)<\/code>. This naming convention helps you keep track of different backup versions easily.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2231\" src=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Zip-Archive.webp\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Zip-Archive.webp 1920w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Zip-Archive-300x169.webp 300w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Zip-Archive-1024x576.webp 1024w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Zip-Archive-768x432.webp 768w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Zip-Archive-1536x864.webp 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/span><\/li>\n<li><span style=\"font-weight: 400;\">Once the files are compressed, right-click on the compressed file and select <\/span><b>Download<\/b><span style=\"font-weight: 400;\"><span style=\"font-weight: 400;\"> to save the backup to your local machine.<\/span><\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2233\" src=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Download-Zip-Archive.webp\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Download-Zip-Archive.webp 1920w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Download-Zip-Archive-300x169.webp 300w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Download-Zip-Archive-1024x576.webp 1024w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Download-Zip-Archive-768x432.webp 768w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Download-Zip-Archive-1536x864.webp 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">You now have a full backup of your website files stored locally.<\/span><\/p>\n<h4><b>DirectAdmin File Manager<br \/>\n<\/b><\/h4>\n<p><span style=\"font-weight: 400;\">DirectAdmin users can follow these steps to manually back up their website files:<\/span><\/p>\n<ol>\n<li><span style=\"font-weight: 400;\"> Access the DirectAdmin hosting control panel by navigating to <code>https:\/\/yourdomain.com:2222<\/code>.<\/span><\/li>\n<li><span style=\"font-weight: 400;\"> Once logged in, locate the <\/span><b>System Info &amp; Files<\/b><span style=\"font-weight: 400;\"> section, and click on <\/span><b>File Manager<\/b><span style=\"font-weight: 400;\">.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2234\" src=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/DirectAdmin-File-Manager.webp\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/DirectAdmin-File-Manager.webp 1920w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/DirectAdmin-File-Manager-300x169.webp 300w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/DirectAdmin-File-Manager-1024x576.webp 1024w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/DirectAdmin-File-Manager-768x432.webp 768w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/DirectAdmin-File-Manager-1536x864.webp 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/span><\/li>\n<li><span style=\"font-weight: 400;\">Navigate to the <\/span><b>domains<\/b><span style=\"font-weight: 400;\"> folder, then open the folder corresponding to your domain (e.g., <code>yourdomain.com<\/code>). Inside this, find the <\/span><b>public_html<\/b><span style=\"font-weight: 400;\"> folder containing your website files.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2235\" src=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/yourdomain.com_public_html.webp\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/yourdomain.com_public_html.webp 1920w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/yourdomain.com_public_html-300x169.webp 300w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/yourdomain.com_public_html-1024x576.webp 1024w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/yourdomain.com_public_html-768x432.webp 768w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/yourdomain.com_public_html-1536x864.webp 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/span><\/li>\n<li><span style=\"font-weight: 400;\">Select the necessary files in the <\/span><b>public_html<\/b><span style=\"font-weight: 400;\"> directory that you want to back up.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2236\" src=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Select-Files-DA.webp\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Select-Files-DA.webp 1920w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Select-Files-DA-300x169.webp 300w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Select-Files-DA-1024x576.webp 1024w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Select-Files-DA-768x432.webp 768w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Select-Files-DA-1536x864.webp 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/span><\/li>\n<li><span style=\"font-weight: 400;\">Right-click and click on <strong>Add To<\/strong><\/span><b>\u00a0Archive<\/b><span style=\"font-weight: 400;\"> from the options menu and choose to compress the files.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2237\" src=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Add-To-Archive.webp\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Add-To-Archive.webp 1920w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Add-To-Archive-300x169.webp 300w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Add-To-Archive-1024x576.webp 1024w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Add-To-Archive-768x432.webp 768w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Add-To-Archive-1536x864.webp 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/span><\/li>\n<li><span style=\"font-weight: 400;\">After the archive is created, right-click on it and choose <\/span><b>Download<\/b><span style=\"font-weight: 400;\"> to save the backup to your computer.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2238\" src=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Download-Backup-File-DA.webp\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Download-Backup-File-DA.webp 1920w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Download-Backup-File-DA-300x169.webp 300w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Download-Backup-File-DA-1024x576.webp 1024w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Download-Backup-File-DA-768x432.webp 768w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Download-Backup-File-DA-1536x864.webp 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/span><\/li>\n<\/ol>\n<h4><b>FTP Client (FileZilla)<\/b><\/h4>\n<p><span style=\"font-weight: 400;\">An FTP (File Transfer Protocol) client is an application software that allows you to connect directly to your website\u2019s server to manage files. It provides a user-friendly interface to upload, download, and modify files between your local computer and the server where your website is hosted.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Using an FTP client is particularly beneficial when dealing with large backup files that may exceed the size limits of hosting control panels like cPanel or DirectAdmin. FTP clients allow for unlimited file sizes and provide a stable connection for uploading, along with features like pausing and resuming transfers.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">In this guide, we\u2019re using FileZilla, follow these steps to back up your files using it:<\/span><\/p>\n<ol>\n<li><span style=\"font-weight: 400;\"> Open FileZilla and connect to your server by entering your FTP credentials (host, username, password, and port).\u00a0<\/span><\/li>\n<\/ol>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\"><strong>Hostname<\/strong>: ftp.yourdomain.com<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Use your hosting account credentials in the username and password fields.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\"><strong>Port<\/strong>: 21<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2239\" src=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/FileZilla.webp\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/FileZilla.webp 1920w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/FileZilla-300x169.webp 300w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/FileZilla-1024x576.webp 1024w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/FileZilla-768x432.webp 768w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/FileZilla-1536x864.webp 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/span><\/li>\n<\/ul>\n<ol start=\"2\">\n<li><span style=\"font-weight: 400;\">Once connected, navigate to the <\/span><b>public_html<\/b><span style=\"font-weight: 400;\"> directory on the server, which contains all your website files.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2240\" src=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/FileZilla-public_html.webp\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/FileZilla-public_html.webp 1920w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/FileZilla-public_html-300x169.webp 300w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/FileZilla-public_html-1024x576.webp 1024w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/FileZilla-public_html-768x432.webp 768w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/FileZilla-public_html-1536x864.webp 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/span><\/li>\n<li><span style=\"font-weight: 400;\">Select the files you want to back up, then right-click and choose <\/span><b>Download<\/b><span style=\"font-weight: 400;\">. This will copy the files to a folder on your local machine.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2241\" src=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Download-Files-FileZilla.webp\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Download-Files-FileZilla.webp 1920w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Download-Files-FileZilla-300x169.webp 300w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Download-Files-FileZilla-1024x576.webp 1024w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Download-Files-FileZilla-768x432.webp 768w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Download-Files-FileZilla-1536x864.webp 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/span><\/li>\n<li><span style=\"font-weight: 400;\">Once the download is complete, verify that all the necessary files have been transferred to your local machine.<\/span><\/li>\n<li><span style=\"font-weight: 400;\"> Afterwards, zip the downloaded files locally.<\/span><\/li>\n<\/ol>\n<h3><b>Backup Database <\/b><\/h3>\n<p><span style=\"font-weight: 400;\">The next step in your manual backup process is to back up your website\u2019s database, which contains all your site\u2019s content and settings.<\/span><\/p>\n<h4><b>Identify Your Website\u2019s Associated Database<\/b><\/h4>\n<p><span style=\"font-weight: 400;\">To back up your WordPress database, you first need to identify which database is associated with your website. Here\u2019s how you can find that information:<\/span><\/p>\n<ol>\n<li><span style=\"font-weight: 400;\"> Within the<\/span><b> File Manager<\/b><span style=\"font-weight: 400;\"> interface, locate and open the <\/span><code>wp-config.php <\/code><span style=\"font-weight: 400;\">file in your domain&#8217;s document root, i.e. <\/span><b>public_html<\/b><span style=\"font-weight: 400;\"> directory.<\/span><\/li>\n<li><span style=\"font-weight: 400;\"> Scroll down through the<\/span> <code>wp-config.php<\/code><span style=\"font-weight: 400;\"> file until you find the section that defines the database settings. Look for the line that starts with <code>define( 'DB_NAME', 'your_database_name' );<\/code>.\u00a0<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">This line specifies the name of the database associated with your WordPress site. Note this database name, as you\u2019ll need it for the backup process.<\/span><\/p>\n<ol start=\"3\">\n<li><span style=\"font-weight: 400;\"> Return to your hosting control panel and open <\/span><b>phpMyAdmin.<\/b><\/li>\n<\/ol>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">In cPanel, scroll down to the <\/span><b>Databases<\/b><span style=\"font-weight: 400;\"> section and click on <\/span><b>phpMyAdmin<\/b><span style=\"font-weight: 400;\">.<span style=\"text-decoration: underline;\"><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2242\" src=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/cPanel-phpMyAdmin.webp\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/cPanel-phpMyAdmin.webp 1920w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/cPanel-phpMyAdmin-300x169.webp 300w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/cPanel-phpMyAdmin-1024x576.webp 1024w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/cPanel-phpMyAdmin-768x432.webp 768w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/cPanel-phpMyAdmin-1536x864.webp 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/span><\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">In DirectAdmin, scroll down to the <\/span><b>Extra Features <\/b><span style=\"font-weight: 400;\">section and click on <\/span><b>phpMyAdmin<\/b><span style=\"font-weight: 400;\">.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2243\" src=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/DirectAdmin-phpMyAdmin.webp\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/DirectAdmin-phpMyAdmin.webp 1920w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/DirectAdmin-phpMyAdmin-300x169.webp 300w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/DirectAdmin-phpMyAdmin-1024x576.webp 1024w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/DirectAdmin-phpMyAdmin-768x432.webp 768w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/DirectAdmin-phpMyAdmin-1536x864.webp 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/span><\/li>\n<\/ul>\n<ol start=\"4\">\n<li><span style=\"font-weight: 400;\">Once inside phpMyAdmin, find and select the database name you noted from the <\/span><code><span style=\"font-weight: 400;\">wp-config.php<\/span><\/code><span style=\"font-weight: 400;\"> file from the list on the left-hand panel.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2244\" src=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Database-phpMyAdmin.webp\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Database-phpMyAdmin.webp 1920w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Database-phpMyAdmin-300x169.webp 300w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Database-phpMyAdmin-1024x576.webp 1024w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Database-phpMyAdmin-768x432.webp 768w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Database-phpMyAdmin-1536x864.webp 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/span><\/li>\n<li><span style=\"font-weight: 400;\">At the top of the phpMyAdmin interface, click the <\/span><b>Export<\/b><span style=\"font-weight: 400;\"> tab.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2245\" src=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Export-DB.webp\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Export-DB.webp 1920w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Export-DB-300x169.webp 300w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Export-DB-1024x576.webp 1024w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Export-DB-768x432.webp 768w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Export-DB-1536x864.webp 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/span><\/li>\n<li><span style=\"font-weight: 400;\">Click the <\/span><b>Export <\/b><span style=\"font-weight: 400;\">button and your database will be exported as an SQL file. Save this file to your local machine for safekeeping.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2246\" src=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/DB-Exporting.webp\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/DB-Exporting.webp 1920w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/DB-Exporting-300x169.webp 300w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/DB-Exporting-1024x576.webp 1024w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/DB-Exporting-768x432.webp 768w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/DB-Exporting-1536x864.webp 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">Your database backup is now stored and ready for future use.<\/span><\/p>\n<h3><b>Backup Restoration<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">In case of a website failure or data loss, you\u2019ll need to restore your backups to bring your site back online. Here\u2019s how to restore both your files and database.<\/span><\/p>\n<h3><b>Restoring Website Files<\/b><\/h3>\n<h4><b>cPanel <\/b><b>File Manager<\/b><\/h4>\n<ol>\n<li><span style=\"font-weight: 400;\"> Access cPanel and go to <\/span><b>File Manager <\/b><span style=\"font-weight: 400;\">under the <\/span><b>Files <\/b><span style=\"font-weight: 400;\">section.<\/span><\/li>\n<li><span style=\"font-weight: 400;\"> Navigate to your domain\u2019s <\/span><b>public_html <\/b><span style=\"font-weight: 400;\">folder, and select and delete the <\/span><i><span style=\"font-weight: 400;\">domain\u2019s associated existing files<\/span><\/i><span style=\"font-weight: 400;\"> to avoid conflicts with the restored backup.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2247\" src=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Delete-Files.webp\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Delete-Files.webp 1920w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Delete-Files-300x169.webp 300w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Delete-Files-1024x576.webp 1024w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Delete-Files-768x432.webp 768w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Delete-Files-1536x864.webp 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/span><\/li>\n<li><span style=\"font-weight: 400;\">After deleting the old files, upload the<strong> backup zip<\/strong> file.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2248\" src=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Upload-Files.webp\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Upload-Files.webp 1920w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Upload-Files-300x169.webp 300w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Upload-Files-1024x576.webp 1024w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Upload-Files-768x432.webp 768w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Upload-Files-1536x864.webp 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2249\" src=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/File-Uploading.webp\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/File-Uploading.webp 1920w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/File-Uploading-300x169.webp 300w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/File-Uploading-1024x576.webp 1024w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/File-Uploading-768x432.webp 768w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/File-Uploading-1536x864.webp 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/span><\/li>\n<li><span style=\"font-weight: 400;\">Once the upload is complete, right-click the zip file and choose <\/span><b>Extract<\/b><span style=\"font-weight: 400;\"> to restore the files to your website.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2250\" src=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Extracting-Backup.webp\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Extracting-Backup.webp 1920w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Extracting-Backup-300x169.webp 300w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Extracting-Backup-1024x576.webp 1024w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Extracting-Backup-768x432.webp 768w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Extracting-Backup-1536x864.webp 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/span><\/li>\n<\/ol>\n<h4><b>DirectAdmin <\/b><b>File Manager<\/b><\/h4>\n<ol>\n<li><span style=\"font-weight: 400;\"> Access your DirectAdmin control panel and navigate to the <\/span><b>System Info &amp; Files<\/b><span style=\"font-weight: 400;\"> section. There, click on <\/span><b>File Manager<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<li><span style=\"font-weight: 400;\"> Navigate to the <code>domains<\/code> directory, then open the <\/span><b>public_html<\/b><span style=\"font-weight: 400;\"> folder corresponding to your domain.<\/span><\/li>\n<li><span style=\"font-weight: 400;\"> Select the existing files <\/span><i><span style=\"font-weight: 400;\">associated with your domain<\/span><\/i><span style=\"font-weight: 400;\"> in the directory and delete them to prevent any conflicts.<br \/>\n<\/span><\/li>\n<li><span style=\"font-weight: 400;\"> Click on <\/span><b>Upload Files<\/b><span style=\"font-weight: 400;\"> and select your backup archive file <code>(files-backup-15-09-2024.zip)<\/code> from your local machine.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2251\" src=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Upload-Files-in-DirectAdmin.webp\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Upload-Files-in-DirectAdmin.webp 1920w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Upload-Files-in-DirectAdmin-300x169.webp 300w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Upload-Files-in-DirectAdmin-1024x576.webp 1024w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Upload-Files-in-DirectAdmin-768x432.webp 768w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Upload-Files-in-DirectAdmin-1536x864.webp 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2252\" src=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/File-Uploading-DA.webp\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/File-Uploading-DA.webp 1920w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/File-Uploading-DA-300x169.webp 300w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/File-Uploading-DA-1024x576.webp 1024w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/File-Uploading-DA-768x432.webp 768w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/File-Uploading-DA-1536x864.webp 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/span><\/li>\n<li><span style=\"font-weight: 400;\">After the upload is complete, right-click on the uploaded zip file, and click on <\/span><b>Extract<\/b><span style=\"font-weight: 400;\"> from the options menu. This will decompress the backup files into the directory.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2253\" src=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Extract-File-DA.webp\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Extract-File-DA.webp 1920w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Extract-File-DA-300x169.webp 300w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Extract-File-DA-1024x576.webp 1024w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Extract-File-DA-768x432.webp 768w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Extract-File-DA-1536x864.webp 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/span><\/li>\n<li><span style=\"font-weight: 400;\">Make sure all files have been properly extracted and are in the correct directories.<\/span><\/li>\n<\/ol>\n<h4><b>FTP Client (FileZilla)<\/b><\/h4>\n<p><span style=\"font-weight: 400;\">For uploading the backup file using an FTP client such as FileZilla, you can follow these steps:<\/span><\/p>\n<ol>\n<li><span style=\"font-weight: 400;\"> Open the FileZilla FTP client on your computer.<\/span><\/li>\n<li><span style=\"font-weight: 400;\"> On the server side (right panel), navigate to the <strong>public_html<\/strong>\u00a0directory of the domain.<\/span><\/li>\n<li><span style=\"font-weight: 400;\"> Select the existing files and folders in the directory <\/span><i><span style=\"font-weight: 400;\">associated with the domain<\/span><\/i><span style=\"font-weight: 400;\">, right-click, and choose<\/span><b> Delete<\/b><span style=\"font-weight: 400;\"> to remove them.<\/span><\/li>\n<li><span style=\"font-weight: 400;\"> On the local side (left panel), navigate to the folder where your backup file is stored.<br \/>\n<\/span><\/li>\n<li><span style=\"font-weight: 400;\"> Select the backup file you zipped earlier (locally), right-click, and choose <\/span><b>Upload<\/b><span style=\"font-weight: 400;\">. The file will begin transferring to the server directory.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2254\" src=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Upload-File-FileZilla.webp\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Upload-File-FileZilla.webp 1920w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Upload-File-FileZilla-300x169.webp 300w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Upload-File-FileZilla-1024x576.webp 1024w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Upload-File-FileZilla-768x432.webp 768w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Upload-File-FileZilla-1536x864.webp 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/span><\/li>\n<li><span style=\"font-weight: 400;\">Keep an eye on the <\/span><b>Queued files<\/b><span style=\"font-weight: 400;\"> section to ensure the backup is uploaded successfully without errors.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2255\" src=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Upload-Completed-FileZilla.webp\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Upload-Completed-FileZilla.webp 1920w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Upload-Completed-FileZilla-300x169.webp 300w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Upload-Completed-FileZilla-1024x576.webp 1024w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Upload-Completed-FileZilla-768x432.webp 768w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Upload-Completed-FileZilla-1536x864.webp 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/span><\/li>\n<li><span style=\"font-weight: 400;\">Once the transfer is complete, extract the zip file on the server.<\/span><\/li>\n<\/ol>\n<h3><b>Creating a New Database in cPanel and DirectAdmin<\/b><\/h3>\n<h4><b>Why Create a New Database?<\/b><\/h4>\n<p><span style=\"font-weight: 400;\">A new database keeps your restored site separate from other sites or installations.It helps in maintaining a clean structure, making management and troubleshooting easier.<\/span><\/p>\n<h4><b>cPanel<\/b><\/h4>\n<ol>\n<li><span style=\"font-weight: 400;\"> Access your cPanel dashboard.<\/span><\/li>\n<li><span style=\"font-weight: 400;\"> Navigate to the <\/span><b>Databases<\/b><span style=\"font-weight: 400;\"> section and click on <\/span><b>MySQL Databases<\/b><span style=\"font-weight: 400;\">.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2256\" src=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/MySQL-Databases.webp\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/MySQL-Databases.webp 1920w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/MySQL-Databases-300x169.webp 300w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/MySQL-Databases-1024x576.webp 1024w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/MySQL-Databases-768x432.webp 768w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/MySQL-Databases-1536x864.webp 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/span><\/li>\n<li><span style=\"font-weight: 400;\">In the <\/span><b>Create New Database<\/b><span style=\"font-weight: 400;\"> field, enter a name for your database and c<\/span>lick <b>Create Database<\/b>.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2257\" src=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Create-New-Database.webp\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Create-New-Database.webp 1920w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Create-New-Database-300x169.webp 300w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Create-New-Database-1024x576.webp 1024w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Create-New-Database-768x432.webp 768w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Create-New-Database-1536x864.webp 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/li>\n<li><span style=\"font-weight: 400;\">Scroll down to <\/span><b>MySQL Users<\/b><span style=\"font-weight: 400;\"> and add a new user by entering a username and password and c<\/span>lick <b>Create User<\/b>.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2258\" src=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Add-Database-User.webp\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Add-Database-User.webp 1920w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Add-Database-User-300x169.webp 300w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Add-Database-User-1024x576.webp 1024w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Add-Database-User-768x432.webp 768w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Add-Database-User-1536x864.webp 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/li>\n<\/ol>\n<ol start=\"5\">\n<li><span style=\"font-weight: 400;\">Under <\/span><b>Add User To Database<\/b><span style=\"font-weight: 400;\">, select the user and the database you just created.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2259\" src=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Add-User-To-Database.webp\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Add-User-To-Database.webp 1920w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Add-User-To-Database-300x169.webp 300w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Add-User-To-Database-1024x576.webp 1024w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Add-User-To-Database-768x432.webp 768w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Add-User-To-Database-1536x864.webp 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/span><\/li>\n<\/ol>\n<ol start=\"6\">\n<li><span style=\"font-weight: 400;\">On the next screen, check <\/span><b>All Privileges<\/b><span style=\"font-weight: 400;\"> to grant full access and click <\/span><b>Make Changes<\/b><span style=\"font-weight: 400;\">.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2260\" src=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Assign-Privileges.webp\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Assign-Privileges.webp 1920w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Assign-Privileges-300x169.webp 300w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Assign-Privileges-1024x576.webp 1024w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Assign-Privileges-768x432.webp 768w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Assign-Privileges-1536x864.webp 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/span><\/li>\n<li><span style=\"font-weight: 400;\">Keep a note of the database name, username, and password. You will need these details to update your <code>wp-config.php<\/code>\u00a0file.<\/span><\/li>\n<\/ol>\n<h4><b>DirectAdmin<\/b><\/h4>\n<ol>\n<li><span style=\"font-weight: 400;\"> Access your DirectAdmin control panel.<\/span><\/li>\n<li><span style=\"font-weight: 400;\"> Under the <\/span><b>Account Manager<\/b><span style=\"font-weight: 400;\"> section, click on <\/span><b>Databases<\/b><span style=\"font-weight: 400;\">.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2263\" src=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Databases-DirectAdmin.webp\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Databases-DirectAdmin.webp 1920w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Databases-DirectAdmin-300x169.webp 300w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Databases-DirectAdmin-1024x576.webp 1024w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Databases-DirectAdmin-768x432.webp 768w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Databases-DirectAdmin-1536x864.webp 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/span><\/li>\n<li><span style=\"font-weight: 400;\">Scroll down and in the <\/span><b>Create New Database <\/b><span style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">section, enter the database name.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2264\" src=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Create-Database-DirectAdmin.webp\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Create-Database-DirectAdmin.webp 1920w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Create-Database-DirectAdmin-300x169.webp 300w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Create-Database-DirectAdmin-1024x576.webp 1024w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Create-Database-DirectAdmin-768x432.webp 768w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Create-Database-DirectAdmin-1536x864.webp 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/span><\/span><\/p>\n<div style=\"background-color: #edffee; border: 1px solid #3eff4a; padding: 22px; margin: 20px 0; border-radius: 15px; font-family: Figtree, sans-serif;\">\n<p style=\"margin: 0; \/* remove default paragraph margin *\/ color: #333;\">You can choose between the simple and advanced database creation forms. The advanced form offers more control, allowing you to create a database with a distinct username and manually set passwords.<\/p>\n<\/div>\n<\/li>\n<li><span style=\"font-weight: 400;\"> Note down the database name, username, and password for updating your <code>wp-config.php<\/code> file.<br \/>\n<\/span><\/li>\n<\/ol>\n<h3><b>Restoring the Database<br \/>\n<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">With your new database created, you can now upload your backed-up database into it using phpMyAdmin.<\/span><\/p>\n<ol>\n<li><span style=\"font-weight: 400;\"> Access phpMyAdmin, In the left sidebar, click on the name of the new database you created.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2265\" src=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Created-Database-phpMyAdmin.webp\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Created-Database-phpMyAdmin.webp 1920w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Created-Database-phpMyAdmin-300x169.webp 300w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Created-Database-phpMyAdmin-1024x576.webp 1024w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Created-Database-phpMyAdmin-768x432.webp 768w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Created-Database-phpMyAdmin-1536x864.webp 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/span><\/li>\n<li><span style=\"font-weight: 400;\">Click on the <\/span><b>Import<\/b><span style=\"font-weight: 400;\"> tab at the top of the page.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2266\" src=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Import-Database.webp\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Import-Database.webp 1920w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Import-Database-300x169.webp 300w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Import-Database-1024x576.webp 1024w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Import-Database-768x432.webp 768w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Import-Database-1536x864.webp 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/span><\/li>\n<li><span style=\"font-weight: 400;\">Under <\/span><b>File to import<\/b><span style=\"font-weight: 400;\">, click <\/span><b>Choose File<\/b><span style=\"font-weight: 400;\"> to import the backed-up (SQL file) database from your local machine.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2267\" src=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Choose-File-To-Import.webp\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Choose-File-To-Import.webp 1920w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Choose-File-To-Import-300x169.webp 300w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Choose-File-To-Import-1024x576.webp 1024w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Choose-File-To-Import-768x432.webp 768w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Choose-File-To-Import-1536x864.webp 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/span><\/li>\n<li><span style=\"font-weight: 400;\">Click <\/span><b>Import<\/b><span style=\"font-weight: 400;\"> at the bottom of the page to begin the import process.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2268\" src=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Import-SQL-DB.webp\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Import-SQL-DB.webp 1920w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Import-SQL-DB-300x169.webp 300w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Import-SQL-DB-1024x576.webp 1024w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Import-SQL-DB-768x432.webp 768w, https:\/\/thebeehost.com\/wiki\/wp-content\/uploads\/2024\/09\/Import-SQL-DB-1536x864.webp 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/span><\/li>\n<li><span style=\"font-weight: 400;\">Once the import is complete, you should see a message indicating a successful import.<\/span><\/li>\n<li><span style=\"font-weight: 400;\"> Return to the <\/span><b>File Manager<\/b><span style=\"font-weight: 400;\"> in cPanel or DirectAdmin and open the <code>wp-config.php<\/code>\u00a0file in your website&#8217;s root directory.<\/span><\/li>\n<\/ol>\n<ul>\n<li><span style=\"font-weight: 400;\">Update the database name, username, and password to match the new database you just imported:<\/span><\/li>\n<\/ul>\n<pre>define('DB_NAME', 'user_newdb'); \/\/ Replace with actual database name\r\n<span style=\"font-weight: 400;\">define('DB_USER', 'user_newuser'); \/\/ Replace with actual database user\r\n<\/span><span style=\"font-weight: 400;\">define('DB_PASSWORD', 'password'); \/\/ Replace with actual database password<\/span><\/pre>\n<ol start=\"7\">\n<li><span style=\"font-weight: 400;\"> Save and close the <code>wp-config.php<\/code>\u00a0file.<\/span><\/li>\n<\/ol>\n<h4><b>Finalizing the Restoration<\/b><\/h4>\n<p><span style=\"font-weight: 400;\">After restoring both your website files and database, and updating your configuration files, your website should be up and running.<\/span><\/p>\n<h3><b>Automating Backups<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Manually backing up your site on a regular basis can be time-consuming and prone to human error. That\u2019s why automating the process is one of the best ways to ensure your data is consistently protected.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Being <\/span><a href=\"https:\/\/thebeehost.com\/\"><span style=\"font-weight: 400;\">TheBeeHost<\/span><\/a><span style=\"font-weight: 400;\"> customers, you can also take advantage of our free JetBackup service, which automates backups and allows you to easily restore your website with just a few clicks. This service is available to all clients, automatically creating regular backups of your website and storing them off-site, ensuring that your data is safe even if there\u2019s an issue with your server.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">You can follow this guide to restore <\/span><a href=\"https:\/\/thebeehost.com\/wiki\/restore-thebeehost-free-generated-backups\/\"><span style=\"font-weight: 400;\">TheBeeHost&#8217;s free generated backups<\/span><\/a><span style=\"font-weight: 400;\"> for more information on using this service.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">With automated backups in place, you can rest assured that your data is being consistently safeguarded without the need for constant manual intervention.<\/span><\/p>\n<h3><b>Storing Backups Off-Site (Cloud or External Drive)<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Equally important as taking regular backups is storing them in a secure, off-site location. Relying solely on your website\u2019s server or hosting provider for backup storage is risky. If your server experiences a failure, or if there\u2019s a security breach, your backups could be compromised as well.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">To prevent this, it\u2019s best practice to store backups off-site, either on a cloud storage service like Google Drive, Dropbox, or Amazon S3, or on an external hard drive. By storing backups off-site, you ensure that they remain safe and accessible, even in the event of a total server failure or a hacking incident.<\/span><\/p>\n<h3><b>Final Thoughts<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">When it comes to backing up your WordPress website, there\u2019s no one-size-fits-all solution. Your backup method should reflect the unique needs of your site. Having regular, automated backups that are securely stored off-site can save you from the irreversible damage caused by data loss, cyberattacks, or technical errors. With a solid backup strategy in place, you can safeguard your WordPress website from unexpected issues and keep your online presence secure.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Thank you for taking the time to follow this guide. If you encounter any issues or need further assistance, our <\/span><b>TheBeeHost Technical Support<\/b><span style=\"font-weight: 400;\"> team is always here to help. Feel free to reach out to us, and we\u2019ll ensure your website remains safe, secure, and fully operational.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"tmnf_excerpt\"><p>Is your website prepared for the unexpected? With WordPress powering over 40% of all websites, it\u2019s a prime target for hacking attempts, unauthorized access, accidental deletion, or technical failures. But don\u2019t worry! In this guide, we\u2019ll cover the methods to create and restore backups, providing step-by-step instructions and making it easy for you to protect &hellip;<\/p>\n<\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[8],"tags":[],"class_list":["post-2225","post","type-post","status-publish","format-standard","hentry","category-how-to-restore-backups"],"_links":{"self":[{"href":"https:\/\/thebeehost.com\/wiki\/wp-json\/wp\/v2\/posts\/2225","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/thebeehost.com\/wiki\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/thebeehost.com\/wiki\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/thebeehost.com\/wiki\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/thebeehost.com\/wiki\/wp-json\/wp\/v2\/comments?post=2225"}],"version-history":[{"count":0,"href":"https:\/\/thebeehost.com\/wiki\/wp-json\/wp\/v2\/posts\/2225\/revisions"}],"wp:attachment":[{"href":"https:\/\/thebeehost.com\/wiki\/wp-json\/wp\/v2\/media?parent=2225"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/thebeehost.com\/wiki\/wp-json\/wp\/v2\/categories?post=2225"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/thebeehost.com\/wiki\/wp-json\/wp\/v2\/tags?post=2225"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}