mysqldumpslow errors

Hi! Steven == Steven Roussey [EMAIL PROTECTED] writes: Description: Steven 1. Handling of string simplification confused, crashes perl! Steven 2. Format of slow log had changed a while back, so now the Steven timing information is broken in mysqldumpslow How-To-Repeat:

Re: [Re: LOAD DATA LOCAL INFILE in Alpha 3.23.49]]

Hi! Thomas == Thomas Birchmire [EMAIL PROTECTED] writes: Thomas I tried putting --local-infile in my server script and local-infile in the Thomas /etc/my.cnf file. I also placed a number or logging cammands in the startup Thomas script hoping to catch lower level messages. There appears to

Why queries only the first SELECT statement

Hi list, I am trying to making online telephone directory search. I have an input form which has input for name and SELECT option for the area. Name of this form file is 'searchtel.php' This form parsing is done by 'searchtelparse.php' file which has query, i.e $query with 'IF' statement for

Re: Foreign keys in mysqldump?

Bob, I have now improved foreign key support so that version 3.23.50 does 1. show the FOREIGN KEY definitions when you call SHOW CREATE TABLE; this should also show them in mysqldumps; 2. preserve FOREIGN KEY definitions in ALTER TABLE and CREATE INDEX; 3. allow backquotes around column and

Re: foreign keys for relation ships

Hi! The message I sent 5 minutes ago answers also this :). I have now improved foreign key support so that version 3.23.50 does 1. show the FOREIGN KEY definitions when you call SHOW CREATE TABLE; this should also show them in mysqldumps; 2. preserve FOREIGN KEY definitions in ALTER TABLE and

MySQL database; MS SQLserver connection;

Hi there, I have a problem with MySQL and the connection to it. What I want is to connect a Visual Basic application with a MySQL database with ADO. The only problem (and maybe more) is that there isn't a ODBC driver available to connect to the database. For company security it is not possible

MySQL hangs on reqular SQL-query

Hi, I have this table: CREATE TABLE FOR_SALE ( ISBN VARCHAR(10) NOT NULL, STOREID MEDIUMINT(8) UNSIGNED NOT NULL, MYDATE DATE NOT NULL, PRICE SMALLINT UNSIGNED NOT NULL, PRIMARY KEY (ISBN, STOREID, MYDATE) ); When I execute this query: SELECT count(*) FROM FOR_SALE nothing

RE: Why queries only the first SELECT statement

* Tshering Norbu if ($location =Gasa) { Try ($location == Gasa)... :) -- Roger query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

Date for V4

I have looked at the MySQL site and can not find a revised date. I'm using V4 on a test box and it is better, but now I am putting together a production box and have to stick with V3. Is there a revised time table? snip MySQL 4.0 until it is released in beta version later Q4/2001

Re: Why queries only the first SELECT statement

On Sunday, 10. March 2002 09:53, Tshering Norbu wrote: Hi list, I am trying to making online telephone directory search. I have an input form which has input for name and SELECT option for the area. Name of this form file is 'searchtel.php' This is not a mysql problem. Go to php.net and read

LEFT JOIN problem.

