Web
Analytics
Connect with us

WordPress

How to Move WordPress From Local Server to Live Site?

Published

on

How to Move WordPress From Local Server to Live Site

How to Move WordPress From Local Server to Live Site? If that’s what you need an answer to then you’re at the perfect place.

Moving a site from a local server to a live site isn’t the hardest task on this planet, but it’s not the easiest either, so I’ll try to simplify it as much as possible for you.

What’s a Local Server?

Before answering How to Migrate WordPress Website from Localhost to Live Server, let me start from the basics.

A local server is basically just the “web-environment” on your computer which allows you to work on your web-projects similarly as you would on the internet, but just with a lot more speed and ease.

That’s the case because on the Internet you need to save and refresh for every change to take effect and that in total makes a “lot” of changes, hence lot’s of wasted seconds which add up to hours in the long run.

Also on the web, deleting or modifying certain files need repeated permissions, asking you to login or authenticate over and over again, but on your local server,  you just need to authenticate them once.

The only problem is, a project on the “local server” is placed locally on your system and not the internet. So if you want the project to be accessible worldwide on the web, you need to move it to a live server.

So the bottom line is, “local server’ and “live server” both are basically just “storage space” for your projects, the former is local and offline while the latter is online and available to everyone.

How to Move WordPress From Local Server to Live Site?

Before you can move your WordPress from local server to live site, you’ll need three basic things:-

  • Make sure your local site is ready.
  • Make sure WordPress is already installed on your Live server.
  • Make sure you write down the SQL database and password which you use while installing WordPress.

Step 1:- Exporting the Site Content

The first thing you need to do is, export your WordPress content so that you can upload it to your live server.

In order to do that, go to your local server’s WordPress module, go to your dashboard and click on Tools>Export.

How to Move WordPress From Local Server to Live Site

On the next page, choose “all content” and click on “download export file”.

How to Move WordPress From Local Server to Live Site

You’ll get a .xml file containing all your WordPress site’s content. This is the file you’ll need to import in the next step.

Importing the WordPress Content:-

Now you’ll need to import the file you just downloaded. Again login to your WordPress, go to tools>import.

It might ask you to install an “importer”. Just install the “WordPress” importer. (It takes couple seconds only!)

How To Move Your WordPress Website From localhost To Live Server

Once you’ve installed it, just browse to the .xml file you downloaded and import it. Once that’s done it means you’ve successfully imported your posts, images, menus, etc to your live site.

Step 2:- Exporting and Importing the SQL database:-

You need to import your MySQL database to your live server as well so that your live server can communicate with your WordPress files.

Login to your Phymyadmin module on the local server. You can alternately use “http://localhost/phpmyadmin” to directly access it on your local server.

How to Migrate WordPress Website from Localhost to Live Server

Next, you’d want to click on “export” if you want to learn How To Move Your WordPress Website From localhost To Live Server.

So click on export, and select “SQL” from the drop-down menu and click go.

How to Move WordPress From Local Server to Live Site

Now you’d need to find and replace all the primary URLs of your project. Because by default, local server projects have the URL of “localhost”. You need to change them to your URL.

So right-click on the SQL file you just downloaded, and edit it with any editor. I normally use notepad++.

Just press ctrl+f and go to the “replace” tab. There enter “http://localhost/your_project (replace “your_project” with the name of your project file), and in the “replace with” tab, enter your URL.

How to Move WordPress From Local Server to Live Site

Step 3:- Linking the Database with your WordPress Installation:-

During the WordPress installation, there was a moment when you were asked to create a new username and password for the database.

Something like the following screenshot:-

How to Move WordPress From Local Server to Live Site

I’m sure you wrote down the username and password. Those are the credentials you’ll need now.

Now you’ll need to edit your Wp-config.php file. Just change the following credentials with the credentials you used while creating the MySQL databse during the installation:-

  • define(‘DB_USER’, ‘your_database_user’);
  • define(‘DB_PASSWORD’, ‘your_database_password’);
  • define(‘DB_HOST’, ‘localhost’);
  • define(‘DB_NAME’, ‘your_database_name’);

Done!

Optional Step:-

If you had customized your WordPress local server with logos and personalized images, you’d need to upload all the files you have on your local server to the live server.

This is nothing technical or complex, all you’ve to do is upload all the files to your Public_HTML folder (if you have not installed WordPress is any other directory like /blog /mysite etc).

