Hi,
You can run multiple instances on the same host and specify configuration
options either by adding the options as arguments on the command line, or by
storing them in configuration files.
for example, from the command line:
shell> mysqld --port 3306 --log=/path/to/server1/log
shell> mysqld -
Hi,
I am exploring multiple instances with MySQL which will be running using the
same set of binaries (single MySQL base). Two things which I'm not able to work
out are -
1. Why mysqld_multi stop doesn't work? Well, I know why it
doesn't because there is nothing in the script to hand
Hi Phil
Yep, it looks like that will do.
Thanks
>> -Original Message-
>> From: freedc@gmail.com [mailto:freedc@gmail.com] On Behalf Of
>> Phil
>> Sent: 10 May 2010 13:53
>> To: mysql@lists.mysql.com
>> Subject: Re: Database tables for Exchange rates
>>
>> For the exchange rate
Thanks, It worked :)
On Mon, May 10, 2010 at 6:25 PM, Jay Ess wrote:
> On 2010-05-09 13:29, Prabhat Kumar wrote:
>
>> INSERT INTO myTable_info (id,range, total_qt, qt_correct, finish_time,
>> username, datestamp) VALUES (NULL,'Kumar', '20', '17', '111', 'Prabhat','*
>> NOW()');*
>>
>> Last_SQL_E
On 2010-05-09 13:29, Prabhat Kumar wrote:
INSERT INTO myTable_info (id,range, total_qt, qt_correct, finish_time,
username, datestamp) VALUES (NULL,'Kumar', '20', '17', '111', 'Prabhat','*
NOW()');*
Last_SQL_Error: Error 'You have an error in your SQL syntax; check the
manual that corresponds to
For the exchange rates only you don't really need more than one table. I
work with an enterprise financial system and we have exchange rate tables
which are updated with data every day.
Something like
BASE_CURR char(3)
NONBASE_CURR char(3)
EFF_DATE DATE
EXCH_RATE DECIMAL(15,6)-- or however
I am designing a database to store exchange rates and other information. The
tables fro the exchange rates will store exchange rates fro all currencies.
Can I have any suggestions about the number of tables to use for the
exchange rate? I think I will need at least 2 tables, but I am looking for