Hi All, I have a curious problem with a left join:- create table foo (a int); insert into foo values(1); insert into foo values(2); create table bar1 (a int, b datetime not null); insert into bar1 values(1, '25-12-2001'); create table bar2 (a int, b datetime); insert into bar2 values(1,

RAID

Hi all! Can somebody give me an intro into using MySQL over RAID array or direct me to a good resource on the net. I also want to know what type of tables support RAID. Is it only MyISAM tables? Thanks. Riz - Before

mysqld -- chroot and user options

Sorry if this is stupid question but how do you get both of these options to work at the same time. using mysql 4.0.1 on RedHat Linux 7.2 I have: /etc/passwd .../jail/etc/passwd with mysql defined as a user in both. mysqld will run chroot if user=root or it will run as user=mysql if not

An opinion about indexes

Hi, I need your opinion about optimizing this query... I would really appreciate your help on this: The following table saves data about views to certain object identified by (cod-campanha,cod_tema,cod_canal,tipocanal,localizacao,seccao) from users. Each tuple

Re: LEFT/RIGHT Join?

Try: select t1.player,t1.game,t1.points,t1.ppg,t2.team as team_name from sc_scoreleaders as t1 left join sc_seasonstanding as t2 ON t1.team=t2.id You don't need to join sc_scoreleaders 2 times... Better: select t1.player,t1.game,t1.points,t1.ppg, ifnull(t2.team,No Team) as team_name

RE: Order by list?

George, What I would do is include an auto_increment column in the table and order the select queries by that column. I don't know of a way of doing what you want with existing data. John Lodge -Original Message- From: George Marnellos [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March

Order By and Use Index

Hi all, I have a table like that table1: field1 field2 . . . where : field1,field2 is the primary key. When I make this query: SELECT * FROM table1 USE INDEX(PRIMARY) I get a different result, if I make this: SELECT * FROM table1 ORDER BY field1,field2 Why? Is not

Re: MySQL++ samples are not working?

Radhakrishna Mohan Tadepalli writes: Does anybody tried MySQL++ samples? I guess they are not working. Any help is appreciated -Radha Hi! They should all be working. Supported compilers : * GNU 2.95.* and 3.* * Compaq 6.3 * VC++ 6.0 (custom*.cc examples do not work) * BC++ 5.* --

Conflicting results problem with MySQL/PHP

Hi all, I'm having a small problem with a biggish query. The query: $Itemlistquery= select [a whole load of fields from 3 tables] ending with ; $Itemlistquery.= transactions.Pdownload ; $Itemlistquery.= from bib_extract,scanrates,transactions where ; $Itemlistquery.= (transactions.CourseID =

Re: Multiple languages (was Re: Cyrillic characters)

On Mon, 2002-03-11 at 23:39, Joel Rees wrote: Sort of off topic, but here goes: Jim Philips wrote: I am trying to understand how to store both Latin and Cyrillc characters in a database. I built in support for koi-8 and win1251, but I don't seem to be getting real support for

Re: site search

Thanks Kim and Georg, but I want to do this myself! Ok it may be hard, but i'm confident I have taught myself an awful lot by having a 'difficult' project on the go so, bearing that in mind, can I re-ask my question! thanks again incidently I am making a SITE search, not a web search

RE: site search

I'm with you on that. Many times we preach against reinventing the wheel, but sometimes doing that can help you learn an awful lot about the wheel. I also find that some of my best learning comes from taking on a hard project and just trying to make my own solution to it. Anyway... You might

RE: Foreign keys in mysqldump?

Heikki, You are the man! I am glad you are addressing these issues in 3.23.50. They will make foreign key support in MySQL much more robust (in my opinion, anyway..) Is the .50 release available yet? If not, do you have a timeline for when it will be, and when it would be recommended to use

Re: Bug in MySQL privilege system?

Harald Fuchs writes: [This is for MySQL 4.0.1 alpha on Linux 2.2.18-SMP, if it should matter] Either I misunderstand the manual, or I found a small bug. Consider the following command sequence: mysql -e 'CREATE DATABASE t1' mysql t1 -e 'CREATE TABLE t1 (id INT)' mysql -e 'GRANT

Re: Foreign keys in mysqldump?

Bob, thank you! I believe 3.23.50 will be out in two weeks. It is a stable version. The changes in foreign keys were actually rather small. I hope they do not degrade .50 to the beta category. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at

Re: Foreign keys in mysqldump?

On Tue, Mar 12, 2002 at 11:50:12AM +0200, Heikki Tuuri wrote: : Bob, : : I have now improved foreign key support so that version 3.23.50 does : : 1. show the FOREIGN KEY definitions when you call SHOW CREATE TABLE; this : should also show them in mysqldumps; : 2. preserve FOREIGN KEY

Re: Foreign keys in mysqldump?

Philip, -Original Message- From: Philip Molter [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: Bob McLaughlin [EMAIL PROTECTED]; MySQL Mailing List [EMAIL PROTECTED] Date: Tuesday, March 12, 2002 4:21 PM Subject: Re: Foreign keys in mysqldump? On Tue, Mar 12, 2002 at

error logging

Jerrad, Tuesday, March 12, 2002, 12:52:00 AM, you wrote: JP Why doesn't mysql have a --err-log option? JP Are at the *very* least send it's output to STDERR instead of STDOUT? mysqld writes all errors to the 'mysql.err' file (in Windows) or to the stderr, that is redirected by safe_mysqld to

mysql server can't work.

Äþº£½¢, Tuesday, March 12, 2002, 7:47:34 AM, you wrote: Ä The mysql server can't work.Anyone know what will I do? 1. What OS do you use? 2. How did you install MySQL? (binary or source distribution) 3. How did you start MySQL server? 4. What type of error did you receive? (check 'mysql.err' or

Re: mysql with java

Hi, Denny wrote: Hi, Is there any examples on developing a java interface with mysql? Do you want to develope a JDBC API with MySQL? If no and you want to develope a Java Program using JDBC API with JDBC Driver for MySQL, please see this web site.

Re: MySQL database; MS SQLserver connection;

How about trying to avoid using ODBC? Check out: http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=22472lngWId=1 or http://www.icarz.com/mysql/ Craig At 10:53 AM 3/12/2002 +0100, you wrote: Hi there, I have a problem with MySQL and the connection to it. What I want is to

Accessing mysql across a LAN

This is odd. I was able to access my mysql server from another machine on the LAN just fine last week. I updated the rpms from the official mysql site and am now running version 3.23.49a of the server. Access is fine from the localhost, but I get an ERROR 1130 from a host on the LAN. That host

MySQL 3.23.41 on RH7.2

--- Reçu de RVIDOI.BUNTERMA 04 72 96 57 7712/03/02 16.32 All, Installed MySQL as part of my setup. Server is running, I can connect as root with no password. I attempt : mysqladmin -u root -p password 'newpassword' I get : Enter password : blahblahblah root@localhost rejected I

mysql client seems to preffer fs socket over --port=

Description: mysql command line client seems to favor local sockets for connections, even when -P or --port are used. I wish to have mysql connections tunneled through ssh. This is complicated by the fact that I'm running mysqld on the remote host and the local host.

RE: MySQL 3.23.41 on RH7.2

You could just log on and use update on the user table... Or try entering a blank password? Simon -Original Message- From: BUNTER MATTHEW [mailto:[EMAIL PROTECTED]] Sent: 12 March 2002 15:32 To: [EMAIL PROTECTED] Subject: MySQL 3.23.41 on RH7.2 --- Reçu de RVIDOI.BUNTERMA 04 72

RE: MySQL 3.23.41 on RH7.2

--- Reçu de RVIDOI.BUNTERMA 04 72 96 57 7712/03/02 16.45 I tried the blank password by hitting enter instead of entering text with no luck - same rejection. I shall try updating the table. I thought that passwords could only be changed with mysqladmin. The password will be unencrypted

mysql-4.0.1-alpha: small build glitch on DEC Alpha OSF/1 4.0: snprintf use, and a patch to fix it

Description: A build of mysql-4.0.1-alpha on DEC Alpha OSF/1 4.0 failed like this: gcc -O3 -DDBUG_OFF -o ft_dump ft_dump.o libmyisam.a \ ../mysys/libmysys.a ../dbug/libdbug.a \ ../strings/libmystrings.a -lpthread -lmach -lexc -lz -lm \

Order By and Use Index

Javier, Tuesday, March 12, 2002, 3:04:21 PM, you wrote: J I have a table like that J table1: J field1 J field2 J . J . J . J where : J field1,field2 J is the primary key. J When I make this query: J SELECT * FROM table1 USE INDEX(PRIMARY) J I get a different result, if

RE: MySQL 3.23.41 on RH7.2

BUNTER, Tuesday, March 12, 2002, 5:45:00 PM, you wrote: BM I tried the blank password by hitting enter instead of entering BM text with no luck - same rejection. I shall try updating the BM table. I thought that passwords could only be changed with BM mysqladmin. The password will be unencrypted

Inserting strings containing only spaces fails?

Hello, Appareantly it's impossible to insert a string, consisting entirely out of spaces, in a textual field (I've tried varchar(19) and char(2) types, they both don't work). MySQL doesn't complain about it, but it trims the strings down to the empty string. If I try a select searching for

Running a script using MySQL++

All, I tried to run a script using MySQL++, but the procedure threw an exception stating that there's something wrong with the syntax. I did the following: Connection conn; Query query(conn); Result result; conn.connect(dbase,host,user,passwd); query source batch.sql; //most likely the

RE: Running a script using MySQL++

* Thi Cao dropt database if exists sample; ^ Don't know if this is the reason for your problem, but it should be 'drop'. -- Roger query - Before posting, please check: http://www.mysql.com/manual.php (the manual)

RE: innodb monitor

Hi, you can see the monitor's output in the logfile. In my case (mandrake linux), it is in /var/lib/mysql and I do: tail -f /var/lib/mysql/SERVERNAME.err Also, where do I designate autocommit = 0; Use SET AUTOCOMMIT = 0 as a SQL query. Just issue it where you do your SELECT, UPDATE etc.

RE: Running a script using MySQL++

sorry, careless typing, but that's just a typo -Original Message- From: Thi Cao [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 10:48 AM To: MySQL Subject: Running a script using MySQL++ All, I tried to run a script using MySQL++, but the procedure threw an exception stating

GROUP by multiple columns [id:fns]

Hi folks, I need a select groupped by more than one field like: SELECT a, b, c, SUM(d) FROM a GROUP BY CONCAT(a,b) - but it doesn't work (MySQL 3.22). Is it poissible somehow? cu, fns -[ mailto:[EMAIL PROTECTED] http://www.megaram.hu/~fns icq:878397 ]- -[ Zavart erzek az

RE: Running a script using MySQL++

that's just a typo in the email message, however the script itself is correct -Original Message- From: Thi Cao Sent: Tuesday, March 12, 2002 11:00 AM To: Thi Cao; MySQL Subject: RE: Running a script using MySQL++ sorry, careless typing, but that's just a typo -Original

Re: Foreign keys in mysqldump?

InnoDB Hot Backup-0.33 beta is now available for Windows NT/2000/XP and Linux. Any plans for Solaris by the May 2002 release date? From: Heikki Tuuri [EMAIL PROTECTED] The beta testing of InnoDB Hot Backup (a non-free add-on tool) started on Monday. If you want to take part in the beta

mysql client errors

i am having a problem with mysql-3.23.49. just the client seems to be having issues. it segfaults and core dumps, on this one machine. if i move it to another machine, it works fine. so im pretty sure its not a bug. anyway here is what i have found: mysql-3.23.49 gcc 2.95.3 gnu make 3.79.1 gnu

RE: GROUP by multiple columns [id:fns]

SELECT a, b, c, SUM(d) FROM a GROUP BY a,b this will not work however because c isn't contained either in the group by or a function. Try either: SELECT a, b, c, SUM(d) FROM a GROUP BY a,b,c or SELECT a, b, max(c), SUM(d) FROM a GROUP BY a,b depending on your needs -Original

User / Group Permissions

Does MySQL support creation of groups so you can grant specific permissions to a group of users instead of having to do this to each individual user? Jason Joines -

creating a password field..

Hi, i'd like to create a password field like in the user table in the mysql database. The data would need to be encrypted. Can mysql do the whole job. I would need it ideally to automatically decrypt it for me when I do a select.. any suggestions - code example would be really helpful..

RE: User / Group Permissions

Some use of the Host table in db mysql mite do what you need? Simon -Original Message- From: Jason Joines [mailto:[EMAIL PROTECTED]] Sent: 12 March 2002 17:25 To: MySQL Users Subject: User / Group Permissions Does MySQL support creation of groups so you can grant specific

Re: Changing Default for Not Null to NOTHING

Beings as I haven't gotten an answer to this, is there a better place to find information on this? - Original Message - From: David M. Peak [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Friday, March 08, 2002 1:03 PM Subject: Re: Changing Default for Not Null to NOTHING I

mysql slave status

Does anyone have a script to check on the replication status of the slave to make sure it isn't falling too far behind? Thanks, Dave Turner sql - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: Running a script using MySQL++

Thi Cao writes: All, I tried to run a script using MySQL++, but the procedure threw an exception stating that there's something wrong with the syntax. I did the following: Connection conn; Query query(conn); Result result; conn.connect(dbase,host,user,passwd); query source

RE: creating a password field..

Peter, I have no idea what your front end is, and this is what will do the actual encryption, all mysql does is holds the data. So whatever your front end programming language is, it will have to do the encryption. Below is the link for php encryption

Losing connection during a REPAIR TABLE

Description: I am not subscribe to this list so please cc me in your reply. I created a ~5GB table full of large (TINY|BIG)TEXT fields in it. This is a fresh build and there has been no activity except for the following: 1) Record inserts from flat file parsing. 2) OPTIMIZE TABLE wich died in

