Hello friends welcome To helprobo as a newbie blogger you always want to improve your WordPress Blog performance so

There are two important components of a typical WordPress installation:

1-WordPress files stored on your server

2-WordPress database

It’s very essential for you to timely cleanup WordPress database and reduce the size. This is a must-have process for every WordPress user to keep the size of their database at minimum and

keep their WordPress blog fast. Over the time your WordPress database have many redundant table, unused records and many entries which you can remove without affecting your website.

This will help you a lot to reduce load on your server and your WordPress performance will

improve. In this tutorial I will take example of helprobo WordPress database which is of size 286.3 MB before cleaning up, and will share exact steps I took to drastically reduce the size of my blog database. You can follow this guide step by step and work on your blog. 

Only few of the points might require technical know-how, and if you find yourself questioning there; feel free to ask

question or skip that step. So, let’s get on with this simple DIY tutorial.

Tutorial: How to Reduce WordPress Database Size

I’m mentioning steps in the series I followed to reduce the database size, and I suggest you to follow the exact methods.

Step 1: Take WordPress database backup

This is most essential step which you need to take before you work on your blog database. In my case I have used my hosting company backup feature (WPEngine backup feature) to take

complete backup of the database and all files. You can use WP-db manager plugin to take

backup of your database file. You can find tutorial over here to learn taking WordPress backup.

My recommendation here is WP-db manager plugin as we will be needing to run few SQL query, empty and drop database tables with this one useful plugin.

Step: 2 Disabled and delete unused WordPress plugin:

Now go through theactive plugin list of your WordPress blog and first disable those plugins which you are not using anymore.

There might be plugins that you use once in a while, So I suggest you can disable them too and install when you need it again.

Our goal for today is to completely optimise the database size. Only disabling will not be of much help here, so make you

also delete those unused plugins.

The reason being is to clean out the database table that are created using those unused plugins. Need some useful plugins?

Basic WordPress plugins for every blog
Must have SEO WordPress plugins

List of plugins that I use here at ShoutMeLoud 

Step : 3Delete all spam comments, trash posts and post revisions:

What ever comments you have in spam folder and trash folder, empty them. Similarly delete all posts from trash folder and delete post revisions. You can use WP-optimize plugin to get this done with one click.

Step : 4 Find and clean orphan table:

Now follow this tutorial and install and use Clean options WordPress plugin to find orphan and unused tables in your database. Using this plugin you can clean all such tables.

This is quite critical step and use it when you are sure of the table names which you are not using. If you are in confusion, I would recommend skip this step.

Note: Deactivate and uninstall the plugin after using it

Step: 5 Remove unused Meta value from Database (Caution: For tech people only)

This is one step which I use once in a year and suggest you to do it only if you are accustomed with PhpmyAdmin. If you have earlier worked on PHPmyadmin, you can simply follow this easy

tutorial and get rid of all unused meta value from database.

This won’t be decreasing down your database size significantly but again this is useful if you are highly determined to clean up your

WordPress database.

Step : 6 MySql Queries to reduce database size

One of the table which is a major cause of increased database size is wp_commentmeta due to Akismet plugin. Before running below mentioned query, my commentmeta size was 146 MB and after that I reduce its size. 

so how was the article If this article is touching your heart so I think you should must share this on social meadia and if you're feeling any problem let me know by commenting and subscribe us for a newsletter. 

Hello friends welcome To helprobo If you are feeling any problem of security  of your WordPress Blog so don't go anywhere here you will read. 

How to secure WordPress Blog? 

Tip to secure WordPress Blog? 

In recent time, WordPress has been highly targeted by bloggers. Since WordPress uses MySQL and Php, it’s not tough to find a vulnerability in WordPress.

Here I’m sharing some newbie tips to Secure WordPress blog. These are basic tips but sometimes missing these basic tips, may lead 

to losing your WordPress blog by some hacker.

WordPress powers 25% of the website in the world & is most popular CMS apart from a blogging software.

I can quite confidently say that, being a user of this awesome CMS for the past 6 years.

I simply love the fact that I could choose from tens and thousands of plugins from the

WordPress plugin database. The plugin database has never failed me if you need to add a new feature to my blog,

 

someone has already made a neat plugin for that and shared it for everyone

