Manually Restore WordPress Site From Backup (Database, Files & Folders)

No video

Manually Restore WordPress Site From Backup (Database, Files & Folders) | WP Learning Lab

Рет қаралды 219,047

Күн бұрын

Grab Your Free 17-Point WordPress Pre-Launch PDF Checklist: wplearninglab....
Manually Restore WordPress Site From Backup (Database, Files & Folders) • Manually Restore WordP...
Exclusive for WPLearningLab viewers, up to 50% off hosting: wplearninglab....
Download our exclusive 10-Point WP Hardening Checklist: bit.ly/10point-...
In this tutorial I'm going to show you how to manually restore your WordPress site from a backup. We will restore the database, files and folders.
The free versions of a lot of WordPress backup plugins don't have an automatic restore function so if you need to restore your website you have to do it manually.
First let's upload your WordPress website files and folders. Log into your hosting cPanel account and click on File Manager. Open the root of the WordPress website you're restoring.
Once you're in the root upload the ZIP file that contains all your WordPress site files and folders. Once uploaded select all the files in your website root, except for the ZIP, and delete them.
Now click on the ZIP file and click on Extract. That will place all the site files in the root directory.
Now let's restore WordPress database.
Go back into your hosting account cPanel and open the PHPMyAdmin app.
When it loads find your database name in the left hand column and click on it. All of the tables should load in the middle pane. Check the box to the left of all the tables to select them and then scroll to the bottom of the page.
From the drop down select Drop and then click on Go and then Yes on the next page. This will delete your entire WordPress website database.
Now click on the Import tab at the top. Click on the Browse button and find your .sql backup file and click on Open. Then click on Go and your database will be uploaded.
That's all there is to restoring WordPress and restore WP database.. I hope this information helps you! If you have any questions leave a comment below or ping me @WPLearningLab on Twitter.
--------------
If you want more excellent WordPress information check out our website where we post WordPress tutorials daily.
wplearninglab.com/
Connect with us:
WP Learning Lab Channel: www.youtube.com...
Facebook: / wplearninglab
Twitter: / wplearninglab
Google Plus: google.com/+Wpl...
Pinterest: / wplearninglab

Пікірлер: 385

@Mr.Zen_73 Жыл бұрын

7 years later and this video saved my ass! Couldn't for the life of me work out how to restore my wordpress website from backup files I did a few years ago (and forgot how I did the backup). Website is working perfectly again now!

@rifatmia1308 2 күн бұрын

I am happy to see this video 7 years later. Thanks ❤

@wplearninglab 9 жыл бұрын

[VIDEO] Manually restore WordPress site from backup (database, files & folders) kzfaq.info/get/bejne/bbiRrbCG06iqnoU.html #WordPress #tutorial

@MrWcredranger 8 жыл бұрын

+WP Learning Lab Can you restore a site with just phpmyadmin backup?

@wplearninglab 8 жыл бұрын

+Alex Krueger Hi Alex. That will only partially work. By just restoring the database you won't be restoring the wp-content folder which contains your plugins, themes and uploads (images, pdfs and anything you upload via the Media Library).

@thefluffyunicorn5967 7 жыл бұрын

I appreciate a teqnical person as yourself made a video explaining how to accomplish how to do a backup of a website for people like me who are not tech savvy. I lost everything because my hosting company didn't have cpanel. I understand know you cannot rely on a hosting company. You cannot rely on plugins. You cannot rely on someone else to do this for you without changing hundreds of dollars. From watching your video and the tragedy I experienced I have came to the conclusion I need to implement your backup stragety myself from scratch and know how to do everything myself. I believe this is the most important thing to know when having a website how to backup and restore from scratch. I'm so glad I found your video. I will attempt this myself I will then let everyone know my results.

@wplearninglab 7 жыл бұрын

+Brittany Quinn I'm sorry to hear you lost your site because of your host, that is painful! I do believe you can use plugins for having up your site and they are often reliable. But like you said, you also have to know to do it yourself so you're not helpless when something goes sideways. Good luck and thanks for watching!