Re: Re: Feature idea inspired by bug report

Hi! Ken == Ken Menzel [EMAIL PROTECTED] writes: Ken Hi Monty and Sasha, Ken Just a quick not to say that's such a great idea that Monty even Ken thought of it before! Monty and I discussed this last September, I Ken hope we could get something like this in 4.1 Ken Just a vote! I have

Text Limitation

Can any one tell me what is the text limitation for mySQL?? -- Shaj Miah Cheif Information Officer t. 718.599.7775 e. [EMAIL PROTECTED] www.Diversityforhire.Com The Space And Place For Work Culture -- - Before posting, please

MySQL not using Index?

This is probably indexed wrong, so I thought I would put it out to the list to see if it is.. or if I 'm just going to have to live with it. Anyway, I have two tables I'm joining together, and MySQL is not using the index on the column in the second table I'm joining on. Here is the explain and

Re: creating a password field..

From: Peter Gibbons-BU [EMAIL PROTECTED] Hi, i'd like to create a password field like in the user table in the mysql database. The data would need to be encrypted. Can mysql do the whole job. I would need it ideally to automatically decrypt it for me when I do a select.. any

Re: Losing connection during a REPAIR TABLE

[EMAIL PROTECTED] writes: Description: I am not subscribe to this list so please cc me in your reply. I created a ~5GB table full of large (TINY|BIG)TEXT fields in it. This is a fresh build and there has been no activity except for the following: 1) Record inserts from flat file parsing.

