Archive for the ‘MySQL’ Category

 

Magento Tables required to Import Products.

Monday, December 21st, 2009

Data inserted in following tables while importing products.

1)adminnotification_inbox
2)catalogindex_eav
3)catalogindex_price
4)cataloginventory_stock_item
5)cataloginventory_stock_status
6)catalogsearch_fulltext
7)catalog_category_product
8)catalog_category_product_index
9)catalog_product_enabled_index
10)catalog_product_entity
11)catalog_product_entity_datetime
12)catalog_product_entity_decimal
13)catalog_product_entity_int
14)catalog_product_entity_media_gallery
15)catalog_product_entity_media_gallery_value
16)catalog_product_entity_text
17)catalog_product_entity_varchar
18)catalog_product_link
19)catalog_product_link_attribute_int
20)catalog_product_website
21)core_url_rewrite

Regard

Manoj Ninave

Software Engineer,
COG IT Solutions Pvt. Ltd.
www.cogitsolutions.com
n.manoj@cogitsolutions.com

Posted in MySQL, Web Development - PHP | 1 Comment »

SQL_CALC_FOUND_ROWS or two queries

Friday, October 2nd, 2009

While reading few posts I found that SQL_CALC_FOUND_ROWS is faster than two queries. But a very good discussion found at http://www.mysqlperformanceblog.com/2007/08/28/to-sql_calc_found_rows-or-not-to-sql_calc_found_rows/comment-page-1/#comment-661064. check this out

One member posted following on above blog which is worth to read

Please visit the mysql official documentation here http://dev.mysql.com/doc/refman/5.1/en/information-functions.html

Please have a look at FOUND_ROWS() function. They have mentioned that it is much faster to use the query with sql_calc_found_rows rather than using a query again. And I don’t find any reason not to trust them.

Posted in MySQL | No Comments »

Resetting a forgotten MySQL root password

Wednesday, March 18th, 2009
  1. Stop mysqld and restart it with the --skip-grant-tables option.
  2. to start use # /usr/bin/mysqld_safe --skip-grant-tables
  3. Connect to the mysqld server with this command:(you may have to use new shell / window for this) 
    shell> mysql
  4. Issue the following statements in the mysql client. Replace the password with the password that you want to use. 
    mysql> UPDATE mysql.user SET Password=PASSWORD('MyNewPass')
    ->                   WHERE User='root';
mysql> FLUSH PRIVILEGES;
  5. stop mysqld server using service mysqld stop - make sure to stop and restart so that new service will be password protected
  6. restart server with service mysqld start

Tags: , ,
Posted in MySQL | No Comments »

Site map | Blog
Copyright © 2008, COG IT Solutions Pvt. Ltd. All Rights Reserved
XHTML Validated