(newbie) how can I regenerate the data/mysql tables?

2002-03-18 Thread Richard Trahan
I'm running 3.23.43 on Windows 98. I've done the default binary installation, which created the mysql and test databases in c:\mysql\data, and I've added the menagerie and other sample databases to it. I would like to leave that structure in place but create another database somewhere else. I

Re: (newbie) how can I regenerate the data/mysql tables?

2002-03-18 Thread Richard Trahan
Doug Thompson wrote: (snip) Perhaps you have misunderstood how mysql organizes everything and you are wanting to do something that you don't need to do. I haven't misunderstood anything, I think. I know how to create additional databases with CREATE DATABASE. My problem is that I want to

Re: (newbie) how can I regenerate the data/mysql tables?

2002-03-18 Thread Richard Trahan
Stephano Mariani wrote: Use symbolic links :) Actually, that's a good idea; it does let me put my table data somewhere else, but it's my fault that I didn't reveal my secret motivation in my original post. I have a general backup scheme which backs up everything in a set of directories

no tee in mysqlc

2002-03-18 Thread Richard Trahan
Why is there no tee in mysqlc? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To

How to use edit in mysqlc?

2002-03-18 Thread Richard Trahan
I like mysqlc because of the command line editing capability, but I can't find any documentation on this utility. Specifically, I haven't been able to figure out how edit works. Any help, please. - Before posting, please check:

Re: Getting a text field in a table....

2002-03-15 Thread Richard D. Williams
Dear Mad, Don't give a szie just this; ALTER TABLE tablename ADD fieldname LONGTEXT Hope this helps, Richard MadProfessor wrote: Stupid newbie question, but why in the hell can't I get this damned TEXT column added? I've specified it as size 254 and cannot get it to work Someone please

glitch or me?

2002-03-14 Thread Richard
Hi I have 2 SQL fragments that pull up 2 differing results and I have no idea why. The two pieces of code are identical bar one line which is : AND individual_id ='AB00090004' AND Category = 'DXS1047' The code that produces the correct code is: select Raw3_2.category,

glitch or me?

2002-03-14 Thread Richard
Hi I have 2 mySQL fragments that pull up 2 differing results and I have no idea why. The two pieces of code are identical bar one line which is : AND individual_id ='AB00090004' AND Category = 'DXS1047' The code that produces the correct code is: select Raw3_2.category,

Re: varchar attributes

