Page 1 of 1

Point current mantis to a blank new database

Posted: 21 Sep 2017, 09:06
by karishma
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?

Re: Point current mantis to a blank new database

Posted: 21 Sep 2017, 14:19
by atrol
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?

Re: Point current mantis to a blank new database

Posted: 25 Sep 2017, 01:02
by karishma
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)

Re: Point current mantis to a blank new database

Posted: 25 Sep 2017, 20:38
by atrol
karishma wrote: 1)Will my old backed-up db be able to plugin and run on the newer version?
No, but it's no big deal to upgrade the database https://www.mantisbt.org/docs/master/en ... ll.upgrade
karishma wrote: 2)Can I run 2 different versions of the mantis on one server (to be able to access the old data)
You can, but you have to setup two different PHP versions on one system for it.
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

Posted: 27 Sep 2017, 00:55
by karishma
thanks so much atrol!

Re: Point current mantis to a blank new database

Posted: 29 Sep 2017, 14:37
by karishma
atrol wrote:
karishma wrote: 1)Will my old backed-up db be able to plugin and run on the newer version?
No, but it's no big deal to upgrade the database https://www.mantisbt.org/docs/master/en ... ll.upgrade
karishma wrote: 2)Can I run 2 different versions of the mantis on one server (to be able to access the old data)
You can, but you have to setup two different PHP versions on one system for it.
I recommend to use just one version, but upgrade the old data as described under 1)
Can I confirm something, is upgrading database different from upgrading mantis version? What is the purpose of upgrading database without the mantis version upgrade?

Re: Point current mantis to a blank new database

Posted: 29 Sep 2017, 15:21
by atrol
karishma wrote:What is the purpose of upgrading database without the mantis version upgrade?
That makes no sense.

Re: Point current mantis to a blank new database

Posted: 13 Nov 2017, 15:14
by karishma
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:

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
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.

Re: Point current mantis to a blank new database

Posted: 19 Nov 2017, 12:52
by karishma
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.