When we are using the wordpress sites then we need to clean the database always. If your site is having more than 500 articles then you need to worry about server performance.
How to Optimize Your WordPress Database using plugin
Mysql load will impact your server. Many people are suggesting to use the WP-DBManager wordpress plugin. But forgot about plugin feature. That plugin specially made for database backup and managing the tables.
If you want to optimize your wordpress database then you need to use wp-optimize wordpress plugin. I found that is only plugin is helpful for really keep optimize your wordpress database.
I used that plugin. Before using that plugin my mysql database size was 135mb. After using that wp-optimize plugin features database size was 4mb. That means my database really optimized. My sites performance was also improved.
I really liked this wordpress plugin. Thanks to Ruhani Rabin who wrote this plugin.
How to Optimize Your WordPress Database using plugin
Simple but effective plugin allows you to extensively clean up your WordPress database and optimize it without doing manual queries.
What is features of wp-optimize?
Enable/Disable trackbacks for all published post
Enable/Disable comments for all published post
Removal of stale post revisions
Removal of stale unapproved and spam comments
Removal of trashed comments
Removal of akismet metadata from comments
Removal of other stale metadata from comments
Mobile device friendly, now you can optimize your site on the go
Removal of all trackbacks and pingbacks
Cleaning up auto draft posts
Removal of transient options
Clear out the post trash
Automatic cleanup of all the integrated options (also uses retention if enabled)
Ability to keep selected number of weeks data when cleaning up
Option to add or remove link on wp admin bar.
Enable/Disable weekly schedules of optimization
Apply native WordPress MySql optimize commands on your database tables without phpMyAdmin or any manual query.
Display Database table statistics. Shows how much space can be optimized and how much space has been cleared.
Enabled for Administrators only.
Every-time you save a new post or pages, WordPress creates a revision of that post or page. If you edit a post 6 times you might have 5 copy of that post as revisions. Imagine if your post or pages are long and big. It is a huge number of bytes that’s on your MySQL overhead. Now WP-Optimize allows you to optimize and shrink your posts table by removing not necessary post revisions from the database. As example, if you have a post which is approximately 100KB data and you have 5 revisions of that post, the total space wasted is about 500KB. And if you have 100 posts similar to it, you have 50MB database space wasted.
Keeping your wordpress database is very important for wordpress database. In this article we explained, How to clean up and optimize wordpress database. This will improve your site speed aslo. Many times you install the wordpress plugins and some time you dont want that plugins and you delete that plugins.
How to clean up and optimize wordpress database
There is very nice wordpress plugin is avilable for database backup.
WP-DB-Backup allows you easily to backup your core WordPress database tables. You may also backup other tables in the same database.
But that plugins create some tables in your wordpress database. You need to remove that tables from your wordpress database.
Imp note: when ever you are cleaning the database or deleting the unwanted tables from wordpress database. Please consult with your web administrator.
Dont forget to take a full backup of your database.
This tutorial should be forward-compatible with WordPress 3.0
Install WP-DB-Backup by Austin Matzko
Mouse over Tools so that the down arrow appears
Click the down arrow
Click Backup
You’ll see something like this:
How to clean up and optimize wordpress database
On the left are the default database tables included with WordPress. All of these are included every time you backup. The only thing you have to decide here is whether to exclude spam comments from being backed up (I recommend this) and whether to exclude post revisions (I recommend excluding these too, unless you have a specific reason for keeping revisions).
On the right is a list of additional database tables, most of which were probably created by plugins. There’s also a table called that will end with the name “commentmeta” – this can be used by plugins.
If your plugins have created a lot of data that you would like to save, or you’ve spent a lot of time configuring particular plugins, you’ll want to backup these tables. Otherwise, you can keep your database backups smaller by not checking them.
Next we see the Backup Option. There are three choices here:
A. Save to the server
This will save a backup of your database as a file on your web server. I don’t recommend this.
B. Download to your computer.
This will create a database backup file that you can save to your local computer.
C. Email backup to:
This allows you to send a copy of the backup to any e-mail address you’d like.
Let’s go ahead and download a copy to our hard drives now.
Check options you want in the Tables section then click “Backup now!”
You should see a progress bar, and when that’s done your browser will prompt you to save the file. You can save this file wherever you’d like.
There’s another section called “Scheduled Backup.” This is where this program gets really great.
Here we can schedule a backup to be e-mailed to a particular e-mail address however often we’d like. I recommend checking selecting “Once Daily.”
On the right, you’ll see that list of optional tables again. Check the ones you want to backup every time the backup runs.
Enter the e-mail address you want the backups delivered to in the “Email backup to:” field.
Click “Schedule backup.”
You should now get a backup file as an e-mail attachment every day. You should save these attachments to your local computer. If you’re using Gmail or another web mail host that has a lot of storage space, you might want to leave your databases on their server as an additional off-site backup. Be aware that that’s an additional security risk – if your e-mail account is ever compromised, the would have access to all of your database backups.
Restrict the Adults on wordpress website, Many times you website content is not suitable for all the age group. There is very nice wordpress free plugin available.
There’s a lot of content which isn’t appropriate for all ages. The [Association of Sites Advocating Child Protection (ASACP)](http://www.asacp.org/ “ASACP) has developed the Restricted to Adults (RTA) tag which most online protection software respects.
Restrict the Adults on wordpress website
Installing the RTA tag on a WordPress install can be somewhat complicated, so the Restricted to Adults plugin makes it one click — activate the plugin and your site is restricted to adults.
Now WordPress in core the new post thumbnail function will not changed until. we have given info about How to use the the_post_thumbnail In WordPress.
use the the_post_thumbnail In WordPress
You can provide 4 picture formats to the function (change the width and height values to your need):
use the the_post_thumbnail In WordPress
// the thumbnail
the_post_thumbnail(array(100,100));
// medium resolution
the_post_thumbnail(array(300,200));
// large resolution
the_post_thumbnail(array(600, 400));
// original
the_post_thumbnail();
You can set how the images should align. It is also possible to assign an own class:
// left align
the_post_thumbnail(array(100,100), array('class' => 'alignleft'));
// right align
the_post_thumbnail(array(100,100), array('class' => 'alignright'));
// center
the_post_thumbnail(array(100,100), array('class' => 'aligncenter'));
// align right and the class 'my_own_class'
the_post_thumbnail(array(100,100), array('class' => 'alignright my_own_class'));
The 3rd possibility is the control of the images size with an array of height and width:
For this purpose we suppose that the settings for thumbnail is 150×150, for medium 300×200 and for large 600×400.
// thumbnail scaled to 60x60 pixel
the_post_thumbnail(array(60,60), array('class' => 'alignleft'));
// original thumbnail
the_post_thumbnail(array(150,150), array('class' => 'alignleft'));
// medium resolution scaled to 200x133 pixel
the_post_thumbnail(array(200,200), array('class' => 'alignleft'));
// large resolution scaled to 400x266 Pixel
the_post_thumbnail(array(400,345), array('class' => 'alignleft'));
We see that the image proportions are always maintained, even if one specifies crooked values.
For the Theme Designers is this not necessarily easier, because no one knows what the user will put in his settings o his library. One way to approach this problem, to query the options for the various sizes:
// width of the thumbnails
get_option('thumbnail_size_w');
// height of the thumbnails
get_option('thumbnail_size_h');
// height of the medium resolution
get_option('medium_size_h');
// width of the large resolution
get_option('large_size_w');
// 1 = Crop thumbnail to exact dimensions, 0 = Crop off
get_option('thumbnail_crop')
Here another example: If the size of a thumbnail is bigger than 100×100 and crop is activated, then the thumbnail should be resized to 100×100, otherwise use the original thumbnail.
The default upload file size is in php settings is 2 MB and for wordpress also default upload size is 2 MB. File upload size is dependent on PHP settings of your server. Upload size is also dependent on your hosting plan or hosting service provider. For shared hosting most of time you cannot increase the file upload limit.
increase the upload_max_filesize in WordPress
When we try to upload big size image or media files in wordpress we got the following error
The uploaded file exceeds the upload_max_filesize directive in php.ini
For fixing the issue use following steps
Use the php.ini file from root folder.
1. Find this line in the php.ini file in your php installation upload_max_filesize = 2MB and replace it with a higher value (e.g. upload_max_filesize = 64MB)
2. Search for this line in your php.ini file post_max_size and increase it.
If you don’t have a php.ini file in your directory,
you can usually generate one from the control panels of your host. or create the file and put following values in that
memory_limit = 32M
upload_max_filesize = 100M
upload_max_filesize = 100M
post_max_size = 100M
increase the upload_max_filesize in WordPress
This file is copied into your wp-admin folder, the problem should be solved.
You cannot change a WordPress.com account username once it has been set. However, you can change what is seen on your posts and comments by changing the display name (nickname) in your profile, or you can create a new account and transfer your blog(s) to the new account.
How to wordpress change admin username
wordpress change admin username
Change Display Name (Nickname)
1. Access your User Profile
2. Change the value next to Display name publicly as under Basic Details
3. Click Update Profile.
↑ Table of Contents ↑
Change Username
1. Log into your current account (using your existing username)
2. Access your Personal Settings and change the e-mail address to another email address. This will free up your primary e-mail for use with the new username.
3. Once the new address has been verified via email confirmation, log out of the account.
4. Go to http://wordpress.com/signup/ and attempt to register a new account (the username you wish to change to) with your e-mail address.
5. If you’ve got a blog you should transfer its ownership to your new username.
Once you’ve done all of that you’ll be rocking WordPress.com with your new username.
Filters are hooks that WordPress launched to modify text of various types before saving to database. we explained how to work with wordpress plugin filters. Your plugin can specify that one or more of its PHP functions is executed to modify specific types of text at these times, using the Filter API.
how to work with wordpress plugin filters
All filters are located in wp-includes/plugin.php file. Following function you can use for using the filters in wordpress plugin.
has filter
Check if any filter has been registered for a hook.
$tag
(string) (required) The name of the filter to hook the $function_to_add to.
Default: None
$function_to_add
(callback) (required) The name of the function to be called when the filter is applied.
Default: None
$priority
(integer) (optional) Used to specify the order in which the functions associated with a particular action are executed. Lower numbers correspond with earlier execution, and functions with the same priority are executed in the order in which they were added to the action.
Default: 10
$accepted_args
(integer) (optional) The number of arguments the function(s) accept(s). In WordPress 1.5.1 and newer. hooked functions can take extra arguments that are set when the matching do_action() or apply_filters() call is run.
Merge the filter functions of a specific filter hook with generic filter functions.
merge_filters($tag);
$tag
(string) (required) The filter hook of which the functions should be merged.
Default: None
remove filter
This function removes a function attached to a specified filter hook. This method can be used to remove default functions attached to a specific filter hook and possibly replace them with a substitute. See also remove_action(), add_filter() and add_action().
Important: Because of long-time unfixed bugs resulting in flaws of the underlying implementation, it is unpredictable which filters this function will remove when called. Usage might/will result in loss of other then the intended filter(s). Plugin authors should prevent the usage of this function if possible.
Important: To remove a hook, the $function_to_remove and $priority arguments must match when the hook was added. This goes for both filters and actions. No warning will be given on removal failure.
$tag
(string) (required) The action hook to which the function to be removed is hooked.
Default: None
$function_to_remove
(string) (required) The name of the function which should be removed.
Default: None
$priority
(int) (optional) The priority of the function (as defined when the function was originally hooked).
Default: 10
$accepted_args
(int) (optional) The number of arguments the function accepts.
Default: 1
remove all filters
Remove all of the hooks from a filter.
remove_all_filters( $tag, $priority );
$tag
(string) (required) The filter to remove hooks from.
Default: None
$priority
(integer) (optional) The priority number to remove.
Default: false
——————————————-x———————————–x—————————–
All List of all WordPress filter hooks you will find on following URL
If you are internet user then you know about what is spam. You know or saw spam emails earlier so many times. prevent spam comments wordpress is big task and important also.
how to prevent spam comments wordpress
how to prevent spam comments wordpress
Comment Spam Hacks
The following are not recommended for average users. They involve editing WordPress core files. BACKUP your files first.
Delete wp-comments-post.php
The ultimate end-all solution to your comment spam troubles. This will effectively disable comments and is good for stopping comment spam floods. No one will be able to comment on your WordPress site.
Delete wp-trackback.php
The ultimate end-all solution to your trackback spam troubles. This will effectively disable trackbacks and is good for stopping trackback spam floods. This will mean that no one will be able to trackback your posts, so do this after consideration.
Denying access with .htaccess
While drastic, you can make modifications in your .htaccess file if you are using an Apache server. Check the Internet and Apache for more information.
Use nofollow
The nofollow attribute is another method used to strip spammers of their page ranks. According to Google, “when Google sees the attribute (rel=”nofollow”) on hyperlinks, those links won’t get any credit when we rank websites in our search results.” Under WordPress v1.5, the nofollow attribute is automatically added to all links in the comments section.
WordPress comes with a pre installed antispam solution – Akismet.
In order to use Akismet, you should have a WordPress API key. To receive a WordPress API key, you should register at the official WordPress website. The key will be included in your welcome mail.
If you already have a registration at WordPress.org, you can see your API key by visiting the WP dashboard.
To enable Akismet for your blog, follow the steps below:
Step 1. Go to your WordPress admin area > Plugins > Installed.
Step 2. Click Activate.
There are many ways to protect your WordPress.com blogs from unwanted comments:
* WordPress.com blogs are protected by the Akismet comment spam filter.
* You can control whether comments are automatically approved or if they need to be reviewed before they are published.
* You can add rules for comment moderation to control which comments get marked as pending.
* You can add rules to the comment blacklist section to automatically mark some comments as spam.
* If you turn on email notifications, then you can watch those messages for spam and delete them quickly if you find any that get through the comment spam filter.
Akismet learns by those who mark comment spam as comment spam and legitimate spam is despammed. If your comments are being caught by Akismet, remove them from the Akismet Panel. It might take two or three times, but it will learn and automatically not designate your comments as spam.
Commenters on your blog may have their comments caught by Akismet. If you do not regularly check your Akismet Panel, have an easy way of allowing readers to email you if their comment did not appear.
With updates to the database and major changes to the software, this process may have to be repeated.
If you continue to have problems with Akismet catching your comments or too many of your readers’ comments, contact Akismet for more assistance.
If you want to use smiley images in wordpress posts then you can use our tricks. Here in this article, we given sample and trick for using smiley in posts.
Follow our steps.
Find your smiley image files in the /wp-includes/images/smilies directory and back them up to another directory
Note the names of each smiley file. Your files must match these names and should be in the same ‘gif’ image format.
For predictable behavior, the image sizes should be similar.
Upload your new files to the /wp-includes/images/smilies directory with an FTP program.
How to use smiley images in wordpress posts
How to use smiley images in wordpress posts
If you want to changes the names of smiley and you need to edit wp-includes/functions.php file.
In that file you will find the “smilies_init” function.
In article, I explained you the 5 best tips about how to keep your wordpress blog or website impressive and 5 tips to increase wordPress traffic and look. It is very important to increase wordPress traffic by doing some tricks. There are many ways for increase wordPress traffic. But here in this article, I found some very unique increase wordPress traffic tips which are very useful for every web master.
I also did many tricks for my client to increase wordPress traffic. So think deeply about, how to increase wordPress traffic.
increase wordPress traffic
WordPress is becoming most popular CMS these days. It is very easy to use and great search engine support. Following are simple steps which I used to increase wordPress traffic.
Last year wordpress left behind all the cms. Many people are thinking about how to keep the there wordpress site impressive.
In this article I am going tell you the 5 best tips about how to keep your wordpress blog or website impressive.
1. Create a widget controlled footer that keeps visitors busy on site
increase wordPress traffic
Widget controlled footer is not new thing in wordpress website but still having footer with multiple information is good.
You should keep the following footer widget in website.
1. Recent posts
2. Popular Post
3. Recent Comments
For recent comments you can use following code in footer without plugin
<?php
$my_query = new WP_Query('showposts=15');
while ($my_query->have_posts()) : $my_query->the_post();$do_not_duplicate = $post->ID;
?>
For popular post We can use the wp-popular-post plugin. Using that plugin use can use following code in your website
You can increase wordPress traffic and website will look cool with best custom made images.
You can use following code for showing the images on homepage.
First you need to open the functions.php file from your wordpress theme folder and copy paste following code in that file.
In your index.php file you need to copy paste the following code for showing the image.
<?php get_first_image($post->ID); ?>
3. Add social media links to the bottom of post
Visitors always want to bookmark the website or your posts.
So keeping that very simple adding the social media links to your posts is very nice.
Finding the good social media icons as per your website is very easy with google.
There are some nice wordpress plugins available for adding the social media icons but recommend not to use any wordpress plugin.
Or you can use following code.
4. Install the Tweetmeme style Twitter button to your posts
Twitter is very popular these days. Twitter is micro blogging website.
So many people want to share there articles with twitter and Many visitors want to share article with there friends and follower by tweeting the article.
I recommend to use the tweetmeme wordpress plugin for putting the Twitter button to your posts.
You can download the tweetmeme wordpress plugin from following URL
http://tweetmeme.com
5. Always show the Author information with photo
Many visitors want to know about author. Keeping Author’s information on wordpress website is really good idea.
That will become your website more interesting the user friendly to visitors.
Some people like the specific writing style of author and They want know more information about Author.
In wordpress keeping the users photo and information I will suggest to use the user-photo wordpress plugin.
http://wordpress.org/extend/plugins/user-photo/
After adding following plugin you can use following code in your wordpress posts.