to use. There are endless options when it comes to themes, as well, right from the Genesis theme

to Thrive themes.

That was the good part but whenever there is good, there is also evil too.

My site has been hacked nearly 6 times in the past by some Arabian and some Turkish hackers (atleast that’s what

they claim from). They leave your site with an ugly black background with GIF images of skulls and Ravens.

 

Most of these hack attacks are done by what is called as an SQL injection.

Nowadays it has become a necessity to do all the preliminary safeguarding measures to keep these hackers at bay.

Proven tips to Secure any WordPress Blog:

1. Configure the backup:

Well, I have given a lot of proven tips below to secure your WordPress blog, but no matter what you need to ensure if something goes wrong you can restore your blog. Not having a proper WordPress backup solution in place is the biggest mistake you can have. When a big site like Sony, Dropbox can be hacked, a WordPress blog is relatively easy to be cracked by a hacker.

So first thing first, ensures you are taking a daily backup of your blog. If you are earning money from your blog, I would suggest using VaultPress for the backup which cost only $5/month.

You might say that your hosting offers backup which is good only if they store the backup on the different server.

2. Use reliable & secure hosting company:

Your WordPress installation is just a software installed on a server. The foundation of a secure website is the server which has enough provision to stop hackers from getting inside your website.

A free web-hosting company is a big nay for you & something one should avoid. Ensure

your hosting company have placed proper rules & have the firewall to stop the server from attacking your website.

I understand that it’s hard to know which hosting company is reliable against hacker & that’s why I have created this quick list of hosting companies that offer great security on their server level.

B-Bluehost:

One of the top rated hosting which offers great security.

InMotion Hosting: Founded in 2001 & since then they are known for great hardware quality &

security infrastructure. They also migrate your existing site for free.

A-WPEngine:

 

A managed WordPress hosting

company which is recommended for business 

WordPress sites with low or medium traffic. They offer backup, security at multiple levels.

3. Update WordPress

Keeping your WordPress up to date is the first and basic security tip for any WordPress blogger.

This is something that you never want to miss, whenever WordPress is sending an update, it means that they have fixed some bugs, added some features and most importantly added some security features and fixes.

You never want to miss out on this.

When you see the message WordPress x.x.x is available! Please Update.

Especially, with one click update, it’s easier to upgrade your blog. Make sure, your theme andplugins are compatible with the latest version of WordPress.

If an update has been rolled out and

it’s not a security update, I suggest you to wait for 5-6 days, before other users stop reporting 

any bug in the latest version of WordPress.

4. Update WordPress Plugins

update your WordPress plugin because there is risk In using unknown and malicious WordPress plugin but If you don't know that which website can you use for WordPress plugin so try this some trusted sites by user.

you can use www.Sumome.com or you can use www.privy.com for install WordPress plugin .

so I think you should must share this article with your own friends for aware them about secure their WordPress Blog and don't forget to subscribe us and if you are feeling any problem let me know by commenting. 

Hello friends welcome To helprobo you know 

WordPress is  being popular but security vulnerable platform, it’s important for us to keep our WordPress blog secure.

Here I’m sharing some essential WordPress security tips, which will help you to keep your blog safe and secure.

Here you will read that

How to secure your WordPress Blog? 

Top security tips to secure your WordPress Blog? 

When I was 17, I hacked our university’s web-portal to get the semester final questions draft by entering into teachers area.

I needed the questions of ‘network security’ course, so I attempted to

login as rohit (the respective teacher) and I succeeded in a few attempts to get his password as it was his girlfriend’s name without any space. 😃

Reading my story of hacking, as a webmaster, you might be strained about your website security.

For any website, a security strategy is a must. And as wordpress is the most popular open source software for blogging, it is a primary target of many malicious attacks.

Luckily, by the strength of being open source software, wordpress has many protective plugins,

functions and techniques to save you.

When used in an aggregate, these tools can defend you from vicious activity, hacks, spam and other threats. Let us have a look to few of these

techniques today.

Useful WordPress Security tips:

1-Always upgrade:

Always upgrade your wordpress version, theme and plugin to the latest version. The upgrade may fix any security bug from the previous version, so it is wise to be upgraded.

Hide your wordpress version number:

For some reason, if you cannot upgrade to the latest wordpress version, do not let hackers know your current version.

