[Flow] Importing data to another database

[Regine Rosewich]

Hi Stephen,


what kind of database are you using? If it’s mysql you should be able to
dump and load the database without any problem. I’m doing that very
frequently because my application has a test-database which is copied from
the productive-database almost daily.

//dump the data
mysqldump —user=<databaseUser> —password=<password> --no-create-db
--no-create-info <database-name>><path to database-structure-dumpfile>

//dump the structure
mysqldump --user=<databaseUser> --password=<password> --no-data
<database-name>><path to database-data-dumpfile>

Attention! don’t forget the „>“ between the database-name and the
dump-file path.

Both files can be reloaded with:

mysql --user=<databaseUser> --password=<password> <database-name><<path to
dumpfile> (See the „<„ having another direction)



If the copied database is a 100% copy of another database you only have to
assure that the EncryptionKey (<Domain>/Data/Persistent/EncryptionKey) is
the same for both databases/applications

Regine