Or use a simple FTP client like FileZilla to accomplish the task.

Final Step:-

So that was all I had on How to Move WordPress From Local Server to Live Site folks. Hope this piece was helpful.

Although I do understand that it’s one of the “more complex” articles, so there’s a fair chance that you’re stuck somewhere, in case you are just let me know in the comment box and I’ll help you out.

Last but not least, I wouldn’t mind if you share this piece around your social networks.

Evan Derek is the Founder and Chief SEO Analyst @ VebbLabbs. Specialising in Affiliate Marketing and helping newcomers to make it a stable profession in the online world, he boasts 6+ years of experience in the industry. 19 year has he spent on this planet successfully, and plans on spending atleast 50more !

WordPress

How To Setup Free SMS Alerts When Your Website Is Down

Published

on

How To Setup Free SMS Alerts When Your Website Is Down?

So you own a website? Hey go check it out, it might be down, all the websites are going down today for a certain reason! (JK! But didn’t that give you goosebumps? Weren’t you “terrified”?) What if I tell you not to be because I’m going to show you How To Setup Free SMS Alerts When Your Website Is Down.

So well yeah now you don’t need to monitor, check or verify if your website is up or not, you’d be automatically getting notifications once the website is down, and as long as it’s up, no pressure, nothing to check, just relax.

And the best part? It’s free! Well yeah, whatever I’m going to explain in this piece today won’t cost you a dime! That’s the beauty of it because well money can buy everything, the real fun is when you don’t need to empty your pockets out when you’re hunting something. (Especially something as awesome as this!).

But hey before getting into all the science, we could cover a bit of basic, right? I mean why does your website even go down? Yeah once you figure that out, you can work on the factors and that would solve your problems totally! I mean your website won’t go down in the first place, so the monitoring problem is solved anyway, right?

Top Reasons for Website DownTime:-

Servers:- Of course if you don’t have quality servers, your website can’t be blamed for not being up. Servers are the backbones of your websites, right? Your server response time, bandwidth, available space, everything comes together to finalize your final server uptime or downtime.

Wrong A Records:- While setting up your website, you do have to link the DNS to the server, right? That done wrong, and your site is going down for sure. And it’s one of the most common mistakes most people out there make while setting their websites up.

DDoS Attacks:- Well a DDoS attack is one of the easiest attacks to perform in this industry. Once unleashed, the attacker sends a huge number of requests to the victim server, which results in the crashing of the server, and thus the website goes down.

It’s simply like asking for more server pings, then the server can handle.

Old Version of WordPress:- Well, to be honest, not just WordPress, it can happen with just about any other CMS in the world. They release newer versions because the older versions have glitches or issues in them, right? So well yeah in case you’re using an older version of your CMS, then it’s quite possible that your CMS is affected by some kind of glitch and hence your website is down.

Well, so the point is, whatever the reason might be, it’s totally possible from your end to learn How to get Email Notifications on Site Downtime, and that’s what I’d be showing you in this piece today.

How To Setup Free SMS Alerts When Your Website Is Down:-

I will teach you how to build your own Website Monitor! What? Nope, I’m not high, and it won’t take more than 10seconds for you to complete the whole process!

Let’s first learn about how to monitor it using your Google Plus account! The monitor would send you “All is well” reports to your Email and Google Plus notifications bar. Which technically is permanently available on your Google Chrome’s top right area.

  • Click here to access this pre-made google sheet.
  • Click on Make a copy.
How-to-get-Email-Notifications-on-site-Downtime
  • A new Google Sheet would open up. Edit the Website URL and change it to your own website’s address.
How-to-get-Email-Notifications-on-site-Downtime
  • Do the same with the Email address too!
How-To-Setup-Free-SMS-Alerts-When-Your-Website-Is-Down
  • Done! You don’t need to change anything else in the piece. Simply click on the Website Monitor button on the toolbar, and click on Initialize.
How-To-Setup-Free-SMS-Alerts-When-Your-Website-Is-Down
  • An “Authorization required” box would pop up. Click on the authorize button.
How-To-Setup-Free-SMS-Alerts-When-Your-Website-Is-Down
  • Login to your Google Plus account, and click on allow.
How-To-Setup-Free-SMS-Alerts-When-Your-Website-Is-Down

