RE: Frequent Table Corruption - Please Help

hi guys i am runing the rh 2.4.20-18.7smp kernel with mysql 4.0.13 and i sometimes experience problems with table corruptions when volumes become high. i'm trying different parameters for mysqld to see if the problem goes away. tom -Original Message- From: Richard Gabriel

Connection problem!!! Windows to Linux

Hi there: I need URGENT help about this .. I wrote a program application for windows which can add and delete data from this application, it working fine with my own MySQL install on the same windows OS.. Now I try to change the connection this dayabase to the server whihc runnign under

subselect question... shouldn't this work?

I am new to subselects, and what I really want is to do them in an update, but the following shows a simpler select, that also doesn't seem to work as I think it should. Advice? Do I just misunderstand how subselects are actually executed? (This is on mysql version 4.1.0-alpha-max-nt.) First,

Re: More duhh! questions

I've been having the same problem, using mysql++ with mysql 4.0.13. It works just fine entered into mysql-front or mysql.exe, but not through mysql++ Can I check the CREATE TEMPORARY TABLES privilege through the API? - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To:

Re: WG: wait_timeout in my.cnf

Moritz Steiner [EMAIL PROTECTED] wrote: I set a lot of variables in the my.cnf file, all variables are set (I checked it with show variables) except of wait_timeout. If I set the option in MySQL with option wait_status=xxx it works. How did you set the wait_timeout variable? -- For

Re: Frequent Table Corruption - Please Help

Tom, you could also try a 'stock kernel' 2.4.20, not a Red Hat one. We are running a SuSE kernel 2.4.18 and it has worked perfectly. [EMAIL PROTECTED]:~/mysql-4.1/client uname -a Linux hundin 2.4.18-64GB-SMP #1 SMP Wed Mar 27 13:58:12 UTC 2002 i686 unknown Regards, Heikki - Original

Re: genereal query log

Moritz Steiner [EMAIL PROTECTED] wrote: I want to turn on and off the general query log from time to time. Is there a possibility to do this without changing the my.cnf file and restarting the server. I thought for example set option log=ON You can do SET SQL_LOG_OFF=1; to turn off

RE: Managing big tables

Maybe you could get some speed increase for you queries by setting the record_buffer to a higher value. Because with fixed row length this buffer fills up faster too. Although I doubt that you will gain a lot... /rudy -Original Message- From: Alexander Schulz [mailto:[EMAIL PROTECTED]

RE: MySQLDump

It does not fail if some tables are not locked. But like you said, you could miss data. So the better way is first to lock, then flush and then dump the table. It does not backup the transaction log (if you mean the binary log with transaction log). Even worse, you normally have no way of telling

RE: One Big Data Base or Many Smaller Ones

Really depends on what exactly you want to achieve. But as I read the mail below, create a lot of smaller ones. If the ISP however charges you for each DB it is also easy to only create one huge DB, just do not make the table names too long. Developers are lazy in typing... :) /rudy

Re: table protection

azamka [EMAIL PROTECTED] wrote: Is there any command that we can use to view the protection on the tables??. Is there any way that we can convert read only tables to read write?. Please ehlp If you get error that table is read only, it means that: 1. table is compressed with myisampack 2.

compare longblob with binary data

hi all a question about checking the data of a longblob for equality. assume the `data` field is of type longblob. the following statement returns the image records with equal data. SELECT * FROM `image` WHERE `data`=? how does mysql performe the test. does it check the length of the blob

RE: Best practice column type for storing decimal currency amounts?

Problem is that DECIMALs are currently stored as FLOAT or DOUBLE in the DB (at least MyISAM). MySQL AB is busy with adding a true monetary type (like MONEY) to the system. What I am doing when using monetary values is putting them into floats if I can live with rounding problems or put them into

RE: Complex select statement

