Backup MySql Database using phpMyAdmin

This procedure explains how to backup MySql Database through phpMyAdmin.

1. Login in phpMyAdmin.
2. Select the Database you want to backup (click on it). If your version of phpMyAdmin is different from ours, there is a possibility that you have to click on Databases, in order to select the database you want ot backup. *
3. The tables of the databases will appear with some other stuff. Just go straight for the export tab.
4. Under Export, select all tables (if they are not already selected), or just select the tables you want to backup.
5. Choose the format of the file you want to export (right under the tables). SQL is the default and the recommended option for this.
6. On the Options – Structure, select Add DROP TABLE / VIEW / PROCEDURE / FUNCTION, Add AUTO_INCREMENT value and Enclose table and field names with backquotes (If you are familiar with SQL, select the options you want).
7. On the Options – Data, select Complete inserts and Extended inserts.
8. Look for the Save as file checkbox and click on it. You now have the compression options, None, zipped or gzipped. Choose whatever you prefer.
9. You now have an SQL file (compressed ot uncompressed), which is actually a script to create the structure of the database you have just backed up, together with all your data. (Very nice and easy)

* If you are not sure about your database name (in case you have multiple databases), check from your application (a config file), for the database name it is using.

Backup MySql Database using phpMyAdmin

This procedure explains how to backup MySql Database through phpMyAdmin.

1. Login in phpMyAdmin.
2. Select the Database you want to backup (click on it). If your version of phpMyAdmin is different from ours, there is a possibility that you have to click on Databases, in order to select the database you want ot backup. *
3. The tables of the databases will appear with some other stuff. Just go straight for the export tab.
4. Under Export, select all tables (if they are not already selected), or just select the tables you want to backup.
5. Choose the format of the file you want to export (right under the tables). SQL is the default and the recommended option for this.
6. On the Options – Structure, select Add DROP TABLE / VIEW / PROCEDURE / FUNCTION, Add AUTO_INCREMENT value and Enclose table and field names with backquotes (If you are familiar with SQL, select the options you want).
7. On the Options – Data, select Complete inserts and Extended inserts.
8. Look for the Save as file checkbox and click on it. You now have the compression options, None, zipped or gzipped. Choose whatever you prefer.
9. You now have an SQL file (compressed ot uncompressed), which is actually a script to create the structure of the database you have just backed up, together with all your data. (Very nice and easy)

* If you are not sure about your database name (in case you have multiple databases), check from your application (a config file), for the database name it is using.

Alexa Ranking

Alexa, originally an abbreviation for Address Lookup EXperts Authority, is supplying the Internet Archive with web crawls as it was also doing in the past. Alexa (An amazon.com company from 1999) ranks sites, based on tracking information received from users who are using Alexa toolbar (sparky). Last year (April 16th, 2008) Alexa confirmed that, with their new system, they have more data sources for ranking, instead only the data from their toolbar’s users. Now the real questions is: “Is Alexa ranking unbiased considering a random sample internet users of sufficient size? Or is it a biased ranking from a random sample of some groups of internet users such as Webmasters, Publishers and Advertisers?”

Conclusion: Even if Alexa, is only being used by Webmasters, Publishers and Advertisers, then it is a ranking system provided as a measure of comparison between multiple sites.

Their toolbar is useful for showing the ranking for each site (working for Firefox, IE).
Use their widget in order to display Alexa ranking for your site (it is generally believed, that it improves your ranking if you have it)

Google XML Sitemaps for WordPress

In WordPress, an easy and efficient way to create your web site’s XML Sitemap, is by using a plugin called Google XML Sitemaps.
This WordPress plugin has been used many times by the AmberPanther team for various WordPress installations. The name of the plugin is “Google XML Sitemaps”, but it actually creates a sitemap.xml file, which is accessible by Google, Bing, Yahoo, MSN and Ask search engines (more about sitemaps). Google XML Sitemaps plugin, automatically updates your sitemap everytime you update or modify a post or a page and notifies the search engines that support the sitemap protocol about the updates on your web site. This is a must for every wordpress installation.

Google XML Sitemaps Plugin’s WebSite

Sitemaps And SEO

A sitemap is a list of all your web site’s pages, that you want to be accessible by the crawlers and the users browsing your web site. Search Engine bots use your sitemap to crawl existing, new or modified pages on your web site. A sitemap is a must for your web site, if you want to improve SEO (search engine optimization) for your site, by making sure that all your pages are acessible and can be found.

XML Sitemaps
Some of the major Search Engines, Google, Bing, Yahoo and Ask, support the Sitemaps protocol. The sitemap is an xml file, that lists all the URLs of your web site, with information like:
– when it was last updated
– how often it changes
– importance of each URL

You can read more about the sitemaps protocol at http://www.sitemaps.org.