I am currently running mantis 1.1.8 on php 5.5.9 ubuntu14.
We want to start the mantis database fresh new, is it ok to just backup the old database, and create a brand new database with no users/data?
Is there any dependency of the way mantis runs on the database?
Point current mantis to a blank new database
Moderators: Developer, Contributor
Re: Point current mantis to a blank new database
Backup config_inc.php and remove it. After that start the admin/install.php script to create a new empty database.
But why do you want to start with a complete outdated MantisBT 1.1.8 instead of the latest 2.6?
But why do you want to start with a complete outdated MantisBT 1.1.8 instead of the latest 2.6?
Re: Point current mantis to a blank new database
Thanks for your reply.
Yes i am also considering upgrading the mantis altogether.
1)Will my old backed-up db be able to plugin and run on the newer version?
2)Can I run 2 different versions of the mantis on one server (to be able to access the old data)
Yes i am also considering upgrading the mantis altogether.
1)Will my old backed-up db be able to plugin and run on the newer version?
2)Can I run 2 different versions of the mantis on one server (to be able to access the old data)
Re: Point current mantis to a blank new database
No, but it's no big deal to upgrade the database https://www.mantisbt.org/docs/master/en ... ll.upgradekarishma wrote: 1)Will my old backed-up db be able to plugin and run on the newer version?
You can, but you have to setup two different PHP versions on one system for it.karishma wrote: 2)Can I run 2 different versions of the mantis on one server (to be able to access the old data)
I recommend to use just one version, but upgrade the old data as described under 1)
Re: Point current mantis to a blank new database
thanks so much atrol!
Re: Point current mantis to a blank new database
Can I confirm something, is upgrading database different from upgrading mantis version? What is the purpose of upgrading database without the mantis version upgrade?atrol wrote:No, but it's no big deal to upgrade the database https://www.mantisbt.org/docs/master/en ... ll.upgradekarishma wrote: 1)Will my old backed-up db be able to plugin and run on the newer version?
You can, but you have to setup two different PHP versions on one system for it.karishma wrote: 2)Can I run 2 different versions of the mantis on one server (to be able to access the old data)
I recommend to use just one version, but upgrade the old data as described under 1)
Re: Point current mantis to a blank new database
I am attempting to update database using the current 1.1.8 mantis (I cant upgrade the version due to infrastructure issues here),
So i removed the config file and running install.php, and i get this error:
Mysql version is 5.5.43, and I suspect the install.php is using a different version mysql.
I had a few other mysql errors too which i was able to rectify, but I cant figure this one out.
Appreciate if anyone can help.
So i removed the config file and running install.php, and i get this error:
Code: Select all
Schema CreateTableSQL ( ) BAD
CREATE TABLE ( email_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, email VARCHAR(64) NOT NULL DEFAULT '', subject VARCHAR(250) NOT NULL DEFAULT '', submitted DATETIME NOT NULL DEFAULT '1970-01-01 00:00:01', metadata LONGTEXT NOT NULL, body LONGTEXT NOT NULL, PRIMARY KEY (email_id) )ENGINE=MyISAM
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '( email_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, email ' at line 1
I had a few other mysql errors too which i was able to rectify, but I cant figure this one out.
Appreciate if anyone can help.
Re: Point current mantis to a blank new database
I found my solution.
My server is running 5.5.43 mysql and the mantis install script was looking for 4.0.
I commented out the create table commands for the 4 tables it was giving error for at the schema.php. I also commented out the check for the mysql ver 4.0.1.
Installation is done now.
My server is running 5.5.43 mysql and the mantis install script was looking for 4.0.
I commented out the create table commands for the 4 tables it was giving error for at the schema.php. I also commented out the check for the mysql ver 4.0.1.
Installation is done now.