Done! Now you’d be notifications if your website is down! This monitor works on a 5-minute interval, so well I think that’s fair enough for an unlimited, free forever monitor, right? 5 minutes won’t make your break your career.

How to Setup Free SMS Alert when Website is Down:-

So we’re done with Emails and google plus notifications, huh? How about an SMS alert? Free!

Well yeah, signup at Monitoring. (It’s free!).

How-To-Setup-Free-SMS-Alerts-When-Your-Website-Is-Down

Once you’ve provided your Email, check into your Email account for a confirmation E-mail from monitoring. And click on the button.

How-To-Setup-Free-SMS-Alerts-When-Your-Website-Is-Down

That would take you to a Google Plus authorization page, allow the application to access your profile.

How-To-Setup-Free-SMS-Alerts-When-Your-Website-Is-Down

And then it would redirect to monitoring again, where you’ve got to specify your website URL.

How-To-Setup-Free-SMS-Alerts-When-Your-Website-Is-Down

After that on the next screen just enter your cell phone number where you’d want to get the notifications.

How-To-Setup-Free-SMS-Alerts-When-Your-Website-Is-Down

And finally, click finish.

How-To-Setup-Free-SMS-Alerts-When-Your-Website-Is-Down

Now the only thing left for you to do is, click on the “SMS” checkbox on the next screen to enable the SMS notifications.

How-To-Setup-Free-SMS-Alerts-When-Your-Website-Is-Down

Wrapping it Off:-

So yeah folks that were everything I had on How To Setup Free SMS Alerts When Your Website Is Down. I’m pretty sure I made the steps pretty clear and straight-forward.

If I still missed something out, I’d love to hear about it from you in the comment boxes down there.  And of course, it won’t hurt you to hit the share button if this piece was something new for you, right?

Continue Reading

WordPress

How to Restore WordPress from Backup?

Published

on

WordPress is the most used CMS on this planet there’s no doubt to it. In fact, it’s powering more than 25% of the total no. of World’s websites, now that’s a B-I-G number. And that’s the reason today I’d be showing you How to Restore WordPress from Backup.

Now I chose the topic for several reasons, first because it’s related to WordPress. Second, you need to know How to Restore a WordPress Site From Backup in order to do lots of things, be it migration, or a simple change on your WordPress blog.

Well before explaining to you how to restore the backup of a WordPress website, I think it’s only fair of me to explain what will be included in the backup, and why you would want to restore it.

What is a WordPress Backup:-

I strongly insist you check out those three articles above before proceeding. Trust my backups aren’t as simple as they seem, and those three articles would clear this up for you.

Anyway in case you won’t, let me explain a WordPress backup. Basically, WordPress is just a “CMS”, so if you’re talking strictly about “WordPress” backup, it just means the backup of your articles / Text/images.

While just those things aren’t enough in order to get a website up and running. So the other part of a “WordPress website” backup include the Database, the email aliases, and the other important files, if you don’t back these up, only your WordPress backup won’t help you restore the whole websites.

And I’ve covered how to back up each of these things separately in those three articles above.

The “WordPress” backup file is generally a .xml file, a pretty lightweight file that consists of all your important data.

So Bottomline is, in this article I’ll show you how to restore a WordPress backup. This restoration will include restoring:-

  • Old Articles.
  • Previous Images Files.
  • Any other On-Page Elements. (On-Page = elements which were present on the content page)

When to Restore WordPress from Backup:-

As I always say, you don’t need a reason to create a backup of your WordPress website, you should just do it anyway. But even then there are some specific moments when having a WordPress backup and restoring it might mean life or death of your online career, so let me scribble them down for you:-

  • You are Migrating your URL completely.
  • You are changing your servers. (In that case, you’d need a “complete backup”, which you can learn how to create if you check out the three posts in the first paragraph.)
  • If you changed something on your website, and things went south.

These are just some of the moments when restoring your WordPress backup might seem like a good idea.

Requirements to Restore WordPress from Backup:-

In order to restore your WordPress website from backup, you need a couple of things beforehand. Make sure you have:-

  • A .xml backup of your website before proceeding. If you don’t know how to get one,  just check out the three posts I’ve mentioned in the first paragraph.
  • A WordPress Importer. If you got it installed, it’s great. If not, don’t worry it’ll get installed automatically.

How to Restore WordPress from Backup:-

How-to-Restore-WordPress-from-backup

In order to Restore your WordPress Backup, login to your WordPress dashboard, and click on  Tools>Import.

