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 th
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 - pref
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 can
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... this is
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
digit
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 10:08 2002-10-31, Benji Spencer wrote:
Just a silly question: are you pushing those 12.5 Mbytes/s over the
network ? If this is the case you have hit the limit of Fast Ethernet
(12.5x8 = 100Mbits/s) and no database (not even MySQL ;) ) will be
faster ! May be an upgrade to Gigabit Ethernet wou
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 d
It doesn't specifically mention MySQL, but I just had a look at the other
database failover scripts, and it shouldn't 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
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 d
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 stag
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
t; DESCRIPTIONvarchar(255),
> primary key (ITEM_NAME)
>) TYPE=INNODB;
>create table if not exists ITEM_DEF
>(
> ITEMDEF_ID intnot null,
> ITEM_NAME varchar(64),
> prima
pefully You helped not just me
>Heikki Tuuri
>Innobase Oy
>---
>Order technical MySQL/InnoDB 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
>
>
>-Ori
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
arent_id) REFERENCES 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 p
;s, Inc.
Methinks it's You, or the beer... ;)
----------
sql, query
Tomasz Korycki [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://list
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 se
Oy
>---
>Order technical MySQL/InnoDB 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 &
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
21 matches
Mail list logo