@mustafak4378 Жыл бұрын

Just restored a hacked website! Thank you so much for this video! Still working great!

@JamesSamples 3 жыл бұрын

2021 and it's still helpful. Thank you, Bjorn.

@wplearninglab 3 жыл бұрын

You’re welcome James, thanks for watching!

@winkipinky 7 жыл бұрын

Thanks again, this tutorial was concise, well detailed and to the point.. plus easy to follow. Thank you very much!!!

@wplearninglab 7 жыл бұрын

+winkipinky You're very welcome, thanks again for watching!

@MelodysKitchen Жыл бұрын

whaaaaa this video was made 7 years ago... Glad I found you 7 years later.

@wplearninglab Жыл бұрын

Wow, time flies!!!!

@YourMomsSideDude 5 жыл бұрын

2019 and it's still helpful. Thank you, Bjorn.

@RossGoldberg24601 5 жыл бұрын

Thank you for the video. A rogue plugin infected my father's wordpress install, so I had to wipe the whole thing. Luckily I had a manual backup from before the incident, and this helped me quickly restore everything cleanly and easily. Everyone is happy again!

@wplearninglab 5 жыл бұрын

Hi Ross, Sorry for the delay in responding. Our third child arrived 12 days ago and it's been a bit of a gong show around here 👶 Backups to the rescue again! I'm glad everyone is happy again :)

@tonysheppard5457 4 жыл бұрын

Thanks very much for this, It helped me a lot in restoring my website! Just what I wanted.

@rmcellig 3 жыл бұрын

This is so easy. I hate using plugins!! Thanks!!!😀

@zulfikeryahya5375 Жыл бұрын

I also hate using plugins

@romicatanasache1773 2 жыл бұрын

My website broke and I was able to recover it. Many thanks :)

@greenlife-gardens 6 жыл бұрын

Thanks , you might have saved my life in the future.

@wplearninglab 6 жыл бұрын

That's what I'm all about! Thanks for watching!

@benadkins3270 7 жыл бұрын

You are so awesome. I wonder why your channel doesn't have over 500K subscribers.

@wplearninglab 7 жыл бұрын

+Ben Adkins Thanks Ben! All channels have you start somewhere and the beginning is always the slowest/hardest in any thing you do. Although 500k subs would be sweet I don't think there are they many wordpressors in here. The biggest WP channel I know if had around 150k subs last time I checked.

@texagonproductions1353 2 жыл бұрын

Excellent! Brief, concise and accurate. Made my day!

@WilliamOstertagJr_aka-Tony 9 жыл бұрын

THANKS SO MUCH! Took a bit of googling and youtubing, but finally found what I was looking for after a call to the host provider for basically only some new keywords thrown at me to continue researching!

@wplearninglab 9 жыл бұрын

William Ostertag Jr. I'm glad I could help! Figuring out the manual restore was actually one of the most frustrating things for me when I was starting out too.

@wplearninglab 9 жыл бұрын

William Ostertag Jr. I'm glad I could help! Figuring out the manual restore was actually one of the most frustrating things for me when I was starting out too.

@alix6477 5 жыл бұрын

Thank you very much! I didn't want to use plugins and save it on online services (i'm working offline), there were only videos WITH plugins and there you are! :)

@dr.johnandyvonnewagner5067 5 жыл бұрын

I bookmarked this video incase I ever need it to restore the files I backed up. Thanks again for the help.

@wplearninglab 5 жыл бұрын

Hi John, That's smart. I'll be recording a video soon on how I schedule my backups and restore a site if anything happens. It's using a free plugin. The manual way as I show in this video is always great to know, but it's also great to know other ways to accomplish something :)

@sleeky123 4 жыл бұрын

2020 and its still helpful. thank you Bjorn

@wplearninglab 4 жыл бұрын

You’re welcome Shirley, thanks for watching!

@kentjensen4504 4 жыл бұрын

Both these tutorials are brilliant.

@JamesQQuick 6 жыл бұрын

