I recently upgraded a clients magento from V1.4 to V1.7.2.0 and i followed this steps:-
Following are the main points to upgrade the website from Magento v1.4.0.0 to v1.7.2.0:-
-
Collect the live database backup in a zipped format, without the following tables:-
- “log_customer”
- “log_quote”
- “log_summary”
- “log_url”
- “log_url_info”
- “log_visitor”
- “log_visitor_info”
“log_visitor_online”
-
Unzip the zipped backup database, in your own file system, in any folder.
-
Start the local WAMP / XAMPP, and create a test database “test_something” or any other name, using the web app “phpMyAdmin”.
-
Open the command prompt window and then type “mysql” to start the MySQL Command Prompt.
-
Import the unzipped database into the test database, using the command prompt, so that it will be a lot faster without any errors.
-
After the successful import, run the SQL mentioned in the file “DB Changes.txt” from phpMyAdmin.
-
Extract a fresh Magento v1.7.2.0 in local WAMP / XAMPP, and start installing this Magento using the test database with the old livesite data.
-
After successful Magento installation, export & dump the new upgraded database in a zipped format using command prompt, so that it will be a lot faster without any errors.
-
Extract a fresh zipped Magento or upload a fresh unzipped Magento of v1.7.2.0 into the live server’s file system, without installing anything.
-
Upload this zipped database into the live server’s file system, and then open the PuTTY for the live server.
-
Upload a copy of the “app/etc/local.xml” Magento file of local WAMP / XAMPP, to replace the live Magento’s “app/etc/local.xml” file. Remember to change all the DB credentials of this file, as per the new live server, before uploading it to the live server.
-
Remember not to browse the Magento from the web browser for the live web server, till the point #14 gets completed.
-
Using PuTTY commands, extract the zipped database, and then import it into the new database of the live website.
-
After the successful import, search “core_config_data” database table with the “path” column value as “%base_url%”. Replace all the values of the “value” column with the full URL of the live Site “http://www.livesite.com/”, without any mention of “index.php”.
-
Upload the theme and its related files to the new server’s file system.
-
Upload the extension/module check there compatibility.
-
Make sure to configure the required modules in the System Configuration are from the Admin panel.
The DB Changes.txt are as follows:-
CREATE TABLE IF NOT EXISTSlog_customer
(
log_id
int(10) unsigned NOT NULL AUTO_INCREMENT,
visitor_id
bigint(20) unsigned DEFAULT NULL,
customer_id
int(11) NOT NULL DEFAULT ‘0’,
login_at
datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
logout_at
datetime DEFAULT NULL,
store_id
smallint(5) unsigned NOT NULL,
PRIMARY KEY (log_id
),
KEYIDX_VISITOR
(visitor_id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=’Customers log information’;
—
— Table structure for table
log_quote
CREATE TABLE IF NOT EXISTS
log_quote
(
quote_id
int(10) unsigned NOT NULL DEFAULT ‘0’,
visitor_id
bigint(20) unsigned DEFAULT NULL,
created_at
datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
deleted_at
datetime DEFAULT NULL,
PRIMARY KEY (quote_id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=’Quote log data’;
—
— Table structure for table
log_summary
CREATE TABLE IF NOT EXISTS
log_summary
(
summary_id
bigint(20) unsigned NOT NULL AUTO_INCREMENT,
store_id
smallint(5) unsigned NOT NULL,
type_id
smallint(5) unsigned DEFAULT NULL,
visitor_count
int(11) NOT NULL DEFAULT ‘0’,
customer_count
int(11) NOT NULL DEFAULT ‘0’,
add_date
datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
PRIMARY KEY (summary_id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=’Summary log information’;
—
— Table structure for table
log_url
CREATE TABLE IF NOT EXISTS
log_url
(
url_id
bigint(20) unsigned NOT NULL DEFAULT ‘0’,
visitor_id
bigint(20) unsigned DEFAULT NULL,
visit_time
datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
PRIMARY KEY (url_id
),
KEYIDX_VISITOR
(visitor_id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=’URL visiting history’;
—
— Table structure for table
log_url_info
CREATE TABLE IF NOT EXISTS
log_url_info
(
url_id
bigint(20) unsigned NOT NULL AUTO_INCREMENT,
url
varchar(255) NOT NULL DEFAULT ”,
referer
varchar(255) DEFAULT NULL,
PRIMARY KEY (url_id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=’Detale information about url visit’;
—
— Table structure for table
log_visitor
CREATE TABLE IF NOT EXISTS
log_visitor
(
visitor_id
bigint(20) unsigned NOT NULL AUTO_INCREMENT,
session_id
char(64) NOT NULL DEFAULT ”,
first_visit_at
datetime DEFAULT NULL,
last_visit_at
datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
last_url_id
bigint(20) unsigned NOT NULL DEFAULT ‘0’,
store_id
smallint(5) unsigned NOT NULL,
PRIMARY KEY (visitor_id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=’System visitors log’;
—
— Table structure for table
log_visitor_info
CREATE TABLE IF NOT EXISTS
log_visitor_info
(
visitor_id
bigint(20) unsigned NOT NULL DEFAULT ‘0’,
http_referer
varchar(255) DEFAULT NULL,
http_user_agent
varchar(255) DEFAULT NULL,
http_accept_charset
varchar(255) DEFAULT NULL,
http_accept_language
varchar(255) DEFAULT NULL,
server_addr
bigint(20) DEFAULT NULL,
remote_addr
bigint(20) DEFAULT NULL,
PRIMARY KEY (visitor_id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=’Additional information by visitor’;
—
— Table structure for table
log_visitor_online
CREATE TABLE IF NOT EXISTS
log_visitor_online
(
visitor_id
bigint(20) unsigned NOT NULL AUTO_INCREMENT,
visitor_type
char(1) NOT NULL,
remote_addr
bigint(20) NOT NULL,
first_visit_at
datetime DEFAULT NULL,
last_visit_at
datetime DEFAULT NULL,
customer_id
int(10) unsigned DEFAULT NULL,
last_url
varchar(255) DEFAULT NULL,
PRIMARY KEY (visitor_id
),
KEYIDX_VISITOR_TYPE
(visitor_type
),
KEYIDX_VISIT_TIME
(first_visit_at
,last_visit_at
),
KEYIDX_CUSTOMER
(customer_id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;TRUNCATE
report_event
;TRUNCATE
report_viewed_product_index
;TRUNCATE
report_compared_product_index
;TRUNCATE
dataflow_batch_export
;ALTER TABLE
orders
CHANGEurl
parent_id
VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL;