MySQL installation changes 5.5
I am installing for the first time according to your instructions below but I beleive things have changed with MySQL 5.5
there are several .ini files. small/medium/huge - I am assuming we would ned to add the extra lines to all the .ini files?? or which ones??
Thx Rob.
MySQL Configuration
- Stop the MySQL database server. My Computer->Manage->Services->MySQL. Right Click and Stop.
- Navigate to MySQL application folder C:\Program Files\MySQL\MySQL Server 5.0
- Save copy of my.ini file
-
Double click on my.ini file at the bottom of the file add the lines
max_allowed_packet=16M
innodb_file_per_table
Re: MySQL installation changes 5.5
PS: some of the installation options in your notes are no longer present with mysql 5.5.
I have then had trouble with the next section Database Setup section - which may be related.
I have attached a screenshot of Command prompt error when adding your pameters.
The second window is where I have tried to add the paramenters directly with command line client. both produce errors.
Any help with these please?
Re: MySQL installation changes 5.5
The first screenshot indicates that you don't have mysql.exe in your PATH.
See To add or change the values of environment variables for instructions on how to add this.
Alternatively, run mysql by specifying its full path e.g.:
"C:\Program Files\MySQL\MySQL Server 5\bin\mysql" <some-command-here>
The second screenshot indicates that you need to specify the full path to the createdb.sql script.
E.g. source c:\openvpms\openvpms-release-1.4\db\createdb.sql
-Tim
Re: MySQL installation changes 5.5
Thanks Tim
First option worked perfect. Rest of install worked amazingly smooth til end BUT:
1. When I try to go to the localhost in IE to log on i get an error - see attachment
I am loading this on a terminal server 2008 and assume this is involved. ?
Had loaded dataload base - seemed to load ok. Any help would be appreciated.
2. Was my assumption about .ini files in original question correct? Do you have to add lines to ALL .ini files?
Re: MySQL installation changes 5.5
1. I haven't seen that particular error, but then I don't use IE.
A search on "No Such Interface Supported" turned up the following links:
You will get a much nicer OpenVPMS experience using Firefox.
2. You only need to add those lines to the .ini used by MySQL.
To determine which is in use:
a. Go to Control Panel -> Administrative Tools -> Services
b. Right click on the MySQL service, and click Properties
The "Path to Executable" field will display something like:
"C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld" --defaults-file="C:\Program Files\MySQL\MySQL Server 5.1\my.ini" MySQLThe --defaults-file argument indicates which .ini is being used.
A simpler approach is to use MySQL Workbench which you can get from http://dev.mysql.com/downloads/workbench/
To configure the server, start MySQL Workbench and go to Server Administration -> Configuration.
-Tim
Re: MySQL installation changes 5.5
Thanks Tim
Firefox works perfect. I believe it must be the "Enhanced security settings" with IE when run in a terminal server enviroment.
I believe Tony mentioned he could transfer our own data over to the trial system to use and get use to. How do I go about organising this?
Also I think the install instructions could be changed/ updated for Mysql 5.5 as install options of this is different than 5.1.
Thanks again for this quite straight forward installation.
Rob.
Re: MySQL installation changes 5.5
Hi Rob,
I am happy to add additional notes to the implementation documentation to support Mysql 5.5. If you have any notes on the changes please send them through and I will make sure they are incorporated as well.
As far as data migration work this can be done by independent implementation companies. I suggest you contact me off forum so we can discuss options.
Cheers Tony
Re: MySQL installation changes 5.5
Thanks Tony
Can you call me? I can't seem to find your details. 0893002322