Re: [Mantisbt-help] Moving a Mantis Database

[Russell <ru...@xe...>]

I've just spent several days trying to get Mantis working on a new (Windows)
server. I copied all the PHP scripts across, and tried to copy the DB using
Backup/Restore, but the restore kept crashing (lost connection to server!).
So I just copied the entire Mantis DB directory across, which looked OK in
the MySQL admin GUI. However, Mantis still wouldn't fire up. Then I noticed
that there were 3 tables missing from the copied database - the 3 InnoDB
ones. I deleted the underlying .FRM files for these 3, and then did a
backup/restore of those 3 tables only, and Mantis started up fine.

So the procedure for copying the Mantis DB is to copy the entire Mantis DB
directory to the new machine, delete the mantis_config_table.frm,
mantis_project_heirarchy_table.frm and mantis_tokens_table.frm files, and
then backup/restore those 3 tables.


Amir-5 wrote:
> 
> Hello,
> I have a regular Mantis database that I would like to move to a different
> box which is running the latest version of SUSE. I already have Mantis
> installed on the new system, and it appears to be working correctly. How
> do
> I go about running the older database on the new system? Any help is
> greatly
> appreciated.
> 
> Thanks,
> Amir
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
> your
> opinions on IT & business topics through brief surveys -- and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Mantisbt-help mailing list
> Man...@li...
> https://lists.sourceforge.net/lists/listinfo/mantisbt-help
> 
> 

-- 
View this message in context: http://www.nabble.com/Moving-a-Mantis-Database-tf2035118.html#a6051245
Sent from the Mantis - General forum at Nabble.com.