Migrate OS Property data

[TOC]

In case you are using old OS Property versions or in another site (with different Joomla DB prefix). You won't use DB Backup and Restore function to migrate data. But you can do follow these steps to implement data migration.

1. Using PHPMyAdmin to export all OS Property tables of old version to .sql file. The OS Property DB table will have the prefix (#__osrs...). For example: jos_osrs_properties.

   Notice: When you export database to .sql file, please add option: Drop tables if exists

2. Open .sql file by Notepad and replace the prefix of old database by prefix of new database.

   The database table prefix is a string (a few characters long) prepended to the name of Joomla!'s tables. Using a prefix enables you to run multiple installations of Joomla! using a single database.
   The database table prefix can be set during installation. Changing it later is possible, but requires access to the database through a non-Joomla medium or a Joomla Extension such as Akeeba Admin Tools and will cause some downtime.
   Extension developers need to use the string #__ to represent the prefix. This will be replaced by the real prefix during runtime by Joomla.

3. Import modified .sql file into new Joomla database site. Because in .sql file, you add option "Drop tables if exists", so even in new site, you already installed OS Property. You won't have any issue in this step.
4. Re-install new OS Property version in new site.
5. Copy directory: Root > Images > Osproperty from old site to new site.