Great stuff!!

@wplearninglab 6 жыл бұрын

Awesome, thanks for watching James!

@erickmmbando1909 5 жыл бұрын

Thanks, bruh it worked for me. I was facing 500 internal server error and used all steps include replacing the wp-admin and wp-include but never worked so I deleted and I restore my web completely on my hosting site. Thank you!

@SilasoftheLamb Жыл бұрын

You saved me! Thank you!

@wplearninglab Жыл бұрын

You're welcome Sean, thanks for watching!

@killerncgaming 8 жыл бұрын

Another great video!

@wplearninglab 8 жыл бұрын

+KillerncGaming :-)

@killerncgaming 8 жыл бұрын

Do you have any videos teaching how to add large mysql databases to phpmyadmin? I have a large database and hostgator is not letting me import it

@wplearninglab 8 жыл бұрын

+KillerncGaming I don't have one like that. You will probably have to contract Hostgator support. Either they will be able to import it for you or they will be able to raise the limit on your account.

@andreavairo8884 6 жыл бұрын

Great video, congratulations! Just one question, please: if something get wrong with my website and I need to do a restore as you explain in this video, I have to delete all the tabs in my database before restoring the last backup copy? Thank you in advance :)

@wplearninglab 6 жыл бұрын

Hi Andrea, Yes, if your backup is of the entire database and you are restoring the entire database then you will have to "drop" the entire database before you upload the backup. If you don't then you should just get an error message saying the upload didn't work. I hope that helps and thanks for watching!

@andreavairo8884 6 жыл бұрын

Ok thank you so much!

@aniketjoshi7518 5 жыл бұрын

Very helpful video. You are an expert and gem.

@wplearninglab 5 жыл бұрын

Thanks Aniket and thanks for watching!

@barrettokarate 4 жыл бұрын

I was building a wordpress site on my localhost and would periodically back it up to an external hard drive. I recently updated to a more recent version of XAMPP. I created a new database for my site using the same info as before and pasted a copy of my site's entire folder from its last backup into the htdocs folder. But when I login to my dashboard nothing is there except my plugins and of course when I type in the URL I get the "Hello World" page. Should I attempt to do what's in the video or is there another way?

@albertoverissimo2790 5 жыл бұрын

So, if you update your website and something goes wrong you always have to go back and delete both he core files and the database? or just the main files and you leave the database as it was?

@espressochinese 8 жыл бұрын

It is very useful, that's what I need. Love your video, very clear and simple.

@wplearninglab 8 жыл бұрын

+John Wang Hi John, glad I could help. Thanks for watching!

@crazyforcanada Жыл бұрын

This is cool. But I have a different wrinkle to solve. I'm trying to restore a web site from years ago made in localhost using a backup plugin with no restore feature. So all I have is a zip folder with the backup of my site in localhost. I have used Softaculous to make a fresh installation of wordpress under my new chosen domain name that's different from the site name when it was in localhost. Do I drop all the tables of the fresh site in phpmyadmin and import my old database from my localhost site? Then do I keep the config file from the old site and over-write the config file on the fresh installation? Or do I keep the fresh config file and ignore the old one? Do I need to run some kind of url updater after all this? If so, what's my old url? Because it's not a regular domain name, it's something with the word "localhost" in it, and no dot-com at the end. Thanks in advance.

@jayashreenair3875 4 жыл бұрын

This video is a saviour. Thanks so much!

@wplearninglab 4 жыл бұрын

You’re welcome Jayashree, thanks for watching!

@swayzierated6756 2 жыл бұрын

Bro!! Thank you!! Do you realize how many of the go daddy reps DON'T know how to do this!? 😂😂 Thank you so much 🙏🙏

@yvonnejohnson3710 2 жыл бұрын

I am unable to access the WP Admin and need to upload my Updraft Plus backup files to my Cpanel in order to restore my website. I have 5 zip files (uploads, themes, plugins, others, db.gz). I believe that 4 of the files are uploaded into the File Manager folder and the db.gz is uploaded to phpmyadmin. Although your video was informative, I need you to elaborate on the exact procedure. My website is still up but all of the formatting is missing along with all of the plugins. Thanks in advance for your help.

