2011年11月23日星期三

Yahoo Webmaster tools is gone

I often use Yahoo Webmaster tools to check website external link , but i just open the tool today , the website had changed , it show me the following text .
------------------------------------------------------------------------------------------------
With the completion of algorithmic transition to Bing, Yahoo! Search has merged Site Explorer into Bing Webmaster Tools. Webmasters should now be using the Bing Webmaster Tools to ensure that their websites continue to get high quality organic search traffic from Bing and Yahoo!.
... ...
------------------------------------------------------------------------------------------------
like the p1:

p1



It is recommend us to use Bing Webmaster Tools , but Bing Webmaster Tools is not so convenient to Yahoo Webmaster tools , you can only analysis your website in Bing Webmaster Tools .

like the p2 and p3:

p2



p3

2011年11月18日星期五

The History of Vests and Down Vests

Vests include close-fitting, waist-length, sleeveless garments that button down the front designed to be worn under a jacket, a part or trimming simulating the front of such a garment such as vestee, waist-length garments worn for protective purposes such as bulletproof vests, sleeveless, waist- or hip-length garments made of various materials with a front opening usually secured by buttons, a zipper, or the like, worn over a shirt, blouse, dress, or other article for style or warmth such as sweater vests and down vests.

Vests first appeared in the west world was in the 17th century in Britain during the reign of Charles II for the purpose of undermining the influence from French fashion on one hand and diminishing the extravagance prevailing in the upper class. In China, vests originated from Han dynasty, which was almost 2,000 years from now and then they were advocated in the following dynasties such as Sui and Song and in Qing Dynasty, which was the last dynasty of China, vests even turned into a symbolization of privilege and social status.

One kind of vests is used as a piece of clothing suitable for cold weather, which is called down vest. Down, a layer of fluffy feathers underneath the regular feathers of geese and ducks, can trap air and keep these animals warm in the cold weather. It was said that back to the 15th century Native Americans had already been acquainted with the insulating quality of down and took advantage of this quality, but it was not until the late 1960s that people started to realize the feasibility of down vests. Down vest is a short warm jacket without sleeves which is filled with the soft feathers of a duck or a goose. In history, people started to establish the conception of down vest mainly because of a skier Suzy Chaffee, an American Olympic bronze medalist in 1968 who appeared in front of the public in brightly colored vests.

As time passes by, down vests have succeeded being part of the fashion rather than be cast out. Now many famous brands of down jackets have included down vests on the list of their product such as Moncler down vests, Kathmandu, etc.

2011年11月15日星期二

how to import SQL file to create tables of mysql database

you must create database at first , and use the database , use source command import SQL file at last . This SQL file is used to create tables of magento database .



mysql>
mysql> create database test;
Query OK, 1 row affected (0.02 sec)

mysql>
mysql> use test;
Database changed
mysql>
mysql> source E:\magento\magento_sample_data_for_1.2.0.sql;


Query OK, 0 rows affected (0.00 sec)