RE: creating a password field..

MySQL can do the whole job. The client doesn't need to do the encryption. Just use the password() function in your select and updates. --Aaron Java examples: String insertStatementStr = INSERT into users VALUES (?,?,?,?,PASSWORD(?),?,?, ?, ?); ResultSet myResultSet = stmt.executeQuery(SELECT

Re: Text Limitation

From: shaj [EMAIL PROTECTED] Can any one tell me what is the text limitation for mySQL?? The limitation for the TEXT datatype? From http://www.mysql.com/doc/B/L/BLOB.html: The maximum size of a BLOB or TEXT object is determined by its type, but the largest value you can actually transmit

Re: Inserting strings containing only spaces fails?

From: Wout Neirynck [EMAIL PROTECTED] Appareantly it's impossible to insert a string, consisting entirely out of spaces, in a textual field (I've tried varchar(19) and char(2) types, they both don't work). MySQL doesn't complain about it, but it trims the strings down to the empty string.

Re: foxpro xbase conversion

I have some code I used to convert Foxpro to XML. I've put it up for anonymous ftp at ftp://lexpar.com/pub/foxpro_conversion.zip. There's an executable, which requires only the Foxpro runtime dll's (which are redistributable). It does put out memo fields correctly. I've included the

Re: RAID

On Tue, Mar 12, 2002 at 04:04:48PM +0500, Rizwan Majeed wrote: Can somebody give me an intro into using MySQL over RAID array or direct me to a good resource on the net. I also want to know what type of tables support RAID. Is it only MyISAM tables? If you're talking about a RAID disk