@user-on6pe5nm8m 5 жыл бұрын

Don´t you forget to mention that also the DB Tabel option (siteurl, home) and the file wp-config.php (DB name, DB user, etc.) must be adjusted?

@nayelliojeda8339 4 жыл бұрын

absolutely yes

@franshescomviran5741 4 жыл бұрын

You are a genius Mr Foy! :-)

@ultracobrax Жыл бұрын

2023 and it's stll helpful. Thank You! I'd like to know how to delete, remove and then restore a especific domain to do this.

@vpk800 7 жыл бұрын

I have a WP-content folder and WP DtaBase but the problem is I had taken the backup on last week and two days ago i had changed my WordPress domain name .Do you think i can restore with those files

@namanmodi4303 5 жыл бұрын

Great and informative video and this is very important and really worth for me and I am going to implement this method on our website, you have explained it very clearly. thanking you.

@worldamogh436 2 жыл бұрын

I have got a backup zip file of my website. I want to change the hosting of it. So will the zip file be enough to restore the entire website as it was and also the WP Dashboard?

@dustincarter8959 8 жыл бұрын

Very informative video, but the "subscribe" and twitter "follow" pop ups that keep appearing every 20-30 seconds was a bit annoying because I had to get out of full screen and close them to see the video more clearly then reopen full screen. It just seemed a little overboard to me, but that's just my opinion.

@wplearninglab 8 жыл бұрын

+Dustin Carter Hi Dustin. Good feedback. I've been thinking about cutting back on them. I try to make it so they appear in places and times when they don't hide anything.

@x7m 8 жыл бұрын

what about files like ini.php file outside the website file under public_html section do this matter when backing up?

@smartputers 5 жыл бұрын

love you man!! you got my website back!!!

@LeleZabeo-Marketing 4 жыл бұрын

Thank you very helpful!!!!!!!!

@depramze 8 жыл бұрын

Wooooow...... Just what I needed at this moment, Great video {*very complete}.... thanks :)

@wplearninglab 8 жыл бұрын

+depramze Awesome! Thanks for watching!

@1lifeonearth 9 жыл бұрын

amazing video!! you are a lifesaver. Thank you !

@wplearninglab 8 жыл бұрын

+1lifeonearth No problem. I'm glad I could help!

@ReelyboredJon 4 жыл бұрын

Is there anyway to navigate and browse posts from an old backup file to retrieve some old posts?

@AxMataz 8 жыл бұрын

I'm trying to move a site from one host to another, and everything works as in the video, except when I go to the site after successfully importing the database, I still get the install wordpress part, why is that?

@OliverWilliamDK 4 жыл бұрын

Hi Bjorn, Thank you for all your great videos. I am working locally and my Apache has stopped working. And is was wondering if and how I can adopt the appoach you are shopwing here. Can I make a backup of my WordPress site and transfer it when I have reinstall Xammp? How to do this best, so I don’t have to start over? I cannot access phpmyadmin, so I am unsure how to get the database files? Best,

@LeuvieOne 7 жыл бұрын

Again awsome video, so easy explained, so clear, very helpful thank you !! ++++

@wplearninglab 7 жыл бұрын

+LeuvieOne Awesome, thanks again for watching!

@sultancam2k 5 жыл бұрын

helpful for me thanks again

@DamirVuckovic 8 жыл бұрын

Great video...just what I needed at this moment, thanks :)

@wplearninglab 8 жыл бұрын

+Damir Vuckovic Awesome, thanks for watching!

@leonardomacedoc 8 жыл бұрын

Excellent!!.

@FiberDesignsbyAnn Жыл бұрын

Very good instructions. When attempting to restore my zip file a message comes up that tells me the maxi size to upload and that my zip file is too large. What to do? Thanks for any help.

@omnesmediaab9342 5 жыл бұрын

Thank you for this video! Saved my day!!

