How To Backup And Restore Wordpress From Cpanel

in this tutorial I'm gonna show you how to backup WordPress in cPanel and once it's backed up I'm gonna show you how to restore a wordpress in cPanel using those backup files that you created if you have any questions for this tutorial please leave them in the comments down below I try to answer every single one and if you like this video please like it my name is bjorn allpass in the BPP learning lab where we help you get better at WordPress you can earn more for yourself for your clients and for your business if you haven't done so yet please subscribe so you don't miss any future videos and we're getting started on this one right now we're gonna backup and restore this website right here at WP speed of 5 calm this is a lab domain if you go to the site right now you'll see something that resembles this this is part of a tutorial series that I'm doing on how to speed up a website watch out for that on the channel coming soon and we're gonna back this website up and restore it through cPanel in the next few minutes so first we got to get into cPanel which is inside of your hosting account in my case I'm using SiteGround you should be as well or some other host that is not an e IG host watch this - toilet peer about site lock about why I should not use the edgy host and if you are in your cPanel you then go into let's go to cPanel first and then once you're in cPanel we need to zoom in a little bit so you can see what's happening and inside of the cPanel we have to do two things to back it up and then two things to restore it we have to backup all the site files in the file manager or via FTP it's more comfortable with FTP and we have to back up the database using the PHP my admin software in cPanel first let's backup the files and then restoring is just the opposite we upload the files back to the server the file manager and then we import the database back into phpMyAdmin so first let's open a file manager let's go to the home directory and in here if you have sub accounts they may be listed right here you probably go into public underscore HTML and in here the sub accounts in my case are called Brizzy I'm under 2019 get WP Astra and WP speedify there's two of them and likely this one is the accurate one no it's not if you speed a fight calm okay this is where all the files are so these are the files for this website I'm going to highlight all the files just shift-clicking to highlight all of them I'm gonna right-click and I'm gonna choose compress as a zip file and I'm gonna call this zip file full backup and click on compress files now this will zip all the files which would make it easier to download them this is not possible via FTP if you want to zip the file so you have to do it be a fine manager in cPanel the FTP is going to download all the files to a folder in your hard drive all individually you can zip on your hard drive later if you want to but you can't zip them via FTP click on close when that's done then click on reload and we have our full backup zip file right here and I am going to right click it and choose download now it's telling it right to my hard drive now that's downloaded let's check it out on our hard drive this is the zip file right here full backup it is ninety four point three megabytes I'll be able to back this up using a plugin in WordPress a free plugin but if when your websites too large the free plugins still longer work because they limit you by the amount you can backup as in file size you can backup and if your website is beyond that limit you have to go to the pro version and then backup using the pro version which you have to pay for well I'm showing you here today is free and you can do this anytime it is manual so there's pros and cons but I always believe that you should know how to do something a plugin does on your own before you let the plugin do it and that goes for backups as well so now we have the files of the website now I'm gonna go back in a cPanel leave that tab open I'm going to open PHP myadmin it's gonna control click to open that in a new tab I'm gonna find the database for this website and my databases in here are fairly random names there's two ways you can go about this you can go into every single one these databases let's go to this one for example go to the options file underscore options options table I mean and here you can see if this is the correct site that you're looking for and that's the slow way kind of trial and error the faster way is going back into your files going to the dhobi config file click on edit and edit again and here we'll show you database name right here so this database is WP SPE so we got to go back into PHP my admin and here it is WP SPE so let's open that let's click on the options table just to confirm here's the accurate domain name this is the table that we want now databases is where all the content of your site lives the files provide storage for the images and templates that this content in the database will be fed into so all the written content all the text all the settings where the images are you have an image uploaded to your server in the files but what is the URL to that image where is that image on your website all that information is stored in the database to export the database make sure you click on the top level of the database and go to export and we can just use quick export that's good enough click on go and now our database is being downloaded it's gonna wait a few seconds while that downloads and then we're gonna do something really crazy I do not recommend you do this I'm just doing this for the purposes of this video I'm gonna check all these boxes go down on the very bottom check all options down there and I'm going to drop all these tables yes they're all gone the database is still here but all the tables are gone meaning all the information that is used to construct our site is gone come back out here to the website and i refresh it asks us to install our website it's gonna go as a fresh install from the very beginning now to compound this problem even further I'm going to delete all of the files for the website as well I'm gonna pretend the website is just gone not gonna believe the backup actually yes I am gonna delete everything delete all those files now our directory is empty now I come back out here and we have an internal server error our website is it's gone so now we start the second half the tutorial which is how do we restore our website from the backups we made hopefully we did those backups properly which I think we did and we're gonna find out in just a few minutes first let's go right back to the very beginning back into our cPanel the first thing we want to do is upload our files so let's go to file manager go to home directory or even the root directory will work find our folder which is WP speedify com I want to upload our backup files into here let's click on upload click on choose file I'm gonna choose our full backup click on open now it's gonna upload the 90 megabytes of files up here it shows our maximum file size left for uploads 15.4 to gigabytes which is huge if your website exceeds that what you can do is go on to WP uploads folder which is where the bulk of the size your website will be because that's where your images are stored and all your media is stored you can go and zip up each individual folder inside OTP uploads and download those individually and if you do it that way guaranteed this would be less than your upload limit our uploads done so is in the bottom right as complete we can close this we can refresh out here click on our backup click on extract click on extract files click on close once that's done reload again and here are our files again we can delete the backup we uploaded and the WP content area is just telling you about where the bulky website is is right here and if you go into uploads you'll quite often see things in folders these are images from 2018 and they're broken down by month and the gym it was from 2019 also broken down by month the month they were uploaded to your site so if you find your file size is too big to be uploaded you can come in here zip each of these individually and then upload them individually that's one way you can get around the FOB load limits in cPanel so now that we have our files back we have to get our database back because if we come back out here we now are back to install WordPress but we don't want that we want our website back so let's go into cPanel again go to PHP my admin control clicked to open that this is our database that we dropped let's go to import let's choose file choose the SQL file here open it and then just click on go save all keep all the settings as they are click on go and now please be patient files being uploaded it has been uploaded if we click on the database this looks pretty similar what we had before if we come back out here and refresh websites already installed because we're at this URL let's go back to the home page here we go here's a website back and restored now the one thing I'd be asking is what if you don't have this database to restore to then you have to make a database so you'd come into cPanel and you go to MySQL databases you enter a database name here let's just make a funky one click on create database go back and before you go back copy this to a notepad or summer copied this somewhere where you can copy and paste it into the config file just a minute so copy that to somewhere then create a username and generate a password create the user and copy that username to a notepad as well and now we have to connect the username to the database and I think it's this one that isn't made I don't even remember good so whatever the database and username you just created make sure you know what they are and then you click on add to add them together choose all privileges choose make changes and now this database user that you created is able to use this database with the password that we just created so then we go back into cPanel all the way back up this database will now appear here so if i refresh we don't have a new database with this gibberish right here we can now import our SQL file into this database and then update our credentials inside the dopey config file to be the database username database name database username and password that we just created and then now if we've connected our old site to a new database and it should load just fine just like I did here and that's how we could back up and restore work press in cPanel so that's how it works hope this video helps you if you haven't done so yet please make sure you click Subscribe dang the Bell so you don't miss any future videos and then check out this video up here which shows you how to speed up your website once you have it all backed up and restored that'll make your website a whole lot faster and this one down here will help you make your website more secure so check that out too my name is Ron all passed in the BP learning lab until next time keep crushing it and I will see you in the next video

Channel: WordPress Tutorials - WPLearningLab

Views: 64,810

Keywords: how to backup wordpress site, how to backup wordpress site manually, how to backup wordpress website, how to backup wordpress website from cpanel, backup wordpress, backup wordpress database, how to restore wordpress site, how to restore wordpress website, how to restore wordpress website from cpanel, restore wordpress from backup, backup website, cpanel backup, cpanel tutorial, wordpress backup, wordpress backup plugin, wordpress database backup, bjorn, wplearninglab

Id: 5UH7F_tGyRs

Length: 11min 31sec (691 seconds)

Published: Thu Oct 31 2019