Query OK, 458 rows affected (0.05 sec)
Records: 458  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.14 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.08 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.13 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql>
mysql>
mysql> show tables;
+--------------------------------------------+
| Tables_in_test                            |
+--------------------------------------------+
| admin_assert                               |
| admin_role                                 |
| admin_rule                                 |
| admin_user                                 |
| adminnotification_inbox                    |
| api_assert                                 |
| api_role                                   |
| api_rule                                   |
| api_user                                   |
| catalog_category_entity                    |
| catalog_category_entity_datetime           |
| catalog_category_entity_decimal            |
| catalog_category_entity_int                |
| catalog_category_entity_text               |
| catalog_category_entity_varchar            |
| catalog_category_product                   |
| catalog_category_product_index             |
| catalog_compare_item                       |
| catalog_product_bundle_option              |
| catalog_product_bundle_option_value        |
| catalog_product_bundle_selection           |
| catalog_product_enabled_index              |
| catalog_product_entity                     |
| catalog_product_entity_datetime            |
| catalog_product_entity_decimal             |
| catalog_product_entity_gallery             |
| catalog_product_entity_int                 |
| catalog_product_entity_media_gallery       |
| catalog_product_entity_media_gallery_value |
| catalog_product_entity_text                |
| catalog_product_entity_tier_price          |
| catalog_product_entity_varchar             |
| catalog_product_link                       |
| catalog_product_link_attribute             |
| catalog_product_link_attribute_decimal     |
| catalog_product_link_attribute_int         |
| catalog_product_link_attribute_varchar     |
| catalog_product_link_type                  |
| catalog_product_option                     |
| catalog_product_option_price               |
| catalog_product_option_title               |
| catalog_product_option_type_price          |
| catalog_product_option_type_title          |
| catalog_product_option_type_value          |
| catalog_product_super_attribute            |
| catalog_product_super_attribute_label      |
| catalog_product_super_attribute_pricing    |
| catalog_product_super_link                 |
| catalog_product_website                    |
| catalogindex_aggregation                   |
| catalogindex_aggregation_tag               |
| catalogindex_aggregation_to_tag            |
| catalogindex_eav                           |
| catalogindex_minimal_price                 |
| catalogindex_price                         |
| cataloginventory_stock                     |
| cataloginventory_stock_item                |
| catalogrule                                |
| catalogrule_affected_product               |
| catalogrule_product                        |
| catalogrule_product_price                  |
| catalogsearch_fulltext                     |
| catalogsearch_query                        |
| catalogsearch_result                       |
| checkout_agreement                         |
| checkout_agreement_store                   |
| chronopay_api_debug                        |
| cms_block                                  |
| cms_block_store                            |
| cms_page                                   |
| cms_page_store                             |
| core_config_data                           |
| core_email_template                        |
| core_flag                                  |
| core_layout_link                           |
| core_layout_update                         |
| core_resource                              |
| core_session                               |
| core_store                                 |
| core_store_group                           |
| core_translate                             |
| core_url_rewrite                           |
| core_website                               |
| cron_schedule                              |
| customer_address_entity                    |
| customer_address_entity_datetime           |
| customer_address_entity_decimal            |
| customer_address_entity_int                |
| customer_address_entity_text               |
| customer_address_entity_varchar            |
| customer_entity                            |
| customer_entity_datetime                   |
| customer_entity_decimal                    |
| customer_entity_int                        |
| customer_entity_text                       |
| customer_entity_varchar                    |
| customer_group                             |
| cybermut_api_debug                         |
| cybersource_api_debug                      |
| dataflow_batch                             |
| dataflow_batch_export                      |
| dataflow_batch_import                      |
| dataflow_import_data                       |
| dataflow_profile                           |
| dataflow_profile_history                   |
| dataflow_session                           |
| design_change                              |
| directory_country                          |
| directory_country_format                   |
| directory_country_region                   |
| directory_country_region_name              |
| directory_currency_rate                    |
| downloadable_link                          |
| downloadable_link_price                    |
| downloadable_link_purchased                |
| downloadable_link_purchased_item           |
| downloadable_link_title                    |
| downloadable_sample                        |
| downloadable_sample_title                  |
| eav_attribute                              |
| eav_attribute_group                        |
| eav_attribute_option                       |
| eav_attribute_option_value                 |
| eav_attribute_set                          |
| eav_entity                                 |
| eav_entity_attribute                       |
| eav_entity_datetime                        |
| eav_entity_decimal                         |
| eav_entity_int                             |
| eav_entity_store                           |
| eav_entity_text                            |
| eav_entity_type                            |
| eav_entity_varchar                         |
| eway_api_debug                             |
| flo2cash_api_debug                         |
| gift_message                               |
| googlebase_attributes                      |
| googlebase_items                           |
| googlebase_types                           |
| googlecheckout_api_debug                   |
| googleoptimizer_code                       |
| ideal_api_debug                            |
| log_customer                               |
| log_quote                                  |
| log_summary                                |
| log_summary_type                           |
| log_url                                    |
| log_url_info                               |
| log_visitor                                |
| log_visitor_info                           |
| newsletter_problem                         |
| newsletter_queue                           |
| newsletter_queue_link                      |
| newsletter_queue_store_link                |
| newsletter_subscriber                      |
| newsletter_template                        |
| oscommerce_import                          |
| oscommerce_import_type                     |
| oscommerce_orders                          |
| oscommerce_orders_products                 |
| oscommerce_orders_status_history           |
| oscommerce_orders_total                    |
| oscommerce_ref                             |
| paybox_api_debug                           |
| paybox_question_number                     |
| paygate_authorizenet_debug                 |
| paypal_api_debug                           |
| paypaluk_api_debug                         |
| poll                                       |
| poll_answer                                |
| poll_store                                 |
| poll_vote                                  |
| product_alert_price                        |
| product_alert_stock                        |
| protx_api_debug                            |
| rating                                     |
| rating_entity                              |
| rating_option                              |
| rating_option_vote                         |
| rating_option_vote_aggregated              |
| rating_store                               |
| rating_title                               |
| report_event                               |
| report_event_types                         |
| review                                     |
| review_detail                              |
| review_entity                              |
| review_entity_summary                      |
| review_status                              |
| review_store                               |
| sales_flat_order_item                      |
| sales_flat_quote                           |
| sales_flat_quote_address                   |
| sales_flat_quote_address_item              |
| sales_flat_quote_item                      |
| sales_flat_quote_item_option               |
| sales_flat_quote_payment                   |
| sales_flat_quote_shipping_rate             |
| sales_order                                |
| sales_order_datetime                       |
| sales_order_decimal                        |
| sales_order_entity                         |
| sales_order_entity_datetime                |
| sales_order_entity_decimal                 |
| sales_order_entity_int                     |
| sales_order_entity_text                    |
| sales_order_entity_varchar                 |
| sales_order_int                            |
| sales_order_tax                            |
| sales_order_text                           |
| sales_order_varchar                        |
| salesrule                                  |
| salesrule_customer                         |
| sendfriend_log                             |
| shipping_tablerate                         |
| sitemap                                    |
| strikeiron_tax_rate                        |
| tag                                        |
| tag_relation                               |
| tag_summary                                |
| tax_calculation                            |
| tax_calculation_rate                       |
| tax_calculation_rate_title                 |
| tax_calculation_rule                       |
| tax_class                                  |
| weee_discount                              |
| weee_tax                                   |
| wishlist                                   |
| wishlist_item                              |
+--------------------------------------------+
229 rows in set (0.00 sec)

mysql>

2011年11月10日星期四

how to delete mysql database through shell command

If you want to delete a database from mysql through shell command , to follow by the following steps.

mysql>
mysql> show databases
    -> ;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| phpmyadmin         |
| test               |
| zhiwu              |
+--------------------+
5 rows in set (0.06 sec)

mysql> drop database test;
Query OK, 1 row affected (0.03 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| phpmyadmin         |
| zhiwu              |
+--------------------+
4 rows in set (0.00 sec)

mysql>

2011年11月7日星期一

o-idea开博印象

   谷歌这个杯具的blogger ,真是太冤屈了,在中国大陆就没能运行很长时间,就被挡在了国门外面,当时我正好有一个这个博客,正当赞美ing它的排名、收录速度以及与google adsense广告的无缝对接时,突然有一天就打不开了,而且再也打不开,我还以为是服务器检修呢,那个天真啊,后来在月光博客看到老月的愤怒之后才明白,原来是这么个情况。于是通过代理再次踏上了这片久违的土地。
   那时候的在线代理可不好玩,很不稳定,经常没有没代理成功,所以最好放弃了。而如今VPN代理风行的时代,我再次重操旧业,我要看看blogspot还是不是当年的廉颇。能否助我一臂之力,为我所用。