strange performance problems with mysql

Hello All, I've recently installed mySQL on a RH7.2 box without any problems - it runs great. I've been testing some long running queries (full table scans, etc) under different scenarios, and get wildy differing results. Between each test case, I was flushing all tables and re-starting

mysql-4.0.1-alpha: native cc compiler build failure on IBM AIX 4.3 because of gcc'isms in source code

Description: mysql-4.0.1-alpha fails to build on IBM AIX 4.3 because of gcc'isms in the source code. A fix for that problem is supplied below. However, configure says: checking for alloca.h... no checking for working alloca.h...

Re: MySQL++ samples are not working?

Thanks for your reply. I do not have any problem in compilation. My problems are with double quote characters, single quote characters and insufficient help. Is there any way I can supress exceptions? Here is one of the problems I am facing when try to run a sample. The sample compiles with 0

Re: strange performance problems with mysql

On Tue, Mar 12, 2002 at 11:37:20AM -0800, Henry Hank wrote: Hello All, I've recently installed mySQL on a RH7.2 box without any problems - it runs great. I've been testing some long running queries (full table scans, etc) under different scenarios, and get wildy differing results.

Re: Date for V4

On Tue, Mar 12, 2002 at 10:42:37AM -, Simon Green wrote: PS sorry I know it not the most interesting on questions And it has been discussed a lot frequently, in one form or another. The bottom line is that it'll be ready when it's ready. For more details, please check the archives.

