Web
Analytics
Connect with us

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 basic 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 on, 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 times, “localhost” is the default host! Unless ofcourse your server company has different things in mind.
  • Tables:- Just as I said, the tables are where the data is stored. It's like the 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 “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 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 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 affiliate 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, login 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 ofcourse you can download it.

If that wasn't enough for this free of cost plugin, it also let's 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 commentbox! I'm all ears.

 

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 !

Tutorials

How to Display Related Posts in WordPress without Plugin

Published

on

How to Display Related Posts in WordPress witnout Plugin

Owning a blog or a website is not a great thing, but to manage the consistency of the blog or a website that's a hard task. We all (blogger) familiar about the word – “Bounce Rate”, and this word has great importance in our blogging life. 

Bounce rate essentially represents the percentage of initial visitors to a site who jumps away to a different site, rather than continue on to other pages within the same site. If you have a high bounce rate that means your website isn't impressive enough to explore it more.

There are many reasons why visitors leave your website without exploring it further such as “Broken navigation links”,  “Irrelevant content”, “Popups” and much more. And this problem will be not solved ASAP then the no. of visitors will decrease.

Our revenue totally depends upon the visitors (exceptions are always there), so to decrease the bounce rate of our blog/website and to increase no. of visitors and revenue you can Display Related Posts in WordPress.

Read: How to Install WordPress Using Fantastico

There are many plugins out which helps you to “Display Related Posts in WordPress“, but every time it's not necessary to use the plugin. Plugin consumes space in your WordPress database.

It also increases the loading time of your website. That's why today in this article I will show you “How to Display Related Posts in WordPress without Plugin”.

Display Related Posts in WordPress without Plugin

<?php
//for use in the loop, list 5 post titles related to first tag on current post
$tags = wp_get_post_tags($post->ID);
if ($tags) {
echo ‘Related Posts';
$first_tag = $tags[0]->term_id;
$args=array(
‘tag__in' => array($first_tag),
‘post__not_in' => array($post->ID),
‘posts_per_page'=>5,
‘caller_get_posts'=>1
);
$my_query = new WP_Query($args);
if( $my_query->have_posts() ) {
while ($my_query->have_posts()) : $my_query->the_post(); ?>
<a href=”<?php the_permalink() ?>” rel=”bookmark” title=”Permanent Link to <?php the_title_attribute(); ?>”><?php the_title(); ?></a>

<?php
endwhile;
}
wp_reset_query();
}
?>

Paste the above code in single.php where you want to Display Related Posts in WordPress. This is the easiest way to Display Related Posts in WordPress without Plugin.

If you face any problem in finding the single.php file or in placing the code then you can surely contact us via comments below.

Continue Reading

Tips

How to Display Recent Posts in WordPress

Published

on

How to Display Recent Posts in WordPress

If you want that reader must stay up to maximum time on your website/blog then provide content as per their choice.

Earlier, to decrease the “bounce rate” of the blog I have written an article on “How to Display Related Posts in WordPress without Plugin” and now if the reader wants some fresh & recent articles then Display Recent Posts in WordPress.

Mostly, we Display Recent Posts in WordPress on the sidebar but there are other users who also want some change. In this article, we will show you the different ways to Display Recent Posts in WordPress.

Display Recent Posts in list format:

We know, the list format is mostly used in sidebars so if you want to display Recent Posts in a sidebar then put the following code in a template file (sidebar.php):

', ''); ?>

I have put the default no. posts at 10, if you want some less or more posts to display then change according to your requirement.

Display Recent Posts with Summary:

To give a small overview of the post to the reader, some people display Recent Posts with a title and a short description. For them, I have found two ways to display Recent Posts.

The First Way:

  • have_posts()) : $the_query -> the_post(); ?>
  • ”>
 

If you put the above code in a template file (sidebar.php) then you have to specify a short description of the post. So, you have to rewrite the excerpt as per the word limit.

So, here is the second way to display Recent Posts in WordPress. First, you have to download this Limit Post plugin and activate it. Once the plugin is activated then paste the following code in your theme files where you want to display Recent Posts.

  • have_posts()) : $the_query -> the_post(); ?>
  • ”>
 

Here I have put the description limit as 250 you can change according to your blog.

Display Recent Posts with Full Content:

If you want to display Recent Posts with Full Content then place the following code in your theme files:

  • have_posts()) : $the_query -> the_post(); ?>
  • ”>
 

Here also you can change the no. of posts.

I hope now you can Display Recent Posts in WordPress blog easily. If you face any difficulty in placing code then connect with via the comments section below.

Continue Reading

Tips