As the bugs of previous releases are known to all through wordpress.org, it will easier for them to attack your website. You can hide your wordpress version number by

following below instructions:

If you are using an older theme, remove the following line from your theme’s header.php filephp
bloginfo('version'); ?>" />
If you are using a newer theme, just add the following in your theme’s functions.php file

Be careful about plugins: Be careful about installing plugins. Weak plugins may have buggy codes through which some

other codes or sql queries can be injected or some other harmful activities can be done to

damage your site or its ranking.

Check plugin’s ratings and popularity before installing it. And to be sure, read reviews or ask your blogger friends about the plugin you are going to use.

While upgrading plugins to latest version, make sure you upgrade wordpress plugin in correct

way.

2-Secure administrator account:

Prior to wordpress version 3.0, the default wordpress installation used to come with an

administration account ‘admin’ as username. As the hackers know it, they will always try this.

Make sure, your administrator account username is not something easily guessable like ‘admin’, ‘yoursitename’ or ‘yourname’. If you already did so or you had installed a wordpress version older than 3.0, you need to change it.

3-Disable directory browsing:

Enabling directory browsing in your site is comparable to keeping your door always open, so that the thief can see your wealth inside house and can do a plan to steal. 😃

I hope you understand the importance of keeping your door closed A simple trick to disable directory browsing is to upload a blank index.html or index.php file in each directory and sub directory except the root.

Also make sure this WordPress hack to find the plugin used in your website does not apply to your website.

Monitor any hacking attempts using wassup:

Wassup is a wordpress plugin that records details data of each user.

Using this plugin you can monitor any malicious activities like code/sql injections.

Hello friends welcome To helprobo as you know that  To be profitable and celebrated, your website needs returning visitors.

So here you will read that 

How make famous website? 

Top ways to make a famous website? 

Now, the content you provide on your site will have the biggest impact on whether or not people return, but there are other factors too.

One such factor is your domain name.

Have you ever read an article you really liked  or found an interesting fact online, and then  forgot where you found it?

You may try to Google it, but sometimes you  just can’t find it again.You don’t want that to happen to your site.You want people to visit  your site, be struck by the brand name, and  never forget it. This will make all of your  promotion a little bit easier.Just think, if you  do a great job picking your name, every single thing you do will be a little bit more  successful. Pretty exciting, isn’t it?

That’s why it’s so important that you take your time, and choose an excellent name for your business.In this guide, I’ll show you:six tactics for a more memorable namea tool to create additional name ideashow to check if the

domain and social profiles are availableGet a note taking app or pen and paper out now.

   

  Your brain is sure to be buzzing with ideas by the end of this.

Unforgettable Domain Name:

Yes! That’s possible with little work

Keep it Short and Sweet :

When it comes to remember anything, seven  is the magic number.

Based on famous research by George A. Miller, we know that  people can reliably remember about seven  things at once, give or take two.In the study,  the research subjects could recall a set of  five random words about 50% of the time .What does this mean for you?

You should use as few words as possible in  your domain name. If you use more than five words, it will start to get hard to remember.In general, the fewer words the better. Use  Simple WordsTo build upon the first point,  you also want the words themselves to be  simple.

The five words memorized in the study were all monosyllabic (like cat, dog, or phone). Use monosyllabic words in place of more complex words whenever possible.

A domain with more words may be easier than a shorter one if the words are simpler.

For instance, the domain name  antidisestablishmentarianismvolcanologist.com

is terribly hard to remember, while a name  like learnhowtoblog.com might be easier to  remember, despite having 100% more words.

Make it NovelIn Moonwalking with Einstein, by Joshua Foer, he explains that memory is  more a practice of creativity than anything  else.We remember things that are novel. Things that stand out because they are different

from what we normally experience.    For  instance, I can never remember if I’ve taken my allergy medicine. It’s hard to recall                       because it’s so mundane, and my brain knows it. We don’t remember things that are

 

mundane and unimportant.On the other hand, when something is surprising and unique, we  remember it quite easily.For instance, you’ve probably seen thousands of trees. You strut  past them without paying heed,

but if you saw a golden tree, or a tree a     hundred stories tall, or a tree that grew  reverse into the ground, you’d never forget it.Add an element of surprise in your name, and people won’t forget it.