This will bring up the following screen on your monitors

How-to-Restore-WordPress-from-backup

Then click on the WordPress button

How-to-Restore-WordPress-from-backup

It will ask you to install the WordPress installer plugin, install it, it’s verified by WordPress for security and bugs hence it’s safe. So just click on Install Now.

How-to-Restore-WordPress-from-backup

It will automatically install the importer on your WordPress website. If the installation was successful, you should see a screen like this

How-to-Restore-WordPress-from-backup

Just click on Activate Plugin and Run Importer button. Once you click on it, you’d be taken to this screen

How-to-Restore-WordPress-from-backup

I don’t think I need to explain what to do over here, right? All you’ve got to do is, click on Choose File.

How-to-Restore-WordPress-from-backup

Once you click on it, the file browser popup would come up, which will let you locate your backup file. So just find the backup file and click on it and then click OPEN!

 How-to-restore-the-backup-of-a-WordPress-website

Once you get the backup file, just click on Upload File and Import button.

 How-to-restore-the-backup-of-a-WordPress-website

Done! This will start the upload automatically, once the upload is done, you’ll get your posts/images/permalinks back.

Final Words:-

So that was it folks, that’s all I had on How to Restore WordPress from Backup. I’m sure I made it simple and straight-forward enough for you guys to understand.

By using this process you can have a full backup of your Posts/Images/Permalinks and anything else that existed on your WordPress pages/posts.

Although if you need to learn how to create a “complete” backup, including the Database, Files and Email Aliases, checkout the three posts I’ve inserted right at the starting of this post.

While this is the simplest available method, it isn’t the only one, so if you guys know any other method that might be simpler, do let me know.

Also if this piece helped, I’d appreciate if you share it around, it might help one of your guys (and would definitely help us get more traffic and attention! I think we’ve earned it, haven’t we?)

Continue Reading

WordPress

How to Add Web Push Notification to Your WordPress Site?

Published

on

The internet has become advanced enough and hence the possibilities too have expanded beyond just browsing and downloading. With the advent of hundreds of new marketing strategies, today I’ll be showing you How to Add Web Push Notification to Your WordPress Site?

A decade back, owning your own website seemed like a dream, only companies and firms used to do so, today? Every kid around the corner has his own. Similarly, just couple of years back Push Notifications were one such luxury for website owners.

But today? With the help of so many third party pieces of codes and stuff, answers to questions like How to Add Push Notifications to WordPress site, have become as easy as a couple clicks.

What are Push Notifications?

Before asking your questions like Best Way to Add Push Notifications to Your WordPress Site, I think it’s fair of me to explain to you a bit what Push Notifications exactly are, right?

Have you ever subscribed to price-comparison websites? Which compares the price of certain products you’re looking for from various websites and then display a little tab at either corner of your desktop, even when you aren’t browsing any website?

Let me just show you:-

How-to-Add-Push-Notifications-to-WordPress-site

So yeah those are Push Notifications.

Why do You Need Push Notifications?

There are a couple of benefits you’ll be getting with Push Notifications, and so it’s fast taking over the traditional marketing methods.

1. Push Notifications don’t need you to be browsing the Internet. They can be delivered to you directly on your Desktop /Laptop Homescreens.

2. They can also be delivered to you if you’re browsing something else, watching a movie, or anything else.

3. They don’t need the user to do anything! Like with E-mail marketing the user needs to open his Email account, and then from the thousands of mails, needs to click on your mail to get the information, well with Push Notifications it’s not so.

4. The combination of Text+Image kind of makes the notifications clickable. If the content is good and the image you’ve used is lucrative enough, you’re bound to get yourselves some clicks.

5. They can also be displayed on Mobile Devices!

6. A recent survey declared that Push Notifications have 51% more Open rates compared to the traditional SMS, Internet and Email methods.

How to Add Web Push Notification to Your WordPress Site:-

In order to Add Web Push Notifications to WordPress, you’d be needing a plugin (the god-solution to all WordPress Problems isn’t it?)

So Go to your WordPress Dashboard, and click on Plugins>Add new

How-to-Add-Push-Notifications-to-WordPress-site

And search for OneSignal and install it.

How-to-Add-Push-Notifications-to-WordPress-site

Once you’ve installed the plugin, just click on the “OneSignal” tab on the left sidebar and you’d be taken to the plugin’s page.

