At 12:42 2004-09-08, you wrote:
Greetings
We have installed MySQL 4.0 on a dedicated Windows Server 2003. I have
the MySQL server running
and it appears all is set to go minus one problem. We need to move a
MySQL database from the old
host to this server. To do that, I want to use a GUI -
At 13:19 2004-09-08, you wrote:
I am going to amalgamate both Your messages.
Hi Tomasz
There are two MySQL servers - the one at the shared host and the new
one that I just set-up on the dedicated. We need to move the MySQL
database from the shared host to our dedicated. I am able to connect to
At 02:03 2003-12-03, David Garamond wrote:
What do people recommend for storing money amounts? I've seen people use
NUMERIC(18,3) and other use NUMERIC(18,4). Which one is more appropriate
and why? This is considering various existing currencies, some having low
rates (like IDR, in which you
At 20:12 2003-09-17, Mike Klein wrote:
Question: how is this done?
I am getting tired of entering my existing unix login information (same
login/pwd) every time I want to login to mysql.
I would like to propagate my existing unix credentials (/etc/pwd) or
possibly use pam/sasl/etc.
Note...of
At 21:08 2003-08-10, you wrote:
On Sun, Aug 10, 2003 at 05:25:05PM -0700, James Johnson wrote:
I have a MySQL database for books. The ISBN field is set as varchar(15) and
I've put a test ISBN number in of 1--111-11.
Note that ISBN numbers are a maximum of 13 characters, not 15. Ten
digits,
At 13:14 2003-06-17, Bernd Jagla wrote:
Sorry I forgot to mention:
We are using IRIS on an Origion2000, 7GB memory, 8 CPUs. I was thinking of
spending up to $10K.
I also wanted the redundant data for speeding up the seeks, I also need to
speed up the writes.
Bernd
I assume You mean IRIX on O2k.
At 23:46 2002-10-04, Chris Couture wrote:
1 - Where does mySQL normally store it's data base
files?
* From what I have seen, it depends on how you install it. You can
check in the my.ini file and that will let you know where it is.
On Linux (which I believe is the one in question) it
At 09:15 2002-06-05, Ramon Kagan wrote:
Hi,
(mysql 3.23.49, debian linux 2.4.18)
I am looking at running a program called keepalived so I can monitor
the availability of my mysql server. Data is stored on a NetApp filers so
its readily available to multiple machines. What I'd like to do is
take You long to change them
for MySQL. Once You do, You may want to put them up for others to use.
Other than that it works like a charm.
--
sql, query
Tomasz Korycki [EMAIL PROTECTED
At 01:57 2002-03-14, Heikki Tuuri wrote:
Tomasz,
are you sure you are running 4.0.1? In the rpm of 4.0.0 there were no
foreign keys.
I tested this on mysql-max-4.0.1, and it worked.
Well...
[root@flow11 httpd]# mysqladmin -p version
Enter password:
mysqladmin Ver 8.23 Distrib 4.0.1-alpha, for
At 07:22 2002-03-14, Heikki Tuuri wrote:
Tomasz,
are you using a non-latin1 character set?
No, didn't change the charset. As You can see from my reply to Victoria
yesterday, will need to, eventually (for different reasons, though, not
books), but right now I am in a proof-of-concept stage:
At 08:14 2002-03-14, Konstantin Tsolov wrote:
right, of course ;-) (i neglected the join part)
so, now i know exactly whom to ask ;-)
i have the following bother (it's in the planning state):
i have the idea of setting up a two-way replication system with 2 mysql
servers for my radius
At 13:26 2002-03-13, Victoria Reznichenko wrote:
Alex,
Wednesday, March 13, 2002, 7:16:02 PM, you wrote:
AK I'm very much interested to know how do you manage multiple language
support with
AK mySQL.
AK I haven't found how i can define different character sets for
different tables or
AK even
to MySQL/InnoDB through support contracts
See http://www.innodb.com for the online manual and latest news on InnoDB
-Original Message-
From: Tomasz Korycki [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Date: Wednesday, March 13, 2002 1:05 AM
Subject: constraints in InnoDB
varchar(64),
primary key (ITEMDEF_ID),
INDEX FK_ITEM_NAME_INDEX(ITEM_NAME),
FOREIGN KEY (ITEM_NAME) REFERENCES ITEM(ITEM_NAME)
) TYPE=INNODB;
-- Rick
Thanks! So, what's next?
--
sql, query
Tomasz Korycki [EMAIL PROTECTED
parent(id);
No error. No effect, either...
So, here comes the big question: What am I doing wrong?
--
sql, query
Tomasz Korycki [EMAIL PROTECTED]
-
Before posting, please check
... ;)
--
sql, query
Tomasz Korycki [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
Hi,
Newbie here, so please be kind...
I decided to try out the foreign keys (REFERENCES tabel(column) in CREATE
TABLE) and I hit two problems. Maybe it's my clumsiness with search
specification, but I couldn't find answers in the archive. Oh, I tried it
on InnoDB tables created just for this
support at https://order.mysql.com/
Speed up adding of features to MySQL/InnoDB through support contracts
See http://www.innodb.com for the online manual and latest news on InnoDB
-Original Message-
From: Tomasz Korycki [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Date: Tuesday, March
At 04:18 2002-03-05, you wrote:
Tomasz,
are you running on Windows?
Please use innodb_table_monitor as explained in section 9.1 of
http://www.innodb.com/ibman.html, and also look into section 15.1.
Best regards,
Re: 9.1: Well, can't find innodb* anywhere on the system
Re: 15.1: The second
20 matches
Mail list logo