MySQL Database Clone


If MySQL is used as the user's meta data repository, then follow these instructions.


  1. Take the backup of splash_mds and splash_demos databases using following commands.
  2. Login as SplashBI OS level user to source instance.
  3. Use mysqldump command:[splash@splashdba ~] mysqldump -u root -p --default-character-set=utf8 --routines --events splash_mds > splash_mds.dmp.
  4. Enter the mysql root password.



Repeat the same steps for splash_demos database backup.


  1. Copy splash_mds.dmp and splash_demos.dmp files from source to target instance.
  2. To restore the mysql database splash_mds, MySQL should be already installed in target instance. If MySQL is not present on target instance, then use the SplashBI Installation Guide to create one.
  3. Login as SplashBI OS level user to target instance.
  4. Use mysqldump command:[splash@splashdba ~]mysql -u root -p splash_mds < splash_mds.dmp.
  5. Enter the mysql root password.



Repeat the same steps for splash_demos database to restore.