How-To-Make-Your-Blog-Push-Notification-Ready-in-easy-steps

Once you’re on this page, you’d need a couple of API’s and Key’s, which I’ll show in detail how to create. (Worry not it’s no rocket science!)

So okay now you should head over to Add Google Services Page.

How-to-Add-Web-Push-Notification-to-Your-WordPress-Site

Basically just Name your project, and in the second box, give your android package a name. Don’t worry the service won’t be using any kind of android package, it’s just a requirement for advanced users who might have different needs than us, but for us, we just need a name nothing else.

And then click on Choose and Configure Services.

The next screen would look something like this.

How-to-Add-Web-Push-Notification-to-Your-WordPress-Site

As you can see, there are three options out there, and you’d want to click on the “+” button that’s on top of the “cloud messaging” option.

And then Click on Enable Google cloud Messaging option.

How-to-Add-Web-Push-Notification-to-Your-WordPress-Site

Then you’d be provided with your Server API Key and Sender ID, copy the sender ID and go to your OneSignal plugin’s “configuration” tab and paste it there under “Google Project Number” tab

How-to-Add-Web-Push-Notification-to-Your-WordPress-Site

Step #2:- How To Make Your Blog Push Notification Ready in Easy Steps:-

So by now, I gather you’ve your Sender ID (which is pasted in your plugin’s configurations tab!) and your Server API key (which we will use later), right?

Now move on to OneSignal’s Official Website, and create a free account over there.

Once you’re logged in to your Free account on OneSignal, you should click on the Add a new App Tab.

How-to-Add-Web-Push-Notification-to-Your-WordPress-Site

A popup would come up asking you for a name, enter just about any name there and you’re good to proceed.

 Best-Way-to-Add-Push-Notifications-to-Your-Wordpress-Site

On the next screen, you would want to select Google Chrome and Mozilla Firefox as the platforms.

 Best-Way-to-Add-Push-Notifications-to-Your-Wordpress-Site

And then just click on Configure. Once you do so, another popup would come up which would look something like this.

How-To-Make-Your-Blog-Push-Notification-Ready-in-easy-asteps

Now here’s the tricky part. You can enter your URL in the URL box, and then the URL of the image you want to display with the notifications in the Default Notifications Icon URL.

Now you see the option that says “My site is not fully HTTPS”, right? And I’m considering the majority of you reading this piece don’t have SSL on their websites.

The bad news is that Google Chrome doesn’t support Non-SSL sites or plain HTTP sites for push notifications. Worry not that problem is solved as OneSignal will give you one of their own subdomains with the SSL certificates for this purpose.

So if you do not have SSL, just click that box, and then enter the subdomain you’d want to use, and click on save.

How-To-Make-Your-Blog-Push-Notification-Ready-in-easy-steps

Done! Now for the last part!

You just need to get your OneSignal Keys, and for that, click on App Settings > Keys and ID.

How-To-Make-Your-Blog-Push-Notification-Ready-in-easy-steps

Now for the final part, just copy-paste both of these keys and paste them in your WordPress OneSignal Plugin’s configurations tab.

How-To-Make-Your-Blog-Push-Notification-Ready-in-easy-steps

Final Step:-

Now just login to your OneSignal account once again, and you’d see this box. You should click on the “select SDK” option.

How-To-Make-Your-Blog-Push-Notification-Ready-in-easy-steps

Now select “WordPress” from the SDKs.

Best-Way-to-Add-Push-Notifications-to-Your-Wordpress-Site

Finally, just click on “Test Notifications” to test if your notifications are working which they should.

How-To-Make-Your-Blog-Push-Notification-Ready-in-easy-steps

You would get your notifications preview meaning you successfully setup Push Notifications for your WordPress site.

Final Words:-

So that was all I had on How to Add Web Push Notification to Your WordPress Site folks. I made sure to use as many images and illustrations as possible.

So I doubt any step would still be confusing you, right? But if you’re not getting something right, make use of the comment box and I’m here to your aid.

Also, if this piece helped you, I wouldn’t mind if you hit the share buttons.

Continue Reading

WordPress

How to Import/Restore WordPress Backup?

Published

on

How to import/restore WordPRess backup

Now I’ve been really getting into WordPress lately. If you’re on this piece, you might also find my piece on How to backup WordPress come in handy. Because well this piece on How to Import/Restore WordPress Backup is totally related!

