Hello
How can I find out more information about a MySQL bug fixed in release
3.23.9 and described in the change notes as 'Fixed problem with 8-bit
characters as separators in LOAD DATA INFILE.'?
[I wish to LOAD DATA INFILE using 0xBF as the FIELD TERMINATOR and 0xC6 as
the LINE TERMINATOR but th
Hi,
> Can anyone explain why this is happening?
>
>
> root@www:/# mysql -u dgadmin -h www.4cdg.com -p cdgcatalog
> Enter password:
> ERROR 1045: Access denied for user: '[EMAIL PROTECTED]'
> (Using password: YES)
remove the space between -p and the password.
Rgds,
Indrek
--
For technical
On Fri, Jul 27, 2001 at 02:52:08AM -0500, ryc wrote:
>
> The question is, when do you know when to give up, and when to keep
> on trucking?
If it's still running now, I'd give up. :-)
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-
Do not put a space between "-p" and "cdgcatalog", i.e.
use "-pcdgcatalog".
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
> -Original Message-
> From: Butch Evans [mailto:[EMAIL PROTECTED]]
> Sent: 14. august 2001 07:48
On Mon, Jul 30, 2001 at 10:51:22AM +0200, Werner Stuerenburg wrote:
>
> I don't know where to send this to, so someone who knows please
> forward it to the appropriate address.
I've submitted a doc patch to include that information.
Thanks,
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Tech
Hi,
> I have a databse on the server. It os called ads. I want to make
> copy of it on my PC. I have Win32, Apache with PHP and
> MySQL. And I also have phpMyAdmin on that server.
> I'm writing this:
>
> mysqldump -A ads > /home/myaccount/www/backup.sql
>
> But it says that i'm making a mis
Can anyone explain why this is happening?
root@www:/# mysql -u dgadmin -h www.4cdg.com -p cdgcatalog
Enter password:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
password: YES)
Here is the permissions table:
mysql> select host,db,user from db where db like "cdgcatalog";
+---
On 13 Aug 2001 21:36:47 -0700, Manuel Velasco wrote:
> I am trying to create a database in my account at an
> ISP with a Unix Solaris server.
>
> The error message:
>
> mydomain.com% mysqladmin create newdb
> /usr/local/mysql/bin/mysqladmin: create of 'newdb'
> failed
> error: 'Access denied for
On 14 Aug 2001 06:32:16 +0300, Marius Pertravčius wrote:
> Sveiki, mysql,
>
> I have a databse on the server. It os called ads. I want to make
> copy of it on my PC. I have Win32, Apache with PHP and MySQL. And I
> also have phpMyAdmin on that server. I'm writing this:
>
> mysqldump -A ads > /
On 13 Aug 2001 21:11:21 -0700, Michael Collins wrote:
> Is there a common approach to searching within text columns that
> contain fairly large blocks of text (30,000 - 65,000 characters)? Is
Oh NO! Sorry, I messed my mail folders. Please forget about my previous
mail :(
--
For technical sup
On 14 Aug 2001 06:32:16 +0300, Marius Pertravčius wrote:
> Sveiki, mysql,
>
> I have a databse on the server. It os called ads. I want to make
> copy of it on my PC. I have Win32, Apache with PHP and MySQL. And I
> also have phpMyAdmin on that server. I'm writing this:
>
> mysqldump -A ads > /
On 13 Aug 2001 21:11:21 -0700, Michael Collins wrote:
> Is there a common approach to searching within text columns that
> contain fairly large blocks of text (30,000 - 65,000 characters)? Is
> the recommendation, simply don't do it or is there some sort of
> workaround? I suppose one can sear
> Ok I've finally gotten MySQL 3.23.37 installed and operating. Thanks to all
> that helped! The problem I'm now experiencing is when I try to interface
> with MySQL via PHP. MySQL seems to work fine by logging into MySQL directly
> and through a MySQL GUI Client. I get the following error...
>
>
I am trying to create a database in my account at an
ISP with a Unix Solaris server.
The error message:
mydomain.com% mysqladmin create newdb
/usr/local/mysql/bin/mysqladmin: create of 'newdb'
failed
error: 'Access denied for user: '@localhost' to
database 'newdb''
mydomain.com%
Could someone h
Shu Xiao <[EMAIL PROTECTED]> writes:
> Hi,
>
> I have problem starting MySQL on Redhat7.1. After installed Redhat7.1 which
> include MySQL rpm installation, I saw the file named mysqld under /etc/init.d .
> I set up symlink to it under /etc/rc3.d and etc/rc5.d. I intended to start
> MySQL while
Sveiki, mysql,
I have a databse on the server. It os called ads. I want to make
copy of it on my PC. I have Win32, Apache with PHP and MySQL. And I
also have phpMyAdmin on that server. I'm writing this:
mysqldump -A ads > /home/myaccount/www/backup.sql
But it says that i'm making a mistake.
Hi,
I have problem starting MySQL on Redhat7.1. After installed Redhat7.1 which
include MySQL rpm installation, I saw the file named mysqld under /etc/init.d .
I set up symlink to it under /etc/rc3.d and etc/rc5.d. I intended to start
MySQL while Linux booting. But I failed to start it. Checking
Is there a common approach to searching within text columns that
contain fairly large blocks of text (30,000 - 65,000 characters)? Is
the recommendation, simply don't do it or is there some sort of
workaround? I suppose one can search within these columns using the
LIKE and % wildcards and ris
I'm trying to create a php/mysql user auth script that has a built in
mechanism that will allow me to distinguish between user types. For
example...if a student logs into the site, i would like them transfered to a
web page built specifically for them. Likewise with Professors. Any
suggestion
Hello.
Im wondering whats up with lock tables in mysql.
i need to lock one table but also insert into another table that does not
have to be locked.
why does it need to lock both tables? this is pointless to me if one table
does not need
to be locked.
Also, from the mysql documentation :
If a t
Hi,
I am new to mysql, but as I know, the daemon can be set to use the
socket in different locations, by the configuration files or at the
time you start the daemon. Use 'mysqladmin variables' to see where
the socket is in your configuration.
You can set the default location of the socket in
On Mon, Aug 13, 2001 at 06:32:34PM -0700, David Raufeisen wrote:
>
> Can MySQL have multiple unix domain sockets per mysqld instance
I don't think so.
> or would you know of another way this can be done..?
There's always a way. :-)
> I have postfix running chroot /var/spool/postfix .. and it c
Can MySQL have multiple unix domain sockets per mysqld instance, or would
you know of another way this can be done..?
I have postfix running chroot /var/spool/postfix .. and it can't open
/var/run/mysqld/mysqld.sock .. it works fine over tcp 127.0.0.1 but i'd
rather use a unix socket, is this
Would the submitter of this Email to the list (seen below as
mailto:[EMAIL PROTECTED]) please fix your "/etc/hosts" file to
display your 'real' system name and 'domain'...
Also, you should create an account for yourself on the system, and send
your emails to the list as that user (how is anyone
Thank you guys. I guess there is a big backlog, plus it seems a pretty
active list. Maybe I'd better just stick with the archives. As I
become more familiar with MySQL I'll probably have more specific
questions, and can search the archives a little more productively.
Thank you.
Mike Kimball
>Description:
Error When trying to install rpm (v 3.23.41-1.i386)
>How-To-Repeat:
just run:
shell> rpm -i MySQL-3.23.41-1.i386.rpm MySQL-3.23.41-1.i386.rpm
error: unpacking of archive failed on file /usr/doc/MySQL-3.23.41/manual.txt: cpio:
MD5 sum mismatch
Giving mysqld a couple
Friend,
I learned that 8 + 4 = 12. Maybe you just missed that class ... :D
Before talk, think. ;)
On Thu, 26 Jul 2001 12:31:23 -0700 [EMAIL PROTECTED] wrote:
| 8.00user1
| 14.00 user2
| 160.00 user 3
|
| Now, where I went to school, this adds up to 184!
Cya
Antonio
[
Michael,
Use FreeBSD (http://www.FreeBSD.org) and install MySQL in a K6-3 700 or better
with good motheboard (Asus), ethernet (3com) and as much RAM as you can. I don't
think you need SCSI drives.
Of course it depends on how big it will be. =)
On Sat, 28 Jul 2001 20:12:34 -0600
Selva,
Try to use the ports collection (http://www.FreeBSD.org/ports) and do a:
--
cd /usr/ports/databases/mysql323-server
make clean install
--
It will install all things needed, if they aren't installed yet. =)
If you want I have packages of MySQL 3.23
Martin,
If you want you can change memory configurations at my.cnf. Look at sample
configurations that comes with the source tarball. Use mysqladmin to see the
variables:
--
# mysqladmin -p variables
--
On Sun, 29 Jul 2001 02:50:25 -0400 martin <[EMAIL PROTECTED]> wrote
Exactly what question(s) would you like help with?
Did WinMySQLAdmin request a username/password?
Did you remove the service before you uninstalled?
- Original Message -
From: "Lim Joo Tiong" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 13, 2001 1:17 AM
Subject: Re:I
Friend,
I think this is a JSP problem (mm driver). =)
Try to see if your driver is using an user that is allowed to connect to it
from where you are trying to. ;)
On Sun, 29 Jul 2001 22:30:46 +0800 gokeeper <[EMAIL PROTECTED]> wrote:
| i am running mysql 3.23.40 and tomcat 3.2.3
Dejan,
It seems that you have to add "blahblahblah.com" to the hosts allowed to
connect to the server.
Check the privilegies table and add that domain to the list.
On Fri, 27 Jul 2001 22:49:32 -0700 "Dejan Nikic" <[EMAIL PROTECTED]> wrote:
| Warning: Host 'blahblahblah.com' is
Hi
Y try to use mysql but when i try to execute mysql
the next error apears.
ERROR 2002 Can't connect with local MYsql Server
Trought Socket '/var/lib/mysql/mysql.sock (2)'
i see the the files in this directory but don't apear
this file only files with .frm, .MYD, .MYI extension,
Can you help
> But how do i, as administrator, select the users password and decrypt it?
> This is supposed to be used on a "forgotten password" page.
This is a hash function -- you _don't_ recover the password. Period.
On a recovery page, allow the user to set a new password (they didn't
remember the old o
Ok I've finally gotten MySQL 3.23.37 installed and operating. Thanks to all
that helped! The problem I'm now experiencing is when I try to interface
with MySQL via PHP. MySQL seems to work fine by logging into MySQL directly
and through a MySQL GUI Client. I get the following error...
Warning: My
Doc wrote:
> Hey guys and gals
> my problem for the day:
>
> insert into USERS (User,Pass) values ('TestUser',PASSWORD('TestPass'))
> No problems.
>
> But how do i, as administrator, select the users password and decrypt it?
> This is supposed to be used on a "forgotten password" page.
You
I hope that someone here can help me with a little problem. We have a
database that has a lot of duplicate entries in it for one of the fields
(email). I need to find a way to search the database, find all of the
duplicate entries and delete all but one of the entries. It would not be
pract
Hey guys and gals
my problem for the day:
insert into USERS (User,Pass) values ('TestUser',PASSWORD('TestPass'))
No problems.
But how do i, as administrator, select the users password and decrypt it?
This is supposed to be used on a "forgotten password" page.
Select User,PASSWORD(Pass) from US
Yes I'm missing the query line in this posting my error (frustration is
taking over me ). The error occurs on line 5, which is the $dbconnection
line.
> -Original Message-
> From: Adam Douglas [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 13, 2001 2:00 PM
> To: Mysql@Lists. Mysql. Com
Ok I've finally gotten MySQL 3.23.37 installed and operating. Thanks to all
that helped! The problem I'm now experiencing is when I try to interface
with MySQL via PHP. MySQL seems to work fine by logging into MySQL directly
and through a MySQL GUI Client. I get the following error...
Warning: My
Hey everyone,
Has anyone had any experience establishing a secure connection between a
palm device and MySQL database that's on the net? I've setup secure web
pages on our webserver that are visible on the web and viewable by wireless
palms (securely). Scripts on that interface provide a way
Anybody know how to deal with this problem?
> -Original Message-
> From: Kevin [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 13, 2001 9:40 AM
> To: [EMAIL PROTECTED]
> Subject: Compile error (checking for restartable system calls...
> configure: error can not run test while cross com
Rene Churchill writes:
>
> I'm having a problem with mysql forgetting the location
> of it's datadir. After the server has been running for
> some time, it looses track and starts throwing errors
> when I attempt to select a database. Killing mysqld
> and letting safe_mysqld restart it fixes th
Hello, I am starting to notice some funny behaviour in our MySQL setup.
(3.23.39)
Our database server will randomly stop accepting connections on port 3306 ,
or rather, they simply hang in limbo and appear to cause a TIME_WAIT
connection on our database server. This causes our website to hang , s
Thanks for pushing me in the right direction :) It turns out that it
wasn't the semicolon on the end of $sql_query -- it was the newline. I had
been invoking it as follows:
./rundatabasequery.cgi
sql_query=SELECT+*+FROM+newssites_dynamicdata%3B%0D%0A
and the "%0D%0A" was a hex-encoded newline
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:Root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
Hi !
)-Original Message-
)From: Conor McTernan [mailto:[EMAIL PROTECTED]]
)Sent: Monday, August 13, 2001 4:20 AM
)To: [EMAIL PROTECTED]
)Cc: [EMAIL PROTECTED]
)Subject: mysql/lotus approach question(sort of)
)
)
)Hey there,
)
)sorry about the cross post, but whenever i mail the ODBC list,
> I know I'm getting away ahead of myself here, but is there a GUI
> application development tool for mySQL? Something like Paradox or
> Access, that lets you create complete applications with attractive
> screens/forms and even start-up/splash screens. This would be on an NT
> workstation.
Any
> hi,
>
> I have pretty bad performance on the following query. Could
> someone help me to define the indexes I need on the tables to
> improve this.
> Thanks in advance.
>
> select a.field_1,a.date,b.field_1,b.field_2,sum(a.subtotal) as total
> from table_a as a, table_b as b
> group by b.f
I apologize in advance for jumping in with a hardware suggestion,
but I just joined the list to sort out some similar questions.
Our production sql server (Microsoft's) is sitting on a box
that's now outdated w/ 2 200mhz processors and maybe .5G
of RAM. A query that takes 30 seconds on that box
> Go error 127 from table handler.. fixed itself in about 10 minutes..
> don't know what this is or why it happened.. anyone know?
>
> It happened while doing an update SQL command to a table.
> I'm not even sure what it means.. can't find any error codes.
Try running perror 127
---
> And is there some way to download the previous posts to this list? I
> found one list admin function that will download up to 100 posts
> concatenated into one email, but I'd like to be able to d/l them
> individually, with their own subject line and threading info. I just
> think it would be
I'm having a problem with mysql forgetting the location
of it's datadir. After the server has been running for
some time, it looses track and starts throwing errors
when I attempt to select a database. Killing mysqld
and letting safe_mysqld restart it fixes the problem
for a while, but having t
Dan Makovec wrote:
>
> Hi folks,
>
> Wondering if anybody can help me with this one.
>
> I've got a table with 6.2 million rows in it, and MySQL seems to be straining a bit
>with it. It's a basic table storing stock trading prices:
>
> ++-+--+-++--
> I've put an index on date and symbol combined,
> and tried putting one on just date.
Did you then do an "EXPLAIN ..." before your query
to see the results?
> select min(date) from stockmarket where symbol='abc'
explain select min(date) from stockmarket ...
That will tell you if your indexe
It is possible using the columns_priv table in the mysql database. Check
out http://www.mysql.com/doc/P/r/Privilege_system.html for more information.
Good Luck,
David Price
-Original Message-
From: Jonas Arvidsson [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 13, 2001 3:09 AM
To: [EM
Hi folks,
Wondering if anybody can help me with this one.
I've got a table with 6.2 million rows in it, and MySQL seems to be straining a bit
with it. It's a basic table storing stock trading prices:
++-+--+-++---+
| Field | Type| Null | Ke
Go error 127 from table handler.. fixed itself in about 10 minutes..
don't know what this is or why it happened.. anyone know?
It happened while doing an update SQL command to a table.
I'm not even sure what it means.. can't find any error codes.
---
Xavier,
I assume you have increased
innodb_buffer_pool_size
to 16M or bigger?
The fsync problem fixed in .40b could cause
that InnoDB was not able to flush modified
pages quickly enough to disk, causing the
error message 'Difficult to find free block..."
Please download the brand-new 3.23.41
Hi!
This release mainly removes some of the old limits for InnoDB tables.
We have already moved most development to 4.0 and plan to release 4.0-alpha
by to the end of this month or at the start of September.
Changes in release 3.23.41
--
* Added option `--sql-mode=
try using "SHOW FIELDS FROM TABLE LIKE EXPR", where 'TABLE' is the
name of the name of the table, and 'EXPR' is an expression indicating what
you wish to match.
for example, to get the information about a column called 'ckey' in table
'config', you would do: "SHOW FIELDS FROM CONFIG LIKE 'CKEY'".
How do I benchmark 2 queries that return same results
without having mysql read from cache?
Example:
if i run the first query it will take 2 seconds, when I run the query
again, it takes 0.05 seconds.
And
What is the max. size of the index file that fits into 512M memmory, so that
mysql doesn'
Hi,
I just created a table which only accepts one record. I can delete and then
add a record but I can't have more than one record at the same time. I have
another table which only accepts 10 records . I can delete and then add
records but I can't have more than 10 records. I created these table
Hi,
I guess somthing happenned this weekend and mysql
restarted.
After the doing a recovery scanning . message
I get the following:
Warning difficult to find free block try to increase memory buffer pool
size.
I have killed the process and increased the memory so now mysql is using
about 90.6
>Description:
Index analysis and optimization is choosing wrong index when a
table involved in a JOIN is compound. MySQL should still be using
the first part of the GECK_STATE PRIMARY key (geck_id) since it is the column being
used to JOIN on the GECK table.
>How-To-Repeat:
You should a
Help! I can't get the DriverManager.getConnection() method with the 3-arg
signature to work (need it for DreamWeaver). Here are the two statements,
which should be equivalent:
WORKS:
Connection myConn =
DriverManager.getConnection("jdbc:mysql:///wroxjsp?user=xxx&password=yyy");
DOESN'T WORK:
It seems that it is not possible to write a non blocking select query in
C (if the server is not responding, the program is hung till the timeout
expires).
If the above is true, is it possible to use threads (on a Linux machine)
along with the MySQL client library?
--
Jean-Luc Fontaine
--
Horvath Gyula wrote:
>
> Dear Members!
>
> How can I convert a Corel-Paradox table (.db) to MySQL database ?
>
> Thanks!
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://l
hi,
I have pretty bad performance on the following query. Could someone help me to define
the indexes I need on the tables to improve this.
Thanks in advance.
select a.field_1,a.date,b.field_1,b.field_2,sum(a.subtotal) as total
from table_a as a, table_b as b
group by b.field_2,a.field_1
ha
I get the following error when running configure on a mysql-3.22.32 source
distribution for Solaris 2.7:
==
checking for restartable system calls... configure: error can not run test
while cross compiling
==
On Sunday 12 August 2001 01:01, Bennett Haselton wrote:
> I've written a CGI script that runs a database query on a MySQL database (I
> know that's risky -- it's password-protected though, for what it's
> worth). (...)
It's a free world ;-)
> When I run the script with the first of these two lin
> Hi,
>
> I'm new to mysql. I've installed an RPM undr Linux PPC and after running mysql
>server as root and trying to use a sample database from Paul Dubois book MySql, I '
>ve got the error 13, can't create directory/file ./samp_db/president.xxx.
>
> The thing is I'm using an example DB, any
hi people
this is the correct syntax:
"delete from TABLE_NAME where DATE_ADD(TIMESTAMP_COLUMN, interval 3 day) <
now()"
the function to be used is outside the parenthesis, the column name inside;
this way mysql applies the function to the column (using the specified
parameters "interval..."
> which version are u using?
> and pls state other info about ur OS!
> using with 3.23.38-max-nt in Windows2000 Advanced Server without problem when I
>search exactly your example.
> about the case "%0xF4 0xF4%", have u really used it to search in where clause,
> or u just want to elaborate ur e
Hey there,
sorry about the cross post, but whenever i mail the ODBC list, i tend not
to get any replies.
I posted a couple of weeks ago with this problem, basicially I am using
lotus approach to access a mysql database through myodbc.
it seems that i can only ever return approx 200 or so record
If you use a same MySQL handle for several threads you have to put
mutex locks around each {mysql_query() ..}
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_,
Hi,
Is anyone out there happily developing applications on RAQ4 / Chillisoft ASP
/ mySQL in the UK?
My company is looking to migrate some apps to this platform - I would be
very grateful if there is someone out there UK based willing to answer a
couple of questions I have.
any responses much ap
Hi
This is my first question to this group.
Is there anyway to grant access for all users to a table but two columns in
that table should be readonly, and
if username is something else it should have access to those two columns
with read and write and change.
Regards
Jonas Arvidsson
--
Try "mysqldump".
You should if there is no data being saved to the database be able to copy
the files.
It mite be a good thing to make shore that there is not a problem with the
DB?
Simon
-Original Message-
From: Guillaume Denizot [mailto:[EMAIL PROTECTED]]
Sent: 13 August 2001 12:31
To:
Hello,
Having trawled through the documentation for a while I'm none the wiser -
is there any way of retrieving the data type of a single column using
MySQL? Any suggestions would be most appreciated.
Thanks,
Matthew Marcus
Hello list
I want to save a database in order to replace it in case of
manipulating error.
Is there a way to save database (like export and import)?
Because I tried to copy files .frm, .ISD and .ISM, but when
I want to replace theses by old files, I obtain a
message "key error".
How can I do that?
Hi
I am reposting this just in case someone who would be able to assist me did
not see it first time around.
Thanks
Deon.
I am currently putting together a backup system for our MySQL server. The
way I want to do this is to make use of mysqldump to perform the backup and
have the binary log (o
- Original Message -
From: Horvath Gyula
To: [EMAIL PROTECTED]
Sent: Saturday, August 11, 2001 4:52 PM
Subject: Converting
Dear Members!
How can I convert a Corel-Paradox table (.db) to MySQL database ?
Thanks!
Hiya !
I run a website with a PHP and MySQL driven front & backend. The sites
hits increase day by day, and today I got the messege: too many mysql connections ..
well I thought, just check the my.conf ..
But there is no :(
I have MySQL v.8.21 Distrib 3.23.40 installed, with the RPMs given @ mysq
85 matches
Mail list logo
