The question is i have the table suppose, location_master and the table have colom like ‘postcode’, ‘latitude’, ‘longitude’, ‘county’, ‘region’, ‘town’  and thats all , and i have get or generate the all data about the table in suppose .sql or .csv file format, the fact is when i have the data size above 1 GB then how should i import the large data from that csv or sql file to our mysql database table.

generally all use the import facility which the phpmyadmin provide to us. but thats not full proof that to import all the data from file there can be it stop from the half way and also it takes so much time.

the best way to import the data is to fire the import query like below,

We have to use ‘LOAD DATA INFILE’ query to import the file data,

1) Suppose I have to create one dummy table in my database, like the following,

CREATE TABLE location_master LIKE your_table;

the above query is used to create one dummy table name ‘location_master’ in my db.

2) open your phpmyadmin in your wamp

3) select your database in which you have create table,

4) select your new created dummy table

5) then click on query tab from menubar,

6) write the following query in the textarea of ‘SQL query on database’,

“load data local infile ‘/temp/file.csv’ into table location_master
fields terminated by ‘,’
enclosed by ‘”‘
lines terminated by ‘\n’
(‘postcode’, ‘latitude’, ‘longitude’, ‘county’, ‘region’, ‘town’)”;

note: please remeber the csv file should contain the same colom which your table have.

7) The above technic is simple and also take very less time to import data.

Replace the it with the original index.php

as the change affected this.

It changed the original line  Mage::run(’default’);

so replace 

Mage::run(’’); 

with 

Mage::run(’default’);

It is done by adding some code to a file called .htaccess on your web host/server.

The code below should be added to the top of your .htaccess file.

## EXPIRES CACHING ##
<IfModule mod_expires.c>
ExpiresActive On
ExpiresByType image/jpg "access 1 year"
ExpiresByType image/jpeg "access 1 year"
ExpiresByType image/gif "access 1 year"
ExpiresByType image/png "access 1 year"
ExpiresByType text/css "access 1 month"
ExpiresByType text/html "access 1 month"
ExpiresByType application/pdf "access 1 month"
ExpiresByType text/x-javascript "access 1 month"
ExpiresByType application/x-shockwave-flash "access 1 month"
ExpiresByType image/x-icon "access 1 year"
ExpiresDefault "access 1 month"
</IfModule>
## EXPIRES CACHING ##

Save the .htaccess file and then refresh your webpage.

Cron in Magento is fairly easy to configure. A few lines in config.xml, a method and it’s done. But what happens if you want to spice it up a bit and create a schedule-configurable cron? Fortunately for us, Magento has that already included in the system and it’s pretty easy to implement.

Cron itself is more or less straightforward. As seen in the code below, it is defined in a config.xml file with two main parts: schedule and a method to be ran. A sample below shows a cron job named “my_cron” that runs “doSomething” method inside the observer file every five minutes. If you’re not familiar with the cron schedule format, there’s a bunch of the articles and cron generators on the internet.