Okay so yeah this piece is totally going to be about how you can backup /restore your WordPress site! Because I know I’ve done a complete piece on How to backup WordPress site (which you can access from the above link), but just backing it up isn’t the goal, right? You need to know how to restore it as well, don’t you?

And as it has become my habit to get into the basics before actually covering the real thing, let me continue the trend by clearing off the air a bit about the basics.

What are WordPress Backups and Their Types:-

Because of the huge list of plugins in the market these days, it has become hard for people to “learn” things. All they have to do these days is, install a plugin, activate it, and it does its job. While they have no idea about what the hell just happened.

So well you might not know but yeah there are more than one “types” of WordPress backups.

Complete WordPress backup:- It’s the complete backup of your WordPress files, your Email Aliases, and WordPress database! (You might actually love my piece on How to backup WordPress Database because it’s especially centered around the Database thing!)

And then partial backups. Partial backups are backups that are concerned about specific parts of the website. Let’s say just the files, or the database or the Aliases.

Well a backup is the “restore” point of your website. It’s like you want to try something new, and something goes wrong. Now that’s where backups jump in to help you.

How to Import/Restore WordPress Backup:-

I take it as you’ve already created your WordPress backup using any of the methods I’ve shared, or whatever you might have already known. At this point I just want to make sure that if you’re proceeding, you’ve your Backup file ready with you.

So okay in order to backup your Website, you can either make use of the Cpanel, or some of the best WordPress backup plugin (s), out there. I’ll be covering both the steps, so let’s first look into the plugins thing.

Keep in mind that the plugins aint free, while the Cpanel method is. Still it’s your choice what you want to go with.

How to Import/Restore WordPress using Plugins:-

BackupBuddy is just one of the best options when it comes to restoring your WordPress backup. I’ve talked about it enough times, so just install BackupBuddy on your WordPress.

Now you’ll need a file that goes by the name :- importbuddy.php. Which you can obtain by going to WpDashboard>Backupbuddy>Restore/Migrate.

Now Download Importbuddy. (And also the backup if you haven’t already got it!)

How-to-import/restore-WordPress-backup

It will ask you to set a password. So that only YOU can restore it again. Just set a password, and you’ll get the importbuddy.php file.

Well now, upload this file to your server. Let’s say www.yoursite.com/importbuddy.php, and then enter the exact URL of the file on the address bar.

For eg. if you’ve uploaded it to www.yoursite.com/blog/importbuddy.php, well then enter this exact URL there.

Once you do, import buddy would ask you for the authentication password, the one which you set some time ago. Enter it.

how-to-backup-wordpress-site

Now, just click on the “upload” tab, and upload your backup file.

How-to-Create-a-Complete-WordPress-Backup

The next screen would unzip the file. Just wait, and when it’s done click on the Next step button.

best-wordpress-backup-plugin

Now, just click Next step again if you’re simply restoring your WordPress site and don’t want to change any other settings.

best-wordpress-backup-plugin

The next screen allows you to test the database settings, so just click on Test settings. If the test is passed, then proceed to click on the Next step again.

best-wordpress-backup-plugin

Done! Well that was it folks! If the database import was successful and you did everything right, you just successfully restored your WordPress website.

How to Import/Restore WordPress Website Using Cpanel:-

If you’re going this way, I assume you have a complete backup of your Website, (Or you can learn How to Create a Complete WordPress Backup using my tutorial in the first paragraph) which consists of:-

  • Home Directory backup
  • Email Aliases.
  • SQL databases.

All these backups are included in the .zip file you downloaded as a backup when you were backing up so not a lot of trouble there. So well extract the compressed backup file. Because you have to upload the backups separately.

So okay login to your Cpanel, and search for “backups”.

How-to-import/restore-WordPress-backup

Click on the Backup Wizard button.

How-to-Create-a-Complete-WordPress-Backup

Then click on the Restore button.

How-to-Create-a-Complete-WordPress-Backup

Now click on the home directory.

How-to-Create-a-Complete-WordPress-Backup

And then finally choose the file you want to upload, and click upload.

How-to-Create-a-Complete-WordPress-Backup

Done, just repeat the same process with the other two kinds of files.

Backup Wizard > Restore > Mysql Database > Upload your sql backup.

Similarly, just use the exact same steps, and finally upload the Email Aliases.

Final Words:-

