On Thu, Jan 17, 2002 at 10:37:22AM +0530, aravind gorthy wrote:
>
> Hai,
> Where can I find the Architecture Diagram of MySQL. Just like in
> Oracle do we have a diagram which explains how MySQL works behind
> screen. I am using MySQL 3.23.44(NT) and 3.23.40 (Linux)Version
I've never seen one
Dear Gurus,
Yesterday I changed the ownership of /var/lib/mysql to
user mysql
chown -R mysql /var/lib/mysql
Then I started the mysql server with command
/usr/bin/safe_mysqld --skip-grant-tables
The daemon started without crashing immediately.
I then could get into mysql prompt
As per manual i
Hai,
I am using MySQL with TOMCAT and JSP for development
purpose.
1. Every morning without restarting the tomcat
server, i am unable to connect the MySql Database.
What might be the problem..
I did't get this type of problem in Oracle & SQL server.
2. While Running Tomcat Server , I Loose Dat
Hi All,
I just installed resin-cmp-1.0.5 with Apache1.3.22 and mysql3.23.47. I
used m.mmysql.2.0.8 JDBC driver with the following config segment in my
resin.conf:
jdbc/test
javax.sql.XADataSource
The initialization servlet did create and populate tables into
Hai,
Where can I find the Architecture Diagram of MySQL.
Just like in Oracle do we have a diagram which
explains how MySQL works behind screen.
I am using MySQL 3.23.44(NT) and 3.23.40
(Linux)Version
Thanks and Regards
Aravind
Aravind Gorthy,
VisualSoft Technolgies,
Hyderabad-India.
_
Howdy,
Does anyone know of a good conduit and supporting Palm-side software that
will allow me to cart a small database around in my Palm, and sync it with
my MySQL server through ODBC? Surely someone must be doing this but I'm
having a heck of a time finding the software for my Palm V. My desk
At 11:13 +1000 1/17/02, Mr Aaron Brandis wrote:
>Hi everyone
>
>This is the first time I have posted to this list and I was wondering if
>someone could answer my question. I know you can run commands from a
>shell prompt (such as unix...) like:
>
>shell> mysql -e 'SELECT * FROM table' database
>
try calling session_start() as the very first thing in your php script.
- Original Message -
From: "René Fournier" <[EMAIL PROTECTED]>
To: "PHP General" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, January 16, 2002 7:41 PM
Subject: Re: [PHP] Mac OSX !?!?!?
> Somebody sugges
Somebody suggested I post the source--good idea! So here it is... The
header.inc file, in its entirety:
Site :: Jupiter :: Europa
Europa"; }
if ($table) { echo " : Tables"; }
Somebody suggested I post the source--good idea! So here it is... The
header.inc file, in its entirety:
Site :: Jupiter :: Europa
Europa"; }
if ($table) { echo " : Tables"; }
I have a bit more info. The only thing I could think of that could
create a constraint problem was that the two columns being grouped on
have some data in common.
ie., there could be two records like this:
src dst
=== ===
9.9.9.9 aaa
bbb 9.9.9.9
>From my limited
From the innodb.com site (bugs & fixes):
>On Linux x86 you must be careful you do not set memory usage too high.
glibc will allow the process heap to grow over thread stacks, >which
will crash your server. Make sure
>innodb_buffer_pool_size + key_buffer +
>max_connections * (sort_buffer +
Can anyone please explain what the subject error means? Full details are
below. Have tried searching and not come up with anything.
Thanks!
Darryl Luff
[EMAIL PROTECTED]
When running this query:
select src as Source, dst as Destination, count(*) as Drops
from data
where (action in ('drop', '
On Tue, Jan 15, 2002 at 10:59:07PM -0500, Wendell Dingus wrote:
>
> I'm fairly certain this is a bug. It's on 3.23.46-max and the
> changelog for .47 doesn't mention it.
>
> I have 2 servers using replication. Server1 is used by client
> machines and all updates are to it. Server2 stays in perfec
Won't this handle half of your issues?
http://www.mysql.com/doc/S/e/Security.html
If you want to restrict the number of connections for a single user, you can
do this by setting the max_user_connections variable in mysqld.
nickg
-Original Message-
From: Dave Dyer [mailto:[EMAIL PROTECT
When I try to use MySQL 3.23.38 on my RH7.0 Alpha system, the only way I can
create and access tables is as a root user. BUT --- I don't need to be
logged in as root to become root user, it will let anyone be root with the
command: mysql -u root
I tried granting permissions for users, but it m
Hello,
I'm using the 3.23.46 mysql binary kindly supplied by Marc Liyanage
(www.entropy.ch/software/macosx/) on OS X 10.1.1.
Maybe 1 out of 5 tries mysqladmin shutdown fails, timed-out waiting for
the pid file it says.
mysqladmin doesn't return and I have to either use ^C or open a new
window
Hi everyone
This is the first time I have posted to this list and I was wondering if
someone could answer my question. I know you can run commands from a
shell prompt (such as unix...) like:
shell> mysql -e 'SELECT * FROM table' database
for a simple select query and
shell> mysqlimport --loca
Kind of hard to say without source code for the session part.. Although the
MySQL warnings, I got those because MySQL does not automatically start in
OSX, if you know it's started then Im not sure, but if not.. go here to get
the autostart utility:
http://www.entropy.ch/software/macosx/mysql/
T
Can someone PLEASE explain why I get the following error message under
OSX (PHP+MySQL), but not under Windows ME or Linux?
Warning: Cannot send session cache limiter - headers already sent
(output started at
/Users/rene/Sites/smartslitters/jupiter/europa/header.inc:6) in
/Users/r
Can someone PLEASE explain why I get the following error message under
OSX (PHP+MySQL), but not under Windows ME or Linux?
Warning: Cannot send session cache limiter - headers already sent
(output started at
/Users/rene/Sites/smartslitters/jupiter/europa/header.inc:6) in
/Users/r
Hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Jeremy Zawodny writes:
>> According to what I read in the manual, I'm lead to believe that MySQL
>> on Windows can read from either C:\my.cnf or systemdir\my.ini. Which
>> will it read first?
>>
>> The manual also s
All,
Please disregard this "Summary: Board Meeting" message. It was sent to
the public mailing list in error. This message was NOT at all meant for
the public mailing list.
Please except my apologies for the intrusion.
Matt Wagner, MySQL AB
--
For technical support contracts, visit https:
I agree with you, sometimes my server experiences some DoS and because MySQL
cannot handle all that connections, the load goes really high and we can't
do anything :(
- Original Message -
From: "Dave Dyer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 16, 2002 11:17
On Wednesday 16 Jan 2002 8:50 pm, Hamlin Nicholas-qa568 wrote:
> >On Wednesday 16 Jan 2002 8:35 pm, Hamlin Nicholas-qa568 wrote:
> >> I can't get table-specific grants to work.
> >
> >
> >
> >Have you "flush privileges" ?
>
> Yes. That didn't change it.
>
I think I've got it, from the manual sec
Mysql in a shared environment is prone to punish all clients
with "too many connections" errors if one client is hyperactive.
There seems to be no way to deal with this within the standard
framework.
This could be dealt with by adding "max_connections_per_ip" and
"max_connections_per_user" to p
Below are two tables..
How can table 'regs' populate 'type' from table
'equip'??
$sth=$dbh->prepare (" CREATE TABLE equip (
typevarchar(255),
type_id smallint unsigned not null auto_increment,
primary key (type_id) ) ");
$sth->execute ();
$sth->finish
running isamchk -eis and -o gives me following
output
1) impossible length!!! does anyone got this before?
2) recordspace used: 100% ??? what does this mean?
I have plenty of space on my hard drive
# isamchk -o trend_data
- recovering ISAM-table 'trend_data.ISM'
Data records: 2371874
Guto,
what version of MySQL you are running and on what operating system and
version?
Please upgrade to the latest 3.23.47. Many bugs in earlier versions have
been fixed.
Starting from 3.23.44 you have the following forced recovery option which
you can use to dump your tables from a corrupt dat
How did you add the users?
If you inserted them into the user table, you are asking for trouble
unless you
understand exactly what you are doing. That is why the GRANT and REVOKE
statements were added.
Since you did not use 'identified by "somepassword"'
I'm not sure if you set one, in which case
>On Wednesday 16 Jan 2002 8:35 pm, Hamlin Nicholas-qa568 wrote:
>> I can't get table-specific grants to work.
>>
>
>
>
>Have you "flush privileges" ?
Yes. That didn't change it.
Nicholas
-
Before posting, please check:
htt
After some trial and [much] error, I finally have the latest version of
PHP (4.0.6??) and MySQL running under Mac OSX 10.1.2. And they seem to
be working... sort of.
The only problem is when I try to load some pages that use the PHP
Session ID function. Now, these exact pages--the whole site i
On Wednesday 16 Jan 2002 8:35 pm, Hamlin Nicholas-qa568 wrote:
> I can't get table-specific grants to work.
>
Have you "flush privileges" ?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
h
All,
Below is Marten's IRC summary of the recent MySQL AB Board Meeting that
he attended.
14:04:00Kaj asked about the board meeting, so here we go with
a fresh report
14:04:12 * Kaj listens eagerly
14:04:13SUMMARY: Board meeting went fine
14:04:52BUDGET: Board will
I can't get table-specific grants to work.
(FIRST: I log in as an administrator and run the following command:)
mysql> GRANT SELECT, INSERT, UPDATE, DELETE ON myDataBase.watch TO '%';
Query OK, 0 rows affected (0.00 sec)
mysql> SELECT * FROM tables_priv;
+--++--++
Dear folks,
It´s the first time I´m using this list and now I got a really big
problem. It´s the fourth time the error below hapens to my server and
every time it happened I had to process back my backup file. I´ve been
working all day long and I don´t wanna loose the information this time.
How ca
Sorry, I just re-subscribed just to ask this question and didn't actually
read any of the messages. Thanks for pointing this out.
B
On Wed, 16 Jan 2002, Marinos wrote:
> http://lists.mysql.com/ (the list archive)
>
> (This is at the end of each email)
>
>
>
> - Original Mess
http://lists.mysql.com/ (the list archive)
(This is at the end of each email)
- Original Message -
From: "Ben Olasov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 16, 2002 9:40 PM
Subject: searchable archives of mysql list
> Hi,
>
> There used to be
This did the trick. Thanks Nod and everyone else!
-Original Message-
From: nod [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 16, 2002 2:02 PM
To: David Burklin
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL newbie question
On Wednesday 16 Jan 2002 7:36 pm, you wrote:
> Hello, and sorry
On Wednesday 16 Jan 2002 7:36 pm, you wrote:
> Hello, and sorry for the bother with what is probaby a very simple problem.
>
> I'm new to MySQL. I have just installed RedHat 7.2 Linux, and installed the
> included distribution of MySQL, which is version 3.23.41
>
> When I try to run the mysql prog
yes... at least I thought so, although I think I may not have started it
properly.
I have set it to an on state, using chkconfig --level 2345 mysqld on.
Afterwhich, if I do a chkconfig --list mysqld, it reports that mysqld is
running. However, I have found reference to using the command mysql.se
did you start mysqld ?
-Original Message-
From: David Burklin [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 16, 2002 1:36 PM
To: '[EMAIL PROTECTED]'
Subject: MySQL newbie question
Hello, and sorry for the bother with what is probaby a very simple problem.
I'm new to MySQL. I hav
Hello, and sorry for the bother with what is probaby a very simple problem.
I'm new to MySQL. I have just installed RedHat 7.2 Linux, and installed the
included distribution of MySQL, which is version 3.23.41
When I try to run the mysql program, either by itself, or with any
arguments, I get the
Hi,
There used to be a link to searchable archives of the mysql list on the
old mysql web site. Is there still a link to it somewhere?
Thanks,
Ben
-
Before posting, please check:
http://www.mysql.com/manual.php (the m
I think you need to do this:
ALTER TABLE table1 ADD FULLTEXT (column1)
I may be wrong though, and I too have a question.
Does adding the FULLTEXT index affect performance dramatically? If it does,
what is a better way to search for exact word matches in columns that may
contain thousands of wo
On Wed, 2002-01-16 at 18:51, [EMAIL PROTECTED] wrote:
> Hi there.
>
>
> I need to do this sentence:
> select * from table1 where match column1 against "word";
Try:
select * from table1 where match column1 against ("word");
> But it don´t works becouse crate the column like this:
> alter table
Hi there.
I need to do this sentence:
select * from table1 where match column1 against "word";
But it don´t works becouse crate the column like this:
alter table table1 add column1 varchar(100);
Well my question is:
How I should create the column1 to have fulltext for this query??
Thanks
Vict
I have data coming into the database from various sources.
Some of these data may be duplicated, except that there is a field
noting the data source they are coming from. I do not wish them to appear
twice, but I do wish to make a note that these records were seen in two or more
sources. As I un
> With InnoDB, FK support is in the 3.23.x branch. That's a stable
branch.
I never used innoDB before so I checked out the homepage now, but
unfortunately it says:
"InnoDB does not yet support CASCADE ON DELETE or other special options
on the constraints."
Thanks anyway, that innoDB stuff seem
On Wednesday 16 January 2002 07:28, Hamlin Nicholas-qa568 wrote:
> Easier yet, when using DBI::mysql, is:
>
> my $IncrementedID = $dbh->{'mysql_insertid'};
>
>
> When executed after the INSERT command.
Does this now work with 64-bit auto-increment fields now in DBI? As of
less than a year ago,
Salerno, Vincent writes:
> I am getting the following when trying to compile.
>
> checking if gcc PIC flag -fPIC works... yes
> checking if gcc supports -c -o file.o... yes
> checking if gcc supports -c -o file.lo... yes
> checking if gcc supports -fno-rtti -fno-exceptions ... yes
> checking if g
http://home.earthlink.net/~jaymzh666/mysql.html
Have a look at this.
Plus I gcc V3 would not work but V2 did
Hope this helps
Simon
-Original Message-
From: Salerno, Vincent [mailto:[EMAIL PROTECTED]]
Sent: 16 January 2002 15:54
To: '[EMAIL PROTECTED]'
Subject: INstall error
I
Hoffmann, Sven (thingk) writes:
> hi everybody,
>
> i am new to mysql, got it up and running nicely under macos X 10.1,
> BUT i can't stop the daemon!
> "myqsqladmin shutdown" used with correct arguments does not show any effect.
> a normal "kill" won't do either. "kill -9" is the only option to
On Wed, Jan 16, 2002 at 04:51:55PM +0100, Bruno Haller wrote:
: Hello,
:
: I did not follow mySQL development really in the last months / year, so
: I can't estimate that: When can we expect foreign key support in mySQL?
: I think it's the most important feature for me that is missing,
: cascadin
I am getting the following when trying to compile.
checking if gcc PIC flag -fPIC works... yes
checking if gcc supports -c -o file.o... yes
checking if gcc supports -c -o file.lo... yes
checking if gcc supports -fno-rtti -fno-exceptions ... yes
checking if gcc static flag -static works... -static
Hello,
I did not follow mySQL development really in the last months / year, so
I can't estimate that: When can we expect foreign key support in mySQL?
I think it's the most important feature for me that is missing,
cascading deletes and this stuff.
I know its planned in the mySQL 4 development c
Hello,
I did not follow mySQL development really in the last months / year, so
I can't estimate that: When can we expect foreign key support in mySQL?
I think it's the most important feature for me that is missing,
cascading deletes and this stuff.
I know its planned in the mySQL 4 development c
Show Tables;
-
VirtualChicagoLand.com Is Your Chicagoland Resource!
Visit: http://VirtualChicagoLand.com
On Wed, 16 Jan 2002, Bret Ewin wrote:
> I need to know how to get a list of all the tables in a database. In Oracle
> you could "select OWNER, TABLE_NAME from ALL_TABLES" to get a list
Easier yet, when using DBI::mysql, is:
my $IncrementedID = $dbh->{'mysql_insertid'};
When executed after the INSERT command.
Nicholas
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 16, 2002 9:28 AM
To: 'Ben Curran'; [EMAIL PROTECTED]
Subject:
Hi,
Because i don't like the mysql DELETE syntax, i prefer using this quick
method:
% create a new table = table1
CREATE TABLE Table3 (...)
% insert into table3 the records from table1 that aren't in table2
INSERT INTO Table3 (Table3.fields)
SELECT Table1.fields
FROM Table1 LEFT JOIN Table2 U
hi everybody,
i am new to mysql, got it up and running nicely under macos X 10.1,
BUT i can't stop the daemon!
"myqsqladmin shutdown" used with correct arguments does not show any effect.
a normal "kill" won't do either. "kill -9" is the only option to get rid of the daemon.
anything i can do to
show tables will get you a list of tables. To get the schema of tables
type 'describe '
J
Bret Ewin wrote:
> I need to know how to get a list of all the tables in a database. In Oracle
> you could "select OWNER, TABLE_NAME from ALL_TABLES" to get a list of all
> tables and their schemas. How d
I need to know how to get a list of all the tables in a database. In Oracle
you could "select OWNER, TABLE_NAME from ALL_TABLES" to get a list of all
tables and their schemas. How does one do this in MySQL?
Thanks,
Bret
-
Befor
To answer your second question about how to retrieve the auto_incremented
values:
$dbh->do("SELECT last_insert_id() AS myvalue");
execute the above IMMEDIATELY after inserting the record
-Original Message-
From: Ben Curran [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 5:5
Skip the -p.
You have no current password .
Jay Paulson wrote:
>I'm trying to change the root password for mysql. This is the first time
>I've tried to change the password and I can't get it to work. Below is the
>error message I get:
>
>[root@localhost bin]# ./mysqladmin -u root -p password '
If you have just finished installing, then root has no current password
and you can leave out the -p altogether:
root@localhost bin]# ./mysqladmin -u root password 'new-password'
good luck
Richard Ward
>>> "Jay Paulson" <[EMAIL PROTECTED]> 01/16/02 12:57AM >>>
I'm trying to change the root pa
Vernon A Webb writes:
> I'm sorry if I'm bothering people, some times I get the
> feeling that I am, so please let me know if I'm out of line.
>
> So now I've figured out that I need to use the
> skip-show-database option which I have added to the my.cnf
> file under [mysqld]. When I do this n
Ryn writes:
> Has anyone received the following [Exhibit 1] when building mysql 3.23.47 on
> Solaris 8? I am following
> the directions from the source installation web page on mysql.com.
>
> Thanks for any info,
>
> Ryan
>
> [Exhibit 1]
> gcc -DUNDEF_THREADS_HACK -I./../include
Hi!
As it has been asked by several users, there is finally a mysqlgui
binary for the SPARC Solaris 2.8.
It is as static as possible. The only dynamically linked libraries are
those for which Sun does not supply static variants.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \
* Anders Bjarby
> Jag har problem med en enkel SELECT DISTINCT, på ett enda fält i en enda
> tabell. Har jag missat något mycket grundläggande eller är det en BUG?
I would suggest you use english on this list... :)
> | indate| timestamp(8) | YES | | NULL||
I t
Jag har problem med en enkel SELECT DISTINCT, på ett enda fält i en enda
tabell. Har jag missat något mycket grundläggande eller är det en BUG?
mysql> repair table faktura_history;
+++--+--+
| Table | Op | Msg_type | Ms
Hello!
My MySql server on RedHat 6.2 restarts itself. In the
MySql log writes:
Number of processes running now: 0
020116 14:16:16 mysqld restarted
020116 14:16:17 Can't start server: Bind on TCP/IP
port: Address already in
020116 14:16:17 Do you already have another mysqld
server running on po
Hi!
> "Miguel" == Miguel Angel Solorzano <[EMAIL PROTECTED]> writes:
Miguel> At 12:13 12/01/2002 +0100, Carl Troein wrote:
Miguel> Hi!
Miguel> Thanks you for the bug report I was be able to repeat
Miguel> in the 4.0.1 Windows release too.
Miguel> Regards,
Miguel> Miguel
>> CREATE TABLE t
Vernon,
> I'm using the:
> LOAD DATA LOCAL INFILE "/home/filename.txt" INTO TABLE list;
> which works just fine. Only problem is the date column
> which is formatted as such "4/11/1970" comes out as "-
> 00-
> 00"
>
> The date field is setup as Field: "s_date", Type: "date",
> Null, "YES", Ke
Hi,
I also noticed one thing , will the entry in the file
/etc/hosts make a diffrenece.
In Red Hat it is
127.0.0.1 localhost
But in Slack it is
127.0.0.1 prasad( which is my name)
Regards,
Prasad
--- Prasad Paranjape <[EMAIL PROTECTED]> wrote:
> Hello gurus,
>
> I have Slackware 8.0 and RHL
> when as root I give command
> /usr/bin/safe_mysqld &
> It gives me following messages:
> Starting mysqld daemon with databases from
> /var/lib/mysql and on the next line it says
> mysqld ended.
What does /var/lib/mysql/`hostname`.err say?
--
Hello gurus,
I have Slackware 8.0 and RHL7.1 both on my Linux
box.
In Red Hat mysql is working smoothly but I am having
having following problems in Slack8
In Slack8 mysql is installed as a per of standard
installtion but not under /usr/local.The scripts are
in /usr/bin and includes in /usr/inclu
77 matches
Mail list logo
