Magento Themes and Magento Extensions

How to export magento database and then import in another server

Share
Posted on April 9th, 2013 | Posted by admin

How to export magento database and then import in another server

I had alot of problem when exporting database from one server to another. The large amount of data which is not needed for future purpose is log tables. These table contains much more data than we need. so first we have to TRUNCATE these tables:

TRUNCATE dataflow_batch_export;
TRUNCATE dataflow_batch_import;
TRUNCATE log_customer;
TRUNCATE log_quote;
TRUNCATE log_summary;
TRUNCATE log_summary_type;
TRUNCATE log_url;
TRUNCATE log_url_info;
TRUNCATE log_visitor;
TRUNCATE log_visitor_info;
TRUNCATE log_visitor_online;
TRUNCATE report_viewed_product_index;
TRUNCATE report_compared_product_index;
TRUNCATE report_event;
TRUNCATE index_event;

After that export database MY_DATABASE in file db_magento.sql with following command

Magento Database Cleaning

Share
Posted on January 3rd, 2013 | Posted by admin

Magento is an excellent platform, but it unfortunately falls short when it comes to having an efficient database. When selling a myriad of products, it’s a smart idea to have a sizable database. Managing the database by performing regular log cleanings can drastically improve the performance of your website along with its latency. The following is a walk through of how to tidy up a Magento database that has become over encumbered.

For starters, it is imperative that you make a back up of all your files prior to doing anything in case something goes wrong. You can either perform an export of your database using phpMyAdmin, or you can submit a technical support request so that we can do it for you.

Magento manages several logging tables. These tables make logs of things like which products have been compared, customer accesses and other ancillary logs. Magento has a self cleaning program to clean this out regularly, but this feature is inactive by default, and most consumers wont turn it on. Here are three ways to clean out these tables. You can either access the “Log Cleaning” feature in the Magento Admin, or you could just manually do so via phpMyAdmin.

Magento Database Setup Notes

Share
Posted on November 21st, 2012 | Posted by admin

These are some setup notes for setting up a test/development instance of  Magento, using an existing database against a fresh installation of the source code on a staging server.

Use HeidiSQL or MySQL Workbench (both free) to edit the data in the Magento MySQL database tables. These notes assume that you have already installed the Magento source code in ‘/magentoroot’ and configured folder permissions.

* Modify database connection settings in application configuration.

File Name: /magentoroot/app/etc/local.xml

  <connection>
    <host><![CDATA[localhost]]></host>
    <username><![CDATA[johndoe]]></username>
    <password><![CDATA[12345]]></password>
    <dbname><![CDATA[storedb]]></dbname>
    <active>1</active>
  </connection>