Ubaidul,
ok, there is nothing in my.cnf that can explain why memory runs out.
What kind of query are you running when the memory runs out? Does 'top' show
that the mysqld process size grows uncontrollably?
If you are using the C client interface, do you use 'mysql_store_result()'
or 'mysql_u
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
I realized this also. Martin Schwarz off list suggested to me to use
REGEXP for that purpose. That means that I'm rewriting the user input
"übersee" behind the scenes to "^(ü|ue)bersee.*" which works quote well.
The only gotcha is that the user m
On 24/03/2006 11:06 a.m., Eric Beversluis wrote:
Can someone illustrate the correct syntax for using auto_increment in
making a table? I've studied the manual and I'm not seeing how it comes
out.
EG:
CREATE TABLE Books (
bookID INT(5) PRIMARY KEY AUTO_INCREMENT...
THEN WHAT?
Thanks.
EB
Can someone illustrate the correct syntax for using auto_increment in
making a table? I've studied the manual and I'm not seeing how it comes
out.
EG:
CREATE TABLE Books (
bookID INT(5) PRIMARY KEY AUTO_INCREMENT...
THEN WHAT?
Thanks.
EB
--
MySQL General Mailing List
For list archives: http
Dilipkumar,
Thanks much for the tipit did the job!
Now we query mysql to see if the new mysql database is seen by mysql and it
still only sees test:
[EMAIL PROTECTED]:/usr/bin> mysqlshow
+---+
| Databases |
+---+
| test |
+---+
[EMAIL PROTECTED]:/usr/bin>
Here i
kalin mintchev wrote:
hi all...
i can't see the mysql 5 version for freebsd 6.0 on the mysql developer
site?
am i blind or it's on purpose?!?!
curious... and actually need it...
thanks...
/usr/ports/databases/mysql50-server/
/usr/ports/databases/mysql51-server/
I suggest you fa
On 3/23/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> When you generated this dump file, did you remember to use the
> --max_allowed_packet parameter to make sure that mysqldump didn't create any
> extended insert statements larger than your server wants to handle? It could
> be crapping out
Hello,
Anybody here are also familiar with SQL server 2000 Web Assistant Wizard?
The wizard enables you to create queries that run against the SQL server
2000 database to push data to your web site in the form of static pages.
You can choose how often the web client sees the changes in the SQL se
Following is the configuraton of mysqld:
<- Excerpt from my.cnf ->
# The MySQL server
[mysqld]
user= mysql
port= 4406
socket = /tmp/mysql.sock
#socket = /tmp/mysql_4.0.13.sock
set-variab
[EMAIL PROTECTED] wrote on 03/23/2006 02:20:00 PM:
> On 3/23/06, sheeri kritzer <[EMAIL PROTECTED]> wrote:
> > What does line 1189 look like?
> >
>
> Good question. Hard to tell, since it's the insert statement for a
> rather large table (25 million rows) and I have --extended-insert set,
> so it
On 3/23/06, sheeri kritzer <[EMAIL PROTECTED]> wrote:
> What does line 1189 look like?
>
Good question. Hard to tell, since it's the insert statement for a
rather large table (25 million rows) and I have --extended-insert set,
so it's all on one *really* long line. Seems like there should be a
ret
MySQL doesn't have anything like that. You can use the wildcard
characters instead of the umlauts if you want, such as
SELECT * from person where name like "%bersee"
which would get
"übersee" and "uebersee"
but also a whole lot more.
But doing something like
SELECT * from person where name like
On 3/19/06, shreeseva <[EMAIL PROTECTED]> wrote:
>
> - Original Message -
> From: shreeseva
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Sent: Monday, March 20, 2006 01:15 AM
> Subject: About Data types
>
>
> Dear friends,
> I am using MySQL 5.0.17 on Win XP Prof. I have created a prot
What does line 1189 look like?
-Sheeri
On 3/17/06, Jack Baty <[EMAIL PROTECTED]> wrote:
> I'm trying to restore a database from a dump as part of my
> make-sure-this-will-restore-just-in-case process and I get the
> following error...
>
> ERROR at line 1189: Unknown command '\''.
>
> The only thi
Hello everybody,
I have a problem with replication of data from master to slave server.
The problem is, that the master is in a other timezone than the slave
and so inserts with using the now() function creates different values on
master and slave. If I want to update on the master and use the
On Thu, 23 Mar 2006 [EMAIL PROTECTED] wrote:
>
> To: saf <[EMAIL PROTECTED]>
> From: [EMAIL PROTECTED]
> Subject: Re: Question about autoincrement ID
>
> One important thing to remember: You should not let UI
> design requirements dictate your DB design. Most
> developers who design the database
Dilipkumar,
Thanks much for the tipit did the job!
Now we query mysql to see if the new mysql database is seen by mysql and it
still only sees test:
[EMAIL PROTECTED]:/usr/bin> mysqlshow
+---+
| Databases |
+---+
| test |
+---+
[EMAIL PROTECTED]:/usr/bin>
Here i
Shawn,
Thanks. That has done the trick. It turns out that I had passwords
hashed for [EMAIL PROTECTED], but not [EMAIL PROTECTED] Resetting the password
and flushing the privilege has really helped. Guess what, you have done
in 20 minutes what myself and other could not do in a week.
Dwan
I didn't encrypt and that was going to be my next questions. How do I
do that?
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 23, 2006 10:45 AM
To: Atkins, Dwane P
Cc: mysql@lists.mysql.com
Subject: RE: Freeradius and MySql
OK, m
OK, make sure you are using the correct password, too. Did you remember
to encrypt the password with PASSWORD() or OLD_PASSWORD() when you create
the account?
SELECT user, host, password
FROM mysql.user
WHERE user='radius';
make sure your password is hashed, if not we can help you fix that p
I did do a FLUSH PRIVILEGES and this still resulted in the same error.
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 23, 2006 10:31 AM
To: Atkins, Dwane P
Cc: mysql@lists.mysql.com
Subject: RE: Freeradius and MySql
You could try
You could try suggestion B) ;-)
Shawn
"Atkins, Dwane P" <[EMAIL PROTECTED]> wrote on 03/23/2006 11:25:24 AM:
> * a) Verify that you have actually GRANTED permission for the
> account you are trying to authenticate with
>
> SELECT user, host from mysql.user where user ='radius';
>
>
>
[EMAIL PROTECTED] (saf) wrote on 03/23/2006 11:10:04 AM:
> On Thu, Mar 23, 2006 at 11:04:55AM -0500, [EMAIL PROTECTED] wrote:
> > [EMAIL PROTECTED] (saf) wrote on 03/23/2006 10:50:10 AM:
> >
> > The short answer is "no". The Record #2 already existed. It's current
> > status is "deleted". If yo
* a) Verify that you have actually GRANTED permission for the
account you are trying to authenticate with
SELECT user, host from mysql.user where user ='radius';
mysql> SELECT user, host from mysql.user where user ='radius';
++---+
| user | host |
++
>So I must do a big SELECT and then check my self every time (for each
INSERT),
>which IDs are free?
No, you just ignore "deleted" IDs.
What's the point?
Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog
On Thu, Mar 23, 2006 at 04:17:44PM +, [EMAIL PROTECTED] wrote:
> Lots of ways round this. Instead of deleting records, add a boolean
> "deleted" flag. All selects then need to add "and deleted = 0". But you can
> find a (random) deleted row with "select id from table where deleted = 1
> limit 1
[EMAIL PROTECTED] (saf) wrote on 23/03/2006 16:10:04:
> On Thu, Mar 23, 2006 at 11:04:55AM -0500, [EMAIL PROTECTED] wrote:
> > [EMAIL PROTECTED] (saf) wrote on 03/23/2006 10:50:10 AM:
> >
> > The short answer is "no". The Record #2 already existed. It's current
> > status is "deleted". If you h
On Thu, Mar 23, 2006 at 11:04:55AM -0500, [EMAIL PROTECTED] wrote:
> [EMAIL PROTECTED] (saf) wrote on 03/23/2006 10:50:10 AM:
>
> The short answer is "no". The Record #2 already existed. It's current
> status is "deleted". If you had other tables that linked their data to
> record #2 and you cre
[EMAIL PROTECTED] (saf) wrote on 03/23/2006 10:50:10 AM:
> Hi,
>
> I have a question about autoincremend id:
> If I have an autoincrement id set on my first column field of my
> table and I have the
> following entries:
> 1
> 3
>
> And then I make a INSERT INTO foobar VALUES(''); , the next fie
"Atkins, Dwane P" <[EMAIL PROTECTED]> wrote on 03/23/2006 10:38:57 AM:
> Good morning. I am trying to install Free Radius with MySql, but I
> either have a login issue or a permissions issue.
>
>
>
> I have added Radius and [EMAIL PROTECTED] to database, Fedora local users
> and just about ev
Hi,
I have a question about autoincremend id:
If I have an autoincrement id set on my first column field of my table and I
have the
following entries:
1
3
And then I make a INSERT INTO foobar VALUES(''); , the next field would be
automatically 4:
1
3
4
Is there a possibility to take a free ID
Good morning. I am trying to install Free Radius with MySql, but I
either have a login issue or a permissions issue.
I have added Radius and [EMAIL PROTECTED] to database, Fedora local users
and just about everywhere I can think possible. I have added
permissions for radius & radius local t
Eugene Kosov <[EMAIL PROTECTED]> wrote on 03/23/2006 07:03:15 AM:
> Hi, everyone!
>
> I have transfer user's database and grants from one mysql server
> (4.1.15) to an older one (4.0.26). I don't know user's password and have
> only it's hash. How can I convert hashed password stored in
> mys
I get the following error while trying to create the following database
mysql mysql < zm_create.sql.in
ERROR 1044 (42000): Access denied for user ''@'localhost' to database
'mysql'
I tried to run the following script
/usr/bin/mysql_install_db --user=mysql
It does not create mysql database
Luke Vanderfluit <[EMAIL PROTECTED]> wrote on 03/22/2006 08:29:02
PM:
> Hi.
>
> I've got mysql 4.0.18 installed on a sun X4100 running solaris.
> This is just a 32 bit version of mysql.
>
> I've reverted back to this version after trying mysql 5, 4.0.26 and
> 4.0.18 64bit.
> Those versions wer
[snip]
Is there any way I can do a content analysis with MySQL?
I need to find text in a database that have similarity.
[/snip]
http://www.mysql.com/fulltext
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED
Does anyone know the cause of the following error message
Ignoring query to other database
When I log onto the mysql monitor and use any command I get this message.
This is strange because last time I used my copy of mysql it worked just
fine.
I am using MAC OSX and I was wondering if the latest
Hi, everyone!
I have transfer user's database and grants from one mysql server
(4.1.15) to an older one (4.0.26). I don't know user's password and have
only it's hash. How can I convert hashed password stored in
mysql.user.password field to the 4.0 format? Is there something similar
to OLD_PA
Luke Vanderfluit wrote:
Hi.
I've got mysql 4.0.18 installed on a sun X4100 running solaris.
This is just a 32 bit version of mysql.
I've reverted back to this version after trying mysql 5, 4.0.26 and
4.0.18 64bit.
Those versions were all unstable on 64bit, that is, the server would
just go aw
Is there any way I can do a content analysis with MySQL?
I need to find text in a database that have similarity.
/Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have not been receiving the daily digest for the past 2 days. Just wanted
to check if I am the only one it's the same for others too.
Regards,
Rithish.
http://dev.mysql.com/doc/refman/5.0/en/myodbc-windows-binary-installation.html
I don't know how to use Delphi. But I think Delphi is easy to use ODBC just
like VB or PB.
Run "set names utf8" just like a normal SQL statement after connect.
If you don't understand let me know.
regards,
gu lei
Dear ladies and gentlemen,
Upscene Productions is happy to announce a new version of
the database developer tool:
"Advanced Data Generator" (version 1.6.1)
Version 1.6.1 for MySQL specifically fixes an issue with
reporting the null-ability on columns in MySQL 4 and 4.1
( http://tracker.upscene.co
44 matches
Mail list logo