You are not allowed to use grouping functions in the WHERE clause. To restrict on grouped values, you have to put them into the HAVING clause. Cheers /rudy -Original Message- From: Roy Walker [mailto:[EMAIL PROTECTED] Sent: dinsdag 15 juli 2003 23:25 To: Rudy Metzger; [EMAIL PROTECTED]

switch query logging while the server is running

Description: It would be nice if general query logging could be switched on and off while the MySQL server is running, and not only at startup time. While debugging an application that uses foreign database access libraries, this would be very helpful. One could switch on logging, perform an

RE: Single Record Locking - Permanent?

I would add a flag to the record (e.g. 'user_lock'). You then have to evaluate this flag in your application. Or you can wait until 5.0 for triggers where you then can do it in the DB (or maybe not, dunno how far triggers will go). Maybe MERGE tables could help you, not sure about this though.

RE: Foreign Keys

InnoDB is using a totally different concept than MyISAM. Where in MyISAM all the data is in one file, InnoDB uses the principle of Tablespaces (like ORACLE). This puts the whole tables (and metadata) into one HUGE file (in theory. In practice this file can be split and extends can be defined of

RE: Simple newbie question - CURTIME()

Please check the manual, search for DATE_ADD(). /rudy -Original Message- From: Johannes Pretorius [mailto:[EMAIL PROTECTED] Sent: woensdag 16 juli 2003 8:01 To: [EMAIL PROTECTED] Cc: Pieter Subject: Simple newbie question - CURTIME() Good day \-=0=-=00- I have looked in the manual and

Question: using Visual Studio.NET

Hi Everybody, 1- I am trying to upsize an access database to my MySQL server on my website. I tried to get connected within access and failed. Please advise. I am using Win XP as the operating system and MS Office XP Pro. 2- How to connect a Visual Studio.NET project to a MySQL data base

Re: Simple newbie question - CURTIME()

Johannes Pretorius [EMAIL PROTECTED] wrote: I have looked in the manual and seem to be missing it or not understanding correctly, The curtime() function resturns the current server time. my problem is the clients are not in the same country as the server, thus the time of the system is 6

first time to use MySQL on MS Platform with PHP.

Dear my friends... I am trying to develop a database application with PHP Version 4.3.2, MS Window 2000, MySQL 4.0.13-nt and Apache 2. I tried to insert a record onto my MySQL but I got this error messages. What do I have to defined to overcome this problem? Notice: Undefined variable:

RE: subselect question... shouldn't this work?

These are not real subselects. You speak of a subselect when you are define a select in the FROM clause of a kwiri. If you define them in the WHERE clause, you speak of derived tables. Putting them even into the SELECT clause is something specific to MySQL (as far as I know). Ok, now this is

RE: first time to use MySQL on MS Platform with PHP.

I think it is the code in functions you need to look at or the path in one of your ini files :) Andrew -Original Message- From: Prabu Subroto [mailto:[EMAIL PROTECTED] Sent: 16 July 2003 10:14 To: [EMAIL PROTECTED] Subject: first time to use MySQL on MS Platform with PHP. Dear my

Re: switch query logging while the server is running

[EMAIL PROTECTED] wrote: Description: It would be nice if general query logging could be switched on and off while the MySQL server is running, and not only at startup time. While debugging an application that uses foreign database access libraries, this would be very helpful. One could switch

Can someone help me??

I am new in mysql I wrote this query: INSERT INTO testo (id_lingua, id_categoria, id_campo, riga, sezione, ordine, codice) VALUES (10 ,6 ,5 ,10 - 99: ,12 ,50 ,'S12IT3' ) and server reply to me: Query was empty Can someone tell me where i do mistake? Thanks a lot.. Sbandy [EMAIL

RE: Can someone help me??

Did you do that on the mysql command line? Or did you use a different client and/or API? Cheers /rudy -Original Message- From: Sbandy [mailto:[EMAIL PROTECTED] Sent: woensdag 16 juli 2003 11:21 To: [EMAIL PROTECTED] Subject: Can someone help me?? I am new in mysql I wrote this

RE: Connection problem!!! Windows to Linux

If you manually updated the tables, use flush privileges to inform the DB server of your changes. Cheers /rudy -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: woensdag 16 juli 2003 11:23 To: [EMAIL PROTECTED] Subject: Re: Connection problem!!! Windows to Linux Aric

RE: Can someone help me??

I use phpmyadmin At 11.26 16/07/2003 +0200, Rudy Metzger wrote: Did you do that on the mysql command line? Or did you use a different client and/or API? Cheers /rudy -Original Message- From: Sbandy [mailto:[EMAIL PROTECTED] Sent: woensdag 16 juli 2003 11:21 To: [EMAIL PROTECTED] Subject:

RE: Can someone help me??

Try using only single quotes rather than a mixture of single and double quotes? Andy -Original Message- From: Sbandy [mailto:[EMAIL PROTECTED] Sent: 16 July 2003 10:32 To: Rudy Metzger; [EMAIL PROTECTED] Subject: RE: Can someone help me?? I use phpmyadmin At 11.26 16/07/2003

Building from the develepment tree (windows)

I'm trying to build mysql from the development sources of mysql 4.1., retreived using bitkeeper under win2k using cygwin. I have made bk -r edit, and now I'm having a problem running aclocal: aclocal: configure.in: 450: macro `AM_PROG_AS' not found in library When I make automake --version and

Re: Simple newbie question - CURTIME()

Thanks I have figured it out, I only have to add 06 to the curtime() function as example : //== SNIP mysql select curtime() + 06 as TimePlus6, curtime() as TheCurrenTime; +---+---+ | TimePlus6 | TheCurrenTime |

Resource temporarily unavailable - What does that mean?

While accessing MySQl data base by means of perl the value of variable $! sometimes equals Resource temporarily unavailable. At the mean time everything works correct. What does that mean? ___ http://chat.bigmir.net/ - ñàìûé óäîáíûé

Re: Question: using Visual Studio.NET

You can access a mysql database within VS.Net through odbc. To do this you have install myodbc. You can get this from mysql website. After installing myodbc you have to create a new datasource. Then you can connect to mysql with the help of adodb object in vs.net. I have never tried to connect

RE: Simple newbie question - CURTIME()

WRONG! What will happen in this case? The DB is converting/casting the DATE (curtime()) into an integer and then ads 6. So what you get does not necessarily represent a valid date/time! Just replace 06 with 24 and see what you yet. Cheers /rudy -Original Message- From:

RE: Simple newbie question - CURTIME()

SELECT EXTRACT(HOUR_SECOND FROM 1999-07-02 01:02:03); -Original Message- From: Johannes Pretorius [mailto:[EMAIL PROTECTED] Sent: woensdag 16 juli 2003 13:32 To: [EMAIL PROTECTED] Cc: Pieter Subject: RE: Simple newbie question - CURTIME() Thanks \0-\-==-0-= I have seen my error and have

RE: More duhh! questions

For the following I am assuming you didn't edit that output for security reasons. What I see immediately wrong is that you are not passing a username to mysql (If you were, then there would be something like '[EMAIL PROTECTED]' there). Of course you can set MySQL up so that it does not require a

Re: CF MySQL

I am running the current version which is labeled ColdFusion MX. According to Macromedia, you need a Pentium Processor, 128M RAM Minimum, 256M RAM recommended, and 512M RAM preferred, and 350M id HD space. I was running MySQL, Apache standard secure, Sendmail for 25 people, ColdFusion MX,

RE: Connection problem!!! Windows to Linux

Aric, Are you running the linux version of your database on a shared web host? Some web hosts prevent you from using % as a host identifier for security reasons. I would also check to see if the permissions were defined at the proper level (in other words, have you set up access prvis for

date conversion

I need to convert dates in the format below into mysql date format. If I try to change the column type to date, it wipes out the data. +-+ | 26-Jan-2001 | | 26-Jan-2001 | | 15-Apr-2001 | | 1-Nov-2001 | | 31-Oct-2001 | | 26-Jan-2001 | | 22-Jun-2001 | | 23-Jul-2000 | | 1-Nov-2001 | |

Re: Frequent Table Corruption - Please Help

What do you consider high volume? Also, please keep me in the loop on this. Any configuration changes that help would be appreciated. Thanks! Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 - Original Message - From: Tom Roos [EMAIL PROTECTED] To: Richard

Re: Frequent Table Corruption - Please Help

I am running 2.4.18-smp. You said you upgraded to a 2.4 smp kernel and it solved the problem? What 2.4 version exactly did you run and was it a RedHat kernel? Thanks. Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 - Original Message - From: Joseph Bueno

RE: date conversion

SELECT concat( substring_index(DATE,'-',-1), '-', lpad( field(substring_index(substring_index(DATE,'-',2),'-',-1), 'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug', 'Sep','Oct','Nov','Dec'), 2,'0'),

AW: switch query logging while the server is running

Ok, but this only works for the current session, if I close and restart the client the settings are reset... -Ursprüngliche Nachricht- Von: Victoria Reznichenko [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 16. Juli 2003 11:19 An: [EMAIL PROTECTED] Betreff: Re: switch query logging

RE: Question: using Visual Studio.NET

You can also use my native ADO.Net provider for MySql found at http://www.bytefx.com Thanks Reggie -Original Message- From: Veysel Harun Sahin [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 5:15 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Question: using

mysqlcc bug ?

I have noticed that mySQL Control Center (beta 092), will only return back 1000 rows whenever I doubleclick on a table that I know contains an amount greater than 1000 rows. I've checked all properties in mysqlcc and nothing makes a difference. When I select the table and then choose Return all

Freelance Help Sought

Hi I'm hitting lots of brick walls after moving from an Access-driven website (before it grew big) to MySQL, which is all new to me. The problems I have centre around MySQL Server timeouts and various memory problems on the server. The client's getting jumpy and I don't have much time so I'm

RE: first time to use MySQL on MS Platform with PHP.

Prabu, This is kind of off-topic, as it is a PHP problem. ;) Those error messages are telling you that the variables you are trying to use were never initialized. This suggests to me that your PHP installation is set up with the register_globals option turned off. This means all of your

MySQL Error 28

Hi List I got an no space left on device error. Is there a way to drop an index without having MySQL create a temporary table? Can I delete the .myi file directly from the operating system? Thanks in advance Oswaldo Castro

RE: Can someone help me??

I tried but nothing At 10.52 16/07/2003 +0100, Andy Eastham wrote: Try using only single quotes rather than a mixture of single and double quotes? Andy -Original Message- From: Sbandy [mailto:[EMAIL PROTECTED] Sent: 16 July 2003 10:32 To: Rudy Metzger; [EMAIL PROTECTED] Subject:

Unable to perform Inner Join

I have 2 tables with the following fields : table : publisher field1: pub_id - Primary, int, auto table : titles field1: title_id - Primary, int, auto field1: pub_id - int Using sqlyog I noticed that the indexes had already been created for the Primary keys but according to my tutorial I also

How to terminate dead connections that are in SLEEP?

Good morning all, I have a problem with inceasing connection to my database that eventually result in connections being rejected. I know I have an application that is terminating a thread without closing the database handle. Problem is I'm waiting for the fix on some other changes. Here

Unable to perform Inner Join

Try this instead: SELECT pubishers.pub_id, titles.pub_ID FROM pubishers JOIN titles ON pubishers.pub_id = titles.pub_id HTH. ** For great Emap magazine subscription gift offers visit http://www.emapmagazines.co.uk **

RE: How to terminate dead connections that are in SLEEP?

Kill them :) http://www.mysql.com/doc/en/KILL.html Cheers /rudy -Original Message- From: PAUL MENARD [mailto:[EMAIL PROTECTED] Sent: woensdag 16 juli 2003 16:44 To: [EMAIL PROTECTED] Subject: How to terminate dead connections that are in SLEEP? Good morning all, I have a problem

RE: derived tables

I don't Mysql very well, but I would be very surprised if that was supported, based on my experience with Oracle. You need to distinguish between data and database object names. You can use derived_tables to return data, but niot names. You can't do select * from 'table', because 'table' is a

Problem with UPDATE via CGI

I'm having some trouble updating a mysql database with a perl cgi. Here's the perl: $sql = UPDATE grants SET agency2 = \$agency2\ WHERE agency2 = \$key\; $rv = do($sql) or die Can't execute $sql: $dbh-errstr\nbr; Here's the error returned in the browser: Can't execute UPDATE grants SET

Deleted index file (.MYI)

Hi Everybody I have acidentally deleted an index file (.MYI) from a table. Is there another way, besides its backup, to recover this table ? Thanks for any help

monitoring

How are you monitoring on your databases? Who has a good solution? Moritz

RE: monitoring

[snip] How are you monitoring on your databases? Who has a good solution? [/snip] What do you mean by monitoring? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Deleted index file (.MYI)

Accidently? You just asked if you could delete the .MYI table because of your disk full error. Oswaldo Castro wrote: Hi Everybody I have acidentally deleted an index file (.MYI) from a table. Is there another way, besides its backup, to recover this table ? Thanks for any help --

mysql and windows 2003

Wy can't I start the service in windows 2003 server have any one a solusion? Pleas help Ivo tompert

query

Hello: I have 2 tables t1: id age 1 7 2 6 3 7 4 8 5 9 6 4 t2: age 7 9 then I like select all in t1 without are in t2, so I need a result as follow id age 2 6 4 8 6 4 Thanks in advance -- MySQL General Mailing List For list

FW: monitoring [from an off-list reply]

-Original Message- From: Moritz Steiner [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 10:46 AM To: Jay Blanchard Subject: AW: monitoring I want to see: Number of queries Number of Connections Network Data In/Out Key writes Key reads Types of queries Temporary and

RE: How can I display images from a mySQL Database in a web page?

What I have found that works, in PHP, is using a form that allows the user to browse for a file or an image. Upon submitting the form the file is uploaded to a set location on the web server and the name of the file is added to the database. When displaying the information associated with the

Re: Problems compiling Mysql in Alpha with Tru64Unix V5.1

julio [EMAIL PROTECTED] wrote: I try to compiling Mysql V4.0 in the Alpha/Tru64 Unix V5.1a. I have installed in the Alpha C++ and C version 6.5, and gcc 3.3 and GNU MAKE 3.8. # make No suffix list. To me it looks like you are running the wrong make, not GNU one. Can help me

MySQL query problems

Hi, Not sure if the problem here is PHP or MySQL, but here we go. I am trying to do two queries on a database - one after the other, but the second one never seems to get executed. The two queries are identical except for two variables. I have checked my form and they are correct and are being

Re: query

Patricio Gigoux [EMAIL PROTECTED] wrote: Hello: I have 2 tables t1: id age 1 7 2 6 3 7 4 8 5 9 6 4 t2: age 7 9 then I like select all in t1 without are in t2, so I need a result as follow id age 2 6 4 8 6 4

RE: first time to use MySQL on MS Platform with PHP.

Place an echo in the productsave.php page and check the SQL query. If the query that is getting passed is correct then the problem is on the productsave page. Otherwise, your values aren't being passed to the query. Jef -Original Message- From: Andrew [mailto:[EMAIL PROTECTED] Sent:

MySQL Multi Table Delete

I have 2 tables t and t1. In this case, t1 is a copy of t. I want to delete rows from t1 based on criteria on the t table and a relationship between t ad t1 (in this case the id column). In the results below, I would think that the delete should have deleted row 1 {1 5 me) and not row 3 (1 5

join query result difference between 3.23.49 and 4.0.13

hello, i have what seems to me a very common operation i'm performing. i need to find the balance on an invoice. i was not having any problems until the production server was upgraded to mysql v4.0.13-standard for pc-linux. there must be a better way to query for this information than the

Index phpadmin

Hi, i have a quick question in phpadmin when i create an Index on an none empty table. i see that in Cardinality is either a number or has written None what does it mean?? Thank you Anthony

Re: MySQL Multi Table Delete

At 11:39 -0500 7/16/03, Gordon wrote: I have 2 tables t and t1. In this case, t1 is a copy of t. I want to delete rows from t1 based on criteria on the t table and a relationship between t ad t1 (in this case the id column). In the results below, I would think that the delete should have deleted

RE: How to terminate dead connections that are in SLEEP?

Sure I could create an external process that will poll the process list every few minutes but I was hoping for some direction on how to have the MySQL server do it internally. At least that was my impression from reading the docs on the 'wait_timeout' value. Paul Rudy Metzger [EMAIL

Re: query

Thanks a lot that is the solution El Mié 16 Jul 2003 12:24, Egor Egorov escribió: Patricio Gigoux [EMAIL PROTECTED] wrote: Hello: I have 2 tables t1: id age 1 7 2 6 3 7 4 8 5 9 6 4 t2: age 7 9 then I like select all in t1

column default value

Hello: I'm using version 3.23.41. How may I change the default value of an existing table? (type will remain the same) Pointers to docs are welcome and invited. thanks tim -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com

Re: Frequent Table Corruption - Please Help

It is a Redhat 7.2 with a 2.4.7-10smp kernel.It was upgraded last september and mysqld has never been restarted since then (mysqld uptime is now 316 days). Hope this helps Joseph Bueno Richard Gabriel wrote: I am running 2.4.18-smp. You said you upgraded to a 2.4 smp kernel and it solved the

Advice needed on starting out with MySql...

Greetings all, I have formerly installed mysql 4.0.12 on my machine running win2k Advanced Sever, with Apache 2.0.46 and PHP 4.3.2. Somehow I messed up my configuration file and decided to start the whole thing from scratch. Now I hear that version 4.0.14 release date is only days away. My

Re: Frequent Table Corruption - Please Help

Hmm... I am running RedHat 8.0 with 2.4.18smp. The machine itself has been up for 270 days, but MySQL does crash from time to time and also sometimes tables are corrupted. I think I may be left with trial and error at this point. I will try the following things in order: 1. Install the

Re: column default value

At 9:02 -0800 7/16/03, Tim Johnson wrote: Hello: I'm using version 3.23.41. How may I change the default value of an existing table? (type will remain the same) Pointers to docs are welcome and invited. thanks tim -- Tim Johnson [EMAIL PROTECTED]

Re: 4.1.0 Roadmap ?

Hi! - Original Message - From: Blah Blah [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, July 16, 2003 7:03 PM Subject: Re: 4.1.0 Roadmap ? Yes, any information at all would be helpful. daniel Andy J awjarrett[at]hotmail[dot]com wrote in message news:[EMAIL

Re: first time to use MySQL on MS Platform with PHP.

Those are php notices (not warning or errors) .. change your ini error reporting settings.. you can either disable those messages or correctly initialize all variables before trying to use them. I'd suggest posting your msg to PHP list.. On Wed, 16 Jul 2003, Prabu Subroto wrote: Dear my

Question again : mysql.sock

Hello all, after Installing mysql I started the mysql daemon.. The I tried to log in to my mysql database and got the message could not find mysql.sock in /tmp. In the mysql-configuration file /etc/my.cnf (in my redhat system 8.0) I changed the place for the socket file from

Re: Question again : mysql.sock

Hello Tim, OK easiest thing to is cd to /tmp and issue ln -s /var/lib/mysql/mysql.sock mysql.sock What else can I do? Oliver Etzel -Original Message- From: Oliver Etzel - GoodnGo.COM (R) [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 12:31 PM To: [EMAIL PROTECTED] Subject:

RE: first time to use MySQL on MS Platform with PHP.

Hi, This is a PHP issue not MySQL. If anything got inserted at all it will be blanks for no where in your code were your variables ('$productid', '$itemname', '$description', '$price', '$information') defined. Try this in the productsave.php code right at the TOP after your include :

RE: MySQL query problems

Since the first query works, the second one should also work as it is virtually the same. It is querying the same database using the exact same query. The only difference is the variable names passed to it by the form. i.e. $playerfrom may = Hossa $playerto may = Alfredsson $namefrom may = Bill

encrypted entries

Hi, I'm using mysql along with Postfix MTA and courier imapd to run a virtual aliased domain email server. I have no problem connecting to and retrieving mail when i use clear passwords, but when i have the imap client try to connect using tls/ssl..it fails. I've read the docs and know that i

MySQL make test error

Could anyone tell me how to get past this error please? When I 'make test' some of the tests run but then it dies with. create [ pass ] ERROR: /home/tekton/src/mysql-4.0.13/mysql-test/var/run/master.pid was not created in 30 seconds; Aborting Or can this be safely

MySQL, FreeBSD, LinuxThreads, and 950 connections?

Does anyone have MySQL built with LinuxThreads running on FreeBSD 4.x and handling more than 950 connections? If so, did you need to do anything special to make it work? I'm seeing this: Can't create a new thread (errno 35). If you are not out of available memory, you can consult the manual for

Re: Best practice column type for storing decimal currency amounts?

Thanks for the reply, Rudy. My source for the statement that decimal values are stored as strings is: http://www.mysql.com/doc/en/Numeric_types.html : DECIMAL and NUMERIC values are stored as strings, rather than as binary floating-point numbers, in order to preserve the decimal precision of

Re: How can I display images from a mySQL Database in a web page?

Dan Anderson wrote: I have created a BLOB field to store images. Is there any way to embed them within HTML with something like: I've done some notes on this at http://www.scit.wlv.ac.uk/~jphb/sst/php/extra/images1.html - assuming of course you're using PHP as a WWW backend to dig the stuff

Re: MySQL, FreeBSD, LinuxThreads, and 950 connections?

In the last episode (Jul 16), Jeremy Zawodny said: Does anyone have MySQL built with LinuxThreads running on FreeBSD 4.x and handling more than 950 connections? If so, did you need to do anything special to make it work? I'm seeing this: Can't create a new thread (errno 35). If you are

Error while using Mysqldump

Hello All, I am using Mysql 4.0.13-max-log on Solaris 2.8 If I run mysqldump like below /usr/local/mysql/bin/mysqldump -u root -pabc -d -r /usr/local/mysql/testbackup/schemadump.sql --all-databases It abort with following error /usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table

Re: Best practice column type for storing decimal currency amounts?

On 16 Jul 2003 at 16:02, John Hicks wrote: Thanks for the reply, Rudy. My source for the statement that decimal values are stored as strings is: http://www.mysql.com/doc/en/Numeric_types.html : DECIMAL values may very well be stored as strings, but presumably you're going to do some

mysql setup compared to oracle

Hi, I'm new to mysql. Coming from the oracle database a couple of questions came up. Perhaps somebody, who has also experience in oracle, can set me on the tracks. Questions: 1. is mysql simular organized as oracle: instance/users/tables, so that I have to connect to chossen instance

RE: How can I display images from a mySQL Database in a web page?

image start: jpeg /image use this: echo 'img src='.mysql_result($conn, 0, 0).' alt='; where 0,0 is the result-set index for your mysql field. you might use other mysql functions of course, but the place to put the output in is the same the html-source code will look like it is

Re: Stopping MySQL taking down a server?

What Operating system are you using and how are you measuring unresponsiveness? -- Michael Conlen Tim Fountain wrote: This may be a silly question but what can be done to stop load-intensive MySQL processes taking down a server? Things like adding fulltext indexes to very large tables, or

RE: Error while using Mysqldump

This issue is closed. THANKS ! -Original Message- From: Sagar, Sanjeev Sent: Wednesday, July 16, 2003 3:28 PM To: [EMAIL PROTECTED] Cc: Sagar, Sanjeev Subject: Error while using Mysqldump Hello All, I am using Mysql 4.0.13-max-log on Solaris 2.8 If I

Re: MySQL, FreeBSD, LinuxThreads, and 950 connections?

On Wed, Jul 16, 2003 at 03:16:26PM -0500, Dan Nelson wrote: In the last episode (Jul 16), Jeremy Zawodny said: Does anyone have MySQL built with LinuxThreads running on FreeBSD 4.x and handling more than 950 connections? If so, did you need to do anything special to make it work? I'm

MYI file difference

Hi All, I tarred up the data directory from mirror1 data base - slave. Copied the tarball to mirror2 with the hopes of rebuilding mirror2 - another slave. Backed up the data directory from mirror2 into old and untarred mirror1 Then I did a diff -r against another mirror and the diff came

ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)

Hi All: I am trying to run mysql in a Windows XP environment. I downloaded the binary and installation went smoothly. What I am expecting is that if I have winmysqladmin in my startup it should launch and I should be able to connect using the mysql control centre as my client. So far no

Re: mysqlcc bug ?

Asfar as I know that is the default settings in the mysql server to be returned. So you will have to set the necessary parameter from the mysql command line client. Best regards Nils Valentin Tokyo/Japan 2003 7 16 22:32Weir Travis : I have noticed that mySQL Control Center (beta 092),

  1   2   >