For security reasons, it is recommended that we do not use the default jos_ database prefix. However, the sample data SQL file looks for jos_ and will not install properly. It would be nice to have the option of specifying our database prefix so that it is incorporated into the SQL file.

The solution I used was to open the file and use the Replace command to replace all instances of jos_ to xxx_. The error I got was as follows:

SQL query:

--
-- Database: `icetheme_veranda`
--
-- --------------------------------------------------------
--
-- Table structure for table `mys_banner`
--
DROP TABLE IF EXISTS `mys_banner`

MySQL said: Documentation
#1046 - No database selected

I was not able to fix this so after reinstalling, I will use the standard tables