Re: All Tables MyISAM and still InnoDB Datafiles?

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_logfile0,

Re: All Tables MyISAM and still InnoDB Datafiles?

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]

Memory Leak

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

mySQL on Windows 2000 Server

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

re: Re: All Tables MyISAM and still InnoDB Datafiles?

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

re: Re: Fw: Load data infile replication - 3.23.56

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 following

re: Unique compound index slower than non-unique?

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 it

re: link from Access to MySQL

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

re: MySQL connection problem

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.

Join Statement

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

re: hi

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.

Re: [OT] destructive / negative / pathology testing *help, help!*

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

RE: sum() using group, and duplicates problems...

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?

RE: granting privileges using wildcards

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

Re: Soon?

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, obviously,

All Tables MyISAM and still InnoDB Datafiles?

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, with all tables

please help me

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]

re: mySQL on Windows 2000 Server

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

re: Memory Leak

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 goes

re: please help me

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 by

re: Re: [OT] destructive / negative / pathology testing *help, help!*

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

Numbering within groups

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 / A2

re: Memory Leak

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 connectionsand the server has 512 Kb memory

weekly timestamp query

-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

multiple mysqld-max running ?

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

Problem while accessing remote database

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

Problem with Connecting remote MySQL (RH8.0)

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

Re: hi

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 Thursday

Trouble creating foreign keys

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

Re: database size

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

sub-selects and php

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

Re: multiple mysqld-max running ?

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:

AW: sub-selects and php

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

Re: mySQL on Windows 2000 Server

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

AW: multiple mysqld-max running ?

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

Re: AW: multiple mysqld-max running ?

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

Re: Merge MySQL's data directly into Acrobat forms, without programming

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

Re: Numbering within groups

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

Re: Trouble creating foreign keys

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`

More MYSQL daemon on same WIN2K server

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

Re: sub-selects and php

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

RE: weekly timestamp query

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:ss) .

Keys indeces

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:

RE: mySQL on Windows 2000 Server

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

Random result and split over several pages

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

MySQL, Snort ACID

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

Re: MySQL, Snort ACID

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

Union problem ?

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

Need help to control relay-bin log size

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

Re: MySQL, Snort ACID

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

AW: AW: multiple mysqld-max running ?

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:

AW: sub-selects and php

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

Union Problems? Me too!

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

Can't start mysql if installed outside the 'compile time' directory

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

RE: AW: AW: multiple mysqld-max running ?

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 the

How to use GRANT for Network Client?(for newbie)

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

RE: Keys indeces

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

Re: Memory Leak

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

Re: Need help to control relay-bin log size

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 remember

weekly data query

-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

RE: MySQL, Snort ACID

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

RE: weekly data query

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

Re: Merge MySQL's data directly into Acrobat forms, without programming

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 I

conencting to mysql server on windows from windows

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

Storing Images in MySQL

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

optimal selects and indexes ?

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

How to limit the mysqld process use

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.:

How to limit the mysqld processor use

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.:

RE: Storing Images in MySQL

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:

Re: optimal selects and indexes ?

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

RE: optimal selects and indexes ?

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

Re: How to limit the mysqld process use

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.

Re: conencting to mysql server on windows from windows

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.

Re: How to use GRANT for Network Client?(for newbie)

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

Re: optimal selects and indexes ?

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 being used.

About database design

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]

RE: About database design

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.

Re: About database design

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

RE: Storing Images in MySQL

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]

Re: About database design

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

compressed replication

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,

Re: About database design

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

Re: compressed replication

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

mysqld ending at start up

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!

Re: mysqld ending at start up

What's your log say? Should be in /var/lib/mysql/hostname.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

Re: mysqld ending at start up

What's your log say? Should be in /var/lib/mysql/hostname.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

Re: mysqld ending at start up

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. __

mysql.sock

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

MySql, PHP, and Dates

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

Re: mysql.sock

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

Re: mysql.sock

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

Re: mysqld ending at start up

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

Databases go away... But why?

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

Re: mysql.sock

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.conf or

Re: mysql.sock

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

embedded select / left join question

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,

Re: mysql.sock

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

Re: mysql.sock

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

Re: mysql.sock

At 21:10 -0800 3/28/03, Joseph Bannon wrote: 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? What's the full pathname? /etc/my.cnf? [mysqld] datadir=/home/mysqldb

Re: mysql.sock

What's the full pathname? /etc/my.cnf? Correct. J. __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- MySQL General Mailing List For list archives:

  1   2   >