The Backup and Restore buttons in the OS Property administrator are pretty self-explanatory. However, it is important to note that if you have a very large number of listings the backup and restore routines can easily run out of memory. It is advisable to run the backup/restore at non-peak hours if you have issues with memory utilization.
The OS Property backup function is not meant to be a substitute for properly and regularly backing up your Joomla database! Please be sure that you are following Joomlasecuritybest-practices with all of your Joomla sites, and that you have regular, secure backups of your files and database.
Also, the restore function WILL COMPLETELY ERASE YOUR CURRENT OS PROPERTY TABLES! PLEASE BE SURE YOU REALIZE THIS AND ONLY RESTORE WHEN YOU ARE CERTAIN YOU HAVE A VALID OSPROPERTY BACKUP FILE, AND YOUR SITE DATA SECURELY BACKED UP.
You also can use the database backup file (.sql.gz) for other OS Property site. The database backup files are stored in : components > com_osproperty > backup directory.
Note: You can only store database backup file of other site when that site and current site has the same number of activated languages. For example, if the backup site has 2 languages are: English and French, those languages must be available in current site.
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.
Notice: When you export database to .sql file, please add option: Drop tables if exists
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.