What is Black Hat SEO and does it affect my website ranking?
Black Hat SEO is technique in order to increase your website ranking in search results. Such techniques may include spamming other websites with links, adding large amount of keywords in the keyword tags, using invisible text on web pages, using a fake page that is not seen by the visitor (hidden iframe) but for search engine spider bots only and many more. In short, these are techniques that are used to get higher search rankings in an unethical manner.
Previously, such techniques might work to boost your ranking but nowadays your website will be penalized by search engines if you try to use such techniqus. If you try Black Hat SEO techniques, there is a chance that your website gets banned by search engines.
How to optimize MySQL database using phpMyAdmin
Whenever you delete large number of records from your MySQL database, it is recommend to optimize your MySQL database for the best performance. In this article, we will show you how to optimize MySQL database using phpMyAdmin.
- Open your phpMyAdmin tool.
- Select the database you want to optimize on the upper left.
- Select the tables you want to optimize (usually checkmark all tables)
- Using the selection box at the bottom, select “Optimize Table”
This will execute the OPTIMIZE TABLE SQL query on the selected tables.
How to repair a corrupted MySQL database from cPanel and phpMyAdmin
Sometimes, your MySQL database may be corrupted and it requires to repair your MySQL database. Here we will provide you steps to repair corrupted MySQL database from cPanel and phpMyAdmin.
[1] Repair a MySQL database from cPanel
Log in to your cPanel and go to MySQL Databases. In the section Modify Databases, select a database from the drop-down box next to Repair DB: and then click the Repair DB button.
If the database engine used by your database supports repair (for example, MyISAM supports it), you will see a list of the repaired tables within the database.
If your database engine does not support repair (e.g. InnoDB database engine), you will get the following error message:
note : The storage engine for the table doesn’t support repair
[2] Repair a MySQL database from phpMyAdmin
- Open your phpMyAdmin and select the database whose tables you wish to repair.
- Select the tables you wish to repair, or simply click [Check All] to select all tables.
- Click the box [With selected:] and choose Repair table. This will execute the REPAIR TABLE SQL query on the selected tables and they will be repaired.
How to change the database storage engine of a MySQL database table
You may require changing MySQL database storage engine for your table.
Let’s assume that you have a database table called your_table using MyISAM engine and you wish to change the engine from MyISAM to InnoDB.
You can change the storage engine using the following MySQL query:
ALTER TABLE your_table ENGINE = InnoDB;
If you have phpMyAdmin, you can execute the above query from there.
Open your phpMyAdmin tool and select the database which contains your_table. Then click the SQL tab, paste the above query there and click the Go button.
WordPress 3.2 now available
WordPress 3.2 is fifteenth major release of WordPress and comes just four months after 3.1 (which coincidentally just passed the 15 million download mark this morning), reflecting the growing speed of development in the WordPress community and our dedication to getting improvements in your hands as soon as possible. We’re dedicating this release to noted composer and pianist George Gershwin.
The focus for this release was making WordPress faster and lighter. The first thing you’ll notice when you log in to 3.2 is a refreshed dashboard design that tightens the typography, design, and code behind the admin. If you’re starting a new blog, you’ll also appreciate the fully HTML5 new Twenty Eleven theme, fulfilling our plan to replace the default theme every year. Start writing your first post in our redesigned post editor and venture to the full-screen button in the editing toolbar to enter the new distraction-free writing or zen mode, my personal favorite feature of the release. All of the widgets, menus, buttons, and interface elements fade away to allow you to compose and edit your thoughts in a completely clean environment conducive to writing, but when your mouse strays to the top of the screen your most-used shortcuts are right there where you need them.
Are You Ready for WordPress 3.2?
The minimum requirements:
PHP and MySQL
As of 3.2, you’ll need to be running PHP 5.2.4 and MySQL 5.0. As they mentioned almost a year ago when they announced that this change was coming, the percentage of people running older versions of PHP and MySQL is relatively low. With more than 45 million people using WordPress, though, even a small percentage can mean a lot of people! Don’t caught with your pants dashboard down — make sure you’re running compatible versions of PHP and MySQL before you update tomorrow when WordPress 3.2 is released.
How to access Web Disk (WebDav) on cPanel server
The Web Disk feature is cPanel’s implementation of the WebDav protocol. This feature allows you to manage files associated with your website. By creating an account and accessing your Web Disk, you can navigate, upload, and download files to and from your web server as though they were part of your personal computer.
How to access Web Disk (WebDav):
1. Login to cPanel and click on Web Disk icon.
2. Scroll down the page and click on “Access Web Disk” button.
3. Choose your locate system’s operating system.
4. Scroll down and hit the Go button.
5. Click the Save button.
6. On your computer, hit Save, Open, and Run.
Web Disk allows to drag and drop the files/folders easily from your local system to your website.
-
Recommended Host
-
