Data Migration from J1.5 to J25

JA JobBoard for Joomla 2.5 and Joomla 3 documentation

Warning: Before upgrade please perform full backup of your site.

For older versions of the component, you will have to find the uploads folder located in site_root/components/com_jajobboard folder to back-up and re-upload after you install the new version of the component.

To eliminate difficulties with component upgrade and back-up of the front-end user uploads, the JA Development Team changed the component to make it capable to manage user uploaded files in the Joomla! root folder, so outside the component installation folders.

Step 1: Update code

Download and install component (+ sub extensions) Job Board for Joomla! 2.5 (recommend install Quickstart package with sample data)

Step 2: Migrate database

  • In basics, the structure of all Job Board tables in version of Job Board for Joomla! 2.5 are kept as they were in Joomla! 1.5. So you can easily migrate your database from your Jobboard Joomla! 1.5 to Joomla! 2.5. To do that, you need:
  • Export Job Board tables form Joomla! 1.5 database ( the list of table is defiend in Appendix), ensure that you selected option "Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT statement" when exporting (if export by phpmyadmin tool, you might find a similar option if use other tool to export your database)

image:J25-1.png

image:J25-2.png

List of all tables must be exported

  #__jarpx_mapid 

  #__ja_applications 

  #__ja_categories 

  #__ja_codes

  #__ja_config

  #__ja_coupon

  #__ja_coupon_code

  #__ja_credits

  #__ja_email

  #__ja_email_draf

  #__ja_employers

  #__ja_feeds

  #__ja_form_fields

  #__ja_form_lists

  #__ja_jobalerts

  #__ja_jobs

  #__ja_jobseekers

  #__ja_jobs_value

  #__ja_location

  #__ja_notes

  #__ja_paymentconfig

  #__ja_permissions

  #__ja_permissions_detail

  #__ja_posting_plans

  #__ja_profiles

  #__ja_profiles_value

  #__ja_resumes

  #__ja_resumes_value

  #__ja_shortlist

  #__ja_subscriptions

  #__ja_tags

  #__ja_tax

  #__ja_transactions

  #__ja_xml_feeds

  #__ja_xml_import_feeds

  #__ja_xml_schemas

  #__ja_xml_schemas_details

image:J25-3.png

  • Replace table prefix: if table prefix of Joomla!1.5 version and Joomla! 2.5 version are different, you need to replace the prefix of Joomla! 1.5 with Joomla! 2.5 for the SQL script that you have just exported.

image:J25-4-1.png

image:J25-5.png

  • Import the SQL script that you exported from above step into database of Joomla! 2.5 version.

image:J25-6.png

Step 3: Migrate files, folders

  • All files and folders of Job Board component are uploaded in folder “images/stories/jbuploads”, so you just need copy this folder from Joomla! 1.5 version to folder of Joomla! 2.5
  • This folder is maybe changed in your site, depending upon your setting on back-end.

image:J25-7.png