MySQL migration from localhost to webhost

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
amphetamine
Posts: 113
Joined: 05 Jun 2019, 00:17

MySQL migration from localhost to webhost

Post by amphetamine »

windows localhost to webhost (dreamhost)
Checking your MantisBT installation...

Code: Select all

magic_quotes_gpc php.ini directive is disabled	WARN
magic_quotes_runtime php.ini directive is disabled	WARN
Browser Search engine names must be 16 chars or less
Either shorten the "search_title" configuration option to a maximum of 11 characters, or alter the "opensearch_XXX_short" language strings as appropriate to meet the OpenSearch 1.1 specification for the ShortName element.	WARN
after login administrator account,

Code: Select all

APPLICATION ERROR #401

Database query failed. Error received from database was #1146: Table 'mantisbt3.mantis_plugin_Announce_message_table' doesn't exist for the query: SELECT m.*, c.*, c.id AS context_id FROM mantis_plugin_Announce_message_table AS m
JOIN mantis_plugin_Announce_context_table AS c ON c.message_id=m.id
LEFT JOIN mantis_plugin_Announce_dismissed_table as d ON d.context_id=c.id and d.user_id=?
WHERE (d.timestamp IS NULL or d.timestamp < m.timestamp)
AND c.location = ? AND c.project_id = ?
AND c.access <= ? ORDER BY m.timestamp DESC.

Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.
amphetamine
Posts: 113
Joined: 05 Jun 2019, 00:17

Re: MySQL migration from localhost to webhost

Post by amphetamine »

https://www.mantisbt.org/bugs/view.php?id=26957

not sure my procedure is correct or not,

localhost mysql, select the database and copy database to "bugtracker3" and export the sql file.
then imported sql file to webhost bugtracker3 database

got the same error message
amphetamine
Posts: 113
Joined: 05 Jun 2019, 00:17

Re: MySQL migration from localhost to webhost

Post by amphetamine »

after change the database table's name, then work

mantis_plugin_Announce_context_table
mantis_plugin_Announce_dismissed_table
mantis_plugin_Announce_message_table
amphetamine
Posts: 113
Joined: 05 Jun 2019, 00:17

Re: MySQL migration from localhost to webhost

Post by amphetamine »

update status,

after closed an issue, got the same issue

Code: Select all

APPLICATION ERROR #401

Database query failed. Error received from database was #1146: Table bugtracker3.mantis_plugin_Holidays_period_table' 
same solution rename the table from mantis_plugin_holidays_period_table to mantis_plugin_Holidays_period_table
dregad
Developer
Posts: 75
Joined: 26 Jul 2010, 14:24

Re: MySQL migration from localhost to webhost

Post by dregad »

Post Reply