Re: MySQL++ samples are not working?

Radhakrishna Mohan Tadepalli writes: Thanks for your reply. I do not have any problem in compilation. My problems are with double quote characters, single quote characters and insufficient help. Is there any way I can supress exceptions? Here is one of the problems I am facing when try to

Re: mysql under FreeBSD 4.5 HEADSUP

Hi everyone, If you have increased your MAXDSIZ variable in FreeBSD to above 2048 the mysqld will crash on FreeBSD 4.5. Please set it to 2047 or lower: options MAXDSIZ=(2047*1024*1024) to quote a very intelligent source (Thanks Sinisa!) It happens with MySQL as it is the only one

error report

Dear Sir, This is my first time trying to use mysql. The version that I downloaded is mysql-3.23.49-win.zip. After unzipped the file and execute the Setup.exe. I installed the mysql in f: driver. After the installation, I am not able to locate the my-example.cnf file that mentioned during the

installation problem

New to MySQL. Have got RH Linux 7.2 on Intel-based processor Installed MySql from a mysql-max-3.23.49a-pc-linux-gnu-i686.tar.gz Followed the documentation instructions given in Chapter 2 online at http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Installing_binary I get

mysqlbug - installation problem

New to MySQL. Have got RH Linux 7.2 on Intel-based processor Installed MySql from a mysql-max-3.23.49a-pc-linux-gnu-i686.tar.gz Followed the documentation instructions given in Chapter 2 online at http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Installing_binary I get

Re: installation problem

Check /var/lib/mysql/hostname.err and permissions in that directory. Does the mysql user have the permission to write on that directory ? You you don't have the log error (it's very strange if you don't...), i think safe_mysqld has the option --err-log=filename (but, by default, it should be

Re: MySQL++ samples are not working?

I am using Visual C++ 6.0. Samples look like MySql++ adds double-quotes whenever required. - Original Message - From: Sinisa Milivojevic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, March 12, 2002 12:23 PM Subject: Re: MySQL++ samples are not working?

Re: Losing connection during a REPAIR TABLE

On Tuesday 12 March 2002 10:54 am, [EMAIL PROTECTED] wrote: I created a ~5GB table full of large (TINY|BIG)TEXT fields in it. This is a fresh build and there has been no activity except for the following: 1) Record inserts from flat file parsing. 2) OPTIMIZE TABLE wich died in batch caused

Re: installation problem

This is what's going on [root@coolnis-ar mysql]# Starting mysqld daemon with databases from /var/lib/mysql 020312 15:57:31 mysqld ended [1]+ Done./bin/safe_mysqld --user=mysql --err-log=my.err [root@coolnis-ar mysql]# more my.err 020312 15:56:40 mysqld started 020312

PHP/MySQL application - how to schedule server processes?

Hi there, I wonder if anyone can offer me some advice... I have developed a portal using PHP, which allows users to uploads files into their own personal storage locations. These files are stored in a MySQL database. The system also allows the users to select these files and submit them for

Re: installation problem

[root@coolnis-ar mysql]# more my.err 020312 15:56:40 mysqld started 020312 15:56:40 Can't start server : Bind on unix socket: Permission denied 020312 15:56:40 Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ? 020312 15:56:40 Aborting 020312

MySql fatal error in mysql-opt.exe

Hi, I'm trying to run MySQL ver 3.23.49 on Win98 with Apache, PHP Perl. Apache reports that PHP Perl are running OK. When I try to start MySQL, or let it start on boot, or try to use the WinMySqladmin program, I get a Windows error from MYSQLD-OPT.exe, with the usual Win98 close and details

constraints in InnoDB, or is 3.23.43b _really_ 4.0.1?

Here is an excerpt from http://www.innodb.com/ibman.html#InnoDB_distros, section 4.2: Starting from version 3.23.43b InnoDB features foreign key constraints. InnoDB is the first MySQL table type which allows you to define foreign key constraints... Now, I assumed the version number

Re: installation problem

- The default socket parameter is correct - mysqld is not running earlier - I changed the required ownership #ls -ld /var/lib/mysql/ drwxr-xr-x4 mysqlmysql4096 Mar 12 17:46 /var/lib/mysql/ # I am still getting the same #more my.err 020312 15:56:40 mysqld started 020312

Re: Losing connection during a REPAIR TABLE

