ZipSlack 486 installation problems

the grant tables When I setup in an alternative fashion mysql_install_db works, I then find that I can not find the mysql.sock. All advice is welcome.. Duncan - Before posting, please check: http://www.mysql.com

Re: 1' and '1' or '1

thing. Your hack works, but you'd be better off reading up on SQL injection (you can do more than select all records - how's a dropped table strike you?), and looking at the availability of quoting capabilities in your language of choice. -- Duncan Hill - Developer Critical Software +44 (0)870 770 8190 Scanned by mailCritical. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: what is ibdata1

On Thursday 25 May 2006 12:02, balaraju mandala wrote: > Hello All, > > I need some explanations about these files. > > 1. ibdata1 > 2. ib_logfile0 > 3. localhost-bin.index > 4. localhost-relay-bin.01 > 5. master.info > 6. relay-log.info http://dev.mysql.com/doc/refman/5.0/en/innodb-configurat

Re: MySQL documentor - not MySQL Workbench

On Thursday 01 June 2006 15:52, Miles Thompson wrote: > Is there a tool, preferably open source, that can read database schema > scripts (for lack of a better term) or connect to the database, and > generate a diagram? This for a MySQL 5.x database. I use dbVisualizer, but it isn't a free tool.

Re: Replacing A Value

On Thursday 01 June 2006 17:02, Ed Curtis wrote: > I have a column in a table I need to replace a value of certain records > in. The current value is /realtors/Value/. I need to change them to > /realtors/This_Value/. Is there an easy way to do this. There are way too http://dev.mysql.com/doc/refm

Re: MySql Limitations??

On Thursday 01 June 2006 03:05, Mathieu Bruneau wrote: > Harish TM a écrit : > > hi... > > I need to store something like a couple of million rows is a MySql > > table. Is that ok or do I have to split them up. I intend to index each > > of the columns that I will need to access so as to spee

Re: DateTime limits

On Tuesday 06 June 2006 15:38, [EMAIL PROTECTED] wrote: > Quoting Barry <[EMAIL PROTECTED]>: > > Well my msql doesn't give me any errors using that query. > > neither a warning. > > Ditto. > > usemysql> use test; > Database changed > mysql> CREATE TABLE a ( t TIMESTAMP ); > Query OK, 0 rows affecte

Re: MySQL

On Wednesday 07 June 2006 16:04, Kaushal Shriyan wrote: > mysql> use mysql; > Can't read dir of './mysql/' (Errcode: 13) > Database changed > mysql> show tables; > ERROR 12: Can't read dir of './mysql/' (Errcode: 13) > mysql> > > Kaushal $ perror 13 OS error code 13: Permission denied Your fil

Re: Search and Replace a word in memo field

On Monday 12 June 2006 14:16, Gabriel Mahiques wrote: > but I have a problem with this solution, because I have the words in the > middle of the phrase. > For example: Movie Kill Bill Vol 1 in "vhs" format, and I want to > replace IT with Movie Kill Bill Vol 1 in "dvd" format. > In Another case I

Re: Aborting a greedy querry from the command line

On Tuesday 20 June 2006 08:23, Ciprian Vizitiu wrote: > > On Monday 19 June 2006 04:08 pm, Logan, David (SST - Adelaide) wrote: > > > Hi Chris, > > > > > > I've noticed that a Ctrl-C will also leave the query > > > > running (5.0.22 - > > > > > Linux) and I've had to use the kill from mysqladmin or

Re: finding the slow query

google.co.uk/search?q=mysql+slow+query&ie=UTF-8&oe=UTF-8 Combined with show processlist / mysqltop, you can see if you have locking contention. -- Duncan Hill - Developer Critical Software +44 (0)870 770 8190 Scanned by mailCritical. -- MySQL General Mailing List For list archives: ht

WITH ROLLUP, percentage calculations and pivots

Good day list, I've encountered a behaviour with 'WITH ROLLUP' that I don't understand. SELECT a.report_date, SUM(b.daytotal*last1) last1, ( 100*SUM(b.daytotal*last1) / (select sum(daytotal) FROM aggregate_logs WHERE aggr_source like 's%' and aggr_date=CURDATE() ) ) tper FROM m