Add EmotionsWhen we experience strong  emotions, we are more likely to remember those moments.Every American can tell you  where they were on Valentine's  day, but most of us have no clue what we were doing on October 11, 2001. Or, any other October 11 since then, for  that matter.Obviously, you want your brand to be associated with positive emotions, and  luckily, positive emotions do tend to be more memorable.

 

The degree to which emotion affects our memories depends largely on how well our mood matches the emotion from the event.

Try adding terms that evoke strong emotions when read or said aloud. Use words that are uplifting, satisfying, or awe-inspiring to create a positive connection with your brand.

Attach to Existing MemoriesOne of the best  ways to remember something new is to  attach it to an old memory.

This is the basis of the memory palace technique or Method  of Loci.Briefly, the technique involves  mentally navigating through a place you know well,

putting the items you need to remember at  different points in the space. For instance,  you could easily remember a long string of

random digits by mentally walking through  your house, and placing large, physical

numbers in different places.What does this  have to do with your domain name?

You can attach the name of your site to a memory people already have solidified.

This can be as simple as adding a familiar    term to the name of your domain, or hooking  into an existing concept.This will help people quickly identify with what your site is about  and remember it.Trim the fat At this point, you’re probably well on your way to creating a memorable name, but I’ve got one last tip for you: trim the fat!Take out any non-essential words in your domain name.   

 

Unnecessary words clutter the name and

make it harder to remember.For instance,

remove any stop words like, “to, “of”, and “for”. People are likely to forget these terms and

grow frustrated trying to recall your site’s

domain name.Generate a Large List with

name generators

Now with your list of terms and potential  names, it’s time to generate a larger list of potential names.Why create a large list of  potential names? Because the best way to  find a good domain name is to come up with a lot of domain names.Don’t worry about  picking your favorite yet. Keep all potential  candidates in your list.With your list at hand, use the following tools to come up with many more potential name ideas:Impossibility – searches for random words to add with your seed term

(s).Business Name Generator –

 Link=www.businessnamegenerator.com

adds additional random terms to your domain to find available names.Run your ideas  through these tools and come up with as  many names as you can.Check availability of desired nameOnce you’ve got your final list of potential names, you can check to see which ones are available.

Namecheap has an availability checker right  on the homepage, including a link to their bulk domain name checker. Use the bulk  availability checker to narrow down your list to only those that are available.Once you have your list of available domain names, you’ll  want to check which ones still have their  matching social profiles available.

Use www.namcheckr.com

to quickly check the availability of your name across a wide variety of social sites.

When you’re done checking, you’ll have a just handful of options left out of your initial list. 

Now all you need to do is pick your favorite, 

 

register the domain, and claim the social  profiles.ConclusionIn their excitement to  launch a new site, new many webmasters  rush the domain selection process. Once you pick a domain, you’re going to be with it for a  long time.

Take your time with each of the tips above. Create the largest possible list of  names you can –

no list is too large! Then, weed out the   unavailable names, leaving only a few killer  names left to pick from.This process takes a real investment of time, but you’ll thank yourself later when your visitors come back time and time again, compliments to your awesome  name.

Please subscribe us and share this article with your friends because sharing is sexy 

and if you're feeling any problem let me know by commenting and if want to Learn more about WordPress check below articles. 

A lot of new (and even experienced) bloggers make silly blogging mistakes that could ruin their chances of becoming successful in their blogging endeavors.

here you will read 

 Top mistake that can ruin your blog. 

How to make a perfect blog?

It is always important to learn all the silly blogging mistakes to avoid in order to making sure that you generate quality blog posts…

all the time.

Blogging is indeed a fantastic way to build a reputation in your chosen field, as well as  connect with new readers, and keep the old

readers coming back for more. A lot of people have actually used blogging in order to grow

their business.There are so many silly blogging mistakes to avoid, but I will just stick to highlight 5 blogging mistakes that every blogger should never make.1Posting Blog Content Are Downright Boring!You need to make your blog content very interesting to read, nothing scares off new readers more than wasting their time reading a boring blog post. The content you generate for your blog should be engaging. Reading a very interesting blog post will make readers want to leave comments on your 

blog.

Having a sense of humor goes a long way to helping you get new readers, and win the

 

