I am migrating database from Bitnami Mantis Stack 2.0.0 Rev1 to fresh Bitnami Mantis Stack 2.19.0-0. Database was exported in CSV format via phpMyAdmin, imported also via phpMyAdmin without any warnings.
phpMyAdmin on target machine displays expected data in SQL tables (I cannot confirm that all data was migrated successfully), however MantisBT web interface on target machine still does not show any data.
What do I miss to complete the migration?
Please advise.
migration with phpMyAdmin
Moderators: Developer, Contributor
Re: migration with phpMyAdmin
CSV is not a good format to transfer databases.
I assume your new database is different to your old one concerning data types of columns.
The right way would be to export / import the database by using mySQL command line tools mysqldump and mysql.
I am not sure, never tried myself, maybe export type "SQL" in phpMyAdmin does also the job.
I assume your new database is different to your old one concerning data types of columns.
The right way would be to export / import the database by using mySQL command line tools mysqldump and mysql.
I am not sure, never tried myself, maybe export type "SQL" in phpMyAdmin does also the job.
Re: migration with phpMyAdmin
Thank you for response.atrol wrote: ↑17 Jan 2019, 10:40 CSV is not a good format to transfer databases.
I assume your new database is different to your old one concerning data types of columns.
The right way would be to export / import the database by using mySQL command line tools mysqldump and mysql.
I am not sure, never tried myself, maybe export type "SQL" in phpMyAdmin does also the job.
mysqldump command requires SQL database name as argument. Source Mantis installation was created using Bitnami MantisBT Stack https://bitnami.com/stack/mantis and phpMyAdmin reports there 5 databases (see screenshot )
Am I understand correctly that all 5 databases must be exported?