Good Day All,
Let's say I have a paragraph within a field name [summary]
=
United States jets reportedly continued bombing targets Thursday
in Kandahar, and United States special forces were on the ground
coordinating with ethnic Pashtun
Today my slave aborted replication with error (this is the third time in
2 days)
---
06 9:21:23 Slave: error running query 'insert into user_lock
(what,user,locked) values('front edit','ninas'Ý¿ô;'
06 8:27:40 Error running query, slave aborted. Fix the problem,
and re-start the
On Thu, 15 Nov 2001, Gabor Penoff wrote:
can you tell me an estimated speed about filling 100 records with
mysql insert by using the C api?
Last insert job I ran did c. 400 inserts per second. This is real
(wall) time and some computations were involved.
(Dont go running fetching a
Erik Price writes:
Hello all,
Some of you may recognize this post somewhat, I've asked about this
problem before:
I am unable to execute the shutdown command with mysqladmin, running
on Darwin 1.4.1 (from Mac OS X 10.1.0).
Originally, I had compiled MySQL 3.23.44 from source code,
On Thu, 15 Nov 2001, Rick Robinson wrote:
I'm using a MyISAM table in a high availability environment as a rudimentary
persistent FIFO queue. The table definition is simple - the key is an
auto_increment unsigned bigint and the data is a blob (it holds the contents
of a C structure with a
Max writes:
Description:
I am using russian values(cp1251 charset) for ENUM items.
Here is an example how to damage ID field by query to change
F_Category Enum.
How-To-Repeat:
# Create tableA with ID field.
CREATE TABLE tableA (
ID int(11) NOT NULL
Which drivers do you want to install?
1) MySQL only
2) mSQL only (either of mSQL 1 or mSQL 2)
3) MySQL and mSQL (either of mSQL 1 or mSQL 2)
4) mSQL 1 and mSQL 2
5) MySQL, mSQL 1 and mSQL 2
Enter the appropriate number: [3] 1
Do you want to install the MysqlPerl
Just wondering if anyone who knew the answer to this might have missed it
before -- sorry to keep nagging but I really need to find out how, or
whether, you can determine which fields in a table are foreign keys
referencing another table.
Is it not possible to determine, after a table is
Hi
I have just installed mysql directly onto my f:\ drive (instead of
installing on c: and moving it across). I run Windows ME. However, when I go
to my MS-DOS mode and navigate to my bin directory, then input the following
command:
F:\MySql\binmysql -h localhost -u root -p
it tells me Error
From:
Gani Pola
PCI Data
Marketing Division
434 Ridgedale Avenue, PMB # 11-108
East Hanover NJ 07936
Tel: 1-888-248-3443 OR 1-888-713-7201
Fax:1-603-297-5644
mailto:[EMAIL PROTECTED]
Attention: Recruiting Department/Human Resources Department
Did you put the my.ini file in the c:\windows directory?
- Original Message -
From: Shabbir Yusufali [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, October 30, 2001 2:30 AM
Subject: SQL server
Hi
I have just installed mysql directly onto my f:\ drive (instead of
installing on
Hi.
Is it planning add macro defintions to MySQL ?
Thanx.
--
Goodbye.
Dannis.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
In a database that enforced referential integrity, if you say that a field
in one table is a foreign key referencing another table, then any value in
the foreign key field in the first table must reference an existing row in
the second table. (Right?)
But suppose you have a database storing,
Bennett Haselton wrote:
The problem is, how would you add a new bus and a new driver to the
database? Whichever one is added first, you're going to get an error
because its counterpart doesn't exist yet, violating referential integrity.
I was under the impression that databases enforced
Hello,
I installed binary mysql-3.23.44-sgi-irix6.5-mips on irix 6.5.10 following
README. When I issue 'mysql mysql' or 'mysql versions' I got:
ERROR 1135: Can't create a new thread (errno 1). If you are not out of available
memory, you can consult the manual for a possible OS-dependent bug
Hello,
I have problems using the Binary version for SGI
MySQL 3.23.44 SGI Irix 6.5 (6.3M)
It looks like an error in the distribution cq binary program.
After running bin/safe_mysqld on a SGI Indy with Irix 6.5 i get the errors
beneath.
bin/safe_mysqld[133]: ./bin/my_print_defaults: Program
database,sql,query,table
-
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
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
Rich,
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:
Sinisa, everyone,
That's great news! I'm excited to hear that. Which version would that
be... 4.0? Or perhaps another 3.x version?
In the meantime, my boss is going to wonder why I'm not populating a
database for him. He will make me use Access if I don't get cracking,
so... do you know of
Why don´t you try
select TO_DAYS(end_date)-TO_DAYS(start_date) as duration : this will return
the difference in days
if you need mor accuracy i.e. difference in hours, you should word on a
TIMESTAMP 14 instead of date ; this data type holds up to seconds and is
mathematically easy to operate ...
Hi,
I'm currently working on a project in which I am working with CGI scripts
for a web based user interface, and MySQL for my database. I'm a student at
a University of Waterloo (in Canada). The program is a hotel reservation
system (irrelevant) and I'm coding in C and C++. The system is being
On 15 Nov 2001, at 22:32, Carsten H. Pedersen wrote:
Thanks for the response, but I think you missed the key
collection_field_value right under the primary key above.
You're right -- Sorry. Have you tried COUNT'ing something
other than *? i.e. document_id or resource_id?
I tried it.
Rich,
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:
Install the zlib RPM.
Abimael Ailton Machado wrote:
Which drivers do you want to install?
1) MySQL only
2) mSQL only (either of mSQL 1 or mSQL 2)
3) MySQL and mSQL (either of mSQL 1 or mSQL 2)
4) mSQL 1 and mSQL 2
5) MySQL, mSQL 1 and mSQL 2
Enter the
On Thu, 15 Nov 2001 23:29:27 -0800, Jeremy Zawodny used
a few recycled electrons to form:
| On Thu, Nov 15, 2001 at 04:14:58PM -0600, Michael Brunson wrote:
|
| Has anyone ran any benchmarks as to what affect different number of
| RAID_CHUNKS has on speed?
|
| The more chunks, the slower your
You are missing the password and user, and the proper privilege
configuration at your server.
Read up on GRANT in the manual.
[EMAIL PROTECTED] wrote:
Hi,
I'm currently working on a project in which I am working with CGI scripts
for a web based user interface, and MySQL for my database. I'm
Hi.
How can I make FTS index single-character words? I have tried changing the
ft_* values in my.cnf and rebuilding the tables/indices, but I still seem to
be unable to get indexing of single-character words to work.
For example, if I need to index occurences of c++, it doesn't work. I
This is a remedial question, but I am trying to get myisamchk to run from
the database directory. All I keep hearing is put it in your path and you
can run it from anywhere (as opposed to having to be in the bin directory to
execute it). I have searched the web, but haven't found a simple
you're probably not running the server on port 3306. when you start the
mysql server, use --port=3306
[EMAIL PROTECTED] wrote:
Hi,
I'm currently working on a project in which I am working with CGI scripts
for a web based user interface, and MySQL for my database. I'm a student at
a
Description:
I have 2 Servers one master and one slave.
The Master was 3.23.36 and the slave 3.23.44 and i start a replication
between these servers. Then i get errors:
error 'Unknown table 'o,i'' on query 'drop table db_logistik.o,db_logistik.i
from the replication server.
I found the bug
George,
At a minimum, you have to setup a user with permissions to access the
database. Once you have that done I think it might work
[EMAIL PROTECTED] wrote:
Hi,
I'm currently working on a project in which I am working with CGI scripts
for a web based user interface, and MySQL for my
Hi
I have items in a table identified by a Part Number. The Part Number may be
selected by inputting into a php search box (perhaps from users memory).
Example
Original
71HF-9601-AB
Searched for
71HF 9601 AB
or
71HF9601AB
or
Original
36 44 A9
Searched for
36-44-A9
or
3644A9
or with other
Did you *start* mysqld? :
Sounds to me like mysqld hasn't been launched. Check to make sure the server software
is actually running.
HTH
/Rob
Hi:
I telnet to the server. But I can not get into MySql
database. What's the problem?
% mysql
ERROR 2002: Can't connect to local MySQL server
At 04:38 -0500 2001/11/16, Jennifer Slis wrote:
when I type myisamchk my server claims command not found.
Check to see that myisamchk is in your path. Or go directly to the
/usr/local/mysql/bin directory (or where ever it's installed) and type ./myisamchk
[options]
HTH
/Rob
--
Robert
Stephen,
the manual erroneously states that CHECK TABLE only works for MyISAM tables.
I will update the manual. Thanks for pointing out!
Run CHECK TABLE on your tables to check if they are corrupt.
Does CHECK TABLE work on INNODB tables? According to the docs it only work
for the MyISAM type.
I searched the archives and the manual online but could not find the
answer,
I believe this has been covered in the list though. Is it possible to
rename a
database? If not, is it possible to move/copy a table from a database to a
new
database? Could someone point me to the details on this?
--
I may found a solution to my problem
Today my slave aborted replication with error (this is the third time
in 2 days)
Note that it worked for couple of months without a glitch
It has aborted since the sql query had an error ?
1. i think that if the query would have an error it should not
Description:
-- trying to compile source dist 3.23.44 from tarball
-- OS: SuSe 7.0 with gcc 2.95.2
-- configure went fine, with the below specified options
-- I appended the configure output
-- make interrupts with the following error
sql_base.cc: In
Hi,
I am a very beginner of mysql and studying the manul.
I tried set password for user1=PASSWORD('paasw');
after logging in as root user.
Then I quit, try to login as 'user1':
C:\mysql -u user1 -p
and then entered the password paasw. There always an
error:
Access denied for
I'm using Free Pascal 1.0.4 and MySQL 3.22.32
System is RedHat 7.2 (but the same is on RH 6.2)
The Free Pascal package contains mysql unit which makes able to pipe sql
queryes from pascal to mysql.
All worked fine until 3.22.32.
But in 3.23.xx (tested on 3.23.38 and 3.23.44),the error with
stop mysql
cd /var/lib/mysql
mv olddbname newdbname
start mysql
[EMAIL PROTECTED] wrote:
I searched the archives and the manual online but could not find the
answer,
I believe this has been covered in the list though. Is it possible to
rename a
database? If not, is it possible to move/copy
Hello,
I am trying to add a user to the mysql server so that they can access only
certain tables from one of the databases on the server. Anyway the command
that I give is:
GRANT SELECT,DELETE,UPDATE,INSERT,INDEX on clubnet.hsa_exec_listserv to hsa@%
identified by 'hsaadmin';
The table that
Before login with new account you must reload server with this command:
mysqladmin -u root -ppass reload
and then you could login with new account
-Messaggio originale-
Da: wei song [mailto:[EMAIL PROTECTED]]
Inviato: venerdi 16 novembre 2001 17.41
A: [EMAIL PROTECTED]
Oggetto: Access
Ah, good idea. That should resolve my issue.
Thanks!
Zach
-Original Message-
From: Carsten H. Pedersen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 15, 2001 2:08 PM
To: Zach Curtis; [EMAIL PROTECTED]
Subject: RE: Calculating Age
I am trying to calculate an approximate age from
I've been setting up a Linux server at home to have for projects on the
side. I'm new to Linux game, but I think I've got everything set up okay.
The only trouble I'm having is getting MySQL to start up when the server
boots. I thought I'd ask here first--in case I have something w/ MySQL
On Fri, 16 Nov 2001 [EMAIL PROTECTED] wrote:
Date: Fri, 16 Nov 2001 11:40:06 + (GMT)
From: [EMAIL PROTECTED]
To: Rick Robinson [EMAIL PROTECTED]
Cc: Mysql \\(E-mail\\) [EMAIL PROTECTED]
Subject: Re: What maintenance is needed for MyISAM tables?
On Thu, 15 Nov 2001, Rick Robinson
Good morning, this is my first post to the group...
The brew is
Solaris 8(sparc/sunblade)
GCC.2.95.3 ---pkg install
Flex 2.5.4a ---pkg install
Bison 1.28 --- pkg install
Mysql 3.23.44 compiled ( listed as stable version)
Hello all,
As I have written about in two earlier threads this week (you can read
them in the mysql.com archives at these URLs:
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:sss:91326#b
and
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:sss:91495#b
), I am unable to execute the shutdown command in
This method will cause problems if you have entries in
you mysql.db table for that database.
Just make sure you correct your permissions.
On Fri, 16 Nov 2001 11:46:31 -0500, Danny Rathjens
[EMAIL PROTECTED] wrote:
| stop mysql
| cd /var/lib/mysql
| mv olddbname newdbname
| start mysql
|
|
Erik Price writes:
Sinisa, everyone,
That's great news! I'm excited to hear that. Which version would that
be... 4.0? Or perhaps another 3.x version?
In the meantime, my boss is going to wonder why I'm not populating a
database for him. He will make me use Access if I don't get
Dear all,
I have the following query:
SELECT distinct pf.*
FROM homo_sapiens_lite_120.gene lg,
homo_sapiens_lite_120.gene_prot lgp,
homo_sapiens_core_120.protein_feature pf
WHERE lg.chr_name = 'chr22'
AND lg.gene = lgp.gene
AND lgp.translation_id =
On Thu, 15 Nov 2001, Jonothan Farr wrote:
There's no way to know that without knowing the schema of the
table you're inserting into. How you index it is going to be the
biggest factor there.
just a plain file with 2 columns - one of them is a decimal field -
taht's all.
cu,
fns
-[
Well, I really do need the exact timespan in human-readable format. What I
did do was get the difference in seconds, then properly format that manually.
:/
Thanks anyway though.
On Friday 16 November 2001 07:24 am, Walter D. Funk wrote:
Why don´t you try
select
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
El Viernes 16 Noviembre 2001 08:23, escribiste:
Hola a todos.
Alguien tiene una herramienta para exportar tablas dbf a MySql?
saludos
Gastón
Puedes usar dbf2mysql. Saludos.
- --
Alfredo J. Cole
Tegucigalpa, D. C., Honduras
Hi all,
it turns out that I'm trying to join a varchar(40) to an int(10). I didn't
know MySQL allows this (and does it correctly, apparently through an
intermediate table).
Sorry to not have noticed earlier.
Is there a way to get more strict behaviour, just to catch errors like this ?
A couple of weeks ago, Stephanie Wall, Associate Publisher with New Riders offered
list members copies of Paul
DuBois' MySQL and Perl for the Web, in exchange for a review.
I managed to end up with an extra copy. It would be expensive to send back. Stephanie
has granted
permission/asked me to
Hi!
On Nov 16, Erik Price wrote:
Until the next release is available, I must use the
dreaded kill -9 shell command to shut down the MySQL daemon, which
may corrupt data in the database
It shouldn't if you'll execute FLUSH TABLES before.
Actually,
mysqladmin shutdown sleep 60 killall
Hi all,
I am trying to insert data from a form which has 4 fields such that the data
always sits at the top in my database occupying locations :
SEC_ID: 1, 2 , 3 4
Everytime i insert data the data gets appended at the end i,e, if the first
4 fields are occupied my data takes the postions
In the last episode (Nov 16), Erik Price said:
Alternatively, I am open to a workaround until the working version is
released. I can actually use MySQL (as far as I know), it's just the
shutdown that hangs. I have to use kill -9 in order to kill the
daemon. This makes me worry about my
I need to know how if the same structure of a data
base can be
placed mysql in different nodes from mosix, soon to
make a
question and that can respond to me as if outside a
single one.
Example:
NODE1 NODE2 NODE3
DBTABLE DBTABLE DBTABLE
DATAID:5
The answer, I guess, is don't use DECIMAL.
I understand now the need for a fraction (someone pointed out that Euro
calculations must be done in upto 4 decimal places with rounding).
All I can say is that:
(a) you multiply the amounts by 1 (so as to deal with integers), and
(b) Split each
--- Dan Nelson [EMAIL PROTECTED] wrote:
As long as there are no active connections, killing mysql will not
affect the database. If you kill mysql during an update, you risk
corrupting any indexes on the tables being modified. If your tables
are BDB or InnoDB format, you should be able to
Kristian Köhntopp wrote:
Bennett Haselton wrote:
The problem is, how would you add a new bus and a new driver to the
database? Whichever one is added first, you're going to get an error
because its counterpart doesn't exist yet, violating referential integrity.
I was under the impression
Today I'm discovered strange behavior of SQL query
UPDATE tablename SET value=value+const WHERE ...
UPDATE tablename SET value=value-const WHERE ...
UPDATE tablename SET value=value*const WHERE ...
UPDATE tablename SET value=value/const WHERE ...
I have incorrect results of this queries only in
In the last episode (Nov 16), Erik Price said:
--- Dan Nelson [EMAIL PROTECTED] wrote:
As long as there are no active connections, killing mysql will not
affect the database. If you kill mysql during an update, you risk
corrupting any indexes on the tables being modified. If your
Is there a way I can import data from a mysql using the mysql files?
They weren't created using mysqldump; they were just copied from another
directory. For example, I have the files:
databasename/table1.frm
databasename/table1.MYD
databasename/table1.MYI
how can I bring these into mysql?
Find where the tablespaces are located on your server (mine is under:
/usr/local/mysql/data).
Move all your files(table1.*) below to the tablespace directory you choose.
Then login to mysql and do a show tables. Remeber you must login as
some_user and choose the table space name you moved your
If they are not owned by mysql, mysqld can't read them.
Chris Bergeron wrote:
Is there a way I can import data from a mysql using the mysql files?
They weren't created using mysqldump; they were just copied from another
directory. For example, I have the files:
databasename/table1.frm
I have a database defined, and a data file that needs to be imported into
the table.
I'm using Red Hat Linux 7.0 as my operating system, and mysql server is
loaded and running on linux.
When I type LOAD DATA INFILE '/home/usrename/datafile.ext' ; I receive the
following error:
Error 13:
Hi Roger,
You might just need to set File_priv='Y' in the user table in the mysql
database for the user that you logged into MySQL as.
Don't forget to do a flush privileges; after you make the change so that
it takes affect.
-Joe
-Original Message-
From: Greenlaw, Roger
I tried changing my file using chmod 777 datafile.ext and confirmed that I
am the file's owner. Can anyone help me?
Your user directory /home/usrename doesn't allow the mysql process to read
files within it (it uses user 'nobody')
Either change the access to your home directory, or put the
Hello,
I am wondering if there is any method available to switch this
Mysql list to digest mode?
I do not want to unsubscribe, but this list generates tons of
email everyday. I have looked at the site and do not see any
indication that this is within the list structure.
Thank you for your
System: FreeBSD 4.4-STABLE
MySQL version: 3.23.43
UDF code: http://www.aros.net/~lump/udf_int_ip.cc
I've been trying to implement my own loadable function for mysql. I needed
a function which converts a 4-byte integer into an IP address. I wrote a
UDF for mysql, and It compiles fine, but when
I have a FreeBSD 4.4-STABLE machine with two CPUs running mysql-3.23.44.
I'm wondering about how to make MySQL use both CPUs. Am I correct in
saying:
1. The binary distribution of MySQL for FreeBSD from www.mysql.com does
not make use of both CPUs.
2. The only way to make MySQL use both CPUs on
Hello Sandeep!
I am trying to insert data from a form which has 4 fields such that the data
always sits at the top in my database occupying locations :
SEC_ID: 1, 2 , 3 4
Everytime i insert data the data gets appended at the end i,e, if the first
4 fields are occupied my data takes the
On Fri, Nov 16, 2001 at 10:18:44PM -0500, Philip Mak wrote:
I have a FreeBSD 4.4-STABLE machine with two CPUs running
mysql-3.23.44. I'm wondering about how to make MySQL use both
CPUs. Am I correct in saying:
1. The binary distribution of MySQL for FreeBSD from www.mysql.com does
not
INSERT always places data at the end of the table. SQL makes no assumptions
about the ordering of data. If you specify no order, you get arrival
sequence, being the order the data was written to the table. If you want to
see the data in a certain order, you must order it with the ORDER BY clause
On Fri, 16 Nov 2001, Jeremy Zawodny wrote:
Where can I find instructions for compiling MySQL on LinuxThreads?
Try out the FreeBSD MySQL port. I've been told that it's trivial.
What's the URL for that?
-
Before posting,
In the last episode (Nov 16), Philip Mak said:
I have a FreeBSD 4.4-STABLE machine with two CPUs running
mysql-3.23.44. I'm wondering about how to make MySQL use both CPUs.
Am I correct in saying:
1. The binary distribution of MySQL for FreeBSD from www.mysql.com
does not make use of both
In the last episode (Nov 16), Philip Mak said:
On Fri, 16 Nov 2001, Jeremy Zawodny wrote:
Where can I find instructions for compiling MySQL on LinuxThreads?
Try out the FreeBSD MySQL port. I've been told that it's trivial.
What's the URL for that?
http://www.freebsd.org/ports/ has
G'Day All.
I'm trying to do the following in a query, in mySQL.
All my previous years of SQL has been on MS-SQL, and i'm having some little
problems with tricky sql statements.
*
i'm trying to insert a new record if the name doesn't exist in the table. If
i insert, return ID, else return 0
82 matches
Mail list logo