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
Development
Improvement Suggestions
Small Performance improvement with MySQL
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="steve walsh" data-source="post: 371217" data-attributes="member: 84262"><p><strong>How to apply these "tweaks"...</strong></p><p></p><p>Hello,</p><p></p><p>I'm no database expert (this will soon become obvious!) so feel free to point out where I'm going wrong.... </p><p>But for other non-experts I thought I'd share my experiences...</p><p></p><p>So, guessing at what to do, I figured I had to type them into the MySQL command line client.. (this is in the Start/All Programs/MySQL folder)</p><p>On first attempt I got the message : no database selected</p><p>It didn't take long to figure out how to solve this (about 30 secs)....</p><p>"help;" or "\h" pointed me towards the "connect" command : <strong>connect mptvdb</strong> </p><p>Then when I ran the SQL-statements everything seemed to work - I got no errors.</p><p>I typed <strong>quit</strong> afterwards</p><p></p><p>I hope this helps others with little/no db experience... <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="steve walsh, post: 371217, member: 84262"] [b]How to apply these "tweaks"...[/b] Hello, I'm no database expert (this will soon become obvious!) so feel free to point out where I'm going wrong.... But for other non-experts I thought I'd share my experiences... So, guessing at what to do, I figured I had to type them into the MySQL command line client.. (this is in the Start/All Programs/MySQL folder) On first attempt I got the message : no database selected It didn't take long to figure out how to solve this (about 30 secs).... "help;" or "\h" pointed me towards the "connect" command : [B]connect mptvdb[/B] Then when I ran the SQL-statements everything seemed to work - I got no errors. I typed [B]quit[/B] afterwards I hope this helps others with little/no db experience... :) [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Development
Improvement Suggestions
Small Performance improvement with MySQL
Contact us
RSS
Top
Bottom