On Thu, Mar 27, 2003 at 10:55:28AM +0100, Stephan Amann wrote:
>
> The InnoDB files are created in the standard data directory; I did not
> configure any InnoDB Option, since we are not currently using InnoDB.
>
> What's wrong? Why do I get InnoDB datafiles (ib_arch_log_00,
> ib_logfile
The content of the my.cnf (Master)
[client]
port=26001
socket=/tmp/mysql.prod.sock
[mysqld]
port=26001
socket=/tmp/mysql.prod.sock
pid-file=/nas/prod/app/mysql/etc/prod.pid
datadir=/store/prod/mysql/data
log-bin
server-id=1
[mysql.server]
basedir=/nas/prod/app/m
Hi, all
I'm experiencing a memory leak problem on a server with runs Mysql 3.23.55
with 1000 simultaneous users.
It's an athlon XP 1800 with 512 Mb ram.
Befor starting Mysql, webmin shows 350 Mb free memory, but after starting
mysql server it goes down, down, down and the server hangs for lack o
Hi,
I'm looking to purchase my own dedicated server. As standard it doesn't
come with any database support. I was considering installing mySQL. At the
moment I have mySQL running on Windows 2000 professional and everything
looks OK at the moment.
Has anyone installed mySQL on Windows 2000 s
On Friday 28 March 2003 10:37, Stephan Amann wrote:
> The content of the my.cnf (Master)
> The my.cnf of the replika:
> I don't see any InnoDB settings...? Both, Master and Replika have the
> InnoDB Files in the DataDir...
Yes right. But that silently means that InnoBD files to be created for us
On Thursday 27 March 2003 14:22, Sohail Hasan wrote:
> I am running mysql 4.0.12 on both the master and slave servers. I am
> facing the same problem with a slight variation. When I am trying to
> import my database dump on the master the replication fails and slave
> thread exits with the followi
On Friday 28 March 2003 04:39, harlan at artselect dot com wrote:
> When querying a largish (370,000 rows) table, a unique compound index
> on its three int columns performs slower (as slow as no index at all)
> than when I use the same index created without the "unique" keyword.
>
> I've repeated
On Thursday 27 March 2003 14:35, Henning Heil wrote:
Is the crash-me software what are you looking for?
Check these links:
http://www.mysql.com/information/crash-me.php
http://www.mysql.com/doc/en/Custom_Benchmarks.html
>From the latest link, a cite:
To avoid problems like this, you should p
On Friday 28 March 2003 01:02, Rich Allen wrote:
> i found in the ODBC faq how to link from mysql to access, can this be
> done in reverse? link from access to mysql?
What do you mean by that?
MySQL can be used as a backend for Access, i.e. you can create an Access
application that could be us
On Thursday 27 March 2003 07:48, rajup at hydbad dot tcs dot co dot in wrote:
> I really don't know whether it is a bug in mysql 4.0.12.
> I've downloaded 4.0.12 and installed succesfully on my PC(WIN2k with
> SPack2). I've changed the bind-address to "localhost" in my.ini and
> re-started mysql.
Greetings MySQL folk,
New to MySQL.here goes.
Have db with following tables :
Client :
ClientID | ClientName | Address | Distance | ContactName | ContactNo
Jobs :
JobID | ClientID | JobDate | JobDistance | JobWorkDone | JobTimeTaken |
JobTypeID
JobTypes :
JobTypeID | JobDesc
I need to cre
On Thursday 27 March 2003 06:18, Hridyesh Pant wrote:
> i am just new for MySql,can any body tell be from where i have to start
> learn MySql for Unix or Linux.
Take this brand new Paul's book:
http://www.mysql.com/portal/books/item-75.html
It's really excellent. That will help.
> Thanks.
Egor, all, in addition to my first posting and to clear things up a bit:
I am a little step further at the moment, in general you can say
negative testing is going beyond the borders of normal (load, stress,
fail-over, UAT, etc.) testing. Some aspects of negative testing in my
(just reached and
Don
This is more help than I ever anticipated, and
I certainly thank you very much. Let me digest / re-program
this. If there's anything I can do you for, just let
me know.
Thanks lots!
Regards,
Kelly W. Black
Linux was very clearly the answer, but what was the question again?
-Origin
Just run mysql in it's own little "jail"
with --user=mysql # or some username you add to the tables...
Regards,
Kelly Black
-Original Message-
From: Dimitar Haralanov [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 26, 2003 4:18 PM
To: [EMAIL PROTECTED]
Subject: Re: granting privileg
Hi!
On Mar 27, Martin Gainty wrote:
> Hej Michael-
>
> In order to to see 4.1 mysqladmin working
> I started to compiling the 4.1 source obtained from bitmaker
> Originally I had 1000 errors with 1000 unresolved link errors..
> I am down to about 50 on both counts
>
> God Tur-
> Martin
You, ob
Hi!
> "Stephan" == Stephan Amann <[EMAIL PROTECTED]> writes:
Stephan> Hi all!
Stephan> I've downloaded the binary distribution
Stephan> mysql-standard-4.0.9-gamma-sun-solaris2.9-sparc-64bit.tar.gz from
Stephan> www.mysql.org.
Stephan> I have a couple of databases on this installation, wit
i have deleted mysql database,
can i restore it with start defaults ?
Thanks,
Thailon, Slovakia
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I experience problems connecting to my MySQL 3.23.55 on Linux Debian from a
Windows client: through the MyODBC connection everything is fine but direct
access through development tools like Delphi/dbExpress doesn't work.
Of course, the params and privileges are correct (username,pass,port,I
On Friday 28 March 2003 11:23, Neil Tompkins wrote:
> Has anyone installed mySQL on Windows 2000 server, can you tell me your
> experiences, or should I look for another option ?
MySQL is a native win32 application and runs excellent on Win2k. It's a good
choice.
--
For technical support
On Friday 28 March 2003 11:23, DeepBlue wrote:
> I'm experiencing a memory leak problem on a server with runs Mysql 3.23.55
> with 1000 simultaneous users.
>
> It's an athlon XP 1800 with 512 Mb ram.
>
> Befor starting Mysql, webmin shows 350 Mb free memory, but after starting
> mysql server it go
On Friday 28 March 2003 13:59, Ing.Peter Misovic wrote:
> i have deleted mysql database,
> can i restore it with start defaults ?
mysql_install_db is your solution. :)
> Thailon, Slovakia
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored b
On Friday 28 March 2003 11:53, Henning Heil wrote:
> Does anyone have more 'phantasies' on that?
I think, there are no solutions that are ready for that kind of job. Maybe you
better make a 'test suite' by yourself?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensit
Hi
I have the following problem: I have a database with two fields "projectid"
and "partner". Here some data:
Projectid / Partner
1 / A1
2 / A2
2 / B2
3 / A3
3 / B3
3 / C3
4 / A1
4 / B4
...
I want to number the partners for every project, e.g.
Projectid / Partner / Partnernumber
1 / A1/1
2 /
The variables we change are the following:
set-variable = key_buffer=32Mset-variable = max_allowed_packet=1Mset-variable = table_cache=512set-variable = sort_buffer=512Kset-variable = record_buffer=512Kset-variable = max_connections = 500
It's 500 max connections and the server has 512 Kb
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi
just a question.. wondering if anyone knows how to query for Weekly data (e.g.
Week 1 , Week 3... and so forth) from a table that includes the "timestamp"
column in a format of ("-mm-dd hh:mm:ss") .
Thanks
- --
Jasmine Chua
-BEGIN PGP
hi list fellows,
os: suse linux 8.1
myqld: mysql-max-4.0.12-pc-linux-i686
i'm using innoDB and a standard my.cnf (medium) config file.
every time i start the mysqld, there are over 11 deamons running, each
one with 40MB !
the same constellation on a freebsd 4.6.2, same mysqld vers
Hi,
I've been facing problem while trying to access remote MySQL database
using PHP. It is working fine with the local database.
I did in the following way:
Created a user on the database with [EMAIL PROTECTED] identified by
'password';
Warning:
Warning: Lost connection to MySQL server duri
Hi,
I've been facing problem while trying to access remote MySQL database
using PHP. It is working fine with the local database.
I did in the following way:
Created a user on the database with [EMAIL PROTECTED] identified by
'password';
Warning:
Warning: Lost connection to MySQL server duri
The first step is to get a working example-
WARNING: you may have to compile the library to get it working on your
platform..
Good Luck,
Martin
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 28, 2003 2:08 AM
Subject: re: hi
> On Th
I can't seem to be able to create foreign keys. Here are my create
procedures and the error I am receiving.
CREATE TABLE `test1` (
`a_id` smallint(6) NOT NULL default '0',
PRIMARY KEY (`a_id`),
KEY `a_id` (`a_id`)
) TYPE=InnoDB;
CREATE TABLE `test2` (
`b_id` smallint(6) NOT NULL default
Dear Friends
First thanx for all of to ans me but
I feel that i put the question in wrong way.
Actually i created 5 databases other than default one that is mysql and test
I created the 5 different database for my client and i want to resitrct them for
particulary size limt.
So is this possibl
hi there!
i'm wondering about these sub-selects and the mysql-version peroblems
they cause!
somewhere on mysql.com is said:
sub-selects need mysql version 4.1 and up!
BUT:
i have a statement
insert into foo select bar from bartable;
this thing works if i enter it on the mysql-shell. (also wi
Hi,
ps,top,.. on Linux show threads as processes. What you see is ONE
process (mysqld) with 11 threads sharing 40Mb of memory.
Check http://www.mysql.com/doc/en/Memory_use.html
Regards,
Joseph Bueno
Gerald Fehringer wrote:
hi list fellows,
os: suse linux 8.1
myqld: mysql-max-4.0.12-pc-l
>Does the PHP user have insert authority?
grant insert,alter,select on theTable to phpuser;
you mean this? php user is the user with whom the php file connects
to the db right?
i executed every statement from the shell as that user,too!
best regards
udo
--
MySQL General Mailing List
Neil:
MySQL on Windows 2000 Server is excellent.
We have installed about client 80 systems that incorporate MySQL. Some are
running on Unix, some Linux, about a third on Windows NT Server, and the
balance (40+ systems) are running on either Windows 2000 Server or Win2K
Advanced Server.
We have n
hi joseph,
thank you, but still where is defined that it should start 11 threads ??
i don't wanna allocate so much memory for a small server !
thanks
/geri
-Ursprungliche Nachricht-
Von: Joseph Bueno [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 28. Marz 2003 15:44
An: [EMAIL PROTECTED]
Hi,
mysqld creates a few threads at startup (3, I think) plus
one thread per active connection.
The manual explains it better than myself:
http://www.mysql.com/doc/en/MySQL_threads.html
Chances are that you have 8 clients connected.
Once again, your mysql server TOTAL memory usage is 40Mb.
If this
Yeah, 'Desktop Class' cross-platform with RPC and Client/Server no less. We
have MySQL deployed on over 15+ servers across multiple OS's with clients
written in C, C++, VB and PHP. Oh yeah, I have it on my W2K desktop too!
I guess I may be being a little sensitive, but I think one should take car
If it is MYISAM:
ALTER TABLE projected
ADD COLUMN partnumber INT UNSIGNED NOT NULL AUTO_INCREMENT ,
ADD UNIQUE KEY (projectid,partnumber);
If you don't want to keep the automatic incrementing of the partnumber
for each project,
then drop the key.
Renger van Nieuwkoop wrote:
Hi
I have the follow
You have several problems.
Both tables have duplicate keys.
You don't have a (c_id) key in table2 to add a constraint to.
William Hambleton wrote:
I can't seem to be able to create foreign keys. Here are my create
procedures and the error I am receiving.
CREATE TABLE `test1` (
`a_id` smallint(
Hi, i've a problem.
I must put two Mysql server daemon on same WIN2K server, but i don't know
set two different my.ini file.
If i run the service interactively I'm able to set to the service a
different path for my.ini file, but when i start winmysqladmin he create a
new my.ini file under c:\winnt.
You did not show us your actual insert statement, but
You can not insert into a table listed anywhere in the select.
Udo Schubert wrote:
hi there!
i'm wondering about these sub-selects and the mysql-version peroblems
they cause!
somewhere on mysql.com is said:
sub-selects need mysql version
On 28-Mar-2003 Jasmine wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hi
> just a question.. wondering if anyone knows how to query for Weekly data
> (e.g.
> Week 1 , Week 3... and so forth) from a table that includes the
> "timestamp"
> column in a format of ("-mm-dd hh:mm:s
Hello!
Is there a need for adding an index to a key which already primary?
>From the dump file it would look something like this:
PRIMARY KEY (id)
KEY id (id)< Is this nescesary ?
);
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:htt
Hi,
I have MySQL running on a machine at work and a (dev) machine at home. Both machines
are running W2K. The machine at home is an old PIII with 256Meg of memory, the machine
at work is a new P4 2.0GHz with 512Meg of memory. My home machine also has a heavier
load relative to the CPU than my m
Hi!
I was wondering: is there any way to make mysql remember the last
random or to return the limit in exactly the same order?
I want to achieve a random on a result on which I use Limit in the sql.
Greetings
Victor
--
"I wish Bill Gates the best, I really do. I just think he and Microsoft
a
Hey gang, not to sure if I should be posting to this list or not but I'm
having terrible performance problems with MySQL on a high end system. I
believe I've done enough reading through the Doc's to post to this
list.
The system is a Dual 1Ghz with 2GB of Ram running Redhat 8.0, MySQL
3.23, PHP 4.
At 10:35 -0600 3/28/03, Dusty Hall wrote:
Hey gang, not to sure if I should be posting to this list or not but I'm
having terrible performance problems with MySQL on a high end system. I
believe I've done enough reading through the Doc's to post to this
list.
The system is a Dual 1Ghz with 2GB of
Hi, it seems that when there is an 'union' in a query it transforms the 'null' to '0'
when the field is a number, and more over, I think the result is wrong...
I am using the 4.0.12 mysql server for Win32 in a Windows NT server.
this is the query...
select id, name from customer
union all
select
Hi
I know that you may set max binlog size with the max_binlog_size variable.
However, is it possible to control the size of the relay-bin logs on the slave
servers as well ?
Will the relay-bin logs be deleted automaticly by mysqld or are there a
manuall procedure for doing this ?
I am running
Dusty Hall wrote:
DB queries and
inserts are taking a very long time to complete. Speeding these up
would be my goal. Here's a snippet from my slow_queries log
# Time: 030328 10:28:20
# [EMAIL PROTECTED]: acid_user[acid_user] @ localhost []
# Query_time: 17 Lock_time: 0 Rows_sent: 0 Rows_
Hi Joseph,
all connects are from localhost, no external connect and i never
saw this behavior on a bsd box ?!
thanks
geri
-Ursprungliche Nachricht-
Von: Joseph Bueno [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 28. Marz 2003 16:10
An: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Betreff: Re:
>You did not show us your actual insert statement, but
>You can not insert into a table listed anywhere in the select.
sorry,man. i should have been given you the whole thing:
here it comes:
db one with table person
(firstname,name,email,phone,fax,hashval,flag,etc...) and table hashvalue
(
It seems that the union has problems when some values returned in the
selects are nulls like in left joines. Instead of seeing Nulls the rows
inherit the value of the previous row. Which make a real mess. I did how
ever found a work around. I use
coalesce(myfield,space(30)) as myfield
anywhere a
The reason is that if 'basedir' is read from 'my.cfg' then 'bindir'
is not set to $basedir/bin but to /compile-time-dir/bin
>How-To-Repeat:
1) Install mysql in a directory other than the one for which it was compiled.
2) Configure /etc/my.cnf to work with this ne
On 28-Mar-2003 Gerald Fehringer wrote:
> Hi Joseph,
>
> all connects are from localhost, no external connect and i never
> saw this behavior on a bsd box ?!
>
FreeBSD as a default builds with it's own thread library, You'll only
see the parent server thread.
You can build the MySQL server with
Hello Everybody,
I have a MySQL server in my W2K server DNS=Network.srv. User name
'Admin' and password ='password' is for Admin purpose in Server.
Database name = 'TestDB'
IP for server = 192.168.111.2
So I set up grant
GRANT ALL on TestDB.* TO [EMAIL PROTECTED] IDENTIFIED B
No that key is not nessary
-Original Message-
From: Mattias Barthel [mailto:[EMAIL PROTECTED]
Sent: Friday, March 28, 2003 7:57 AM
To: '[EMAIL PROTECTED]'
Subject: Keys & indeces
Hello!
Is there a need for adding an index to a key which already primary?
>From the dump file it would look
I've heard some bad things about turning off swap on Linux. I think it was
on Jeremy Z.'s Blogger page. If he sees this maybe he can comment.
DeepBlue, take a look in the "support-files" directory under your MySQL
install directory. There are 4 example my.cnf files for various memory/box
configura
On Fri, Mar 28, 2003 at 06:10:55PM +0100, Vidar wrote:
> Hi
>
> I know that you may set max binlog size with the max_binlog_size
> variable. However, is it possible to control the size of the
> relay-bin logs on the slave servers as well?
I don't believe it's documented (yet?) but I seem to reme
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
thanks for your reply but let me be more specific in my question. the week()
function returns a particular week based on 53 weeks in a year. but I want to
be able to return data that exists within a particular week based on a time
period that I specify
Bruce is correct. If you need to do a query based on a time frame, try
something like
timestamp >= NOW() - interval X seconds; // where X is your value for
your timerange in the past.
If the timestamp column has a key the above addition will use it. Using
unix_timestamp or mysql functions in gener
Try the function DATE_FORMAT in this syntax
DATE_FORMAT(col,"%U");
I don't know if %U is exactly what you want but DATE_FORMAT can format
any date column into nearly any format you wish to display.
-Original Message-
From: Jasmine [mailto:[EMAIL PROTECTED]
Sent: Friday, March 28, 2003 11
On Fri, Mar 28, 2003 at 10:51:48AM -0500, Patrick wrote:
> Yeah, 'Desktop Class' cross-platform with RPC and Client/Server no less. We
> have MySQL deployed on over 15+ servers across multiple OS's with clients
> written in C, C++, VB and PHP. Oh yeah, I have it on my W2K desktop too!
>
> I guess
Hi,
I recently set up mysql 4.0.12 on my Windows2000
machine. I would like users to be able to
access/create tables with their login. I created new
users and granted them with required priviledges. The
users will also be connecting from Windows machines. I
intend to use Perl DBI and mysql-DBD modu
Hey all,
I'm using phpNewsAds and am wanting to store images in MySQL. I have this
working on my Red Hat 7.2 Box and am moving to a new server running Red Hat
7.3 and of course, after moving the database the images are not being
dispalyed. The database, however, is working.
I'm assuming that
Hey there,
I have a database where i am collecting netflow records, the number of
entries in a table after a day or so reaching toward the millions of rows
I am trying to pull hourly reports, summarizing the byte count's for the
hour previous and writing this out to a csv file
My query current
Is there a way to limit how much of the processor % any of the mysqld
processes could use ?
Regards,
--
Enrique Luis Schamann
Gerente de Infraestrutura
Salutia - Tecnologia e Saúde
Ed. Panambi
Rua Geraldo Flausino Gomes, 61 - cj. 112
04575-060 - Brooklin Novo
São Paulo, SP
Brasil
Tel.: ++55-11-
Is there a way to limit how much of the processor % any of the mysqld
processes could use ?
Regards,
--
Enrique Luis Schamann
Gerente de Infraestrutura
Salutia - Tecnologia e Saúde
Ed. Panambi
Rua Geraldo Flausino Gomes, 61 - cj. 112
04575-060 - Brooklin Novo
São Paulo, SP
Brasil
Tel.: ++55-11-3
I assumed to store the data in mysql you did something like uuencode and
inserted that data into the db?
Could the decode method be different on redhat 7.3?
-Original Message-
From: vernon [mailto:[EMAIL PROTECTED]
Sent: Friday, March 28, 2003 2:19 PM
To: [EMAIL PROTECTED]
Subject: Storin
At 10:08 -1100 3/28/03, Steve Phillips wrote:
Hey there,
I have a database where i am collecting netflow records, the number
of entries in a table after a day or so reaching toward the millions
of rows
I am trying to pull hourly reports, summarizing the byte count's for
the hour previous and w
When ever you use an index on multiple columns remember that mysql uses
the concept of leftmost prefix. I'll explain with an example from one of
your key make-ups below
If you have dest_ip and source_ip in your select statement
idx_time_dest_ip_source_ip would not work, because time is your leftm
On Fri, Mar 28, 2003 at 07:08:27PM -0300, Enrique L. Schamann wrote:
> Is there a way to limit how much of the processor % any of the mysqld
> processes could use ?
There's nothing specific to MySQL, no. But your operating system may
provide such features in a more general way.
--
Jeremy D. Zawo
At 13:07 -0800 3/28/03, Prachi Shah wrote:
Hi,
I recently set up mysql 4.0.12 on my Windows2000
machine. I would like users to be able to
access/create tables with their login. I created new
users and granted them with required priviledges. The
users will also be connecting from Windows machines.
At 18:15 + 3/28/03, Terrance Win wrote:
Hello Everybody,
I have a MySQL server in my W2K server DNS=Network.srv.
User name 'Admin' and password ='password' is for Admin purpose in
Server.
Database name = 'TestDB'
IP for server = 192.168.111.2
So I set up grant
GRANT ALL o
On 28 Mar 2003 at 10:08, Steve Phillips wrote:
> SELECT sum(bytes) FROM tb_ipdata_0303 WHERE (source_ip >
3329275903 AND
> source_ip < 3329276160) OR (dest_ip > 3329275903 AND dest_ip < 3329276160)
> AND (time > 1048802400 AND time < 1048805999);
Using "OR" like that prevents indexes from bei
Where can a newbie go to learn how design and build a database quick.
Thanks
David
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Richard Dice is a friend of mine, and has done a wonderful
tutorial on "Choosing the right database system" that I found
marvelous, at webmonkey:
http://hotwired.lycos.com/webmonkey/backend/databases/tutorials/tutorial1.ht
ml
Regards,
Kelly Black
Sprint PCS
Performance Engineering
Irvine, Ca. 9
At 04:40 PM 3/28/2003, you wrote:
Where can a newbie go to learn how design and build a database quick.
Thanks
David
David,
That's like saying to a sales person at a home center mega store,
"How do I design an build a house real quick". Well, it takes time to learn
database design and M
> I assumed to store the data in mysql you did something like uuencode and
> inserted that data into the db?
> Could the decode method be different on redhat 7.3?
>
> -Original Message-
> From: vernon [mailto:[EMAIL PROTECTED]
> Sent: Friday, March 28, 2003 2:19 PM
> To: [EMAIL PROTECTED]
>
At 04:40 PM 3/28/2003, you wrote:
Where can a newbie go to learn how design and build a database quick.
Thanks
David
David,
That's like saying to a sales person at a home center mega
store, "How do I design an build a house real quick". Well, it takes
time to learn database design and M
Can replication be compressed?
Is it already in a binary format which could not be compressed
further?
If run through openssl would that serve to compress it too?
Also, there are a couple of references to compressed client
connections in the manual. Does this work and is it indeed
compressed, o
VisioModeler does have docs on db design, but AFAIK the download edition
will not generate a MySQL database creation script from the model--you need
the Enterprise edition for that.
There is an open source database modeller, argoURL
(http://argouml.tigris.org/), that is pretty good, but it does no
On Fri, Mar 28, 2003 at 11:54:42PM +, Andy Smith wrote:
> Can replication be compressed?
Yes.
> Is it already in a binary format which could not be compressed
> further?
It's a binary format (sort of) but not compressed.
> If run through openssl would that serve to compress it too?
Yes, or
I installed mysql 4 today and ran mysqld_safe. Here is
what I get back...
[EMAIL PROTECTED] admin]# Starting mysqld daemon with
databases from /var/lib/mysql
030328 05:22:36 mysqld ended
What is wrong?
Thanks,
Joe.
__
Do you Yahoo!?
Yahoo! Pl
What's your log say?
Should be in /var/lib/mysql/.err
-jeff
On Fri, 2003-03-28 at 18:32, Joseph Bannon wrote:
> I installed mysql 4 today and ran mysqld_safe. Here is
> what I get back...
>
> [EMAIL PROTECTED] admin]# Starting mysqld daemon with
> databases from /var/lib/mysql
> 030328 05:22:3
> What's your log say?
>
> Should be in /var/lib/mysql/.err
I don't have one. But there is a mysql.sock.
J.
__
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
--
MySQL General Ma
> I face the same problem a month ago.
> see your mysql database permission; it should be 750
> (minimum) and belong to
> mysql user and group.
YEAH! That did it. Thanks a million!
Also, how do I move the var directory to another
location?
J.
The mysql.sock file is being saved at the location
below
/var/lib/mysql/mysql.sock
...which causes me to get this error...
ERROR 2002: Can't connect to local MySQL server
through socket '/tmp/mysql.sock' (2)
How can I fix this?
Thanks,
Joseph
_
I'm experienced with SQL, but new to MySql and PHP, which I'm using
together to create a dynamic web site. Right now, I'm having minor
difficulties with date formatting. It seems that when I retrieve a date
from MySQL into PHP, it shows up as a string instead of a date data
type, with format
Specify the location in my.conf or ...create a sym link in /tmp.
- Original Message -
From: "Joseph Bannon" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 28, 2003 8:50 PM
Subject: mysql.sock
> The mysql.sock file is being saved at the location
> below
>
> /var/lib/
> Specify the location in my.conf or ...create a sym
> link in /tmp.
Where is the my.conf file?
J.
__
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
--
MySQL General Mailing List
> What I mean is the permission of mysql database
> directory and data. Seems you already solved the
> problem.
Yeah, I figured out what you ment.
> issue the command 'mv /var/lib/mysql
What I ment was, when I installed mysql, I set the
prefix as /home/mysql, however, the var directory for
m
One of our servers has been acting up recently... There is about 400
databases on the machine, about 1000 requests per hour.
Every so often, once every couple days or so, the databases just disappear.
Doing a show databases command yields an empty set. Actually sometimes, it
shows 1 or 2 in there.
My mistake. my.cnf. It should be in /etc or /var/lib/mysql. If not, you can
create one.
- Original Message -
From: "Joseph Bannon" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, March 28, 2003 10:28 PM
Subject: Re: mysql.sock
> > Specify the location in my.
> My mistake. my.cnf. It should be in /etc or
> /var/lib/mysql. If not, you can
> create one.
Is the my.cnf a new thing? Before today, I'd had never
heard of it.
J.
__
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your
This is probably a real newbie question, but, since that's what I am...
Using MySQL 3.23, I have two tables, for instance:
ContestEntries: id, entrant, contestNumber, etc.
Entrant: id, name, etc.
There are multiple contests, and Entrants can enter as many as they
like. So, Entra
At 20:52 -0800 3/28/03, Joseph Bannon wrote:
> My mistake. my.cnf. It should be in /etc or
/var/lib/mysql. If not, you can
create one.
Is the my.cnf a new thing? Before today, I'd had never
heard of it.
Pretty new: 3.22.2. Only been around, oh, 5 years or so. :-)
--
Paul DuBois
http://www.k
> Pretty new: 3.22.2. Only been around, oh, 5 years
> or so. :-)
Well, looks like I've had my head in a hole.
Here is my my.cnf file contents. Can you tell me
what's wrong?
[mysqld]
datadir=/home/mysqldb
socket=/var/lib/mysql/mysql.sock
[mysql.server]
user=mysql
basedir=/var/lib
[safe
1 - 100 of 108 matches
Mail list logo
