Reduce and Optimize WordPress Database Size: Blog loading time is one of the most important search ranking signals used by the search engines. A faster website helps search engine crawlers to access your web pages quickly and easily. No one likes a slow site, a faster website also provides better user experience.
Many shells out their money on coding or clutter-free designs to reduce their site loading time.
But simply reducing the WordPress database size can significantly reduce the loading time of your site and makes it faster. Actually, when you install WordPress then WordPress files and WordPress database is stored on the server.
And as you use WordPress, your database accumulates a lot of extra data like spam comments, trash comments, post revisions etc. that increase the database size. Thus, this leads to increase in blog/site loading time.
So it is necessary to clean up WordPress database at regular intervals to reduce database size. Removing extra data such as revisions, spam comments, unused records will not affect your website. Cleaning up database will reduce the load on your server and your WordPress performance will certainly improve.
In this article, I will be discussing how to clean up WordPress database and reduce the size of your database significantly.
How To Clean Up and Reduce Database Size To Optmize Database
1. Backup Your WordPress Database
Before you do anything with your WordPress database, you must take backup your database. You can use WP DBManager WordPress plugin for creating database backup easily with a single click. Simply install and activate the plugin and go to Database >> Backup DB. This is the most important step before doing anything else. Database backup is highly recommended.
2. Deactivate & Delete Unwanted WordPress Plugins
First of all, go through your installed WordPress plugin list. Deactivate and delete unwanted WordPress plugins. You should first deactivate and then completely delete the plugins that you are not using anymore. This would help us to delete unwanted tables created by these unused plugins.
4. Delete Spam Comments, Trash Posts And Post Revisions
With a single click, you can easily delete these spam comments, trash posts and post revisions using WP-Sweep or WP-Optimize WordPress plugin. This will definitely optimize your database.
5. Use MySQL Queries For Optimizing Database
Most of us use Akismet WordPress plugin to fight spam. But Akismet is also responsible for increased database size due to one of its table wp_commentmeta. Assuming you have installed and activated WP DBManager as mentioned above, run MySQL queries from WordPress dashboard by simply going to Database >> Run SQL Query. Run these queries one by one.
[css]DELETE FROM wp_commentmeta WHERE comment_id NOT IN (SELECT comment_id FROM wp_comments);[/css]
[css]DELETE FROM wp_commentmeta WHERE meta_key LIKE ‘%akismet%’;[/css]
Note: Don’t forget to check table name before running these MySQL queries. Following are few more MySQL queries that will help you in further reducing your WordPress database size.
[css]DELETE FROM wp_postmeta WHERE meta_key = "_edit_lock";[/css]
[css]DELETE FROM wp_postmeta WHERE meta_key = "_edit_last";[/css]
6. Empty/Drop Unused Database Table
Skip this step if you are not sure what you are doing. Empty/Drop tables are created by those plugins which you have uninstalled or deleted. If you have WP DBManager plugin installed, simply go to Database >> Empty/Drop Tables and select and delete the table created by the plugin that you do not use anymore.
7. Optimize WordPress Database
At last, you should optimize your WordPress database. Actually, every information is stored in the database. So, if you are having a un-optimized database, then every time when a page loads, it takes a longer time to find and display information.
You can use WP DBManager WordPress plugin to optimize your database and see how much database size you have reduced. Assuming you have this plugin installed, just go to Database >> Optimize DB.
BONUS TIP:Use a Cache Plugin
A caching mechanism can greatly optimize your WordPress website. You can use any recommended cache plugin like W3 Total Cache or WP Super Cache.
Actually, caching plugins create a static version of your website pages and generate that page for a first-time visitor by accessing database and stores it on the server. So when the visitor again visits the page, then the same page is pre-generated thus database is not accessed this time.
That's all. Follow these steps and this will surely reduce and optimize your WordPress database and thus speed up your blog. You should clean and optimize your WordPress database once every two weeks. For any feedback as well as query, please leave a comment.
Create And Edit WordPress .htaccess File: WordPress being a self-hosted blogging platform is very versatile. You can control every single thing of your blog or website as WordPress allows users to access root folder. So today I am going to discuss a file named .htaccess which is present in the root folder of your WordPress site.
What Is WordPress .htaccess File ?
.htaccess is probably one of the most important and useful files. .htaccess is a server configuration file and communicates with your hosting server to tells how to handle certain things on your site.
With this, you can fully optimize your self-hosted WordPress website. You can do whole lots of things like security settings, block search engine bots, activate Gzip compression, add expire headers, security from spammers, add redirection rules, protecting directories and much more.
The dot before htaccess file indicates that this is a hidden file. To access this you just need to Turn on show hidden file feature when trying to access your .htaccess file through FTP client or cPanel. Now let's move on to the article and learn how to create this file in WordPress.
How To Create WordPress .htaccess File ?
WordPress automatically generates the .htaccess file for the first time when you set up permalink structure for your blog. You just need to go to Settings >> Permalinks and click on save changes there. Then WordPress will automatically generate a .htaccess file in your website root directory.
In rare cases, WordPress may not be able to generate .htaccess file automatically because of file permission issue. In this case, go to Settings >> Permalinks, here at the bottom WordPress will show you a notice informing that your .htaccess file is not writable.
If you have set your permalinks structure to other settings then default it will show you a code that you need to paste in your .htaccess file.
Copy the code and paste it into notepad and save it as .htaccess on your desktop. Now Upload this file to the public_html folder in root directory by connecting your WordPress site using an FTP client like Filezilla or using File Manager in cPanel. You can check the steps below with screenshots.
In case you are getting an error while uploading, then you need to change the file permission of your root directory. You need to change your public_html permission. Just right click on the public_html folder and click on change permission, now a dialog box will appear. Now enter 755 into the numeric value field and click OK.
Now you should be able to upload your file successfully. Make sure to change the permission back to 644.
How To Edit WordPress .htaccess file ?
You can access and edit WordPress .htaccess file in many ways. In this article, I will be sharing some really easy and quick ways to access and edit .htaccess in WordPress.
Login to your cPanel account and under files section click on File Manager.
Now select the home directory and make sure to mark show hidden files.
Then open public_html folder select .htaccess file and click on Edit File. Now you can add codes in the edit and save the file.
2.Edit .htaccess File From WordPress Dashboard
Access and edit .htaccess file directly from WordPress dashboard using WordPress plugins. Many plugins are available like WP Htaccess Editor etc. If you are already using Yoast SEO WordPress plugin, then you can access it from SEO >> Tools >> File Editor.
If you are looking for more control then you must follow this method. If you want to edit WordPress .htaccess on your desktop then this method id perfect for you. This is the method I love and use. You just need an FTP client like Filezilla and login to your FTP account. But make sure to turn show hidden file feature on under Server >> Force Showing Hidden Files.
Now browse to your website root directory and edit or download WordPress .htaccess file. And once you are done with the editing re-upload it back.
I would recommend you to take backup of your WordPress .htaccess file before editing. As incorrect .htaccess file, it can greatly affect your website. And make sure to change file permission of WordPress .htaccess file to 644 for security.
Hostgator Coupon Code : HostGator is One of the top hosting company right now. Trusted by millions of webmasters around the world. If you are looking for reliable as well as cheap hosting for your WordPress blog then HostGator is perfect for you.
Hostgator offers various plans for your WordPress hosting but if you are a newbie you should consider starting with their shared hosting plan. And later move to managed or dedicated hosting services. As BroughtMeUp is also hosted on Hostgator, You can check my personal Hostgator baby plan review.
Hostgator offers quality and perfect hosting for WordPress blogs. I would recommend you to go for baby plan as it can host unlimited domains. Some quality features you should know:
Free Blog migration
24*7 support service
Free AdWords credit
One Click WordPress installation
I love their support services. Hostgator offers 24*7 support service. You can either get support via chat, tickets or you can just telephone them. Their response time is quite fast and they will help in all possible ways.
Another feature that make Hostgator stand out among other hosting providers is their Free Blog migration service. If already have a blog on another host and planning to move to Hostgator, then this feature is like a blessing.
Now I will be sharing Hostgator coupon for January 2016 which you can use to get discount while purchasing Hostgator hosting.
Hostgator Coupon Code August 2016 : BROUGHTMEUP25
Use “BROUGHTMEUP25” hostgator coupon code to get maximum 25% discount on Hostgator hosting. Also you can use "BROUGHTMEUP" discount coupon code to get Hostgator hosting for only 1 cent for 1 month.
Though if you are planning to get hosting for long then I would recommend to buy hosting for more than 1 year and use "BROUGHTMEUP25 coupon code to get maximum discount.
Here is the proof of the both the discount coupon codes:
I hope that this Hostgator coupon code will certainly help you in saving your money on your purchase. Share this on Facebook, Google+ and Twitter. Do let me know your experience with Hostgator. Also do subscribe for updates and more discounts deals directly in your inbox.
Cyber Monday/Black Friday Deals And Discounts:Black Friday and Cyber Monday are here. And it's the best time to get whooping deals and discounts on various products.
As you may know on Black Friday and Cyber Monday different companies, come up with special deals on their products.
They offer a special discount for Black Friday and Cyber Monday. They offer a huge discount that you could not resist and you should never.
Black Friday is falling on 25 Nov 2016, and the Monday after this Friday is Cyber Monday. Because it’s the best time to buy so, I decided to share the latest and best Black Friday deals and Cyber Monday deals for bloggers.
I will list all the products with their discount offers, especially the products are related to blogging including SEO products, WordPress plugins, Web Hosting and much more.
You must keep this in mind that Black Friday deals and Cyber Monday deals are only for limited time.
I will highly recommend you to bookmark this page because I will keep updating this page as soon as other deals are available.
So bookmark it and come back for updated Black Friday and Cyber Monday offers.
Black Friday 2016 Deals And Discounts
I will be listing the product along with the Discount, Deal Period and if you should go for the deal. Here are list of the deals. Click on the interested deal to get full details.
Remember its best time of the entire year to buy. So grab the deal before it's gone.
1) Bluehost Hosting Black Friday Deal [Hosting @$2.95] Highly Recommended
Bluehost one the best hosting providers, indeed one the official hosting provider for WordPress. Bluehost is offering 50% discount on their hosting. The discount will be available from Black Friday to Cyber Monday.
[su_button url="http://www.broughtmeup.com/adores/siteground" target="blank" style="flat" background="#009ee2" color="#ffffff" size="12" center="yes" icon="icon: external-link-square" icon_color="#00000" text_shadow="0px 0px 0px #000000" title="Siteground Black Friday Deal"]Get Siteground Black Friday Deal Now [/su_button]
4) Soliloquy Best WordPress Slider Black Friday Deal [35% Discount]
Soliloquy is the world's best responsive WordPress slider plugin. One the most powerful and user-friendly plugin to create beautiful responsive slider within minutes. It's a drag and drop plugin. If you want to create beautiful and responsive sliders, then Soliloquy is the only recommendation.
Features of Soliloquy:
Drag and Drop builder
Responsive Mobile Design
and the list goes on and on.
Here is Soliloquy's biggest sale of the year "35% Discount". Soliloquy is offering an exclusive 35% off discount from November 22nd to November 30th, 2016. This discount is available for new customers only.
[su_button url="http://www.broughtmeup.com/recommended/WPForms/" target="blank" style="flat" background="#009ee2" color="#ffffff" size="12" center="yes" icon="icon: external-link-square" icon_color="#00000" text_shadow="0px 0px 0px #000000" title="WPForms Black Friday Deal"]Get WPForms 35% Black Friday Deal Now [/su_button]
6) EnviraGallery Black Friday Deal [35% Discount]
Envira Gallery is the best premium WordPress gallery plugin. With this plugin, you can create beautiful as well as responsive photo and video galleries within minutes. Also, it is very easy to use this drag and drop gallery plugin.
Features Of EnivraGallery:
Drag and Drop Gallery Plugin
Responsive and Mobile Friendly
Pre-built Gallery Templates
Social Media Integration
and so on. EnviraGallery plugin also offers exclusive 35% discount.
Black Friday Deal: 35% Discount on EnviraGallery Plugin
[su_button url="http://www.broughtmeup.com/recommended/EnviraGallery/" target="blank" style="flat" background="#009ee2" color="#ffffff" size="12" center="yes" icon="icon: external-link-square" icon_color="#00000" text_shadow="0px 0px 0px #000000" title="Envira Gallery Black Friday Deal"]Get EnviraGallery 35% Black Friday Deal Now [/su_button]
7) OptinMonster Black Friday Deal [35% Discount] Highly Recommended
One of the best email option plugin. It is a drag and drops form builder that will give you high email conversions. With OptinMonster building high converting forms is just a matter of few clicks. Most of the top blogs are using OptionMonster for Lead generation.
I would highly recommend OptinMonster to those who want to boost their leads conversion.
Features of OptinMonster:
Drag And Drop Builder
Multiple types of Forms: Lightbox popups, Floating bars, Slide-ins, Sidebar forms and more.
Page Level Targeting (Target Specific pages)
OptinMonster is also offering 35% discount as Black Friday Deal.
[su_button url="http://www.broughtmeup.com/adores/longtailpro" target="blank" style="flat" background="#009ee2" color="#ffffff" size="12" center="yes" icon="icon: external-link-square" icon_color="#00000" text_shadow="0px 0px 0px #000000" title="Long Tail Pro Black Friday Deal"]Get Long Tail Pro Black Friday Deal Now [/su_button]
10) GetResponse Black Friday Deal: 40% Discount First 1000 Accounts Only
GetResponse is offering 40% discount for only first 1000 accounts. So claim this deal before it's gone. Time is running out.
You need to pay as little as $29/month for complete marketing solution including email marketing, landing pages, webinars, and marketing automation.
Create Google AdSense Account : Many of you might have heard of Google AdSense. If not, Google AdSense is the most popular and probably the best contextual advertising program. Google AdSense is most popular among the bloggers for monetizing their online content. Though there are many AdSense alternatives but no one could beat Google AdSense.
For getting paid, AdSense ads must be placed on your website and clicked by your blog visitors. You might have noticed AdSense ads on very popular blogs and websites. You can make decent money from your blog by using Google AdSense.
In this article, I will be discussing how to create and apply for AdSense.
Steps For Creating an AdSense Account
Creating AdSense account is quite easy. First and the most important thing is you need to have a blog or website. Your blog or website must contain minimum 10 pages and should not violate any Google AdSense policies. Also, you must be 18 years of age to apply for AdSense and if you are not you can use your parent's name to apply for AdSense.
AdSense account approval includes the following steps:
Sign Up for AdSense
Place AdSense ads code on your blog
Wait while your account is being reviewed.
Before applying make sure your website is not violating any of Google AdSense policies. And if it does make sure to fix that first and then apply for AdSense. This ways your AdSense application will have higher chances of getting approved.
Guide To Create Google AdSense Account
First of all, go to AdSense homepage and then click on signup button. Now you need to complete AdSense application form.
Step 1: You need to select your Google account to continue. You will see two options. First is to continue with your existing Google account and second is choosing a different or new Google account. Select the option you like.
Step 2 : After selecting your Google account, you will be to tell about your content. Here you will be adding your website details. Simply enter your website address but without http:// and select your content language and click on continue.
Step 3 : In this step you need to add contact information. Make sure to use payee name same under which you have your bank account. please note that you will not be able to change the payee name after signing up in some countries. So make sure you must have exactly same payee name and bank account name.
Step 4 : Here you need to accept Google policies. Just read and check mark the box and click on submit. These are the Google policies you need to follow:
I will not click on ads nor encourage others to do so.
I will not place ads on sites that include adult content.
I will not place ads on sites involved in the distribution of copyrighted materials.
I do not already have a Google AdSense account.
I will not place ads on sites that include incentives to click on ads.
Make sure not violate any of the Google AdSense policies otherwise your account will be suspended and you have very few or probably no chance of getting your AdSense account back.
Step 5 : Once you have signed up for AdSense, you need to place AdSense codes on your website or blog. This is very important steps as AdSense team will review your application and website. Now just wait for AdSense email to arrive. It can take 24 hrs to months.
Now if your account is approved you need to complete two more steps for getting payments :
Submit Tax Information
Enter your AdSense PIN
You need to fill tax form depending upon if you are US Citizen or Non-US Citizen.
Once your earning reached a threshold of $10 in your AdSense account., then AdSense will mail you a pin to your address. Now login to your AdSense account and enter your pin. That's all, now your account is created successfully and once your earning reaches $100 you can receive it.
I hope this guide helped you in successfully creating your AdSense account. If you don't have any blog then consider reading these following articles.