Unfortunatelly it isn't true in my case. I connect to database server in
local network and I use IP address, so there is no DNS usage...
Jiri Matejka
- Original Message -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Jiri Matejka" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday,
It works. It works very well. As Jeremy said, just make sure you are
very explicit in your configuration and startup
Jeremy Zawodny wrote:
On Tue, May 11, 2004 at 09:26:57AM +0700, Winner H Manurung wrote:
Dear All,
I was an Oracle dba, now my new company want to use Mysql 4.0.18. Does
anybod
Scott Haneda wrote:
If users become day 1000 and each of those users has 70,000 user_contacts,
that would be 70,000 * 1000 total records in one table, as users grow, this
becomes perhaps too many records in one table. Or at least the potential
for it.
My next option would be to make a new table
I just installed the administrator alpha binaries on
my Sun Java Desktop system (SuSe 8 Linux), and I get
the following error at startu:
./mysql-administrator-bin: error while loading shared
libraries: libsigc-1.2.so.5: cannot open shared object
file: No such file or directory
I did a find from r
Sorry for the post again, I hijacked a thread and wanted to get this on the
correct track.
I can not seem to find the section in the manual that talks about the max
number of tables MySql can use, can someone point me please?
I have been asked to build a database which could have some potentially
On Tue, May 11, 2004 at 09:26:57AM +0700, Winner H Manurung wrote:
> Dear All,
>
> I was an Oracle dba, now my new company want to use Mysql 4.0.18. Does
> anybody here has experience of running multiple mysqld (i.e. multiple
> instance on one machine). Is it stable and totally independent to each
I can not seem to find the section in the manual that talks about the max
number of tables MySql can use, can someone point me please?
I have been asked to build a database which could have some potentially
interesting storage needs.
There will be a users table, there can be x users, if all goes
Dear All,
I was an Oracle dba, now my new company want to use Mysql 4.0.18. Does
anybody here has experience of running multiple mysqld (i.e. multiple
instance on one machine). Is it stable and totally independent to each
other?
Thank you for your answer
Winner
__
Hi Mike,
if you refer to MySQL 4.1 then yes you an do that. (I assume you are speaking
about the server side configuration).
I have made a presentation "Using MySQL in a Japanese environment" on the
UC-2004 which can be found here:
www.be-known-online.com/mysql
I hope that this helps a bit.
I am trying to setup an NDB Cluster database for testing purposes. I have no
problems getting things to work when all of my DB and API nodes are located
on one machine. I run into trouble when I try to have one machine run the
management server, a db node, and an API node, while the second machine
Hello,
is it possible to change the default character set for one mysql user without
affecting the mysql global character set setting, via the the user's .my.cnf
option file ??
thx's
--
MikeBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solut
Hello,
is it possible to change the default character set for one mysql user without
affecting the global character set setting, via the the user's .my.cnf option
file ??
thx's
--
MikeBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions t
I can not seem to find the section in the manual that talks about the max
number of tables MySql can use, can someone point me please?
I have been asked to build a database which could have some potentially
interesting storage needs.
There will be a users table, there can be x users, if all goes
Gabriel Ricard wrote:
I'm not sure what's going on with our replication. Everything was
working fine, then all of a sudden it stopped. I did STOP SLAVE; RESET
SLAVE; LOAD DATA FROM MASTER and it completed after a few minutes, but
when I checked SHOW SLAVE STATUS it no longer had any information
Joe Adams wrote:
I have a database setup for replication. I used mysqldump --opt db > db.dmp
to do the initial backup of the primary database (after doing a flush tables
with read lock in a seperate session).
I checked the dump file, and all drop table create table statements are in
the file. Whe
[EMAIL PROTECTED] wrote:
I am running a mysql server off a Dell 2650.
Dual 2.8Ghz Intel Xeon processors
1 Gig of RAM
The MySQL data comes up rather slowly. Would like some suggestions on my
my.cnf file if you had a minute.
Conner:
The problem is very unlikely your my.cnf, and very likely your app
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Monday, May 10, 2004 2:23 PM
> To: [EMAIL PROTECTED]
> Subject: my.cnf setup
>
> I am running a mysql server off a Dell 2650.
> Dual 2.8Ghz Intel Xeon processors
> 1 Gig of RAM
>
> The MySQL data comes up r
Tim Jarman wrote:
I have an iBook G4 running MacOS X.3 on Darwin 7.0. I downloaded and ran the
binary installer (mysql-standard-4.0.18.pkg and it appeared to work fine; I
have /usr/local/mysql and so on as per the docs. I also installed
MySQLStartupItem.
However, I don't actually appear to have
I am running a mysql server off a Dell 2650.
Dual 2.8Ghz Intel Xeon processors
1 Gig of RAM
The MySQL data comes up rather slowly. Would like some suggestions on my
my.cnf file if you had a minute.
here is what I have
++--+
| Variable_name
Can you do a ps -ef | grep mysql? I would like to see the output.
-Original Message-
From: Daniel Shriver
To: Victor Pendleton
Cc: '[EMAIL PROTECTED] '
Sent: 5/10/04 3:55 PM
Subject: Re: authentication problem on non-standard port
Victor Pendleton wrote:
>Are you specifying either the so
Assuming that your pre 4.1, meaning that you can't use a subquery this
will do it, BUT comp_id must be set to allow NULLS for this to work
otherwise the optimizer will handle it differently
(http://dev.mysql.com/doc/mysql/en/LEFT_JOIN_optimisation.html). It is
legal to create a primary key on
I have an iBook G4 running MacOS X.3 on Darwin 7.0. I downloaded and ran the
binary installer (mysql-standard-4.0.18.pkg and it appeared to work fine; I
have /usr/local/mysql and so on as per the docs. I also installed
MySQLStartupItem.
However, I don't actually appear to have a functional inst
Victor Pendleton wrote:
Are you specifying either the socket or the host/port combination? What
types of error messages are you getting
Here is an example of it working and not working (with machine,
usernames omitted)
$ mysql -h -u -p
Enter password:
Welcome to the MySQL monitor. Commands
Are you specifying either the socket or the host/port combination? What
types of error messages are you getting
-Original Message-
From: Daniel Shriver
To: [EMAIL PROTECTED]
Sent: 5/10/04 3:24 PM
Subject: authentication problem on non-standard port
I am having problems authenticating to
I am having problems authenticating to a machine where there are two
database instances running. The instance which listens on the standard
port allows me to authenticate correctly whereas the instance listening
on the non-standard port only works: if I am on the same box as the
database; or i
I have three tables in a MySQL DB... among others:
1. computers
2. users
3. comp_user_link
This particular DB is used for inventory and tracking purposes. I think
the table names are self explanatory. Computers has 'comp_id'... users
has 'user_id' as their primary indexed keys. These keys are li
When I do a SHOW INNODB STATUS i see a query which is
waiting for a lock to be released, but innodb status
doesnt show the whole query, the end of it got truncated.
it looks something like:
INSERT INTO test(col1, .., col10) VALUES ('9',
and just stops.
is it possible to see the entire query, im hav
I have built a custom inverted text index to search my data. I'm not using
MySQL's fulltext index because A) I want more control over the index and
results, and B) I want to learn how this all works, and if it's possible to
do this quickly in MySQL.
I'm trying to formulate fulltext searches using
"Cao, Wenhong" <[EMAIL PROTECTED]> wrote:
> I am trying to export the records from the tables in the mysql database
> into a file. The problem I am having now is that I don't know how to
> export the records into a file without the header information, which is
> the name of columns.
>
> Can someone
Using --skip-column-names with the client or mysqldump suppresses the
column names.
Cao, Wenhong wrote:
Hi All,
I am trying to export the records from the tables in the mysql database
into a file. The problem I am having now is that I don't know how to
export the records into a file without the
There are different ways to do accomplish this.
You can use either:
SELECT id, datecol, text FROM table WHERE YEAR(datecol) = 2004 AND
MONTH(datecol) =$mySelectedMonth;
or:
SELECT id, datecol, text FROM table WHERE LEFT(datecol,7) =
'2004-$mySelectedMonth';
As of formated date... use the DATE_FO
Hi All,
I am trying to export the records from the tables in the mysql database
into a file. The problem I am having now is that I don't know how to
export the records into a file without the header information, which is
the name of columns.
Can someone help?
Thanks,
Wenhong
Hi again,
I got the MONTH() selection thing working now, but it seems like I'm not
getting the hang of the concept with the sql date..
With PHP and a UNIX timestamp I would just insert a timestamp, the
select it and after selection, go ahead and manipulate it to fit my
needs, like extracting day
I have a database
setup for replication. I used mysqldump --opt db > db.dmp to do the
initial backup of the primary database (after doing a flush tables with read
lock in a seperate session).
I checked the dump
file, and all drop table create table statements are in the file. When I
did a
<< Looks like it's a query cache issue. In this case you get result from the
cache.>>
That was it.
THANKS
- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 10, 2004 1:20 PM
Subject: Re: Blocking Selects with LOCK TABLES
I am having some issues getting OpenSSL to work correctly.
I was able to sign and set up the certificates but thats it. I cannot
seem to do much else.
First of all if I try and update my grants tables I get this error.
If I try and mysql_fix_privilege_tables I get an error that says:
error: Fou
At 12:40 -0400 on 05/10/2004, Lou Olsten wrote about Blocking Selects
with LOCK TABLES:
According to the docs
(http://dev.mysql.com/doc/mysql/en/LOCK_TABLES.html) :
If a thread obtains a READ lock on a table, that thread (and all
other threads) can only read from the table. If a thread obtains
"Lou Olsten" <[EMAIL PROTECTED]> wrote:
> According to the docs (http://dev.mysql.com/doc/mysql/en/LOCK_TABLES.html)
> :
> If a thread obtains a READ lock on a table, that thread (and all other threads) can
> only
> read from the table. If a thread obtains a WRITE lock on a table, only the thread
I'm not sure what's going on with our replication. Everything was
working fine, then all of a sudden it stopped. I did STOP SLAVE; RESET
SLAVE; LOAD DATA FROM MASTER and it completed after a few minutes, but
when I checked SHOW SLAVE STATUS it no longer had any information about
the master. I l
If you want to retrieve rows with the correct month, regardless of year,
then you probably want the MONTH() function. It returns the month part of a
date as an integer from 1 to 12, so you could do
SELECT id, datecol, text FROM table
WHERE MONTH(datecol) = $mySelectedMonth;
Note, however, t
Is this what you're looking for?
SELECT id, datecol, text FROM table WHERE MONTH(datecol)
=$mySelectedMonth;
- Original Message -
From: "H Bartel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 10, 2004 11:34 AM
Subject: Select month from Date
> Hi,
>
> I am trying to st
According to the docs (http://dev.mysql.com/doc/mysql/en/LOCK_TABLES.html) :
If a thread obtains a READ lock on a table, that thread (and all other threads) can
only read from the table. If a thread obtains a WRITE lock on a table, only the thread
holding the lock can read from or write to the ta
See below
- Original Message -
From: "Jeremy Smith" <[EMAIL PROTECTED]>
To: "[EMAIL PROTECTED] Mysql. Com" <[EMAIL PROTECTED]>
Sent: Sunday, May 09, 2004 9:31 PM
Subject: Transaction question - no rollback needed?
> Does it make sense to use a transaction just for the row locking
propert
Hi,
I am trying to start using the mySQL Date functions instead of the unix
timestamp from PHP. I have read the man page several times now, but
still haven't come up with a solution for this simple query:
SELECT id, datecol, text FROM table WHERE month-in-date-col =
$mySelectedMonth;
This should
Try looking at www.firepages.com.au - you can download a zipped
pre-configured windows mysql installation with a working mysql database
and loads of mySQL sample pages.
Regards
Jonathan Pilborough
=
--
Please fill in my Business Questionnaire at http://www.businessq.tk
--
Pupil at Haybr
* Ronan Lucio
> Is the Primary Key Column mandatory?
>
> Supposing:
> If I have two tables: Clients and Cars, and a third table Clients_R_Cars,
> that is a relationship between Clients and Cars.
>
> I only need to know what cars the clients have.
> So, I just need to two columns "CliCar_ClientsID"
On Mon, 10 May 2004 11:15:25 -0300
"Ronan Lucio" <[EMAIL PROTECTED]> wrote:
> Is the Primary Key Column mandatory?
>
> Supposing:
> If I have two tables: Clients and Cars, and a third table
> Clients_R_Cars, that is a relationship between Clients and Cars.
>
> I only need to know what cars the c
Slow connections are ususally a DNS or reverse DNS problem.
Jiri Matejka wrote:
Hi,
I'm using MySQL 3.23.53 on W2000 and I have a following problem: when I
restart the database server then the first attempt to connect from any
client program last cca 30 seconds (too long!!), each next attempt to
Hi,
Is the Primary Key Column mandatory?
Supposing:
If I have two tables: Clients and Cars, and a third table Clients_R_Cars,
that is a relationship between Clients and Cars.
I only need to know what cars the clients have.
So, I just need to two columns "CliCar_ClientsID" and "CliCar_CarsID",
th
> Hi there, I am aware this isnt possible. I would like the power of Innodb,
> but one of my applications also requires the boolean search within blocks
of
> text, how can i do this efficiently ?
I know it isn´t so efficient, but you can use:
SELECT *
FROM yourtable
WHERE text_column LIKE '%word%
Hi,
I have a table named t1 with a column x1 which is the primary key for
that table. There are some other tables that reference this table t1 on
x1 with foreign key constraints.
I wanted to rename the column x1 for some reason, so, I went ahead and
renamed the column x1 to y1. I was able t
Mustafa Yalcin Acikyildiz wrote:
hello.
i have a speed problem ;).
table:
title_id bigint(50),title char(200), cdate datetime
query:
select title, max(cdate) as mdt, count(title_id) as num
from entry
where (date_format(cdate, '%Y-%m-%d %H:%i:%s')
The function in whre clause forces a full table
You need to set the Foreign Key on complaint_threads if you want a cascading
delete and not on the complaints table. You will get a Foreign key error
when you run your two DDL statements as is without turning off Foreign key
checks.
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PRO
"Naim" <[EMAIL PROTECTED]> wrote:
> I have a database with several tabels. Example:
>
> Database articles:
>
> Table1:
> id
> name
> title
> tekst
>
> Table2
> id
> name
> title
> tekst
>
> Table3
> id
> name
> title
> tekst
>
> Now I want to search for a specifik title within all the database an
Have you verified the syntax from the MySQL command line?
-Original Message-
From: Marvin Cummings
To: [EMAIL PROTECTED]
Sent: 5/9/04 7:26 PM
Subject: Error creating table in MySQL 5.0
Wondering if anyone can give me some help with this error I'm getting
when trying to create this table:
Robert Ameeti wrote:
I'm a newbie trying to follow a tutorial. The tutorial says to type:
mysql employees The employee.dat file doesn't have to be in any specific location, as
long as you can read it.
To run the command above, cd into the directory with the employee.dat
file (maybe your home di
Hi All
I have a database with several tabels. Example:
Database articles:
Table1:
id
name
title
tekst
Table2
id
name
title
tekst
Table3
id
name
title
tekst
Now I want to search for a specifik title within all the database and then print the
result - how do I do that.
I have tried with:
You have to have zlib installed. This seems to be a bug, which I have
just reported. The fix is
simple: install zlib.
You can check with a simple C-program like this:
#include
#include
int main(int argc, char *argv[])
{
printf("Hello, World\n");
return 0;
}
If this refuses to compile (m
The documentation is wrong. The API for 5 hasn't been implemented yet - it
still uses the 4.1.1/4.1.2 API.
See my other posts on performance etc (should be on both the bugs and Mysql
lists). I suggest you download the latest 4.1.2 snapshot and work with that.
Kevin Cowley
R&D
Tel: 0118 902 9099
>Description:
When I do 'SHOW PROCESSLIST' on my server currently, the line for 'system user' is
as follows:
++-+--+-+-++---+--+
| Id | User| Host | db | Command | Time
"Marvin Cummings" <[EMAIL PROTECTED]> wrote:
> Can someone please advise me on how to prevent the [EMAIL PROTECTED]
> connection? This is preventing me from accessing any of my databases in
> phpMyAdmin.
ODBC is default username on Windows. You should specify username when you connect to
the MySQ
MOD returns the remainder of the division, assuming we use integer
arithmetic. I.e.:
234 / 10 = 23
Then 4 remains (234 - (10 * 23))
Or:
23 / 6: (23 - (6 * 3)) = 5
Best ragards
Anders Karlsson
Thomas Nyman wrote:
Hi All
I'm a bit perplexed..perhaps its a language thing,,but
the MYSQL reference ma
62 matches
Mail list logo