On Tue, 12 Mar 2002, Sasha Pachev wrote: On Tuesday 12 March 2002 10:54 am, [EMAIL PROTECTED] wrote: I created a ~5GB table full of large (TINY|BIG)TEXT fields in it. This is a fresh build and there has been no activity except for the following: 1) Record inserts from flat file parsing.

MySQL++ samples are not working?

I am using Visual C++ 6.0 in Windows 2000. I am able to compile successfully. The following code(s) does not give output as documentation specified. Problem1 : For documentation, please look at http://www.mysql.com/documentation/mysql++/7_Specialized.html (7.7 sql_create) For example

Re: installation problem

You have a strange problem so i've searched the MySQL manual: http://www.mysql.com/doc/S/t/Starting_server.html - If you get the following error, it means that some other program (or another mysqld server) is already using the TCP/IP port or socket mysqld is

Default RPMs and RAID support

I want to use your binaries (i used to build them in my own machine, but i have followed this list and you're always saying to use yours). Just a question: is there a way of using your binaries and have Table type=RAID support ? -- dsoares (sql)

Re: install prob - different error

I re-installed MySql from RH Linux 7.2 cd and now I am getting the following [root@coolnis-ar mysql]# Starting mysqld daemon with databases from /var/lib/mysql 020312 18:29:52 mysqld ended [1]+ Donebin/safe_mysqld --user=mysql --err-log=my.err [root@coolnis-ar mysql]#

mysqlbug

Hi everybody! I am a new for MYSQL. I want to install MYSQL on AIX 4.3.2 (UNIX). And I got the following error message. Could someone can help me? Shell set MYSQL = '/adm/ac/listserv/Calendar/mysql' Shell echo $MYSQL /adm/ac/listserv/Calendar/mysql Shell

can not connet to mysql

I have this following code and mysql server running. //Connect to MySql Server try { Class.forName(org.gjt.mm.mysql.Driver).newInstance(); } catch(Exception e){ System.out.println(Can not get class Name); } try { c = DriverManager.getConnection

can not backup table

Hi, I have this following error when back up table : mysql lock tables mytable read; Query OK, 0 rows affected (0.02 sec) mysql select * into outfile '/home/myhome/dump/mytable.txt' from mytable; ERROR 1: Can't create/write to file '/home/myhome/dump/mytable.txt' (Errcode: 13) what does

Re: Languages

Hi, Dave, Glad to be of help. I hope you don't mind if I CC this rambling response to the list. Concerning The documentation is not that useful (in terms of telling me just what languages are supported) but going by the directories it seems all bar Chinese are supported. I haven't actually

Re InnoDb tables

Hi, does any1 know what is the earliest version of Mysql for Solaris, with support for InnoDB? If I am not mistaken, the version that we have is 3.23.32. Can MySql Max be added or some patch be added? This is not on a personal machine. It's on a server in my department (computer's science)

Re: MySql fatal error in mysql-opt.exe

At 22:30 12/03/02 +, Mick wrote: Hi! Microsoft(R) Windows 95 (C)Copyright Microsoft Corp 1981-1996. C:\c:\mysql\bin\mysqld-opt --standalone --console C:\MYSQL\BIN\MYSQLD~1.EXE: ready for connections Microsoft(R) Windows 95 (C)Copyright Microsoft Corp 1981-1996. C:\c:\mysql\bin\mysql

where should it put jdbc in my linux server

I have two questions about jdbc 1. which files should i down from www.mysql.com(mm.mysql.jdbc-1.2c.tar.gz or mm.mysql-2.0.4-bin.jar?)? 2. Where should i put the driver and do i need to set some env variables? Thanks -

Re: where should it put jdbc in my linux server

At 22:39 -0500 3/12/02, Jianping Zhu wrote: I have two questions about jdbc 1. which files should i down from www.mysql.com(mm.mysql.jdbc-1.2c.tar.gz or mm.mysql-2.0.4-bin.jar?)? Neither. Go to http://mmmysql.sourceforge.net and get the current version, which is up to 2.0.11 or so. 2. Where

How to set permissions?

Hello, I am trying to set permissions for a new user. The only thing this user is allowed to do is to monitor traffic reports. Normally, just SELECT would be enough. But, to show him this report, program does MERGE of several tables. In this database I have 10 static tables, all other tables

  1   2   >