@wplearninglab 5 жыл бұрын

That's how we do it! Thanks for watching!

@juliosanchez10 7 жыл бұрын

Quick question. I don't think it does, but does it matter if the files and database I upload are different from the original. Example: I'm building a website for a client. I download their old website to save it, delete it and then upload the new files and database that I built for them. This is ok to do, correct?

@wplearninglab 7 жыл бұрын

+Julio Sanchez Yep, that's fine to do, but there are 3 things to watch out for. 1. Make sure the databade credentials in the wp-config file are correct and link to correct database. 2. The database prefix set in the wp-config file matches the database prefix on the hosting account 3. After you upload the new database, open the database's options table in phpMyAdmin. In there, make sure the first two entries in that table both contain the correct URL. I hope they helps! I'm publishing a video later this week showing how to manually move a website from one domain to another. It covers pretty much exactly what you need.

@juliosanchez10 7 жыл бұрын

Fan-freaking-tastic video. Thanks for doing this. So well explained.

@wplearninglab 7 жыл бұрын

+Julio Sanchez Sweet, glad you liked it Julio. Thanks for watching!

@ShirleyRobertsMG 8 жыл бұрын

I have files in my Data Base files from plugins etc that I have deleted from my wordpress site. My question is do I delete these files and if so HOW would I execute that ? Thank you in advance.

@JorgeCubidesJ 8 жыл бұрын

Great step by step ! thanks man!

@jdee67 5 жыл бұрын

This worked amazing for me. Thank you so much !!!!!!!!

@muhammadsharjeel1491 6 жыл бұрын

Question 1: How to create a backup of some/single specific plugins? I mean if I have 10 plugins installed. 4 plugins I used on my every site with their same settings so I do not want to set plugins again and again on my every new site I just want to upload a existing backup. So how can I do this?

@wplearninglab 6 жыл бұрын

Hi Muhammad, Great question. To make this plan work you'll need to do some research on your plugins. Nearly every plugin you install creates its own database table in the WP MySQL database for its' settings and other data. Some plugins create many different tables. So you'll need to figure out which tables each of your plugins creates. You may be able to find this information in the plugin's documentation which may be provided by the developer. If not, then you should install a fresh copy of WordPress somewhere; either locally, on a new domain or on a subdomain and install just one of your 4 core plugins. Then see which tables it adds to the database. You can then export those individual tables by going to phpMyAdmin and going to the Export tab. Choose the option that is not the "quick" option. You'll be shown a selection box where you can select just that plugin's tables. Do that for each plugin individually or do this for all plugins at the same time and you should be good to go. Two things to watch out for. 1. When you export the tables they will have the database prefix as part of the table name. The prefix is "wp_" by default, but if you change the prefix for each site you'll have to change the prefix in the plugin tables before you upload them to a new site. 2. Some plugins are "serialized" meaning the domain they were installed on is integrated into their tables. So if you upload them to a different domain they won't work right. You can fix this by changing the domain name in the tables each time before you upload the tables to a new site. You can make changes to an SQL file using a plain text editor. I hope that helps and thanks for watching!

@techohacky9380 4 жыл бұрын

thanks a lot bjorn sir really thanks you...

@nuovonovathegreatoutdoors 2 жыл бұрын

Thank you for the detailed demonstration. I have a question regarding cPanel. I use WordPress for hosting and not HostGator and I seem not to be able to find the cPanel in my WordPress dashboard. Can you please give me a hint accordingly?

@daroikpe7925 2 жыл бұрын

I followed this step by step by when i load my site it hits the "Coming Soon" page. Any tips please?

@emmanuelphillip5856 3 жыл бұрын

Great job... Thanks

@amansingh0926 7 жыл бұрын

Hi, i am facing a problem to restore my WP site. I have backup of my SQL database as well as the other file from my old Hosting company. I shifted my site to Godaddy but installed a new WP setup with a maintenance mode for my site. How can i restore my old site back ? Can you help me out with the problem ? Thanks

@LotusLyn24 8 жыл бұрын