2002-03-13 Thread Richard D. Williams
Sorry, please excuse this post. I found the problem. A single space in front of the account number. Thanks Richard D. Williams [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include

Re: How to sum only nest N values?

2002-03-11 Thread Richard Clarke
create temporary table usertempcnt SELECT *,(@a:= IF(@b=id,@a+1,1)) as cnt, @b:=id from user order by id,points desc; select *,sum(points) from usertmpcnt where cnt=2; where 2 is your N Regards, Richard - Original Message - From: Anzej Becan [EMAIL PROTECTED] To: [EMAIL

Re: How to sum only nest N values?

2002-03-11 Thread Richard Clarke
argh read your scheme wrong answer should be: create temporary table usertempcnt SELECT *,(@a:= IF(@b=id,@a+1,1)) as cnt, @b:=id from user order by user,points desc; select *,sum(points) from usertmpcnt where cnt=2; where 2 is your N Regards, Richard - Original Message

Re: Default record order...

2002-03-05 Thread Richard S. Huntrods
key on tables that must run fast - the overhead of sorting each insert/delete negatively affects performance. Or so I was taught, anyway (back in the dark ages - primative data structures and all that G). Cheers, -Richard As said, the (sorting) behaviour without ORDER BY is undefined according

Re: Default record order...

2002-03-05 Thread Richard S. Huntrods
with the tables and a bunch of selects). -Richard DL Neil wrote: Richard, I guess your problem comes from the fact that SQL has no concept of internal order. If you do not specify an ORDER BY clause, the order or records returned is undefined, i.e. random. That's what I was figuring. I asked

Re: Export Data From Mysql to CSV

2002-03-04 Thread Richard
Hi, SELECT columns INTO OUTFILE 'path/to/directory/file.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '' LINES TERMINATED BY \n FROM table for more info checkout: http://www.mysql.com/doc/S/E/SELECT.html cheers Richard At 11:06 04/03/2002 +, Amit Dilip Lonkar wrote: Hi How can I

LOAD DATA INFILE and how to ignore garbage lines at end of load file?

2002-03-04 Thread Richard Bolen
I'm exporting data from Oracle and importing it into MySQL. The problem is Oracle puts garbage lines at the end of it's output files. Lines like 300 rows selected and input truncated to 9 chars as well as empty lines. When MySQL loads these files, I'm getting rows inserted for the empty

extra max() function possibly very useful?

2002-03-04 Thread Richard Clarke
of this functionality would be much appreciated. Richard p.s. here is the word mysql to get past the intelligent spam filter. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: extra max() function possibly very useful?

2002-03-04 Thread Richard Clarke
mytable; foreach(cid) { select * from mytable where cid='$cid' order by hits desc limit 2; } Which means the table is reread over and over. With this extra function we could reduce the reads to at best once. Richard - Original Message - From: Christopher Thompson [EMAIL PROTECTED

RE: LOAD DATA INFILE and how to ignore garbage lines at end ofload file?

2002-03-04 Thread Richard Bolen
I added the line set feedback off at the beginning of my Oracle report script and that suppressed the output of the garbage lines. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Monday, March 04, 2002 11:33 AM To: Richard Bolen; MySQL Mailing List (E-mail) Subject

Re: extra max() function possibly very useful?

2002-03-04 Thread Richard Clarke
Correct. Richard - Original Message - From: DL Neil [EMAIL PROTECTED] To: Richard Clarke [EMAIL PROTECTED]; Christopher Thompson [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, March 04, 2002 6:34 PM Subject: Re: extra max() function possibly very useful? LIMIT to be applied

Default record order...

2002-03-04 Thread Richard S. Huntrods
. This is for my understanding. I solved my actual problem by simply placing a primary key on the appropriate columns - as I should have from the beginning! G). Thanks, -RIchard - Before posting, please check: http://www.mysql.com

Deadlock found when trying to get lock;

2002-03-02 Thread Richard Clarke
queries thousands of times. Should the dbms not roll back the query automatically and carry on? How can I add functionality in my perl script to stop this error killing the application or must I just put it in a while(1) bash loop? Any help much appreciated Richard

Emulating a sequence in MySQL?

2002-03-01 Thread Richard Bolen
I need to have unique id's for every data element in my system no matter which table it's in. In Oracle I can create a sequence and with one SQL query I can increment the value and retrieve it for use in my next insert. Can I do this in MySQL? I know about AUTO INCREMENT but that appears

upgrade ver. 3.22.32 to 3.23.41

2002-02-25 Thread Richard Reina
the recreation of my old MySQL server on the new one? Thank you very much for any help. Richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: Mysql dies with Signal 11

2002-02-24 Thread Richard Clarke
-variable = innodb_additional_mem_pool_size=20M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 Richard - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: Richard Clarke [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, February 24, 2002 5:32 PM

Mysql dies with Signal 11

2002-02-23 Thread Richard Clarke
to bottom of email. This is a very active server processing 150 apache hits a second. A seperate looped process takes cgi data inserted into an IPC MSGQ and sticks it in the db and another seperate looped process takes data from this db and dumps to a db on a remote machine. Richard p.s. Your

Re: column1 like column2%

2002-02-20 Thread Richard
mysql,query Hi , is there any way of performing something like the below statement? select * from table1,table2 where table1.column1 like table2.column2 thanks in advance Rich - Before posting, please check:

RE: MYSQL HELP

2002-02-20 Thread Shade, Richard
Richard Shade Systems Administrator (936)559-2280 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 20, 2002 11:39 AM To: Shade, Richard Subject: Re: MYSQL HELP Your message cannot be posted because it appears to be either spam

Time bug with MySQL 3.23.49

2002-02-19 Thread Richard Gabriel
Richard Gabriel, CTO CoreSense Inc. (518) 276-2673 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: Statistical analysis query?

2002-02-16 Thread Richard Reina
You're stumped!? Where does that leave us? Unfortunately (AFAIK) the sample data you have enclosed does not demonstrate the condition you seek to describe - perhaps it would have been better if you gave us a replicable example, so that we can UNDERSTAND the problem before we try to help you

Statistical analysis query?

2002-02-15 Thread Richard Reina
other data do I need? Any help is appreciated. Richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL

mySQL and Firewall

2002-02-14 Thread Brumpton Richard
ports do I need open? Richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED

Need help please!

2002-02-14 Thread Richard C Rossy
Ok I can't seem to get this. Now is it possible to have MySQL on a other computer and run the script. In other words the perl script is on foo.com and MySQL database is on foo2.com. What is need to make the script work. What I have in the script is: Configure.pl sub configure {

InnoDB create table error 150

2002-02-14 Thread Richard R. Harms
The create table command included at the end of this message gives the following error: ERROR 1005: Can't create table './catalogmgr/macitm_vendordfrom.frm' (errno: 150) Creating it with type=myisam, and then doing an alter table and converting it to innodb works okay. It just cannot be

Re: triming white space from a TEXT column

2002-02-13 Thread Richard Reina
the trimmed column value, but it won't change the column itself. Try updating the column to its trimmed value: UPDATE tbl_name SET col_name = TRIM(col_name); I tried both ideas and neither one removed the white spaces. arrr! :-( Thanks, Richard

4.0.1-max-nt - quick note

2002-02-12 Thread Richard Morton
I have installed the above as a service. The service seems to start ok, but trying to run mysql console fails. I am running this on Win2k Pro. I have now reverted to MySQL4.0.1-NT running as a service and this works fine. Just a warning. Richard

Re: triming white space from a TEXT column

2002-02-07 Thread Richard Reina
the trimmed column value, but it won't change the column itself. Try updating the column to its trimmed value: UPDATE tbl_name SET col_name = TRIM(col_name); I tried both ideas and neither one removed the white spaces. arrr! :-( Thanks, Richard

triming white space from a TEXT column

2002-02-06 Thread Richard Reina
I am trying to trim both leading and trailing whitespace from a TEXT column in my SELECT query. I found the TRIM() command in the manual, however, I can't get it to act upon a column name instead of an actual string. Can anyone help? Thanks, Richard

Last_Insert_Id() returning 0

2002-02-01 Thread Richard Cannock
with the following statement: select last_insert_id() which returns 0 which is not what I would have expected. I am doing this using mySQlGui 1.7.5-2 on Win 2000 Professional. Grateful for any advice. Best Wishes Richard __ Do You Yahoo!? Great stuff

RE: AUTO_INCREMENT columns randomly restart counting from 1

2002-01-30 Thread Richard Bolen
I think AUTO_INCREMENT is on a per-connection basis. So if you're doing this across different database connections, it will reset to 0. Rich Hi there We have some table used as sequences. They only have 2 columns (ID, PID), with the AUTO_INCREMENT flag set for one of them (ID). By default

RE: MySQL JDBC setup in weblogic.

2002-01-28 Thread Richard Bolen
This config worked for me: weblogic.jdbc.connectionPool.PoolName=\ url=jdbc:mysql://localhost:3306/test,\ driver=org.gjt.mm.mysql.Driver,\ initialCapacity=1,\ maxCapacity=10,\ capacityIncrement=1,\ props=user=DBUser;password=DBPassword

RE: Selecting the row with largest number in a column

2002-01-27 Thread Richard Morton
Thanks, but using SELECT MAX(age) FROM contacts only gives me the maximum age, not the person with that age. The table is tiny, changes very often and therefore indexes would be a waste of time. Thanks Richard -Original Message- From: Butch Bean [mailto:[EMAIL PROTECTED]] Sent: 25

Equivalent of an Oracle SEQUENCE in mysql?

2002-01-25 Thread Richard Bolen
Is there the equivalent of a sequence in mysql? Does anyone have an example of emulating sequences? Thanks Rich Rich Bolen Senior Software Developer GretagMacbeth Advanced Technologies Center 79 T. W. Alexander Drive - Bldg.

Selecting the row with largest number in a column

2002-01-25 Thread Richard Morton
where age=(select MAX(age) from contacts); In escence I am trying to ascertain the details of the person who is oldest. Any suggestions.? Richard - Before posting, please check: http://www.mysql.com/manual.php (the manual

Fw: Porting from MS SQL to MySQL

2002-01-20 Thread Richard Burgmann
- Original Message - From: Richard Burgmann [EMAIL PROTECTED] To: Markus Lervik [EMAIL PROTECTED] Sent: Sunday, January 20, 2002 9:53 PM Subject: Re: Porting from MS SQL to MySQL Hi Markus, I'm an IT Consultant by trade and have been involved in lots of green fields projects

Re: Mysql/Php Help?

2002-01-20 Thread Richard Ellerbrock
I really suggest you do a little homework and read the tutorials in both the php and mysql manuals. They are really valuable and should give you the examples you need. Maintainer IPPlan (https://sourceforge.net/projects/iptrack/) sql Gary Lefko wrote: Can someone writ eme an example of

Re: Changing root password

2002-01-16 Thread Richard Ward
If you have just finished installing, then root has no current password and you can leave out the -p altogether: root@localhost bin]# ./mysqladmin -u root password 'new-password' good luck Richard Ward Jay Paulson [EMAIL PROTECTED] 01/16/02 12:57AM I'm trying to change the root password

Re: [PHP] Mac OSX !?!?!?

2002-01-16 Thread Richard Baskett
Kind of hard to say without source code for the session part.. Although the MySQL warnings, I got those because MySQL does not automatically start in OSX, if you know it's started then Im not sure, but if not.. go here to get the autostart utility: http://www.entropy.ch/software/macosx/mysql/

Re: new bee - Mysql Database Update Problem

2002-01-14 Thread Richard Ward
of the datafile, and then use a merge table to group it all back together into a virtual table. cheers richard samit darne [EMAIL PROTECTED] 01/11/02 09:25PM Hello, I am new to MYSQL platform: Sun Solaris 2.6 mysql version: 3.22.32 I upgrade the hard drive from 4G to 18G as database was increasing

2 masters 1 slave replication

2002-01-14 Thread Richard Ward
servers store information about the mail they send in their individual databases, and theoretically would replicate the information down to the database server where queries can be run on all the data. Is this type of replication possible? Thanks Richard Ward

php.dig

2002-01-10 Thread Richard McNeil
Does anyone use php.dig as a search engine with mysql? If so have you found any bugs or security issues? Thanks, Richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: Prevent WinMySQLAdmin from auto startup when windows 98 reboots

2002-01-09 Thread Richard
://lists.mysql.com/php/unsubscribe.php Richard Czerwonka, Partner, FYI Systems, Perth, Western Australia, Delphi development - Before posting, please

Errors with version 3.22.23b-log

2002-01-07 Thread Richard W. Wood
My ISP has version 3.22.23b-log installed on my hosting service machine, and I have repeatedly encountered problems importing tables to the database that have indexes that are not given a default value or that are not specifically stated to be NOT NULL. Others using the same programs have

Re: unique problem?

2002-01-02 Thread Richard Reina
many characters. If it did change something I fear it would change all of the text in the columns to 'No.' which would send me into a rage. If I am missing something please let me know. And if anyone else might know how I can solve this dilema, I would appreciate the input. Richard Reina

unique problem?

2001-12-31 Thread Richard Reina
and replace # with No.. Can anyone help? Richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL

Backup Question.

2001-12-31 Thread Richard Reina
help would be greatly appreciated. Richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL

Re: Best Delphi VCL to Access MySql.

2001-12-27 Thread Richard
I have two favourites: http://www.scibit.com http://www.microolap.com/index.htm Wich VCL is the best to access MySql I used Interbase for long time and I think to switch to MySql ofr My Delphi Application. Richard Czerwonka, Partner, FYI

Newbie install problem

2001-12-26 Thread Richard Lyons
don't have one. I can't find any mention of it on the MySQL site. Where do I get it from? The installation seems otherwise complete, inasmuch as chkconfig now shows mysqld in the right places. Can anyone enlighten me? -- richard

RE: Nested Queries.

2001-12-21 Thread Richard Morton
Hi, In alot of cases you can use the following query structure (extract from MySQL 4.0.0alpha manual)to negotiate the need for Sub-Selects. I hope this helps. -Rich 1.4.4.1 Sub-selects MySQL currently only supports sub selects of the form INSERT ... SELECT ... and REPLACE ... SELECT

Upgrading from Version 3.22 to 3.23.46

2001-12-19 Thread Richard McNeil
appreciated. e.g. roll back advice, backups, etc. I plan to make tar files of the current db's at the moment. Thanks, Richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Innodb Win2000 error

2001-12-18 Thread Mehalick, Richard RE SITI-ITPSCA
I am trying to use mysql-max-3.23.46a for Windows (Win2000) with innodb in use. After installing from the setup program, I copied my-example to c:\my.cnf and uncommented the innodb lines with the following: innodb_data_file_path = ibdata1:20M innodb_data_home_dir = c:\ibdata\ set-variable =

Re: MySql forum or newsgroup

2001-12-14 Thread Richard McNeil
I agree. I think the forum is a great idea. - Richard - Original Message - From: Etienne Marcotte [EMAIL PROTECTED] To: Philip Molter [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, December 14, 2001 11:14 AM Subject: Re: MySql forum or newsgroup Sorry but I've never seen

safe_mysqld

2001-12-13 Thread Richard Dobson
Hi, I made a copy of safe_mysqld, ammended it and then replaced the old copy with the new one. Does anyone know why I am getting a 'no such file or directory' error when I try to execute it now? -rwxr-xr-x 1 mysqlmysql 8396 Dec 13 15:02 safe_mysqld thanks in advance Richard

Re: MYSQL running under WIN98

2001-12-09 Thread Richard
message: Can't connect to mysql server or localhost (10061). Any suggestions? Richard Czerwonka, Partner, FYI Systems, Perth, Western Australia, Delphi development

Re: Annoying article about MySql

2001-12-08 Thread Richard S. Huntrods
as a normal query and capturing the output to a file. Then I edit the file to perform the outer query (ususally some form of update). Sorry for the long (gradually off topic) reply - but I've had no problems with large mysqldump restores. Cheers, -Richard == quote

Re: HOW TO : SQL Request in a file

2001-12-08 Thread Richard R. Harms
Check out the 'INTO OUTFILE' portion of the 'SELECT' command: http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SELECT -rh Hello Is it possible to put the result of a Mysql request in a file and how to do this ? I try mysql SELECT name from table where name like

Re: Annoying article about MySql

2001-12-08 Thread Richard S. Huntrods
Arjen, Arjen G. Lentz wrote: Hi, Thanks for the great reply! - Original Message - From: Richard S. Huntrods [EMAIL PROTECTED] Basically, the mysqldump output is missing the use xxx command to change to the target database. I have a perl script that does that (and extracts

RE: [PHP] Access denied for user

2001-12-06 Thread Richard Black
I would hazard a guess that you have supplied a username/password/host combination that isn't valid. Check in the mysql.user table, and check that there is an entry there for the user and host. Thepassword should be encrypted so you won't know if its what you're typing, but you should be able

C API hangs on full disk

2001-12-05 Thread Richard J. Sexton
mysql_query (connection, qbuf); seems to hang if the disk is full. Surely this isn't right. The command line utility reports disk full but my poor C program hangs never to return from this call. What's up with that? (FreeBSD/Whatever version of MySQL was current this summer) -- With

unable to assign desired memory

2001-12-04 Thread Richard Clarke
Hi, I have a box with 1gig ram which i am using as my mysql server. however when i try to assig about 600megs to the innodb buffer pool it reports that, InnoDB: Fatal error: cannot allocate 524304384 bytes of InnoDB: memory with malloc! Total allocated memory InnoDB: by InnoDB

Probably something very simple...

2001-12-04 Thread Richard S. Huntrods
in. In my 3.23.39 version, I did not have a password on the root account. How do you turn on passwords in the Unix (Solaris) version? Thanks, -Richard - Before posting, please check: http://www.mysql.com/manual.php

Fixed MYSQL password problem!

2001-12-04 Thread Richard S. Huntrods
I fixed the problem I just posted with MySql new installs not seeing my passwords. I had simply forgotten to flush the permissions after I set the password. mysqladmin -u root flush-privileges Cheers, -Richard - Before

table full

2001-11-30 Thread Richard Clarke
DBD::mysql::st execute failed: The table 'ip_src' is full at /usr/local/lib/perl5/site_perl/5.005/i386-freebsd/Mysql.pm line 172. I get this error when running a query on my database. According to the documentation, in later versions of mysql this problem should be bypassed due to the automatic

bin files

2001-11-22 Thread Richard Clarke
So I have found out that mysql creates bin logs of all queries so that it can do rollbacks and such. But is it really necessary for it to maintain these logs forever so that they end up to be 10gigs + for only a few thousand current rows. Ric

Re: bin files

2001-11-22 Thread Richard Ward
file is) file by hashing out the line with: log-bin server-id = x (where x is a number) to #log-bin #server-id hope this helps. cheers richard ward Richard Clarke [EMAIL PROTECTED] 11/22/01 11:06PM So I have found out that mysql creates bin logs of all queries so that it can do

Re: Export just part of a table to a CSV file

2001-11-22 Thread Richard R. Harms
Check out the 'INTO OUTFILE' portion of the SELECT statement. http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SELECT -rh Hello all, Usually I back-up my tables importing them to .csv files. What I do is I issue the following command : mysqldump - h localhost -u user

Re: indexing question

2001-11-22 Thread Richard R. Harms
If you have an index consisting of member_id mail_id (opposite order), you'll need just one index. A good explanation of why may be found at: http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Optimisation.html#Multiple-column_indexes -rh I for sure need an index on the mail_id

insert/delete locking with innodb

2001-11-20 Thread Richard Clarke
If I have a process inserting into an innodb table in 200 insert chunks. i.e. it commits after every 200 inserts, must another process, which wants to delete data from this table, wait for the next commit on the insert end? If not is there any reason why my process is doing this. Ric

Re: database slow down

2001-11-19 Thread Richard Clarke
with it are going to cause me big problems. Any help much appreciated. Richard Regards, Heikki - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

database slow down

2001-11-18 Thread Richard Clarke
, a restart of the database sets the row count of raw to 0 so I really think it is related to this. Most of the queries revolve around this table so any problems with it are going to cause me big problems. Any help much appreciated. Richard

what is - ric-bin.001, for

2001-11-17 Thread Richard Clarke
Can anyone explain to me what these files are for. If they are related to innodb why don't they go in my specified ibdata directory. I set innodb to use 4gig's and when i start mysql it creates this file in the specified location so why does it need to create bin files when i insert rows into my

mysql magically restarts of its own accord

2001-11-16 Thread Richard Clarke
06 13:38:46 mysqld restarted InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 5 778892274 InnoDB: Doing recovery: scanned up to log sequence number 5 778957312 InnoDB: Doing

crashed queries cause big database slowdown - using innodb

2001-11-15 Thread Richard Clarke
Hi, I'm building an application which uses Innodb. It is very imperative that all data is processed as quickly as it possibly can and so the problem I have is quite a concern. My perl script executes the queries however if if make an error in the code and the script crashes half way through

Re: update from table x to table y

2001-11-14 Thread Richard Dobson
they contain things such as this along with 'nested selects' and the such like. T From: DL Neil [EMAIL PROTECTED] Reply-To: DL Neil [EMAIL PROTECTED] To: Richard Dobson [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: update from table x to table y Date: Tue, 13 Nov 2001 21:13:19 -

Re: update from table x to table y

2001-11-14 Thread Richard Dobson
and Raw.Peak1=0; It is with this last query that there is a problem. I can do it in Access with an INNER JOIN. Hope that's clear :-) thanks Rich From: DL Neil [EMAIL PROTECTED] Reply-To: DL Neil [EMAIL PROTECTED] To: Richard Dobson [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: update from

update from table x to table y

2001-11-13 Thread Richard Dobson
Hi does anyone know of a way of taking some data from one table and updating another table with it? If MySQL doesn't support it i'm gonna have to go back to Access or something! thanks Rich _ Get your FREE download of MSN

Re: update from table x to table y

2001-11-13 Thread Richard Dobson
thanks for that, but that will add a row as opposed to updating a column won't it? I don't want to insert a new row. All I want to do is update a value in table1 if it is present in table2 cheers Rich From: DL Neil [EMAIL PROTECTED] Reply-To: DL Neil [EMAIL PROTECTED] To: Richard Dobson

Re: update from table x to table y

2001-11-13 Thread Richard Dobson
] To: Richard Dobson [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: update from table x to table y Date: Tue, 13 Nov 2001 13:49:23 - Duplicating values (cf keys) in tables involves de-normalisation and is therefore not recommended. Your observation row cf column is correct. I felt

Re: innodb inserts/select crash

2001-11-13 Thread Richard Clarke
What does this mean. How can I fix it. It seems silly that I have to read data out just to write it back in again instead of using the create...select command. Rich - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 13, 2001 10:13 AM

innodb inserts/select crash

2001-11-12 Thread Richard Clarke
Hi there. Can anyone offer a solution to this problem. CREATE TABLE `raw` ( `cid` int(11) default NULL, `agent` char(255) default NULL, `referer` char(255) default NULL, `addr` char(15) default NULL, `via` char(255) default NULL, `forward` char(15) default NULL, `ctime` datetime

Problem adding table

2001-10-31 Thread Richard W. Wood
I've been trying to add the following table to my database, and I keep getting the error below. CREATE TABLE mod_userpage_data ( id INT(5) NOT NULL default '0', title VARCHAR(200) NULL, data LONGTEXT NULL, PRIMARY KEY (id) ); ERROR 1064 at line 1: You have an error in your SQL

Re: Problem adding table

2001-10-31 Thread Richard W. Wood
The problem was in fact an illegal column name in one of the tables that a Content Management program tried to create. (phpWebSite) The program seems to be well done, but somehow they missed a beat on one of the modules that it creates (or doesn't because of the illegal name) I tracked it down

RE: MySQL 4.0 released

2001-10-19 Thread Richard C. Tucker
and select for update statements. Of course it does not apply to MyISAM since MyISAM has neither row level locking or transactions. -regards Richard Tuckerhttp://www.nusphere.com Gemini team member - Before posting, please

Re: How many OR, AND in a query?

2001-09-26 Thread Richard Brown
If you use just 1 OR you will force a table scan and slow everything down ? - Original Message - From: Mysql List [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: 26 September 2001 20:06 Subject: How many OR, AND in a query? Hi, How many OR or AND can I put in a select query

Re: can any one help please?

2001-09-25 Thread Richard Brown
Hi Do you have 'the book' MySQl if so read pages 464-465. if not try deleting the anonymous entries in the user table. They can cause this error. Hope that helps Richard - Original Message - From: David Iyoha [EMAIL PROTECTED] To: Adams, Bill TQO [EMAIL PROTECTED] Cc: [EMAIL

Re: creating database

2001-09-25 Thread Richard Brown
IF EXISTS contact; CREATE DATABASE aardwolf; === use something like the line below should do the trick :-) mysql -u root create.sql Also make sure you have deleted the anonymous users in the user data base they cause alsorts of problems Richard - Original Message

Re: Help - I'm completely locked out of mysql

2001-09-22 Thread Richard Dice
FLUSH PRIVILEGES! If you don't know what this means, read up about it in the manual. Good luck... Cheers, Richard -- Richard Dice * Personal 416 841 7365 * Fax 416 841 7364 ShadNet Creator * http://shadnet.shad.ca

Re: surely an easy quick one

2001-09-16 Thread Richard Dice
that this is the book that you should get. But if you want to increase your SQL knowledge, you should look into getting something. Cheers, Richard From: Jamie Burns [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 14, 2001 9:08 AM Subject: surely an easy quick one Hello again :o

Perl MySQL OO design question

2001-09-10 Thread Richard Reina
INSERT that all scripts call when they need to insert create a new record in a table? Richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

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

2001-09-07 Thread Richard Elsberry
\bin winmysqladmin to shut down the server. This works for me now but I'm not sure if it will cause problems later. I can't tweak any of the scripts in c:\mysql\bin so not sure what other options I have. Is there a better approach than this kind of work around? Thanks, Richard

Using SELECT * without full field select permissions

2001-09-03 Thread Richard William Lake
in MySQL. Any comments? Regards, Richard Lake. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL

<    2   3   4   5   6   7   8   >