Tim Murtaugh wrote:
Hi,
I'm using MySQL server version 4.0.15a in an embedded envirionment (as a
standalone server, I'm not using the embedded server library). I have 128 MB
of memory and disk space is tight. I'm using MyISAM tables.
If my system loses power, some tables are left in a corrupt
L a n a wrote:
Hello,
I've had a problem:
statement SELECT data_id from table WHERE keyword = a NOT keyword =b
returns SQL error
This makes no sense.
You have no column named data_id.
You have no columns named a or b.
You have no no keywords that have a value of 'a' or 'b'.
What exactly are you
ian douglas wrote:
Id Study keyword
1 AK1
2 AK2
3 BK1
4 BK2
5 CK1
6 Ck3
SELECT DISTINCT Study FROM yourtablename WHERE keyword='K1' AND NOT
keyword='K2'
That *should* give you a single entry for 'C' since its keywords do
not match both 'K1' *and* 'K2'
No. Rows 1
Cecep Rosuludin wrote:
Dear Gleb,
[EMAIL PROTECTED] mysql-standard-4.0.21-pc-linux-i686]# chown -R root /var/lib/mysql
[EMAIL PROTECTED] mysql-standard-4.0.21-pc-linux-i686]# chown -R mysql /var/lib/mysql
[EMAIL PROTECTED] mysql-standard-4.0.21-pc-linux-i686]# chgrp -R root /var/lib/mysql
[EMAIL
Paul Fierro wrote:
One of my slaves stopped running due to a corrupted relay log. The error
file shows:
Error writing file 'dbs2.log' (errno: 28)
Error in Log_event::read_log_event(): 'read error', data_len: 160,
event_type: 2
$ perror 28
Error code 28: No space left on device
You are out of
What about
select distinct a.region, a.city
from mytable a , mytable b
where a.region=b.region and a.city b.city
Jay Blanchard wrote:
[snip]
Anybody?
I have a simple problem and I'm just wondering the BEST query to
solve
it.
I want to return all the rows of a table whose foreign key
Matthias Urlichs wrote:
We have a slight opimization problem here.
Given this table:
CREATE TABLE `test` (
`IP` varchar(15) collate latin1_german1_ci NOT NULL default '',
`Type` enum('WARN','ERROR','FATAL','UNKNOWN') collate latin1_german1_ci NOT NULL
default 'WARN',
`epoch` int(10) unsigned
Lau Sennels wrote:
Hello.
I am trying to set up a MySQL database shared between SuSE 9.1 and a Win XP
(both 4.0.18 from binary). The database resides on a FAT32 partiton
accessible from both OS's.
I am able to access the database transparently from Win XP by modifying
my.cfg as described in
Sanjeev Sagar wrote:
Hello All,
I am trying to create a perl DBI/DBD script for creating a database initial build. My input is a extract file, which is a mysqldump result file with --opt and -B option.
I am using DBIx::DWIW. I am able to open a successful database handler. I am having
code
Scott Hamm wrote:
How do I create table that uses timestamp in -dd-mm format as primary id
(no duplicates)?
You can't.
Timstamps are only unique down to 1 second.
It is quite possible to insert hundreds, if not thousands of records in
that length of time.
--
MySQL General Mailing List
For
What indices do you have?
What does explain say?
Richard Reina wrote:
Anyone know why this query takes so long?
SELECT SUM(l.cost+l.fscc)
FROM orders o, acctg.invoice i
LEFT JOIN acctg.payable p
ON (o.ORD_NO=p.ORD_NO)
WHERE p.ORD_NO IS NULL
AND i.ORD_NO=o.ORD_NO;
Is there something I can do to
RV Tec wrote:
Folks,
A couple of months ago I asked this question, and there was no answer,
since then I couldn't find a reasonable answer or a way to find it myself.
What happens if MySQL runs out of space at TMPDIR? I guess I could use the
performance improvement of redirecting that to a MFS
Yes.
RV Tec wrote:
Clark,
MySQL will stop processing the current query until space becomes
available. It will then continue.
Stop processing the current query means locking it all, and everything
else has to wait for this query to be completed?!
Thanks for your reply!
Best regards,
RV
Daniel Kasak wrote:
gerald_clark wrote:
Batara Kesuma wrote:
Hi,
I have a table that looks like:
CREATE TABLE `message_inbox` (
`member_id` mediumint(8) unsigned NOT NULL default '0',
`message_id` int(10) unsigned NOT NULL default '0',
`new` enum('y','n','replied') NOT NULL default 'y
Batara Kesuma wrote:
Hi,
I have a table that looks like:
CREATE TABLE `message_inbox` (
`member_id` mediumint(8) unsigned NOT NULL default '0',
`message_id` int(10) unsigned NOT NULL default '0',
`new` enum('y','n','replied') NOT NULL default 'y',
`datetime` datetime default NULL,
KEY `idx_1`
Carolina wrote:
using mysql version 4.0.13
- **total newbie here**... something as simple as renaming a
database...i've not found anything relating to that on the mysql site
or anywhere else. what i have found is that in order to do this, i'd
have to shutdown and restart the mysql database in
Camilla Brodén wrote:
Hi!
I am trying to do an inner join of two tables using a char(3) key. The field I am
joining by contains integers with sometimes leading zeros.
If it is a char(3) field it contains characters, not integers.
The inner join works when the field is a full 3 character field,
Jeff Burgoon wrote:
Why does selecting backslash give me an error?
select \
gives me...
#1064 - You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use near
'\' at line 1
select /
returns /
select \\
returns \
What's the
Gerald Taylor wrote:
Query optimization question
I am selecting from a single table but it has a lot of rows and it
has a very involved calculation. What I really want to do is
is FIRST restrict the number of rows so that the big calculation is only
performed on the ones that are within 3
Kevin Cowley wrote:
Running 4.1.4 with a database that has a default encoding of UTF8
If we execute the following we get an error.
CREATE TABLE idxbe_resident (
urn INT UNSIGNED NOT NULL,
keyAddress_Part1 CHAR(5) BINARY NOT NULL,
dataPerson_Name CHAR(60),
dataAddress_Part1 CHAR(140),
Anne Ramey wrote:
I had a server hacked last night and they did alot a damage, but I
think I've got just about everything back up as normal...including a
brand new mysql installation (4.0.21). My problem is this. The
4.0.21 or the old 4.0.20 will not start using mysqld_safe and will
start
David Lowe wrote:
Greetings!
I had mysql 4.0.18 installed from the binary package, was working
my way through the tutorial [totally new to database work]. Then i
installed the 4.0.20 package [again from your binary], i can't start
the server. Here are the results:
This is the third time you have asked this, and it has been answered twice.
Once is enough.
Rui Monteiro wrote:
Hello there,
I was wondering how I could make a specific type of search when the string
has more than one word.
Ex.-
String = Green Apple
Mauricio Pellegrini wrote:
Hi,
I'm using Between to fetch rows whose date column is between two dates.
The thing is, sometimes it brings all the rows including those with a
date similar to the upper limit ( which is the correct behaviour,
according to the manual)
and in other cases it brings
Depending on how exact the returned values need to be, and how much data
you have to
sift through, you could do. ( perl example )
$job=$dbh-quote($job.'%');
$city=$dbh-quote($city.'%');
$start=$dbh-quote($start.'%);
.
.
.
$select = SELECT * from myfile where jobtitle like $job and city like
You still did not send your table definitions.
Jeremy Brown [InfoSend] wrote:
Michael,
Thanks for the response. My query was kind of long, so I was just
trying to simplify. Should have included it anyways.
Here is my query:
select REFCLIENTS.sample, TRACKING.* from REFCLIENTS, TRACKING where
Stuart Felenstein wrote:
The returned values should be exact. As far as how
much data, I'm assuming your talking about amount of
records ?
Potentially eventually maybe quite a bit.
Currently mysql statement is comprised of select and
from with all the proper joins.
But Im confused, when you say
Suresh wrote:
Hi,
Yes ofcourse it is a primary key with two fields. The insert exists whenever it
has a duplicate entry, it doesn't continue with further records. Is there any
scope to resolve it.
Thanks
Suresh
Eldo Skaria wrote:
insert ignore
--
MySQL General Mailing List
For list archives:
SELECT * FROM test
WHERE bpm ( 100 * 1.08 ) AND bpm (100*.92)
Stembridge, Michael wrote:
Hello,
I have a music database containing song BPM (Beats Per Minute) data values
stored as FLOAT. I need to pull a range of BPM values based on a
user-supplied integer. The range should pull all
Ronan Lucio wrote:
Hi,
Supposing we have for tables:
One master table (student) and three independent tables.
There is no relationship between them.
Each of the three table have a relationship with table student.
City | Teacher | TestLocal
| === | =
city_id |
Bret Busby wrote:
In trying to download the mysql Linux x86 RPM server rpm download from
http://mysql.mirrors.ilisys.com.au/Downloads/MySQL-4.0/MySQL-server-4.0.21-0.i386.rpm
after an hour or so downloading it, I ended up with an error message;
Plugger: no approperiate (sic) application for
perror 144 shows
Table crashed.
Run myisamchk on the host file if you can.
95% full is not good.
Mysql needs free space to do database repairs, schema changes, and index
changes.
If you don't have as much free space as your largest table+index you
have a problem.
diegon wrote:
Hello everybody,
This is the 3rd time you have asked this.
Perhaps you should take it to a perl list where it belongs.
Kirti S. Bajwa wrote:
Hello:
I am trying to install Perl support with MySQL. After installing MySQL
(v4.0.20)I run the following commands:
% echo $PATH
% perl -MCPAN -e shell
bruce wrote:
i have a tbl with the following...
foo date1
foo2 date2
etc...
how can i do a select to get the last or 1st row based on the
(latest/earliest) date?
SELECT * FROM tbl order by datecolumn DESC LIMIT 1;
SELECT * FROM tbl order by datecolumn ASC LIMIT 1;
can't seem to get it to work..
Carlos Savoretti wrote:
Hello all:
I need to make certain operations like this:
select tbl_no as 'Number' , @sal1 := tbl_db - tbl_hb + @sal1 as 'Total'
I'm using the C API; so I make it through mysql_query()
Problem is than having `tbl_db' and 'tbl_hb' with certain values no
operation is
Stuart Felenstein wrote:
I have this query (below) that on it's own , directly
into the database seems to return all the records just
fine. Apparently though feeding it into a php loop,
the lack of where is causing great distress(at least
to the author)
I'm wondering where to put it though.
Monet wrote:
Hello there,
I tried REPAIR TABLE to recovery the crushed temp
table and that works. Thanks a lot.
But, after reparation, there are some duplicated
records generated. Is that because the temp table has
no primary key? Or is because the table was crushed in
the middle of query?
Tim McDonough wrote:
Is there a way to write the results of a query to an output file on a
client computer instead of the server? My reference book says MySQL
cannot write to a file on the client.
I have a work around by using a PHP script on the user's machine that
does a MySQL query,
Igor Zinkovsky wrote:
After upgrade from 4.1.2 to 4.1.4 I can't start mysqld
error log:
040902 21:47:53 mysqld started
040902 21:47:53 [ERROR] Warning: Asked for 196608 thread stack, but got
126976
/usr/sbin/mysqld: Can't create/write to file '/root/tmp/ibezxsoi' (Errcode:
13)
mysql does not have
J S wrote:
Hi,
I want to copy data from one table to another. However I need to do
this carefully because I haven't got much of space left. I was
thinking of maybe selecting data from every 10 rows of the old
table, inserting it into the new table, then deleting those rows from
the old
We have no idea what you are running, or what you are running it on.
matt ryan wrote:
040901 18:36:21 Error reading packet from server: binlog truncated in
the middle of event (server_errno=1236)
040901 18:36:21 Got fatal error 1236: 'binlog truncated in the middle
of event' from master when
Manisha Sathe wrote:
I want to select first 10 records out of 100. And then get the 10th
position.
If i make use of
order by score asc limit 1
then I will get 100th record, How shall i pick up 10th position?
regards
Manisha
order by score desc limit 9,1
--
MySQL General Mailing List
For list
matt ryan wrote:
Replace deletes and inserts.
?
what do you mean?
Replace does a delete followed by an insert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
matt ryan wrote:
matt ryan wrote:
Replace does a delete followed by an insert.
Ahh, I'm testing innodb on our tables with this problem
I've switched to innodb but performance isnt very good
while the insert runs, here's what I get for performance
select count(*) from rondon;
1 row in .13 sec
Jeff Meyer wrote:
I have the following table:
+-+-+
| ID_AGE | ID_ENTRY |
+-+-+
| 1 | 1 |
| 1 | 4 |
| 1 | 5 |
| 2 | 1 |
| 2 |
matt ryan wrote:
SQL is, replace delayed into table c1, c1, c3 select c1, c2, c3 from
temp table.
This takes 2 hours to comlete, the temp table is rather large.
The table being updated is locked, the whole time, all web requests
are locked and the pages time out.
Is there any way to get this
Mayuran Yogarajah wrote:
From the MySQL docs:
Each |MyISAM| table is stored on disk in three files. The files have
names that
begin with the table name and have an extension to indicate the file
type.
An `.frm' file stores the table definition. The data file has an `.MYD'
(MYData) extension.
Schalk Neethling wrote:
I run the following type of query against it:
SELECT * FROM documents WHERE MATCH (content) AGAINST
('demyer Padgham robinson') AND doctype = 'Motion' AND jstate =
'California:
State Court' OR jdistrict = 'Circuit Court: Federal, California'
SELECT * FROM documents WHERE
Alan wrote:
Description:
See how-to-repeat.
How-To-Repeat:
CREATE TABLE A (A int);
CREATE TABLE B (B int);
CREATE TABLE C (A int, B int);
INSERT INTO A VALUES (1),(2);
INSERT INTO B VALUES (1),(2);
INSERT INTO C VALUES (1,1);
SELECT C.B
FROM A
INNER JOIN C ON C.A = C.A
Perhaps you
If you want them ordered by autoinc_field then add
ORDER BY autoinc_field.
Otherwise expect them to be returned in any order.
Cres Justado wrote:
can anyone help me with my problem regarding mysql 4.0.2. I'm having a
problem with the sequencing of the auto incremnt field. if my
application
Jason Joines wrote:
Is it possible to use a wildcard for field names in a select?
No.
For instance if I have a table with a hundred columns and I want to
retrieve all rows who have a certain value in any column but don't
want to type in a hundred column names in my query, how do I do it?
Alex wrote:
I'm having a problem with summing up joined tables.. can anyone help me?
I have 3 tables that I am joining together
vpn, dialup, and userinfo
vpn has the following columns
(This was a premade table so i couldn't change username into user_id
to link with userinfo)
username
aspsa wrote:
Per the MySQL documentation I used the following commands to establish login
both at the local host and remotely.
mysql SET PASSWORD FOR ''@'localhost' = PASSWORD('newpwd');
mysql SET PASSWORD FOR ''@'%' = PASSWORD('newpwd');
When I attempt the following locally from the Command
Why should it use any other?
Timestamp is the only field in the where clause, and you are selecting
all fields.
The second index would require more index reads, and the third can't be used
to satisfy the where clause.
Eamon Daly wrote:
Okay, now I'm even /more/ confused. I whittled everything
-
From: gerald_clark [EMAIL PROTECTED]
To: Eamon Daly [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, July 29, 2004 8:04 AM
Subject: Re: JOIN/WHERE and index confusion
Why should it use any other?
Timestamp is the only field in the where clause, and you are selecting
all fields.
The second
If you have an auto_increment or other unique recno you can do:
select a.* from file a , file b where a.timefield = b.timefield and
a.recno != b.recno
Robert Reed wrote:
No worries mate, that is exactly what I need, and the
number I've got are 32 and when I subtract the ones
more than a year
Whil Hentzen wrote:
Hi folks,
Just installed MySQL 4 on my Fedora Core 2 box (that didn't have any mysql on
it initially.) Three questions.
I'm reading through the doc (gasp!) on the mysql.com site, specifically, 2.4
Unix Post Installation Procedures:
Your model is flawed.
My son and I have the same first and last names.
Therefore, we could not be users on your system.
Adaikalavan Ramasamy wrote:
I am creating a small database that keeps track of users and assigns
them a unique user ID.
The problem is that sometimes the users might request to
Steve Richter wrote:
-Original Message-
From: Michael Abbott [mailto:[EMAIL PROTECTED]
Sent: Monday, July 26, 2004 11:28 AM
To: [EMAIL PROTECTED]
Subject: RE: using mysql in commercial software
This may not be strictly legal, but you could have the end user download
MySQL.. to
You don't say what version you are running.
Did you forget to commit?
[EMAIL PROTECTED] wrote:
Dear friends,
When I import records fron csv file.I window pops up, stating total number of
records imported, however when I check table nothing has been imported.Any
guidance,
--
MySQL General
Ginger Cheng wrote:
Hello, MySQL gurus,
Since I have been moving data around using mysqldump recently, I
have found sth annoying:
If a table has a column defined as 'float not null' and the
corresponding txt file used to load it have sth like 'nan' for the
column, although giving
You don't say how you retrieved the data or how you are checking the
size of the returned data, but beware.
Most languages will interperate a byte with a value of zero as the end
of a string.
Assigning the result to a string, or doing a length() of a returned
block will give a false answer.
mysql -i filename.sql
matt ryan wrote:
Lopez David E-r9374c wrote:
Since you have a temp table created (no keys I assume), use the command
mysqldump -v -e -n -t dbname tablename filename.sql
This creates a file that inserts the records back into the same table
it also does not do an insert
What are you asking?
Hausmann Johannes IT5624 wrote:
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Acces rights in 4.1.2
Description:
Hi , i've installed the packages and created one db user called pm_user.
the host is called pm-spa280. I created GRANTS for [EMAIL PROTECTED] and
Harald Fuchs wrote:
In article [EMAIL PROTECTED],
gerald_clark [EMAIL PROTECTED] writes:
Asif Iqbal wrote:
Jack Coxen wrote:
If you database contains time-based data you could age out old records. I
only need to keep data for 6 months so I run a nightly script to delete any
Asif Iqbal wrote:
Jack Coxen wrote:
If you database contains time-based data you could age out old records. I
only need to keep data for 6 months so I run a nightly script to delete any
records more than 6 months old. And before anyone asks...yes, I also run
another script to
Hardware?
OS and version?
MySql version?
Size of data file?
Size of index file?
Filesystem type?
Jim Nachlin wrote:
I have a table with several keys. When I try to delete anything from
this table, I get data corruption and have to repair it with
myisamchk. Selects, updates work fine.
Here's
Elmar and Madeleine von Muralt wrote:
Hi,
I'm completely new to MySQL and some of its concepts, therefore, these
questions may be very basic.
To connect to another database format I need the ODBC driver for that
other format - right?
I've built a repair job entry database on my Palm with
darren wrote:
Hi all,
I have 2 tables...one for keeping active items while the other is for older
records.
A housekeep program will come in every night to move some records (matching
several criteria from the active table to the history one.
I am currently doing SELECT, INSERT and then DELETE.
What about getting a bigger drive?
Asif Iqbal wrote:
Hi All
My mysql data dir is filled up to 95% and only 345M left.
Here is the dir looks like
1.9Gibdata1
3.1Gibdata2
3.0Kib_arch_log_02
3.0Kib_arch_log_04
25K ib_arch_log_00
65M rt3
67K
We delete all binlogs over 7 days old.
We figure that if a slave gets that far behind, it is easier and faster to
restore last nights master backup and edit the master.info file on the
slave to
point to todays log file.
Luis Mediero wrote:
Hi,
I would like write a script to purge every
.
But does he even have enough disk space to optimize tables?
Jack
-Original Message-
From: Asif Iqbal [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 07, 2004 2:07 PM
To: gerald_clark
Cc: [EMAIL PROTECTED]
Subject: Re: Space is filling up
gerald_clark wrote:
What about getting a bigger drive?
I
I am not sure what you are trying to do.
Do you want a join, or a union.
Your query is neither, and the results are correct as written.
Dave Gibson wrote:
Hi,
I'm getting some unexpected behaviour from a query and was
hoping someone could shed some light on whether it's a user
error or something
It is telling you that your hard drive is failing.
Replace it.
Hanno Fietz wrote:
Hello everybody,
I'm experiencing problems with a 4.0.15 MySQL-Server running on a SuSE
Linux 8.2 box with 512 MB RAM, some one-point-something GHz CPU and 40
GB IDE Harddisk.
We have a database with some
SHOW MASTER STATUS will show you where you currently are on the master.
You should connect to each slave, and do a SHOW SLAVE STATUS to find where
the slaves are, and delete the logs lower than the lowest one in use by
the slaves.
Luis Mediero wrote:
Hi,
I'm looking for an automatic method
MaFai wrote:
Dear ALL:
Some time the slave would crushed by I/O error.It happen at the server with the lower
CPU.( per 45 days )
All of the slave database has block the binary log,it reduce the CPU loading.
The database would replicate text,int,varchar but no blob.
Network connection hasn't
the rather large demand for temporary disk space account for that?
Thanks,
Hanno
gerald_clark wrote:
It is telling you that your hard drive is failing.
Replace it.
Hanno Fietz wrote:
Hello everybody,
I'm experiencing problems with a 4.0.15 MySQL-Server running on a
SuSE Linux 8.2 box with 512 MB RAM
This is not a mysql question, and please do not cross post.
Any good book un Linux networking will cover this.
Open port 3306.
bruce wrote:
hi...
i'm investigating what needs to be done to allow mysql on a server to be
used remotely by client machines. each machine is running iptables. so i'm
If I want 20 rows to display, I ask for 21.
If I get 21, I know to ask for another page.
Bob Lockie wrote:
Moved from a PHP list to a MySQL list. :-)
On 06/30/2004 09:55 PM John W. Holmes spoke:
Bob Lockie wrote:
If I select rows with a limit clause I need to know if there are
more rows than
Re-installing does not get rid of your old passwords.
You need to use the -p option.
Nguyen, Long P (Mission Systems) wrote:
Hi -
I am new to MySQL - I just recently re-installed MySQL by rpm and when ever I try to issue
a command from the shell prompt, such as mysqladmin or mysqlshow, I would
select count(*) as cnt group by ip order by cnt desc limit 10;
rmck wrote:
Hi,
I have a table with ip,port and I want to see the top ten Ip's with the most entries?
Ip's can be in db many times...
Not the first distinct 10... Im stuck...
I have tried:
mysql select DISTINCT ip from iptable limit
Bing Du wrote:
I have two mysql servers as shown below:
MySQL server A: version 3.23.58, database: mydb, table: mytable
MySQL server B: version 5.0.0-alpha-standard-log
I want the server B to have the exact same database and table as those on
the server A. So, on server B, I manually created a
I answered this same question from you several days ago.
It is Redhat's ps that changed, not MySQL
Oscar Hernández Hernández wrote:
Hello:
I have just installed a Linux RHAS 3.0 with mysql-3.23.58-1,
mysql-devel-3.23.58-1 and mysql-server-3.23.58-1.9.
When mysql starts, there is just listening
Jim Shea wrote:
I'm setting up a cron job to run myisamcheck with the options
-Aacmorv. As I have to put in a username and password, for security
I want to create a special account that has the minimum required
rights. In searching the docs I don't find this listed.
Setup a .my.cnf file that
I suspect he is refering to 3.23's inability to use an index on a ORDER
BY xxx DESC
Jeremy Zawodny wrote:
On Wed, Jun 23, 2004 at 11:36:52AM -0400, Alejandro Heyworth wrote:
Does anyone know when INDEX DESC will be implemented?
I'm storing time values and want to access the data from the most
Alejandro Heyworth wrote:
I don't see any relationship between your two sentences?
Thanks for the responses.
I guess I was not clear enough in my last post.
You can define an index to sort values in a particular order... ASC
is the default.
DESC is an option, but it is not implemented yet. I
Jeremy Zawodny wrote:
On Wed, Jun 23, 2004 at 02:28:15PM -0500, gerald_clark wrote:
I suspect he is refering to 3.23's inability to use an index on a ORDER
BY xxx DESC
In other words ancient history :-)
Not only that, but without ORDER BY, no order is assured.
Jeremy
--
MySQL General
Oscar Hernández Hernández wrote:
Hello:
I have just installed a Linux RHAS 3.0 with mysql-3.23.58-1,
mysql-devel-3.23.58-1 and mysql-server-3.23.58-1.9.
When mysql starts, there is just listening one mysql-daemon.
When I had this configuration running in Redhat 7.3, mysql started 4
No, 4
Victor Pendleton wrote:
load data infile 'absolute-file-name' into table helpdeskgrouptotal;
-Original Message-
From: Chris Stevenson
To: [EMAIL PROTECTED]
Sent: 6/22/04 9:58 AM
Subject: Newby to loading
I'm trying to load ACD call data into a table for the first time. I've
saved my
It looks like mysql does not own the data directory.
[EMAIL PROTECTED] wrote:
Hello List,
I have done some googling around but can't find an answer to this one. Brand new box,
installed with RedHat 9 and trying to run 4.1.2. This is what I get.
--ja
[EMAIL PROTECTED] mysql]#
wrote:
I have large fact table, in which there are much ids (that are in fact
foreign keys but as long as I use MyISAM engine them are not
technically). So when I try to join another table (that contains text
descriptions for each id from one of fact columns, so it has two
fields (id (PK) and
Cemal Dalar wrote:
Hi all,
I'm running a mysql master - slave configuration. My Slave server is on
a dynamic IP address and I restricted the access to master only from
specific IP address for security. I am getting backups through slave server
and writted a small java application to monitor
Cao, Wenhong wrote:
Hi,
I am trying to get the records for the activationstamp within a certain
range. The activationstamp is defined as character(14) in the ddl.
I don't know how to cast the activationstamp field to timestamp before
doing the comparison. I tried to use date(), but it didn't
Developer
http://www.gittigidiyor.com http://www.dalar.net
- Original Message -
From: gerald_clark [EMAIL PROTECTED]
To: Cemal Dalar [EMAIL PROTECTED]
Cc: Group MySQL List [EMAIL PROTECTED]
Sent: Thursday, June 17, 2004 4:30 PM
Subject: Re: How to monitor that slave is not working because of user
Cemal Dalar wrote:
Actually. I am talking about a machine which is at office. And inside office
we're connecting using ADSL which gets dynamic Ip address. The slave
server's IP address actully doesn't change. It doesn't have a real ip
address only the ADSL has. Simply saying we are using NAT.
Are you running out of temp space?
Tim Brody wrote:
binary MySQL 4.0.20-standard on Redhat 7.2/Linux
Dual-proc, 4Gb ram, raid
I'm trying to change an index on a 12Gb table (270 million rows). Within an
hour or so the entire table is copied, and the index reaches 3.7Gb of data.
Then the database
Bob Lockie wrote:
Where is the syntax error in this?
select name from users where name like '%' and strcmp( substr(name
from 1 for 3), 'abc' )=0;
substr(name,1,3)
Check the manual.
You don't include the 'from' and 'for'.
Why should I use strcmp since MySQL automatically converts numbers to
Mack Richardson wrote:
I'm running MySQL 4.0.20 on Mac OS X 10.3.4. I've added the my.cnf to the
etc directory,
Which one, and why?
Did you restart the server after changing my.cnf?
but mySQL server returns the following error:
ERROR 2002: Can't connect to local MySQL server through socket
select sec_to_time(time_to_sec(transfer_end)-time_to_sec(transfer_start));
Dirk Bremer (NISC) wrote:
Looking at the results further reveals that a numeric subtraction is being
performed on the two datetime fields rather than a date-type subtraction.
Any thoughts on how to perform a date
Eric Lommatsch wrote:
Hello,
We had a situation over night where users were getting the error message:
[My SQL][ODBC 3.51 Driver][mysqld-4.0.13-nt] Can't open file: flex. MYI:
[error : 145]
I found that .MYI file had become corrupted and I repaired the table and
things are working as they should
101 - 200 of 608 matches
Mail list logo
