home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 1
Area 51 - Testing Area
MP1-4341 Add possibility to Deploy Tool to upgrade MySQL dB
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Sebastiii" data-source="post: 1058411" data-attributes="member: 60104"><p>Hi,</p><p></p><p>I have spend all the morning to try to add '--skip-grant-tables', it's tricky because we need to start mysqld.exe (not the service) -> start mysql upgrade etc. -> kill mysqld.exe -> start the service etc.</p><p></p><p>But in final lol, '--skip-grant-tables' didn't work and in fact the restore/upgrade works <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile :)" loading="lazy" data-shortname=":)" /> </p><p></p><p>[CODE]Looking for 'mysql.exe' as: C:\Program Files\MySQL\MySQL Server 5.6\bin\mysql.exe</p><p>Looking for 'mysqlcheck.exe' as: C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqlcheck.exe</p><p>Running 'mysqlcheck' with connection arguments: "--port=3306" "--port=3306" "--host=localhost"</p><p>Running 'mysqlcheck' with connection arguments: "--port=3306" "--port=3306" "--host=localhost"</p><p>mptvdb.canceledschedule OK</p><p>mptvdb.card OK</p><p>mptvdb.cardgroup OK</p><p>mptvdb.cardgroupmap OK</p><p>mptvdb.channel OK</p><p>mptvdb.channelgroup OK</p><p>mptvdb.channellinkagemap OK</p><p>mptvdb.channelmap OK</p><p>mptvdb.conflict OK</p><p>mptvdb.diseqcmotor OK</p><p>mptvdb.favorite OK</p><p>mptvdb.groupmap OK</p><p>mptvdb.history OK</p><p>mptvdb.keyword OK</p><p>mptvdb.keywordmap OK</p><p>mptvdb.pendingdeletion OK</p><p>mptvdb.personaltvguidemap OK</p><p>mptvdb.program OK</p><p>mptvdb.radiochannelgroup OK</p><p>mptvdb.radiogroupmap OK</p><p>mptvdb.recording OK</p><p>mptvdb.satellite OK</p><p>mptvdb.schedule OK</p><p>mptvdb.server OK</p><p>mptvdb.setting OK</p><p>mptvdb.softwareencoder OK</p><p>mptvdb.timespan OK</p><p>mptvdb.tuningdetail OK</p><p>mptvdb.tvmoviemapping OK</p><p>mptvdb.version OK</p><p>mysql.columns_priv OK</p><p>mysql.db OK</p><p>mysql.event OK</p><p>mysql.func OK</p><p>mysql.general_log OK</p><p>mysql.help_category OK</p><p>mysql.help_keyword OK</p><p>mysql.help_relation OK</p><p>mysql.help_topic OK</p><p>mysql.host OK</p><p>mysql.innodb_index_stats OK</p><p>mysql.innodb_table_stats OK</p><p>mysql.ndb_binlog_index OK</p><p>mysql.plugin OK</p><p>mysql.proc OK</p><p>mysql.procs_priv OK</p><p>mysql.proxies_priv OK</p><p>mysql.servers OK</p><p>mysql.slave_master_info OK</p><p>mysql.slave_relay_log_info OK</p><p>mysql.slave_worker_info OK</p><p>mysql.slow_log OK</p><p>mysql.tables_priv OK</p><p>mysql.time_zone OK</p><p>mysql.time_zone_leap_second OK</p><p>mysql.time_zone_name OK</p><p>mysql.time_zone_transition OK</p><p>mysql.time_zone_transition_type OK</p><p>mysql.user OK</p><p>Running 'mysql_fix_privilege_tables'...</p><p>OK</p><p>[/CODE]</p><p></p><p>Like we can see : mysql.proc is OK <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile :)" loading="lazy" data-shortname=":)" /></p><p>So we don't have to care about it <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite7" alt=":p" title="Stick Out Tongue :p" loading="lazy" data-shortname=":p" /></p><p></p><p>So we are good <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile :)" loading="lazy" data-shortname=":)" /></p></blockquote><p></p>
[QUOTE="Sebastiii, post: 1058411, member: 60104"] Hi, I have spend all the morning to try to add '--skip-grant-tables', it's tricky because we need to start mysqld.exe (not the service) -> start mysql upgrade etc. -> kill mysqld.exe -> start the service etc. But in final lol, '--skip-grant-tables' didn't work and in fact the restore/upgrade works :) [CODE]Looking for 'mysql.exe' as: C:\Program Files\MySQL\MySQL Server 5.6\bin\mysql.exe Looking for 'mysqlcheck.exe' as: C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqlcheck.exe Running 'mysqlcheck' with connection arguments: "--port=3306" "--port=3306" "--host=localhost" Running 'mysqlcheck' with connection arguments: "--port=3306" "--port=3306" "--host=localhost" mptvdb.canceledschedule OK mptvdb.card OK mptvdb.cardgroup OK mptvdb.cardgroupmap OK mptvdb.channel OK mptvdb.channelgroup OK mptvdb.channellinkagemap OK mptvdb.channelmap OK mptvdb.conflict OK mptvdb.diseqcmotor OK mptvdb.favorite OK mptvdb.groupmap OK mptvdb.history OK mptvdb.keyword OK mptvdb.keywordmap OK mptvdb.pendingdeletion OK mptvdb.personaltvguidemap OK mptvdb.program OK mptvdb.radiochannelgroup OK mptvdb.radiogroupmap OK mptvdb.recording OK mptvdb.satellite OK mptvdb.schedule OK mptvdb.server OK mptvdb.setting OK mptvdb.softwareencoder OK mptvdb.timespan OK mptvdb.tuningdetail OK mptvdb.tvmoviemapping OK mptvdb.version OK mysql.columns_priv OK mysql.db OK mysql.event OK mysql.func OK mysql.general_log OK mysql.help_category OK mysql.help_keyword OK mysql.help_relation OK mysql.help_topic OK mysql.host OK mysql.innodb_index_stats OK mysql.innodb_table_stats OK mysql.ndb_binlog_index OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.proxies_priv OK mysql.servers OK mysql.slave_master_info OK mysql.slave_relay_log_info OK mysql.slave_worker_info OK mysql.slow_log OK mysql.tables_priv OK mysql.time_zone OK mysql.time_zone_leap_second OK mysql.time_zone_name OK mysql.time_zone_transition OK mysql.time_zone_transition_type OK mysql.user OK Running 'mysql_fix_privilege_tables'... OK [/CODE] Like we can see : mysql.proc is OK :) So we don't have to care about it :P So we are good :) [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Area 51 - Testing Area
MP1-4341 Add possibility to Deploy Tool to upgrade MySQL dB
Contact us
RSS
Top
Bottom