So yeah folks that were all I had on How to import/restore WordPress backup, I’m pretty sure I made the steps clear and simple enough for you. But still, if I missed something, or you know better options, do let me know.

And do share it if the piece helped, also of course you can make use of the comment box if you’re stuck somewhere. I love hearing from you guys.

Continue Reading

WordPress

How to Backup WordPress Database?

Published

on

How to backup wordpress database

Hey guys, yeah I’ve got myself into this trend on writing pieces on “WordPress” these last couple days, but I’m pretty sure you’re loving the archive. So here’s another addition to the collection that says ” How to backup WordPress Database.”

Well yeah I already know what you’re searching for, you’re searching for a solution to backup your WordPress Database’s, right? Why else would you be on this post? So that’s exactly what I’m giving out on a plate to you.

But as my habit goes, let me first get into a bit of the basics maybe?

What is a Database?

The reason a lot of you still have to google about stuff like this is, the internet has made things more than just “easier. You can obtain a backup of your WordPress Database, or even the whole site in a matter of seconds by using just about any kind of plugin available out there.

That makes things easier and saves time no doubt, but that also kills the learning curve. If you don’t know what the Database is, well then no matter how many times you back it up, there’s always be a void between your knowledge and career.

So yeah let me just explain to you in brief, about what exactly a database is.

A Database is a “base” for data. Let’s say a Database is where your data is stored, in an organized, structured format. If you take your Database to be a drawer, the different cabinets of the database can be termed as the “tables”.

Whenever you need the data regarding a certain thing, you just have to look into that specific table, and you get your file, right? That saves you time from going through each and every table and file in the drawer. And that’s exactly what the database does for you.

The WordPress you run your sites uses MySQL as the database software. (Which apparently is the most popular database management software on this planet!). WordPress is a very complex platform and hence needs lots of data and tables.

And that’s the reason why you need to have this database thing so that the data can be kept organized.

An SQL Database primarily consists of three parts:-

  • The host:- Your MySQL server needs to be hosted somewhere, right? So the computer or the system where it’s hosted is called the host. Most of the time, “localhost” is the default host! Unless of course, your server company has different things in mind.
  • Tables:- Just as I said, the tables are where the data is stored. It’s like an easier and faster way to store, organize and find data. These tables are where your data is stored.
  • SQL query: – So now you have a host and database, but how would you command it? You can’t just be like “Hey database, please tell me where this file is”, right? That’s where the SQL queries come in, they are the language you can speak to your databases in and issue-specific commands.

How to Backup WordPress Database:-

This article specifically deals with backing up WordPress’s “database” and not the whole WordPress website.

Okay so let’s get down to business.

#1:- Backup Your WordPress Database Using Cpanel:-

This is my favorite method as it’s the simplest one to backup the WordPress Database.

Login to your Cpanel, and search for Backup> Backup Wizard.

How-to-backup-wordPress-Database

Once on the next page, just click on the Backup button.

wordpress-backup-plugin

On the next page, just click on the Mysql Databases option.

How-to-backup-wordPress-Database

This would take you to the page which has all your “databases”. Just click on the database you want to backup.

best-wordpress-backup-plugin

Done! You’ll get a .sql.gz file downloaded on your browser! Which you can use to restore your SQL database anytime. (I’ll show you how in the next piece, and then I’ll update this link, so do check back, that’s like in 24hours!)

wordpress-backup-plugin

Done! This was one of the easiest ways to backup your WordPress database. But wait, I’ve got other recipes for you too.

#2:- Backup Using a Plugin:-

There’s this tiny little light-weight plugin called Wp-Db-Backup you can use to backup your database on WordPress. (Nope I’m not affiliated to, or in partnership with the product or the owner in any way. I’m just listing it here cause it does the job!)

Then, log in to your WordPress dashboard, and click on Tools>Backup!

best-wordpress-backup-plugin

Now just click on the Backup Now button to backup your WordPress Database.

wordpress-database-plugin

So well yeah that’s like a two-click process to get your WordPress database backed up! Guess what; you can even get the backup E-mailed to you! And of course, you can download it.

If that wasn’t enough for this free of cost plugin, it also lets you schedule your WordPress Database Backups!

Final Words:-

So that was it folks on How to Backup WordPress Database! I’m sure I didn’t leave anything out, and I made this process as simple as possible.

If you still got a question, just make use of the comment box! I’m all ears.

Continue Reading

Trending