Re: mysqld refuses to run on boot

and your patch. I can't find what I think is where you > want to put one line of code. The other lines do not exist. Or I don't > know what I.m doing :-) chkconfig mysqld on -- Duncan Hill - Developer Critical Software +44 (0)870 770 8190 -- Scanned by iCritical. -- MySQL Gener

Re: Version Numbers - Precedence

On Saturday 24 June 2006 12:50, Asif Lodhi wrote: > Hi, > > Mathematically speaking, the 5.0.22 I am using came _before_ 5.0.5. > Is that correct? Or 5.0.5 came first and then came 5.0.22? After. 5 < 22. Major.Minor.Release -- Scanned by iCritical. -- MySQL General Mailing List For list a

Re: array type

On Tuesday 04 July 2006 16:21, Nolan Rumble wrote: > SELECT COUNT(*) FROM temp GROUP BY recipient; > > and it will list all the email addresses and how much email they > sent/received. > > I suppose I can create another table which handles the variable length > recipients but I would like to avoid

Re: Money

On Tuesday 04 July 2006 21:33, Karl Larsen wrote: >     I have not yet found how I can put a $ in front of all the money > columns :-) Either use concat() or do it in your program that retrieves the data from MySQL. Currency symbols are not something the database should have to store for you. -

Re: I don't understand why SCSI is preferred.

On Wednesday 12 July 2006 20:58, Chris White wrote: > performance?". From what I know of MySQL, not really, because MySQL does a > good amount of work in memory. The only time I'd see disk access being a > factor is if you had a large mass of swap/virtual memory. I have to play with 300 gig of

Re: CREATE VIEW xxxx

On Monday 17 July 2006 13:26, Karl Larsen wrote: > I'm using mysql on Linux and all is going well but I can't find the > proper way to write a CREATE VIEW. I'm using 4.1 and is this function > still in mysql? If the MySQL manual for 4.1 does not list views as a feature of that version, odds a

Re: Upgrade from 4.1.7 to 4.1.20

On Tuesday 18 July 2006 16:08, Dominik Klein wrote: > > My question is : do I have to follow the upgrade procedure from 4.0 to > > 4.1 or can I juste installed the new binaries? We are not ready yet for > > the version 5. > > As always when upgrading: Make sure you have a backup :) This becomes a

Re: Select Query taking time

On Monday 24 July 2006 09:05, Ratheesh K J wrote: > Hello All, > > I run a select query to see its speed. It took around 5 seconds. Now i run > the same query simultaneously twice usng two instances of the client tool. > It took 10 seconds for both the queris to complete. Its not 5 secs + 5 > secs.

Re: Select Query taking time

On Monday 24 July 2006 09:06, Duncan Hill wrote: > On Monday 24 July 2006 09:05, Ratheesh K J wrote: > > Hello All, > > > > I run a select query to see its speed. It took around 5 seconds. Now i > > run the same query simultaneously twice usng two instances of the

Re: Synro MySQL databases

On Monday 24 July 2006 16:16, Brian E Boothe wrote: > HI all i have a question, I have A server MySQL database in our > office location that stores Contact information / inventory etc... and > also we have a Internet Site > NOw what id like to perform is Whenver Someone changes something in the

Re: yum version 5.*

On Wednesday 26 July 2006 22:16, Karl Larsen wrote: > I am using Red Hat Fedora Core 4 and I wanted to yum mysql version 5 > of any other and find with Core 4 I can yum only mysql version 4. > > I imagine Core 5 might be able to yum mysql version 5 but not > certain of that. Is there a way

Re: Monitoring Slow Queries

On Wednesday 02 August 2006 09:28, Asif Lodhi wrote: > Hi, > > Though I understand very well that it has been discussed lots of time > before but I don't have time to browse through the previous archives > and dig out the stuff I need. So, guys, I would be thankful if you > could give me your valu

Re: structure of whole table...

