Show popular search terms in sidebar Magento

Hi in some project i need to show the popular search terms in the sidebar . For that i have use the following code


  <reference name="right">
            <!-- Search Terms -->
            <block type="catalogsearch/term" after="cart.sidebar" name="catalogsearch.term" template="catalogsearch/term.phtml"/>
        </reference>


you can place this code in the  catalog.xml file of your theme

Move Magento from one server to another

Hi You can easily  move Magento website from one server to another server in 3 very easy steps.

1. Delete the content of the folder /var   // it contains cache and session files dont worry about this just delete this

2. Change the values of the file /app/etc/local.xml There you can find your connection string data (database user, host and name).

3. Once you got your database uploaded, you need to make some changes.
Run this query:

SELECT * FROM core_config_data WHERE path = 'web/unsecure/base_url' OR path = 'web/secure/base_url';

1	SELECT * FROM core_config_data WHERE path = 'web/unsecure/base_url' OR path = 'web/secure/base_url';

You gonna get something like this:

+-----------+---------+----------+-----------------------+--------------------------------------+ | config_id | scope | scope_id | path | value | +-----------+---------+----------+-----------------------+--------------------------------------+ | 2 | default | 0 | web/unsecure/base_url | http://localhost/magento/ | | 3 | default | 0 | web/secure/base_url | http://localhost/magento/ | +-----------+---------+----------+-----------------------+--------------------------------------+

1 2 3 4 5 6

+-----------+---------+----------+-----------------------+--------------------------------------+ | config_id | scope   | scope_id | path                  | value                                | +-----------+---------+----------+-----------------------+--------------------------------------+ |         2 | default |        0 | web/unsecure/base_url | http://localhost/magento/ | |         3 | default |        0 | web/secure/base_url   | http://localhost/magento/ | +-----------+---------+----------+-----------------------+--------------------------------------+

Now, change that values for your new url, run below query.

PgSQL

UPDATE core_config_data SET value = 'http://www.somedomain.com/' WHERE path LIKE 'web/%/base_url';

1	UPDATE core_config_data SET value = 'http://www.newdomain.com/' WHERE path LIKE 'web/%/base_url';

If you run the first query, now you gonna get something like this:

PgSQL

+-----------+---------+----------+-----------------------+------------------------------+ | config_id | scope | scope_id | path | value | +-----------+---------+----------+-----------------------+------------------------------+ | 2 | default | 0 | web/unsecure/base_url | http://www.somedomain.com/ | | 3 | default | 0 | web/secure/base_url | http://www.somedomain.com/ | +-----------+---------+----------+-----------------------+------------------------------+

1 2 3 4 5 6

+-----------+---------+----------+-----------------------+------------------------------+ | config_id | scope   | scope_id | path                  | value                        | +-----------+---------+----------+-----------------------+------------------------------+ |         2 | default |        0 | web/unsecure/base_url | http://www.somedomain.com/ | |         3 | default |        0 | web/secure/base_url   | http://www.somedomain.com/ | +-----------+---------+----------+-----------------------+------------------------------+