Step 1 - export database of the source site |
Source site: create database dump file:
$ mysqldump -u<username> -p --default-character-set=latin1 --skip-opt -Q <ver3db> > ver3.dump
Note: Use parameter "--skip-opt" only in MySQL 4.1 and later, otherwise remove it.
|
|
Step 2 - import database into the target site |
2A If created dump file size is > 50 MB and you have linux shell access to server
-
Run shell command that creates a new dump file "new_ver3.dump":
$ bash ./addprefix2dump.sh ver3.dump
-
Import dump file "new_ver3.dump" into the target site database:
$ mysql -u<user> -p --default-character-set=latin1 <ver4db> < new_ver3.dump
|
2B If created dump file size is > 50 MB and you don't have shell access
-
Run windows executable addprefix2dump.exe and convert your database dump.
|
2C If created dump file size is <= 50 MB (exact limit depends on your server settings)
Proceed with Step 3
|
|
Step 3 - copy files |
- create a new folder "ver3" under target website root folder
$ mkdir ver3
- copy database dump file and the following folders from source site to the target site:
| Source site | Target site |
| ver3.dump | => ver3/ver3.dump (skip it if you passed step 2A) |
| failid/ | => ver3/failid/ |
| classes/smarty/templates/ | => ver3/templates/ |
| px_custom/* | => px_custom/* |
Sample: $ cp -a /path/to/sourcesite/failid/ /path/to/targetsite/ver3/
- copy conversion script "convert.php" to the target website root folder
- copy database dump "default_db_4.2.0.sql" to the target website "admin/updates" folder
|
|
Step 4 - run conversion |
- Open "convert.php" in the browser, eg http://www.yoursite.com/convert.php. Follow instructions on the screen.
NB! Check also system information displayed in the Step 1, you may need to increase PHP settings.
- When viewing conversion results in Step 3, search for string "error" to be sure in conversion accuracy.
|
|
Step 5 (optional) - site encoding conversion |
|
In case your website encoding is not UTF-8, we suggest to convert site content to the UTF-8 encoding.
|
|
Step 6 - delete conversion files |
- Delete file "convert.php"
- Delete file "admin/update/default_db_4.2.0.sql"
- Delete folder "ver3/"
|
|
Step 7 - enter a license |
Log in to the admin/ environment and enter a correct site license key.
|