Hi Bjorn, I was watching other videos prior to watching your easy to follow video. I had to delete my WordPress site because the directory is missing. I downloaded my WordPress files singly ie. wp-content; wp-theme etc instead of zipping them. I have backed them up though. I found that Updraft Plus has backed up these files and so did DropBox! I discovered this when trying to restore and saw the many files in addition to Updraft's and Dropbox zips. Now I am confused as to what should be uploaded via ftp . Your advice please...thank you

@wplearninglab 8 жыл бұрын

+LotusLyn24 Lucky that you have a backup of your site! Deleting the WordPress site files doesn't delete the database so your should be able to simply upload all the backed up files. Assuming it was a full back up with all of the root directory contents (wp-config.php,index.php,etc), the wp-admin folder, the wp-content folder and the wp-includes folder the you can upload all those files to the correct directory and it should work. I hope that helps or let me know more specifics of your situation.

@KBlakK Жыл бұрын

Thank you for this!!!

@wplearninglab Жыл бұрын

You’re welcome Ahmid, thanks for watching!

@carmelg2490 6 жыл бұрын

Thank you Bjorn for your helpful videos as always. You mentioned that it is a security risk to retain a zip file on server. What about those back-up (zip) files automatically created and stored on the server by some backup plugins? What do we do about them? And also those templates in zip files that has to be uploaded on the website? Thank you

@wplearninglab 6 жыл бұрын

+Sunshine G Hi Sunshine, if you want to be extra cautious I would use a backup plugin that sends the backups to your email or uploaded them to a service like DropBox or Amazon S3. Templates in zip files usually don't stay in zip files for long because you install the template. Hackers simply search for vulnerabilities. The more themes, plugins, and files you have on your server the more likely it is that something is out of date and insecure. I hope that helps and thanks for watching!

@carmelg2490 6 жыл бұрын

Thank you so much for your quick reply. Please continue what you do as it helps many. I wish you joy and success!

@OnlineZiggasa 7 жыл бұрын

Hi, How could i do change hosting? Please Help me step by step.

@keosem1070 8 жыл бұрын

Is zipping the folders and downloading them basically the same thing as a Cpanel partial backup, plus a Cpanel backup of the database?

@kashicart 4 жыл бұрын

thanks sir Thank you very much

@wplearninglab 4 жыл бұрын

You’re welcome, thanks for watching!

@bakmie 6 жыл бұрын

awsome! simply just what i need

@wplearninglab 6 жыл бұрын

+Willy Alexander Excellent, I'm happy to help. Thanks for watching!

@dipakbhulku982 7 жыл бұрын

Awesome.... video.... Your videos are really helpful....tkz

@wplearninglab 7 жыл бұрын

+dipak bhulku Thanks Dipak, and thanks for watching!

@NiteshLama89 4 жыл бұрын

Hi, i'm getting hard time restoring websites after it got hacked, all the files from FTP has been deleted. Hostinger is closed and cannot do anything.

@EuAfroBeatMusic 11 ай бұрын

but dose this procedure work but on filezilla?

@ankur92 6 жыл бұрын

wow just nice video bro. thanks.

@harjotsingh6006 4 жыл бұрын

I got my website back without the theme pages I made with brizy. Can somebody help?

@hibald8351 3 жыл бұрын

Hello Thanks for your tutorials...in my work want from me to add some thing like snapADDY imprint crawler in our WordPress site ....so is there any ideas how to do that please I would be appreciate...

@syedzaidi8735 4 жыл бұрын

Can't find the link where you have created the backup..

@sandeepy6231 8 жыл бұрын

I have overwritten my website in WordPress and I have using Hostgator hosting. and I have no backup for my website. So is it possible to restore my website

@wplearninglab 8 жыл бұрын

+Sandeep Y Hi Sandeep, I have bad news. If you don't have backups and your website files are gone, you won't be able to restore it. You should however still have the MySQL database in your hostgator account. So you could reinstall WordPress, then connect to your original database. You'd have to manually upload all the images, themes and plugins though.

@gravelboycauty 4 жыл бұрын

just what i needed, thanks!

@ruhan5769 8 жыл бұрын

Manny Thanks for nice & helpful Video.... :-)

@wplearninglab 8 жыл бұрын

+Rezae Rabbi You're welcome Rezaem thanks for watching!

@silasmarner2686 5 жыл бұрын

Thanks a lot. It is very much helpful.

@marbooksofc 8 жыл бұрын

Thank you very much. This is exactly what I was looking for.

@wplearninglab 8 жыл бұрын

+Marcielli Oliveira Excellent. Thanks for watching!

@dnrhossain 7 жыл бұрын

very easy explained... thanks!

@wplearninglab 7 жыл бұрын

You're welcome Saud, thanks for watching!

@BigWiggley 6 жыл бұрын

I just added a new theme. and want to restore all of my content into the website without breaking my new theme. currently it only has placeholder content. If I upload my backup files, would this break the theme?

@wplearninglab 6 жыл бұрын

Hi Matthew, It's hard to say what will happen. Your best bet is to test it on a subdomain or other domain to know for sure. If that's not an option I would backup the current site so it can be restored if something goes wrong. Then restore the backup files including the old theme. Once the site is online, then activate the new theme. Does that make sense?

@soulboyathotmail 5 жыл бұрын

Hi, very informative video. However, I have a question: would not restoring the old database files give you the same problems as previously experienced? I say that as I have managed to mess up my site and only HTML now displaying, not images sheets etc.

@onagreencloud8577 6 жыл бұрын

Hi Bjorn, Really enjoy your video content. How would you tackle those same processes if the backup files are larger than myphpadmin will accept ??

@wplearninglab 6 жыл бұрын

Good question Ona! The only way is to upload the SQL file via SSH (or possibly FTP). I have not made a tutorial on this yet, but it's on my list. Essentially, you contact your host's support and ask them to turn on SSH for your account. Then using terminal on Mac or the command line on Windows you upload the SQL file to the root of your hosting account directly from your hard drive. There are lots of help articles for this online. Then your host's support can import the uploaded SQL file from the root into your phpMyAdmin. In short, it's a pain, but I hope that helps!

@inkstergraphics7090 7 жыл бұрын

Awesome video! Thanks for this... but I've run into a problem. My zipped backup website weighs in at 975MBs, but my max upload file size is 500MBs. How/where do I increase that restriction?

@wplearninglab 7 жыл бұрын

Hi Nate, You can unzip the backup file on your hard drive and upload the contents via FTP. There are no upload restrictions there, it just takes longer. You could also try contacting your host's support. They may be able to increase the allowed upload size. I hope that helps and thanks for watching!

@inkstergraphics7090 7 жыл бұрын

I meant to get back to you sooner to say "Thank you!" I asked support for that increase and everything worked out well from there!

@wplearninglab 7 жыл бұрын

+Nate Robb Excellent! I'm glad you figured it out :)

@blueghost8057 5 жыл бұрын

Is this better than using a backup plugin?

@maxblogslife8542 7 жыл бұрын

I have found you video very interesting and has helped me a lot. When I download my Backup from the file manager as I'm on MAC it comes as a folder. Should I compress the folder into a zip file? When I'm done downloading the folder should I delete it from the File manager or should I leave it there?

@wplearninglab 7 жыл бұрын

+MaxBlogsLife If you can upload the folder through file manager go for it. If not, upload the zip file and then delete the zip once you 've extracted the file on the server. I hope that helps and thanks for watching!

@maxblogslife8542 7 жыл бұрын

Thanks, I have the file on the server and off the server, Thanks for the info, quick question. Should I turn the folder into a zip file ?

@wplearninglab 7 жыл бұрын

+MaxBlogsLife I only zip it for faster uploading to the server and so I can use file manager to upload. So it's really just a matter of preference.

@maxblogslife8542 7 жыл бұрын

Okay thanks

@andersbrinchmann3356 7 жыл бұрын

