
Upgrade script: Marketplace 1.4.0 and 1.4.1 to Marketplace 1.4.2

This is the easiest and recommended way with a downtime of your Marketplace of only a few minutes.

Remove the old version and install the new one following the next steps.

Please make a backup of your database before you start!!!


Here we go:

1. save your current marketplace data

    - write down your configuration (duration, ad-fields, rss,...). You have to re-enter them again later.


    - copy your current language file to a save place


    - copy category images (if you have own ones) and ad images to a save place


    - backup marketplace tables ( types, categories, ads, users)
	  Note: Replace USER, PASSWORD and DATABASE with the settings of your database
	  Note: If you use table-prefixes, you must add them before the table-names

        mysqldump -uUSER -pPASSWORD DATABASE marketplace_types --add-drop-table > marketplace_types.backup
        mysqldump -uUSER -pPASSWORD DATABASE marketplace_categories --add-drop-table > marketplace_categories.backup
        mysqldump -uUSER -pPASSWORD DATABASE marketplace_ads --add-drop-table > marketplace_ads.backup
        mysqldump -uUSER -pPASSWORD DATABASE marketplace_users --add-drop-table > marketplace_users.backup


2. remove the Marketplace Extension from your Joomla-Website using Joomla backend installer


3. Install new Marketplace 1.4.2 the normal way with the Joomla backend installer


4. restore your saved data

    - restore marketplace tables ( types, categories, ads, users):
	  Note: Replace USER, PASSWORD and DATABASE with the settings of your database

        mysql -uUSER -pPASSWORD DATABASE < marketplace_types.backup
        mysql -uUSER -pPASSWORD DATABASE < marketplace_categories.backup
        mysql -uUSER -pPASSWORD DATABASE < marketplace_ads.backup
        mysql -uUSER -pPASSWORD DATABASE < marketplace_users.backup


    - copy category images (if you have own ones) and ad images from save place back to the marketplace directory


    - add your saved language file settings to the new language file or
      restore your saved language file and add the new lines for the actual version at the end.


	- Re-Enter your configuration (duration, ad-fields, rss,...)



That's it :-)

Achim Fischer