loyalty of old readers.Whenever I write,

 

I always want to show my personality and let readers know that I am real and they can count on me to help them learn a thing or two. One of the goals that you should have at the back of your mind when you are generating content for your blog is to make sure that the content you post is interesting to read.

 

No one wants to spend their time  reading a boring piece of article.It is to know what is    considered to be funny as opposed to what   many consider to be racist or religious jokes made in poor taste. I have been in front  of people who have actually thought there  were telling afunny joke, but all the while  they were being very rude.

 

There are so many ways you can make  your blog post interesting without retorting to so-called funny jokes that would upset a lot of readers.This is the part where some people would want to ask: “I write about business, so how can I make my blog posts more interesting?”  When it comes to writing interesting topics about business,   i have found that what keep people glued 

to business posts is topics that address issue in business and how to solve them.  People also want to read about how a fellow entrepreneur turned a teeny-

tiny business into an empire.If you are not connecting well with your readers,  things could backfire. This brings me to the next point.2.    

  Being Clueless about Who Your Target Audiences AreYou should know your target audience! Of course, no one is saying that you  should know the names and addresses of your readers. But you should know the type of audiences that you wish to reach out to.

 

In my case my target audiences are: online entrepreneurs, small business people, people who are interested in learning new things and people you are interested in personal development.

 

When you write for a specific group of people in mind, it would help you connect with them much more easily.

 

3-Making Spelling and GrammarErrors –

 

Yikes!Okay let’s face it, there are times when we write in a hurry and a few typos  slip through the cracks, but when your readers keep seeing badly spelt words, typos and poor syntax, then you can count on losing your readership base.

 

I am a Nigerian, and English is not  my native language; but back home in Nigeria, English is the lingua franca. Any Nigerian  who attended primary school up to the university/polytechnic level would definitely be able to write and express themselves in decent English.Read: 20 common Grammar mistakes I started using American spelling when I began blogging, because I noticed that it was the norm. Instead of writing honour (which I learned in school),

I simply spelt it the American way; which  is spelt “honor”. But if you are not too  confident when it comes to writing error-free English, you can pay someone  toproofread the content prior to posting the write –

up on your website.Accong to the research I made some time ago, Matt Cutts from Google revealed that websites/blogs with better grammar and spelling rank higher in Google  search results.

Read this very carefully, because I am only going to write it once: Poor spelling and poor grammar will leave a bad impression on your readers. Think about it, why on God’s earth should someone trust you when you cannot even spell the name of your company right, or when you are guilty of writing sentences packed with grammar errors and misspellings?!   

4.Not Using Search Engine Optimization (SEO) TechniquesDo not forget about search engine optimization when you blog. I do not mean that you should just stuff your webpage with keywords and keyword phrases! You need to write for readers and not just for search engines and learn the art of balancing quality writing with search engine  optimization –

 

hey, do not worry, the process There are  certain types of keywords that would not sound natural; so you should not worry if you cannot “squeeze” it into your blog post more than once. Learning how to tactfully add unnatural-sounding keywords into an article is a  skill that can be acquired easily, eespecially when you are a naturally gifted writer.  Google is getting better by the minute at being able to fish out spammy web pages.

5.Not Promoting your Blog ContentWriting   thought provoking and super interesting blogs is just not enough,

you will also need to make sure that you promote your blog on social media  websites such as facebook and Twitter.  If you do not have a facebook or twitter account, the best time to sign-

up for one is NOW! If you already have

different social media accounts, then you have absolutely no reason not to start promoting your website or blog!These are just 5 of many silly mistakes, which happens unknowingly.

 

If you are a newbie blogger or one  of those blogger who are taking the leap  of faith to become a successful blogger, you need to work hard on mistakes which you are making on daily basis.

 

A good strategy is to learn from other people mistakes, and quickly jump ahead. Here I’m suggesting some of the articles from helprobo archive, which will help you learn more  about common mistakes which every blogger

 

makes in his initial days of blogging:I’m sure  you will learn many new things today, which will change the way you blog.

If you like to share some of your stories about mistakes that 

you used to make, feel free to add few via  comments. Don’t forget to share this article with your blogger friends on Facebook and

Google plus.and subscribe us for newsletter I wish you success in your

blogging