How To Use Google Advanced Image Search For Finding Royalty FREE Images

Published

on

Let us start with a simple question, what's the most common way that you use to find images? Most of the people just Google about the topic, save the images that they like and use them for their purpose.

Many people even put their own watermarks on the images they found on Google, well all these things are actually wrong you may have to pay a fine of almost 1000$ per image.

You never know that the image you downloaded from Google is copyrighted or not. Personally speaking, many of my fellow blogger friends have already faced an issue because of using copyrighted images.

Sometimes you may even have to shut your blog down.

You must be thinking that the best way is to generate the images yourself. Well, this is not the only solution, no doubt this is one of the best ways. I

n this article, I will be showing you How To Use Google Advanced Image Search For Finding Royalty FREE Images.

You must be wondering what do I exactly mean by Royalty free images, these are some images which are not acclaimed/copyrighted by any online firm or blog.

It means you guys can use these images in any way you want, no one will charge you even if you put on your own watermark on these images.

These images also prove to be pretty handy to the people who design flyers/posters for different firms and educational agencies.

So without any further delay lets get down to the main topic, below are given the steps using which you will easily be able to find some useful and royalty free images.

Follow the steps as listed below:-

  1. Google whichever topic that you want to search the image on and select the images tab.
  2. Now all the right you will see a gear icon, all you need to do is just click on that gear icon and go to advanced search.
  3. Now once you click on Advanced search, it will open up a completely new window in the same tab, here you will see a lot many setting, all you need to do is just simply scroll down to Usage Rights once you click on that it will open up a drop-down menu, from this drop-down menu select “Free to use and share even commercially “.
  4. Now once you have done this, without playing around with the other options, just go ahead and click on advanced search button which will be on the right side in blue colour.
  5. Once you click on the button it will take you back to the image window in the same tab, but this time all the images you see up there are completely royalty free and meant to be used in any way that you want to.
  6. So all good to go? you will now also get some additional features, for eg:- when you click on Labeled for reuse you will get several options and you select the one you feel the most suitable to you.

Hope this article helped you out, Keep stalking for more tricks 🙂

Continue Reading

Tips

How to Find Duplicate Images Online

Published

on

Finding Duplicate Images online on the internet is not easy!

It may be not of a majorities concern if their pictures or tech pics are being used without there permission but for a photographer, it will be of more concern than even his camera!

Pics are very diplomatic at times they may not even generate a Penney but a few make rootless money out of this!

So why do others let use your hard earned pics rather than just make it available where you think it should be!

As I said it is hard to Find Duplicate Images of your own on the internet, being vast enough over 55 million websites it is actually not hard but impossible to find pics over the internet.

Let's not talk of the internet just let it be small scale just into Facebook, even then it is impossible to find that who uploaded you priceless possession on FB.

So here we are to Find Duplicate Images easily. Firstly we should be well aware that our image can be anywhere in any format may it be an embedded one or an image uploaded to Rapidshare in zipped format.

The tool we will be using here will always track out every form of an image may it be in any format.

Find Duplicate Images online:-

Finding duplicate pictures can be beneficial in a number of situations. For instance, Find Duplicate Images online can be greatly helpful if you are trying to get the same picture in a different resolution or if you want to see if somebody is reusing your picture.

To Find Duplicate Images online you can use a nifty tool called “Who Stole My Pictures” for Firefox.

Right click on the image to see the searching options!

Who Stole My Pictures is a browser add-on for Mozilla Firefox. The add-on helps you easily search for Duplicate Images online using three websites dedicated to this purpose: Yandex, Tineye, and GazoPa. With the image open in your Firefox tab.

Simply right-click on the image and choose one of the above-mentioned websites. You may choose to Find Duplicate Images online from whichever tool you like.

A new tab will open up with that site’s results for duplicate images displayed with the numbering of the websites using that same image.

This is how the new tab looks like when we search for duplicate images!

The new tab will be having all the images which are close enough to your image with there sizes in which they are available and also their size including the Title, ALT text and the link of the image to the directory where it is uploaded.

That means it is easy to track all the websites which use your images within being in the same tab.

Why do we consider this tool to be the best to Find Duplicate Images online?

  • Lets you search and find duplicate photos online.
  • Lets you use 3 different websites (Yandex, Tineye or Gazopa).
  • Similar sites: MacroGlossa, Similar-Images, Pixolu and GazoPa.

So here we just made you know that how to Find Duplicate Images online with ease with “Who Stole my Pictures”. !

If you have any queries or issues using this add-on or using other search engines comments are always welcome!

Continue Reading

Blogging

How to Edit WordPress htaccess File?

Published

on

WordPress, is the most popular Blogging CMS in the world as of now. It powers more then 25% of the total world websites! Now that, is a huge, huge number. And that also is the reason why I'm writing this piece on How to edit WordPress htaccess file.

Well, before you actually jump in and start pondering over How to Create and Edit WordPress .htaccess file or where is .htaccess file, let me make couple things clear.

See Also: How to customize WordPress themes?

I don't want you messing with something you're not sure about, so let's get sure about what exactly is the .htaccess WordPress file, right?

What is WordPress .htaccess File:-

.htaccess is the file responsible for manipulating how the Apache server handles any changes in configuration of your WordPress CMS. So now you'd be asking, What do “changes” and “configuration” exactly mean, right?

So well, your WordPress is based out of a Permalink structure, isn't it? And someone needs to handle how those permalinks would come into being, right? That's what .htaccess does, it manipulates and changes and does whatever is needed to keep the pretty permalink structure of your WordPress stable and running.

That, sounded a bit complicated, huh? Well let me give you an “English version” of what .htaccess file can do for you:-

  • It can Protect your Admin Area!
  • It can even put in a Password Protection for your WordPress Folders!
  • Lets you hide backlinks and do some other magical tricks that might not be possible, or at least seem possible without it.
  • It has the power to hide / disable your directory from being browsed. Meaning your inner system files and stuff.
  • Wpconfig.php is one of the most important files to your WordPress blog, and well it can protect it!
  • Oh, and you can't forget that it allows you 301 redirecting your blog in case you ever need it.
  • It can even help you banning someone from checking your blog out.

htaccess file for WordPress is often ignored, most webmasters don't even use it to it's full potential and instead waste thousands of dollars on third-party tools and plugins.

While all of those tweaks and tricks and little magical stuff performed by those tools could have been achieved simply by adding one extra line of code to our .htaccess file! So yeah the potential? It's unlimited!

And some other stuff similar to that. So no doubt you're curious about how to change .htaccess file WordPress, right? Yeah, that's what I'm solving right here. Just keep reading.

See Also: How to Choose the Best WordPress Theme?

Where is .htaccess File:-

So once you know what exactly the .htacces file does, now you might proceed to something more practical like How to edit WordPress htaccess file right? But before that, you need to know where is .htaccess file don't you?

The WordPress default htaccess file is located in your Cpanel, under your WordPress Installation. (Don't worry, in the later sections I'm covering How to edit WordPress htaccess file, and there you can checkout the step by step procedure, and it's location! )

How to Edit WordPress htaccess File:-

So yeah if you wondered How to Create and Edit WordPress .htaccess file then this section covers that for you. Not just that, this section will also show you where is .htaccess file located on your server.

So, before you can actually venture into how to change .htaccess file in WordPress, let's first checkout where is .htaccess file located and then we can edit it.

Login to your Cpanel.

How-to-edit-wordpress-htaccess-file

Once you do, click on the File Manager option, and on the next popup, select Public_Html directory.

How-to-edit-wordpress-htaccess-file

Then, on the next page, click on the blog for which you are trying to edit the WordPress default htaccess file.

Well, you're almost there. Put a bit of pressure on your eyes and you should be able to easily spot out the .htaccess file! (See? I told you I'd answer where is .htaccess file located on WordPress, right?)

How-to-edit-wordpress-htaccess-file

Now this is the part you've been waiting for, if you were wondering How to Edit WordPress htaccess File just right click on the file, and select edit.

How-to-edit-wordpress-htaccess-file

A new tab will open up with a text like an editor, that is where you can edit your .htaccess file without any fuss!

How-to-edit-wordpress-htaccess-file

So yeah that was about it ! Nothing like rocket science there right? But hey wait, you might not always find your .htaccess file in some cases, because they might be hidden! 

Well, so I thought why not add a section to explain it out how to show hidden htaccess files, right?

Well in order to do that, just make sure the checkbox that says “show hidden files” when you click on the File Manager is ticked!

How-to-edit-wordpress-htaccess-file

Just get it ticked, and you're going to have a smooth sailing!

See Also: How to Install WordPress with cPanel?

Over to You:-

The .htaccess file is of utmost importance to your blog. It might seem like a tiny bit of code but it does miracles and magic when it comes to tweaking your blog for better performance or especially protecting it.

So I'm guessing this piece solved your issues over How to edit WordPress htaccess file right? Oh, I even tried my best to explain to you where is .htaccess file and how to show hidden htaccess files.

But I get it, there still might be couple doubts arising in that curious little mind of yours, guess what I love questions. Make use of the comment box; I'm here for each and every one of them.

Continue Reading

Trending