On Friday 11 August 2006 08:25, [EMAIL PROTECTED] wrote: > Can the output of the DESCRIBE be stored somewhere ( in file)? mysql mydb 'describe table' > table.describe.txt ? > Or is there any way to get the structure of whole table? show create table? -- Scanned by iCritical. -- MySQL General

Re: Weird SELECT bug in 5.0.21

On Thursday 31 August 2006 12:21, Renald Buter wrote: > The problem is that a simple 1-table query shows different answers > depending on whether you select 1 or 2 columns. Relational databases are founded on mathematical set theory. Unless you specify an ORDER BY stanza in your query, the data

Re: South American timber products.

On Thursday 14 September 2006 11:46, Martijn Tonies wrote: > > > for commercial email under bill S.1 6 1 8 Title lll, Section 301, > > lol .. I believe it's not really that ... It CAN be considered SPAM, but > it's just "allowed spam" ... :-D 1618 never passed. http://www.techlawjournal.com/cong

what WHERE how... i am confused: extra instances of foreign keys are being problematic

I am having trouble with this small bit of sql I am using for a homepage. I need to select information on the next two events from two separate tables; tblevents (which holds event related info), and tbleventdate (which holds info related to each date, including times and informatio

FW: what WHERE how... i am confused: extra instances of foreign keys are being problematic

I am having trouble with this small bit of sql I am using for a homepage. I need to select information on the next two events from two separate tables; tblevents (which holds event related info), and tbleventdate (which holds info related to each date, including times and informatio

Re: Can't connect from remote computer

On Tuesday 12 July 2005 14:25, Salama hussein typed: > I can't connect to Mysql from a remote computer yet I can log in fine > locally. When I telnet from a remote computer to port 3306, I get a > response. The response wasn't meaningful but it was a response. Exact error message? -- MySQL Gener

Oddity with data pointer size

I recently changed /etc/my.cnf to set myisam_data_pointer_size to 6, as we're starting to encounter quite a few tables that are larger than 4 GB. However, the create table statements used by the software application using the DB don't seem to be creating tables with pointers > 4 bytes. Recent

Re: Oddity with data pointer size

On Saturday 10 September 2005 12:17, Gleb Paharenko wrote: > Hello. > > Looks like it is a bug. See: > http://bugs.mysql.com/bug.php?id=7883 > > Duncan Hill <[EMAIL PROTECTED]> wrote: > > I recently changed /etc/my.cnf to set myisam_data_pointer_size to 6, as &

Re: Federated engine and "comment"???

On Wednesday 21 September 2005 11:23, Martijn Tonies typed: > Hi there, > > Did I just see in the documentation that the "comment" clause > is being misused to supply a connection string for the federated > engine? > > If so, I sure hope it will be changed before the final 5.0 release. > > "comment

Re: Federated engine and "comment"???

> On Wednesday 21 September 2005 11:23, Martijn Tonies typed: > > Hi there, > > > > Did I just see in the documentation that the "comment" clause > > is being misused to supply a connection string for the federated > > engine? > > > > If so, I sure hope it will be changed before the final 5.0 relea

Evaluating text as an expression

Select evaluate(queryText) from queryTable where queryId = x This is probably a bit more redundant now that 5 has stored procedures etc but still... any ideas Thanks Duncan

Re: Evaluating text as an expression

ino wrote: See comments interspersed below. Rhino - Original Message - From: "Duncan Miller" <[EMAIL PROTECTED]> To: Sent: Sunday, November 06, 2005 8:36 PM Subject: Evaluating text as an expression I am trying to set up a table where the returned value is a res

Re: Evaluating text as an expression

n the later releases. Sorry for any confusion I caused! Rhino - Original Message - *From:* Duncan Miller <mailto:[EMAIL PROTECTED]> *To:* Rhino <mailto:[EMAIL PROTECTED]> *Cc:* mysql@lists.mysql.com <mailto:mysql@lists.mysql.com> *Sent:* Monday, Novemb

Re: MySQL temp files?

On Tuesday 08 Nov 2005 08:42, Timothy Wu wrote: > another partition. So I manually removed the files. However, not much disk > space was freed from the operations. I suspect what I removed were hard > symlinks, but I wasn't quite sure. Why wasn't my disk space freed? How > would I be able to free

Re: Tips for better performance

On Tuesday 22 Nov 2005 09:24, Marko Knezevic wrote: > is running on dedicated server which consists of two Xeons @ 3 Ghz, 2 GB > RAM and two 150 GB disks @ 1 rpm running under RAID 1 controller. OS is > CentOS 4.2 A very recent article that crossed my eyes indicates that in certain cases, HT

Re: Tips for better performance

on lesser hardware (ok, so the SAN > > isn't lesser). The manual also contains a lot of information on how to > > tune > > MySQL for large memory environments - the default configuration is for < > > 256 > > MB I think.# > > Thank you Duncan and Sco

Re: Wrap Tag Around Result

On Wednesday 07 December 2005 15:29, Shaun wrote: > SELECT Firstname FROM Users; > > Matthew > Matthew > > I need to do this with pure SQL - no server side scripting... http://dev.mysql.com/doc/refman/4.1/en/string-functions.html CONCAT() perhaps. Scanned by mailCritical. -- MySQL General

recursive queries

Title: DIY MTB Is there any built in or other support for recursive queries . I suspect not, but wonder what is considered the best approach. With stored procedures being supported in 5.0 is that the way to handle these. Thanks -- Duncan Miller [EMAIL PROTECTED] www.diymtb.com.au

Re: recursive queries

I am looking to do a query on a self join table that returns the parent records. Obviously there are ways to do this, but just wondered if there are any functions in MySQL that make this easier, or specific functions available to stored procedures. I have read the manual and couldn't find any

Re: Hijackers?

On Tuesday 13 December 2005 02:25, Peter Lauri wrote: > Best group member, > > > > How can I prevent people from hijacking a query? I read this in an article > about a few months ago, but now I can not find that article again. This > question is maybe not so exact, and I do not know how risky it is

Re: Linking to documents on another server

On Thursday 15 December 2005 15:01, Darrell Troth wrote: > I am designing an intranet for a law firm. Everything works fine. My > problem is that they need to include the documents that are relative to > specific cases in their database. These documents are on a different > computer and I cannot fi

Re: [OT] SPAM

On Friday 16 December 2005 00:34, Stephen Cook wrote: > I got one from mysql@lists.mysql.com, and one from [EMAIL PROTECTED] > > And my filters remove anything that isn't from one of the mailing lists > I subscribe to. Did the spam actually come through the list, or did it just fake the From to m

Re: install mysql-5.0.17 on linux AMD 64 processor

On Friday 30 December 2005 10:35, jean-marc Jegou wrote: > i try to install mysql-standard-5.0.17_linux-x86_64-glibc23, but it did > not work ! > > System: Linux localhost.localdomain 2.6.9-10.2.aur.2 #1 Thu Feb 10 > 04:34:27 EST 2005 i686 athlon i386 GNU/Linux > Architecture: i686 x86_

Re: install mysql-5.0.17 on linux AMD 64 processor

On Friday 30 December 2005 14:05, jean-marc Jegou wrote: > Re: install mysql-5.0.17 on linux AMD 64 processor > http://lists.mysql.com/mysql/193352 > > dir Duncan Hill , > > thank you to answer to my question ! > > my processeur is AMD 64 2800+ ( 64 Bits processeurs!)

Re: Wordpress MU

On Friday 24 February 2006 12:33, Erich Beyrent wrote: > My question is whether or not it is good design to have each user have > his or her own set of tables. Would it not make sense to have all user > posts in a single table, referenced by a BlogID? This table could > easily grow to be a few m

Re: Prinitng MySQL Structure from ssh

On Friday 07 April 2006 10:30, Mark Sargent wrote: > alexj wrote: > > try mysqldump --no-data -u > > Hi All, > > thanx, but get the following, > > mysql> mysqldump --no-data osc -u admin; > ERROR 1064: You have an error in your SQL syntax near 'mysqldump > --no-data osc -u admin' at line 1 mysql

replication problems

bad code on the part of my users? And if the latter, what can I do to prevent their bad code making my slaving fail? -- Duncan Hutty System Administrator, ECE Carnegie Mellon University Please use informative subject lines -- MySQL General Mailing List For list archives: http://lists.mysql

Re: Performance Problems With Two Tables With Over 500K Rows

On Saturday 25 November 2006 17:54, John Kopanas wrote: > The following query takes over 6 seconds: > SELECT * FROM purchased_services WHERE (purchased_services.company_id = > 535263) What does EXPLAIN say about that query? Have you done an optimize recently? -- Scanned by iCritical. -- MySQL

Re: Setting up version 5

On Monday 18 December 2006 13:10, Karl Larsen wrote: > Is there a paper I can d/l that covers intalling MYSQL on Red Hat > Linux? http://dev.mysql.com/doc/refman/5.1/en/linux-rpm.html perhaps? -- Scanned by iCritical. -- MySQL General Mailing List For list archives: http://lists.mysql.com/

Re: Count the number of specific rows

On Friday 29 December 2006 14:02, Servers24 Network wrote: > Hi, > > Well this question may seem funny, but I really need to know! > The problem is with counting a user's contribution in my site. Suppose that > each user that send an email will be stored in DB. Now I want to count > number of times

5.1.14-beta with ssl build failure

. x86-suse9.3, openssl-0.9.8d, gcc-3.4.6 (or gcc-4.1.1) using: CFLAGS="-O3" CXX=gcc \ CXXFLAGS="-O3 -felide-constructors \ -fno-exceptions -fno-rtti" \ ./configure --with-ndbcluster \ --with-ssl=/usr/local/openssl \ --enable-assembler && make Any suggestions? -- Dunca

Re: 5.1.14-beta with ssl build failure

Chris White wrote: Duncan Hutty wrote: I attempted to build 5.1.14-beta with ssl support and it failed (output below). It builds quite happily on this system without the ssl support parameter to configure. Since it appears to fail in an area (timezone system) that to me seems rather

Re: Query Two Databases

On Thursday 25 January 2007 11:08, Neil Tompkins wrote: > The databases are on the same server, however the login details for each > database are different. > A query executes with the credentials of the authentication used to set up the connection. If you want to query two tables simultaneously

Re: Getting number days between 2 dates

On Sunday 04 February 2007 17:24:29 Jim MacDiarmid wrote: > I've been trying to figure this out using the CURDATE() function, but I > keep getting a syntax error. Below is the code I'm using: > > SELECT > `vb_links`.`DateAdded` > FROM > `vb_links` > WHERE DATEDIFF( CURDATE() , `vb_links`.`DateAdded

Re: How can I detect if MySql is already installed?

On Thursday 15 February 2007 11:12:11 Juan Eduardo Moreno wrote: > Linux : > > $ rpm -qa |grep -i mysql > > Regards, > Juan > > On 2/14/07, Zsolt Csillag <[EMAIL PROTECTED]> wrote: > > Hello, > > > > I would like to create a setup program for my demo version that uses > > MySql database. > > > > I

Re: Breaking Up Tables

On Thursday 01 March 2007 09:56:41 [EMAIL PROTECTED] wrote: > Hi; > I have an unusual problem. My current production server's OS is corrupt and > I'm building a new one. However, due to the corruption, I can't move files > out of it. I have a "back door" through Zope, but I can only move files of >

Re: Breaking Up Tables

On Thursday 01 March 2007 13:43:38 [EMAIL PROTECTED] wrote: > >Otherwise you're looking at perhaps select limit 0,1000, 1000,1000, > > 2000,1000 > > > >etc .. > > Can you clean up this command? I can't find documentation on the select > limit part of a mysqldump command. It's nothing to do with my

Re: *.MYI was corrupted with OS crash when lots of rows were inserting

On Tuesday 06 March 2007 01:51:38 xian liu wrote: > Hi all, > > when I insert many records into a myisam type table, at the same time, > unplugged the power cable, the os crash, I found several *.MYI file was > corrupted, but can use "repair" or "myisamchk" to repair those table. > > Is there any w

Re: Problem on creating root password

On Thursday 29 March 2007 11:38:21 Stephen Liu wrote: > > http://dev.mysql.com/doc/refman/4.1/en/resetting-permissions.html > > I tried learning resetting the password according to above URL. I > can't find "set" command on this box. I don't know which package > provides it so finally I surrende

Re: The time of last updated field

On Monday 02 April 2007 09:11:18 sam rumaizan wrote: > I have to two different fields Last_Updated and Story. I want whenever > Story Field got updated (modified) the time and date of the modification > get recorded (insert) in Last_Updated Field The answer you seek lies within the manual. http:/

Re: Trying to open a big sql script

On Thursday 19 April 2007 11:43:34 molemenacer wrote: > Hi all, > > I have backed up a database using mysqldump and have a .sql script that is > over 2GB in size. I am trying to open this file to view it and make some > changes. I have not been able to find a program that can open this file. > >

Re: Trying to open a big sql script

On Thursday 19 April 2007 15:53:54 molemenacer wrote: > I am trying to change all the names of the database from mthosp to another > name, is this possible? Assuming you mean tables, not database (as mysqldump doesn't store the database name in the dump file [or at least never has for me]): sed

Re: How do I Put a 'Literal' Value in a Report Column?

On Monday 07 February 2005 07:57, Sue Cram might have typed: > I'm writing a report listing animals from our shelter and whether they have > been adopted. I am selecting the animal name field and a field called > 'adopted' from a table called 'animal'. The values in 'adopted' are > either: 1 (m

Two servers, one InnoDB area?

I'm currently evaluating ways to increase our online storage capacity for our DB engine. The current winner is a massive external SAN/disk array. However, I'm wondering how MySQL will handle failover when it comes to InnoDB tablespaces. The current plan, based on the disk array, is to have ea

Re: find duplicates - revisted

On Wednesday 20 April 2005 16:55, [EMAIL PROTECTED] typed: > For the small number of records, this query takes a remarkable amount of > time, so clearly this solution does not scale. A query that uses keys should not take a long time to run - unless your key data is not maintained as a key in the

Re: Read past Equivalent in MySQL

On Friday 13 May 2005 11:34, Ramesh G typed: > I am using InnoDB only. > But, it's not skipping locked rows. Ditto that here. CREATE TABLE `a` ( `b` int(11) NOT NULL auto_increment, PRIMARY KEY (`b`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 select * from a; +---+ | b | +---+ | 1 | | 2 | | 3 |

Re: Read past Equivalent in MySQL

On Friday 13 May 2005 16:19, Eric Bergen typed: > I agree. It sounds like you could use plain repeatable read isolation > transactions. If someone else is modifying those rows you get an older > version from when your transaction was started. No need for skipping > anything. In the case of what I

Re: Read past Equivalent in MySQL

On Friday 13 May 2005 18:21, Gordon wrote: > If you can add a table structure why not create a SELECTED table with > REPORT ID and PERSON ID as the 2 field PRIMARY KEY. > > Then you could INSERT IGNORE into this table [with no BEGN/COMMIT] and the > IGNORE would throw away those already selected.

Re: not a rpm package?

On Thursday 19 May 2005 14:36, Bing Du typed: > > The problem is exactly as the problem says, you're trying to install > > something > > that isn't an RPM package. Try: > > > > file MySQL-server-5.0.4-0.i386.rpm > > > > It'll tell you what the file you've downloaded actually is. Either it's a > > c

Re: How to implement views in mysql 4.12 version

On Monday 23 May 2005 20:01, Dayakar wrote: > Please give me solutions at the earliest as mirgration from oracle to mysql > is started and i need to meet the solution as soon as possible. 4.1 does not support views. As documented in the online documentation: "Views (including updatable views) are

Re: How can I do phpmyadmin/mySQL web based DBase entries/queries?

On Monday 01 December 2003 02:28, [EMAIL PROTECTED] wrote: > creating a web-site which has a spot to make a query as well as text boxes > to input data into the database. This way I won't have to type all the > mysql commands to add new entrys. > > I already have the mySQL database installed, as w

Re: error 1045 happened randomly

On Monday 01 December 2003 11:46, Francis Mak wrote: > it works successfully, however, sometimes it just give me "Error 1045: > Access Denied for user '[EMAIL PROTECTED]'" > it happens RANDOMLY. > > Could anybody please let me know how to fix this??? Remove the password from the login

Re: error 1045 happened randomly

On Monday 01 December 2003 12:24, Wouter van Vliet wrote: > Duncan Hill wrote: > > Remove the password from the login and the problem appears to > > go away. I've hammered my test DBs with thousands of serial > > logins, and the problem only shows when a login has a pas

Re: error 1045 happened randomly

On Monday 01 December 2003 12:51, Wouter van Vliet wrote: > don't do that on your production server. Or, in my eyes better yet, > downgrade to the latest stable verion of MySQL. And compile it yourself, .. > always better since it's totally fit for your system then. > And there I was, hoping to ta

Re: error 1045 happened randomly

nicode support. > does mysql team know this issue? I wanna report this to make this product > better. did you, Duncan? Not yet. I'm still trying to narrow it down to password length etc. Would like to provide a fairly complete report when I do. > and Duncan said the problem occur w

Re: error 1045 happened randomly

On Monday 01 December 2003 11:46, Francis Mak wrote: > I am using PHP4.3.4 + MYSQL 4.1.0-alpha-standard(binary, not rpm and > not compiled by myself) + REDHAT 9 Hmm, I just read this part again.. RedHat 9 is the consistent part between your systems and mine. Wonder if glibc or openssl is at

Double execution of queries?

One of my apps in a test enviroment is showing some strange behaviour. Up-front-answer: No, there are no loops in this segment of code. Snippet: $password = sha1(stripslashes($eval['tpassword'])); $query = "INSERT INTO logins (login_parent, login_name, login_password, fname, lname) values ($id,

Re: Install of mysql 4.1.x on RH 9

On Thursday 04 December 2003 16:27, Rudy Metzger wrote: > Dear all, > > I am positive this has been asked a 1000 times before, but i cannot find > it anywhere on the archive. Maybe a good search function there would > help :) > > Ok, here my problem: I am trying to install mysql 4.1.1 on RH 9.0, bu

Re: Can I use TAB delimiters for importing CSV

On Monday 08 December 2003 13:06, Matthew Stuart wrote: > Am I able to specify to somebody who is dumping from Oracle to use TAB > as the delimiter? Does MySQL enable me to specify during import that > the CSV is a TAB delimited file? Read The Fine Manual :) http://www.mysql.com/doc/en/mysqlimp

Re: 'Sum' syntax

On Tuesday 16 December 2003 09:22, Noamn wrote: > I'm using v3.23.51 on Linux. > > Can anyone explain why a simple 'sum' select won't work?? Here is the > example: > > mysql> select sum (id), pet from visits group by pet; > ERROR 1064: You have an error in your SQL syntax near '(id), pet from > v

Re: php installation with mysql support.

On Tuesday 16 December 2003 13:43, ads mysql wrote: > php-4.3.4]# ./configure --with-apxs2=/usr/local/apache2/bin/apxs --with- > mysql=/var/lib/mysql > > It gives error "configure: error: Cannot find MySQL header files under > /var/lib/mysql" > what should I put in "--with-mysql=/var/lib/mysq

Re: Problem creating new user.

On Wednesday 17 December 2003 12:45, ads mysql wrote: > It gives following error :[EMAIL PROTECTED] root]# mysql -u ads11 -p > bankaccount Enter password: (here I enter password 'ads11') > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: > YES) > Domain www.allnet.com is

Grant access to named table in many DBs

Situation: Multiple DBs with the same named table in each DB. Needed: Grant insert to a named login to the named table in all DBs. Not wanted: A grant for each db.named_table combo :) Am I right in concluding that my not wanted solution is the only solution to this case? Ie, I'll have to grant

Re: convert dynamic page to html page

On Thursday 18 December 2003 17:46, Paul Godard wrote: > Hi > > I build a online catalog linked to mysql db. > > Now my client wants the site on a cdrom. > > What is the fastest way to convert the product pages into static html > format? -- wget --mirror ? -- MySQL General Mailing List For li

Re: newbie FTP question

On Monday 05 January 2004 11:26, Matthew Stuart wrote: > I have my website and MySQL db sitting locally on my PC. I need to get > it to the remote server, I know how to get the website pages and images > there, but am not sure how to transfer the data, tables and all from > the database. Can somebo

Re: installing mysql-standard-4.0.17-pc-linux-i686 in redhat-9 help me urg!

On Wednesday 21 January 2004 10:20, naga rajan wrote: > hi, > i am trying to install Mysql in RH-9.I follow your > instructions .But when i typed Since you have RedHat, might I suggest that you use the RPM versions, which are pre-compiled and should set everything up properly for you. -- MySQ

Re: how to start mysql after rpm installation

On Wednesday 21 January 2004 10:56, naga rajan wrote: > hi, I had just installed mysql RPM in RedHat-9. > It doesn't shows any errors but what nextstep i have > to do work with mysql. RT(f)M: http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Unix_post-installation Pretty

Re: how to upgrade / dependencies problem

On Monday 26 January 2004 13:17, Trevor Smith wrote: > When I try to upgrade from v4 to v4.1, I get the following dependencies > problems: > > [EMAIL PROTECTED] trevor]# rpm -Uvh MySQL-shared-4.1.1-0.i386.rpm > error: Failed dependencies: > libcrypto.so.0.9.6 is needed by MySQL-shared-4.1.1

Re: how to upgrade / dependencies problem

On Monday 26 January 2004 14:08, Donny Simonton wrote: > I figured out a little trick yesterday, I do not recommend it, but I did > work for me. I installed the rpm of MySQL-server, installed the client via > rpm, then when it came to the shared libraries. I went and downloaded the > binary build

Re: Select older than minutes

On Wednesday 28 January 2004 06:00, Scott Haneda wrote: > I have done this so many times.. > SELECT * FROM `support_start` WHERE TO_DAYS(NOW()) - TO_DAYS(date) > 7 > > I have scoured (more like glanced :-)) at the docs on > and can not seem

Re: Bash script to MySql

On Wednesday 04 February 2004 05:44, Scott Haneda wrote: > I need to to the following > Select serial from serials; > > Problem is I need to run this from a script which cron will call once a > day, how do you pass a select statement to mysql with user and pass so it > can all happen in one go? my

Re: What does this error mean: "Duplicate entry '273' for key 1"

On Thursday 05 February 2004 15:50, Daniel R. Anderson wrote: > I got the following error on a perl script: > > "Duplicate entry '273' for key 1" > > I googled for it and found a thread telling me to DROP the table and re > CREATE it. So I did, and my script is working fine. My question: why > di

Insert with multiple value lists

While reading the manual the other day, I noticed that MySQL supports a syntax of INSERT INTO table VALUES (x),(y),(z). Very handy, and nice and fast. However, when this syntax was tested on an AS/400 and an Ingres installation, it doesn't work. The manual doesn't list this format as an exten

Re: Using non-standard hard drive

On Monday 09 February 2004 05:23, Rick Duley wrote: > Hi folks, > > I'm using MySQL for survey data collected during my postgraduate study. I > have MySQL installed on C-drive (WindowsXP) but wish to store the data on > D-drive. (I try to keep C-drive sequestered for installed software > only.)

Re: Reply-to [was Newbie Question]

On Monday 16 February 2004 14:18, gerald_clark wrote: > Rhino wrote: > >To quote the words of an old song "I second that emotion". > > > >As the latest poster to fall into this trap, I just assumed that this list > >worked like others to which I subscribe: the user simply hits Reply on the > >post

Problems with subquery and 'not in'

Mysql version: 4.1.1 Platform: Linux, pre-compiled RPMs from mysql.com Table 1: CREATE TABLE `notifications` ( `recid` int(11) NOT NULL auto_increment, `recdate` datetime NOT NULL default '-00-00 00:00:00', `expiry` datetime default NULL, `notify_title` varchar(150) default NULL, `no

  1   2   3   >