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
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?
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 RHL7.1
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, Key: BLANK, Default:
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 t1 (txt
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
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 |
* 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... :)
cut
| indate| timestamp(8) | YES | | NULL||
I
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,
__ ___ ___ __
/ |/ /_ __/ __/ __
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
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 now
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 password
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
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:59
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
-
Before
show tables will get you a list of tables. To get the schema of tables
type 'describe tablename'
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.
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 solve
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
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 of
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
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
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...
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,
:
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 get rid of
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
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 gcc
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, DBI
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 seems
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
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
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 table1 add
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
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
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
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
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
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 program,
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
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 a link
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 Message
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
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;
All,
Below is Marten's IRC summary of the recent MySQL AB Board Meeting that
he attended.
14:04:00 marten Kaj asked about the board meeting, so here we go with
a fresh report
14:04:12 * Kaj listens eagerly
14:04:13 marten SUMMARY: Board meeting went fine
14:04:52 marten
On Wednesday 16 Jan 2002 8:35 pm, Hamlin Nicholas-qa568 wrote:
I can't get table-specific grants to work.
snip
Have you flush privileges ?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
On Wednesday 16 Jan 2002 8:35 pm, Hamlin Nicholas-qa568 wrote:
I can't get table-specific grants to work.
snip
Have you flush privileges ?
Yes. That didn't change it.
Nicholas
-
Before posting, please check:
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
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
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
Below are two tables..
How can table 'regs' populate 'type' from table
'equip'??
code
$sth=$dbh-prepare ( CREATE TABLE equip (
typevarchar(255),
type_id smallint unsigned not null auto_increment,
primary key (type_id) ) );
$sth-execute ();
$sth-finish
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
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.
snip
Have you flush privileges ?
Yes. That didn't change it.
I think I've got it, from the manual section 4.2.9 :-
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 PM
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
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 seems to say that
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
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
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
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/
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 --local
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
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
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
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 perfect
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',
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 +
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
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
for a
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
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.
Somebody suggested I post the source--good idea! So here it is... The
header.inc file, in its entirety:
html
head
titleSite :: Jupiter :: Europa/title
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1
link rel=stylesheet href=../../common/styles.css type=text/css
?php
//
Somebody suggested I post the source--good idea! So here it is... The
header.inc file, in its entirety:
html
head
titleSite :: Jupiter :: Europa/title
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1
link rel=stylesheet href=../../common/styles.css type=text/css
?php
//
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 suggested I post
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:
resource-ref
res-ref-namejdbc/test/res-ref-name
res-typejavax.sql.XADataSource/res-type
init-param
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
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 for
75 matches
Mail list logo