Great video - thanks You for sharing YOur knowledge! I have a related question. I have a wordpress site with woocommerce and would like to start over with a new theme but keep the database. I imaging doing this locally on my PC and then when finished uploade the new site to my domain. How do I just copy the DB to a new Wordpress intallation? And is it possible to uploade this to my domain afterwoods? Are there anything I have to keep in mind doing this? Br Anders

@wplearninglab 7 жыл бұрын

+Anders Brinchmann Hi Anders, I would move the entire site to your local computer: all files and the whole database. Then install it and make sure it's identical to the live site. This way you won't be missing any functionality that you have on the live site. At that point you can easily install a new theme and change the design. I would also recommend using the Duplicator plugin for the move. I have a tutorial for it here: kzfaq.info/get/bejne/idGadNtymZ63cWw.html That plugin will make it super simple. I hope that helps and thanks for watching!

@andersbrinchmann3356 7 жыл бұрын

WordPress Tutorials - WPLearningLab Great input thank you ☺ If I afterwoods need to update the DB because of eg new orders would that be possible and how?

@wplearninglab 7 жыл бұрын

+Anders Brinchmann That's a little more tricky. I would find out which Woocommerce tables in the database are updated whenever an order ID placed. Then export those tables manually through myPHPAdmin. Then import them manually in your local computer's MySQL database.

@andersbrinchmann3356 7 жыл бұрын

Sounds a bit tricky - think I have to test it on a demo site before doing it on my live site :-D Thank You for Your help! :-)

@wplearninglab 7 жыл бұрын

+Anders Brinchmann It is a bit tricky. Just make backups of everything when you do it. After you fooi it a few times it'll be a breeze.

@emmanuelkachi8599 Жыл бұрын

thank you very much sir......i have a website that am designing as a student but along the line my xampp control panel was short down unexpectedly so i lost the site ,,, so please sir, is there any possibility of getting the site back?

@wplearninglab Жыл бұрын

Hi Emmanuel, xammp just loads website files from your harddrive and xammp crashing shouldn't delete your local files in most cases. You should be able to find your site files on your harddrive and hopefully reconnect them to your xammp dashboard. Maybe by creating an xammp site of the same name?

@angeldisguisedso 5 жыл бұрын

I went through the steps to restore, however, the theme seems to be picking up from another source. It's showing a basic wordpress theme as opposed to my custom theme. Any suggestions on a fix for that? My content is below that theme view but my theme is not visible.

@wplearninglab 5 жыл бұрын

Hi Shavonne, These questions may seem 'duh', but I have to ask them. 1. Are you sure the backup files contain your custom theme in the wp-content/themes folder? 2. Have you checked in Appearance > Themes to see if your theme is present but in active?

@craigsmith1800 6 жыл бұрын

Hi Bjorn, quick question. If you're copying a WordPress installation site into a subdirectory, if you create a new SQL database, can you import your saved .sql backup file into the new database and be good to go? or is there something more you have to do? (Aside from copying all the WordPress files over first).

@wplearninglab 6 жыл бұрын

Hi Craig, I usually export the SQL file. Then open the SQL file in a text editor (I use Sublime Text 2). I find and replace the original domain name in the SQL with new one. Or in this case, replace with the subdirectory (eg. domain name.com/subdirectory). This will update all the absolute URLs in the db. There can be a lot of them. Once the URLs are updated I upload the SQL into the new DB. Does that make sense? You can also try using a plugin to do the migration. It can be quite a bit easier. Here's a tutorial for the duplicator plugin: kzfaq.info/get/bejne/idGadNtymZ63cWw.html I hope that helps. Let me know how it goes!

@sagarpaskanti4155 6 жыл бұрын

i want to restore my wordpress website. i have SQL database file and theme file. is there any way to restore my website ?

@dempseyblackmon4918 4 жыл бұрын

I made the mistake of importing data to my Wordpress. Now I can't change the homepage. I got the Jetpack Backup software only after I made this mistake should I delete my whole website and start over? Make a new website?