I have found a work around, but I do wonder what the problem is with
MySQL and BDB tables.
When I rerun the load with the table type set to ISAM it all
works. Looks like there may be some limitation of the BDB implementation
I am triggering.
In my previous post, I reported receiving an Error
All 'ä', 'ö', 'ü', etc. are changing in ?,!
What can I do against it?
Rainer
Sql, query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sun, 8 Dec 2002, shawn xu wrote:
> We have an application software which uses MSSQL 7.0
> or 2000 server on Windows. Now we want to use the
> MSSQL as a master, and MYSQL on UNIX as a slave. How
> can we configure Windows MSSQL and UNIX MYSQL both
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sun, 8 Dec 2002 [EMAIL PROTECTED] wrote:
> I have a ntext data type on SQLServer7, and I have the following statement:
^^
First, cross-posting like this is stupid. Second, it's not needed. Third,
(could be 1. +
I have a moderately large database (150K records of nine fields, a bit under 500 bytes
per record with a primary key. The database is of Type BDB.
To improve query performance I concluded I needed to add a three element index.
Running
alter table foo add index udex( w_1, w_2, w3 );
I am doing this search from a website, and from what I can tell there is no
way to use a variable (i.e. $var) with REGEXP as the $ sign has a special
meaning to REGEXP. Any other suggestions, or would you know a way around
this.
TIA
- Original Message -
From: "Robert Citek" <[EMAIL PROTEC
MySQL 3.23.53
I have a table T1 and want to do something like
SELECT * FROM T1 WHERE A = 1 AND xxx...
UNION
SELECT * FROM T1 WHERE A = 2 AND yyy...
Don't read to much in the WHERE clause, this is just for question
purpose. Also I know that UNION is available in MySQL 4.x but need to
have the REP
Hey,
I was wondering if its possible to implant a quota system where i
can give a user just say access to 2 databases which is allowed to grow to
30Mb bewteen the two of them..
What i would really like is if its possible to make mysql use the disk quota
limits.. So i can give the uses say
Yes. I can not connect remotely using ANY Microsoft Windows
clients/tools EXCEPT "Mascon" -- which for some strange reason works
just fine. Yet EVERY OTHER WINDOWS mySQL PROGRAM fails with the same
error message (10061 Can't connect...)
I'm 98% positive my 'permissions' are correct in the mysql da
Hello Bjorn:
Thanks for the encouragement. There are a lot of questions I still have,
though.
I am constantly working on moving the sql code into stored procedures in
order to improve speed.
I'd like to keep asp on 2000 servers. Doesn't the lack of stored procedures
force me to go back to parsed
Sorry for jumping in late, but are you saying that you can't connect from a
remote machine?
Did you add a Host '%' to your username in the users table?
At 07:36 PM 12/8/2002 -0800, Daevid Vincent wrote:
*I* am the admin. I don't have a command line utility on my WinXP box.
The command line uti
In answer to Paul's response: Line 54 does the following:
$sth->execute() or die $sth->errstr;
in the following chunk of code that is in my Perl script:
# update the gpa of 1000 random students
for ($i = 1 ; $i <= $num_updates ; $i++) {
At 23:09 -0500 12/8/02, Geetika Tewari wrote:
Hi,
I am getting the following error while trying to do read-write queries on
MySQL. Does anyone know what this error means?
The name of the script that generated this error is called
randomreadwrite.pl.
Can't lock file (errno: 12) at ./randomreadwr
Hi,
I am getting the following error while trying to do read-write queries on
MySQL. Does anyone know what this error means?
The name of the script that generated this error is called
randomreadwrite.pl.
Can't lock file (errno: 12) at ./randomreadwrite.pl line 54.
Thanks very much.
>Description:
On an unsuccessful INSERT DELAYED using mysql_query(), there is disagreement
between the two functions mysql_error() and mysql_errno(). Specifically,
mysql_errno() will return 0 (indicating no error), whereas mysql_error()
will return what really happened, e.g. "Table 'foo' doesn
*I* am the admin. I don't have a command line utility on my WinXP box.
The command line util on Linux works just fine for itself (localhost,
daevid.com, 192.168.1.254, etc)
MySQL *is* configured properly otherwise "mascon" would not be able to
connect either.
I've done this for a while. The prob
oh! god! -
Thanks a lot, I have a root access and with that I could create a user
directly from command line.
I was thinking that thr phpMyAdmin 2.1.0 I can do it (New version can - but
seems not this version)
Thanks once again
Manisha
At 10:21 PM 12/8/02 -0500, Joe Stump wrote:
It's not a
I am using phpMyAdmin 2.1.0. I created user from this (mysql.user) but do
not know how to reload it ? I am not finding any such option on it. Can u
please tell me more about it.
Thanks,
Manisha
At 09:45 PM 12/8/02 -0500, Joe Stump wrote:
Did you reload the privileges?
--Joe
On Sunday, Decemb
Did you reload the privileges?
--Joe
On Sunday, December 8, 2002, at 09:21 PM, Manisha wrote:
I want to create mySQL user thr phpMyAdmin. I inserted one record in
mysql.user table and one in mysql.db table,
testing with following program
$conn = @mysql_connect
("localhost:/usr/home/nets/mysq
Did you read the Replicatoin Manual?
http://www.mysql.com/doc/en/Replication.html
At 09:15 PM 12/8/2002 -0500, shawn xu wrote:
We have an application software which uses MSSQL 7.0
or 2000 server on Windows. Now we want to use the
MSSQL as a master, and MYSQL on UNIX as a slave. How
can we confi
You need to convert the date format to:
-MM-DD:
http://www.mysql.com/doc/en/Using_DATE.html
At 08:38 PM 12/8/2002 -0500, [EMAIL PROTECTED] wrote:
Hi all,
I have a datetime data field in SQLServer7, and I am trying to get a
recordset according to criteria that the CallDate field in the da
I want to create mySQL user thr phpMyAdmin. I inserted one record in
mysql.user table and one in mysql.db table,
testing with following program
$conn = @mysql_connect ("localhost:/usr/home/nets/mysql/mysql-demo.sock",
"manisha", "pass");
echo("before conn a");
if ($conn){
mysql_select_db ("demo"
We have an application software which uses MSSQL 7.0
or 2000 server on Windows. Now we want to use the
MSSQL as a master, and MYSQL on UNIX as a slave. How
can we configure Windows MSSQL and UNIX MYSQL both
sides to implement replication?
Any idea? Thanks in advance.
Shawn
__
I tried mysql-4.0.5a-beta, and same error...
Pierre.
On 2002.12.08 02:36 Pierre wrote:
Hi,
I try to compile mysql-3.23.53 on my GNU/Linux system with gcc-3.2
there was no problem with the configure, but for the make I got this :
[...]
gmake[3]: Entering directory `/tmp/mysql-3.23.53/sql'
g++
Hello, every body
I have 2 database server. the second is a copy of the first. It's replication.
But there is no connection line because it is not necesery to have an identical copy.
Every day, i have to update the second using a self made program.
To identified which record has changed,inserted or
Hi all,
I have a datetime data field in SQLServer7, and I am trying to get a recordset
according to criteria that the CallDate field in the database equals todays date
09/12/2002
Dim TodaysDate
TodaysDate= cDate(Date)
sCallsSQL = "SELECT
CallBacks.CallDate,CallBac
For information, same error with mysql-4.0.5a-beta
Pierre.
On 2002.12.09 02:11 Pierre wrote:
Hi,
I try to compile mysql-3.23.53 on my GNU/Linux system with gcc-3.2
there was no problem with the configure, but for the make I got this :
[...]
Making all in isam
gmake[2]: Entering directory `/tm
Try the REGEXP modifier. For example:
mysql> select "Another One" regexp "[[:<:]]One[[:>:]]" ;
mysql> select "Fashioned" regexp "[[:<:]]One[[:>:]]" ;
The format differs from that used in sed, grep, awk, perl, python, etc.
http://www.mysql.com/documentation/mysql/bychapter/manual_Regexp.html#Re
Hi,
I try to compile mysql-3.23.53 on my GNU/Linux system with gcc-3.2
there was no problem with the configure, but for the make I got this :
[...]
Making all in isam
gmake[2]: Entering directory `/tmp/mysql-3.23.53/isam'
/bin/sh ../libtool --mode=link gcc -s -O3 -DDBUG_OFF -O3 -march=i686
-L/
Thanks for the suggestions.
(BIt worked fine
(B
(B
(Bregards
(B
(B- Original Message -
(BFrom: "Egor Egorov" <[EMAIL PROTECTED]>
(BTo: <[EMAIL PROTECTED]>
(BSent: Friday, December 06, 2002 11:36 PM
(BSubject: re: Re: alter table syntax
(B
(B
(B> kayamboo,
(B> Friday, December
In the last episode (Dec 09), kayamboo said:
> I don't get you.
> But when I executed the drop table syntax fromt he command line, the result
> was this error
>
> mysql> alter table town_db drop primary key ;
> ERROR 1025: Error on rename of '.\forest\#sql-cc_1' to '.\forest\town_db'
> (errno: 150
Try:
mysql -u{username} -p {databasename}
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Sunday, December 08, 2002 6:43 PM
Subject: Can u us a "source code" file to setup a db in MySQL ?
When created a complicated db in MySQL can you first create a "source file"
with all the MySQL commands...
Hi,
A "dirty" solution would be to search :
field LIKE '% one %' or field LIKE 'one %' or field LIKE '% one' or
field='one';
Regards,
Jocelyn
- Original Message -
From: "Beauford.2003" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Tuesday, December 10, 2002 12:50 AM
Hi,
Hey, did this list change their spam filters? Now every time I send an email
it gets bounced unless the word MySQL or Query is in the email. Anyway,
Please read below for a recent problem I am having.
I want to be able to search on my database and be able to get the
following, but running i
When created a complicated db in MySQL can you first create a "source file"
with all the MySQL commands... and then either pipe them to MySQL or have
MySQL read the "source file" and then create the db accordingly ??
Or, must you input/key in one command at a time to the program in real time?
Tha
I don't get you.
But when I executed the drop table syntax fromt he command line, the result
was this error
mysql> alter table town_db drop primary key ;
ERROR 1025: Error on rename of '.\forest\#sql-cc_1' to '.\forest\town_db'
(errno: 150)
mysql>
Can you make me clear?
regards
- Origina
Hi,
if ($var=='grade_num')
$filter='DESC';
else
$filter='ASC';
$fetch = mysql_query("SELECT * FROM players ORDER BY $var $filter");
should work.
Regards,
Jocelyn
- Original Message -
From: "Alex Behrens" <[EMAIL PROTECTED]>
To: "MYSQL" <[EMAIL PROTECTED]>
Sent: Monday, December 09
hey all,
I have a quick question. I'm trying to display a list of players by their
name, number, position, and grade. Name, number, and position all display
properly. However, grade (which is sorted grade number) is backwards, since
12th grade is after 11, 10, etc. How can I make it so only one fo
hey all,
I have a quick question. I'm trying to display a list of players by their
name, number, position, and grade. Name, number, and position all display
properly. However, grade (which is sorted grade number) is backwards, since
12th grade is after 11, 10, etc. How can I make it so only one fo
Hello Everyone!
I am a member of the Lasso list and heard this would be a good place to
ask about a few things about MySQL.
1. In a few places I read about FULLTEXT searches. In one place I saw it
said 16 columns and in another 15. But, I am finding that when using 15 I
get an error but then
Should Be
sCVInsertSQL = "INSERT INTO CVs (CV) VALUES ('" & strCV &
"')"
Regards
Andres Berger -- Gerente de Marketing -- OnLynux
Hosting por $14.99 Anual -- www.onlynux.com/hosting
---
[root@daevid]# mysqladmin ping -h daevid.com -uroot -p
Enter password:
mysqld is alive
[root@daevid]# mysqladmin ping -h 192.168.1.254 -uroot -p
Enter password:
mysqld is alive
> -Original Message-
> From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]]
> Sent: Su
Hi,
I have a ntext data type on SQLServer7, and I have the following statement:
sCVInsertSQL = "INSERT INTO CVs CV VALUE '" & strCV & "'"
Whats wrong with that please ?
Ps. strCV is a complete CV contains many lines.
-
Befo
Dear Bjoern,
> I have completed a new setup on WinXP, with Mysqld-nt as a service, and
> assigned a new password to root. However I am able to connect as root
> without password, alter and even drop tables and complete databases with
> the tool MySQLFront !!!
After setting up MySQL under Windows,
Dear Dan,
> I have a database that, I now realize, could use the benefits of
> row-locking and non-blocking SELECTs. So, I guess I need to change over
> to InnoDB tables. How do I convert my existing data structures (and the
> data they contain) into InnoDB tables?
ALTER TABLE mytable TYPE=innodb
Hi MySQL
I am a new user of your product, and so far everything looks great, except
for password protection...
I have completed a new setup on WinXP, with Mysqld-nt as a service, and
assigned a new password to root. However I am able to connect as root
without password, alter and even drop tab
Dear Daevid,
> Can't connect to MySQL server on 'daevid.com'(10061)
Try "mysqladmin ping -h mysql_host_name". This is the most basic thing I can
think of to connect to a MySQL server. It should report "mysqld is alive".
If even that doesn't work, try "mysqladmin ping -h 192.168.1.1" (or whatever
Bjorn - you state to use auto_increment in 2-way replication. Others have
said that this could cause a crash if the auto_increment field is
duplicated. Have experienced any problems with it?
- Original Message -
From: "Björn Pålsson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sun
Hello,
I have a database that, I now realize, could use the benefits of
row-locking and non-blocking SELECTs. So, I guess I need to change over
to InnoDB tables. How do I convert my existing data structures (and the
data they contain) into InnoDB tables?
Also, Is there anything that MyISAM tables
First, I wish to say that you are making the right descision leaving M$ and
taking a step into MySQL.
Currently, I'm working on a project involving +500.000 rows and estimated
30.000 visitors / day on a 2 x dual 2.8 GHz Xeon dedicated for SQL.
Additional servers are for HTTP and other tasks. There
Hi.
I am trying to store a date in the following format '08/12/2002' pr '08/12/2002' or
any other format if I have to ...on SQLServer 7.
Basically I want to use
TodaysDate = Date' Date is the system date function
strSQL = "SELECT * FROM CallBacks WHERE CallDate =" & TodaysDate
Is there a
Thanks a lot. I´ll stick to 3.23.53 until 4.0.6 appears.
Adolfo
> -Original Message-
> From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, December 08, 2002 4:21 PM
> To: [EMAIL PROTECTED]
> Subject: Re: May someone try this script under Mandrake 9 and
> Mysql 4.0.5
>
>
> Ad
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
please do not send questions to me directly - send them to our mailing
list instead (Cc:ed on this message again).
On Thu, 5 Dec 2002, shawn xu wrote:
> I am new to MySQL, and I don't know what you said
> about GNU version. Would you please expa
Error No. 2003
Can't connect to MySQL server on 'daevid.com'(10061)
This is the same error I get with all the other programs too...
No SSH or SSL.
I'm connecting from my WinXP box to my Linux server over my local LAN.
> -Original Message-
> From: Karam Chand [mailto:[EMAIL PROTECTED]]
Adolfo,
- Original Message -
From: ""Adolfo Bello"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Sunday, December 08, 2002 12:47 AM
Subject: May someone try this script under Mandrake 9 and Mysql 4.0.5
> I have used a database creation script for months under 3.23.53a.
>
Hi,
Just for information - the stack trace gives:
0x808fdfc _Z15handle_segfaulti + 460
0x815adb8 __pthread_sighandler + 116
0x8171636 __strtol_internal + 1390
0x8098378
_Z17add_field_to_listPc16enum_field_typesS_S_jP4ItemS_P10st_typelib + 344
0x809aacb _Z7yyparsev + 3419
0x8092cdd _Z16handle_boo
Amittai,
- Original Message -
From: ""Amittai Aviram"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Sunday, December 08, 2002 9:46 PM
Subject: Reading logs
> In both the MySQL manual and Paul DuBois superb _MySQL_, I find
information
> about turning logging on, rotating l
Hi!
I was able to break replication with a single SLAVE STOP command in 4.0.6.
I ran an InnoDB stress test ibtest17.
>From the printout below we see that after SLAVE START immediately we got a
foreign key error in the slave. That shows the slave no longer was identical
to the master, since only
Hi!
I just compiled 3.23.53 on my RedHat 8.0 box - but when trying to start the
mysql daemon, my init.d script tries to initialize the required tables. But
this fails:
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_
In both the MySQL manual and Paul DuBois superb _MySQL_, I find information
about turning logging on, rotating log files, and maintaining log files --
but I still do not understand how I am supposed to _read_ a log file. I am
running MySQL 4.0.5-max-debug under Windows XP. If I issue the bare com
At 9:25 -0800 12/8/02, Ryan McDougall wrote:
Hi thanx for the details... Ok I know I am thick... and for some reason I
cannot get my head around this, let me try to explain what I want to do then
maybe you can tell me its possible and how it is possible.
I want to create a user that can be creati
Thanks to everybody who helped me with this!
- Original Message -
From: "Brian P. Austin" <[EMAIL PROTECTED]>
To: "Dietrich Speer" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, December 08, 2002 9:01 AM
Subject: RE: E-Commerce, db-clustering and MySQL?
> There is no clusteri
Anybody out there planning to take the new MySQL Core Certification Exam
anytime soon and anywhere near Columbia, South Carolina, USA? It might be
nice to chat on the phone and compare notes or whatever. Thanks!
Amittai
-
Bef
Benjamin Pflugmann wrote:
Hello.
On Sat 2002-12-07 at 14:15:59 -0800, [EMAIL PROTECTED] wrote:
I would like to lock a specific record in a MySQL table so that no other
user can update it while another user is is update the record via the
user interface. Can someone please tell me the easie
Hi thanx for the details... Ok I know I am thick... and for some reason I
cannot get my head around this, let me try to explain what I want to do then
maybe you can tell me its possible and how it is possible.
I want to create a user that can be creative as he wants... allow him to create
ANY data
If your using a Linux machine try using this when logging on to mysql:
mysql --local-infile=1 -u username -p
Not sure about Windows.
There is apparently a security issue with this so it is not enable by
default. Can't remember where I read this, but the above works for me.
Beauford
- Origi
Thanks to all who recently answered some of my MySQL questions, although I
am still having some problems with the concept of joins, but what I have
figured out certainly does make it more efficient and versatile. I have
managed to eliminate two tables (actually combine them into one) which made
my
MySQL-Front isn't being developed anymore right?
Anyhow, the last version I used was very very buggy.
At 06:37 AM 12/8/2002 -0400, Chris Mason wrote:
I've found mysql-front to be far superior, in fact, I can't complain
about it at all.
-Original Message-
From: Michael She [mailto:[EMA
Greetings
I like SQLyog. http://www.webyog.com/sqlyog/download.html
Rgds
Insane
- Original Message -
From: "Chris Mason" <[EMAIL PROTECTED]>
To: "'MySQL List'" <[EMAIL PROTECTED]>
Sent: Sunday, December 08, 2002 4:07 PM
Subject: RE: How is DBTools Software?
> I've found mysql-front
There is no clustering in MySQL. Replication features allow something
similar.
In my opinion, the reason I prefer MySQL is the fact that the basics are
there to do what ever you need to.
You are responsible for making the solution, not the vendor.
Multiple MySQL slave servers, and multiple webse
Hi!
- Original Message -
From: "Benjamin Pflugmann" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Saturday, December 07, 2002 4:59 PM
Subject: Re: Question about SLAVE STOP
> Hello.
>
> On Sat 2002-12-07 at 14:26:00 +0100, [EMAIL PROTECTED] wrote:
> > Hello.
> >
> > On Fri
SOLUTION 1:
It's probably simplest, conceptually, to build a temporary table which
provides the proper ordering. The "ordering" column below is a computed
value which determines the desired orderint of the File's. Then, you
can join with an ORDER BY clause that gives the desired order.
mysql> c
MySQL doesn't accept variables for field length values.
Your query should look something like this:
CREATE TABLE `db`
(`host` VARCHAR(localhost) NOT NULL,
`db` VARCHAR(64) NOT NULL,
`user` VARCHAR(64) NOT NULL,
`select_priv` CHAR(1) NOT NULL,
`insert_priv` CHAR(1) NOT NULL,
`update_priv` CHAR(1
Mike,
- Original Message -
From: "Mike Gohlke" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Saturday, December 07, 2002 6:44 PM
Subject: Re: Innodb row locking question
>
>
> Benjamin Pflugmann wrote:
>
> >Hello.
> >
> >On Fri 2002-12-06 at 10:28:23 -0600, [EMAIL PROTECTE
Hi!
- Original Message -
From: "Benjamin Pflugmann" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Sunday, December 08, 2002 3:14 AM
Subject: Re: Record Lock?
> Hello.
...
> With InnoDB you can lock a row by selecting it:
>
> SELECT *
> FROM your_table
> WHERE
> FOR
>Originator:
>Organization:
>MySQL support: none
>Category: mysql
>Release: mysql-3.23.53 (Source distribution)
>Environment:
System: Linux cj1398237-a 2.5.49-ac1 #3 SMP Sun Dec 8 17:01:39 JST 2002 i686
unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /u
Dear Ryan,
have a look at the manual:
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm
inistration.html#User_Account_Management
With the exception of Paul's book on MySQL, you probably won't find a better
explanation of the MySQL privilege system.
> PLEASE I'M GOING
I've found mysql-front to be far superior, in fact, I can't complain
about it at all.
-Original Message-
From: Michael She [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 07, 2002 3:27 PM
To: Will Standley
Cc: Sandeep Murphy; Crercio O. Silva; MySQL List
Subject: Re: How is DBTools So
78 matches
Mail list logo