Hello.
I'm running MySQL 3.23.29a-gamma on RH Linux 7.0. I would like to administer
my database from a Win98se client on the same network and installed EMS's
MySQL Manager 1.8. This appears to be an excellent tool and can't wait to
get started. Unfortunately I'm having a problem getting the
Hello.
I'm running MySQL 3.23.29a-gamma on RH Linux 7.0. I would like to administer
my database from a Win98se client on the same network and installed EMS's
MySQL Manager 1.8. This appears to be an excellent tool and can't wait to
get started. Unfortunately I'm having a problem getting the
I have a bit of a problem. I need to do something kinda odd that I'm
hoping to get help with...except for any suggestions of changing my
table structure. This might seem weird but I need to try and make it
work as it is.
I have a table called pwdata that looks like the following:
id
Hello,
Is anyone using Borland's C compiler with Windows (XP) ? I am trying to
compile/link a very simple MySQL client written in C, using MySQL include
files and mysqlclient library, but it does not want to work. What command
line(s) should I use to have it compiled right ? By advance, thank
Hi,
My name is Mike and I have visited your web site
at: http://www.mysql.com/downloads/gui-mysqlgui.html
I love it.
So I have decided to write to you.
I thought that because generating traffic is so critical for
any website, you could be interested in some information
I have about FREE
Neither of the two binary mysql-max 3.23.41 from the MySQL website will run on
my system after installation.
Both configure and mysql_install_db fail due to missing dynamic link libraries
/usr/lib/libdl.so.1 and libnsl.so.1. The system does have libdl.so and
libnsl.so.
The source distribution
Doesn't this figure... the spamming bastards are now wasting time in user
groups. What a dumbass.
Matt
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, September 08, 2002 7:26 AM
Subject: FREE traffic to your website !
Hi,
My name is Mike and I have
Hello!
I have one subroutine in Perl (DBI) that prepares and executes SELECT-like
queries and fetches the output from them.
When I submit SELECT * INTO OUTFILE query, then $sth-fetchrow_array()
generates Error:
Error 19 (fetch() without execute())
How to avoid it?
How can this subroutine
you need to execute your query first
you can avoid execute by using the just 'do' or else you'll need to execute
your query before getting results
Tom
- Original Message -
From: edatanew.com [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, September 09, 2002 12:35 AM
Subject:
I think the report is in rather good detail so not to lose any more of
your time here it is.
bug uname -a
HP-UX student B.11.00 U 9000/800 122901547 unlimited-user license
bug pwd
/var/tmp/vsurlan
bug ll
total 0
bug wget -c ftp://ftp.ntua.gr/pub/databases/mysql/Downloads/\
Hi Chuck,
or take a look at the LEFT() function.
=dn
Try :
SELECT * FROM yourtable WHERE word LIKE 'D%';
Regards,
Jocelyn
- Original Message -
From: Chuck PUP Payne [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, September 08, 2002 2:42 AM
Subject: Have A problem
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sunday 08 September 2002 02:25, Javier Suarez wrote:
Im having a problem compiling the version of the subject, the problem is
with the gethotsbyname function and the message is the next:
libmysql.c: In function `mysql_real_connect':
Yes, I can do that, but the subroutine is the same that execute other
SELECT-like statements. It does:
prepare
execute
fetch result
print
Then it must understand when SELECT * INTO OUTFILE must be executed and do
not try to fetch data.
Is there any criteria that say that there is no data to
Hello,
Is anyone using Borland's C compiler with Windows (XP) ? I am trying to
compile/link a very simple MySQL client written in C, using MySQL include
files and mysqlclient library, but it does not want to work. What command
line(s) should I use to have it compiled right ? By advance, thank
On Saturday 07 September 2002 10:48, you wrote:
You could do something like:
linux:/home/db/TMPOUT # rpm -e MySQL-4.0.3-0.i386.rpm
error: package MySQL-4.0.3-0.i386.rpm is not installed
Don't add the RPM on the end.
Also, what does:
* rpm -qa | grep MySQL
...show. It will be in
I just installed Max v3.23.52-nt and it is working. However, in following
the tutorial, I created a text file and tried to use the Load Data command,
which returned an error: ERROR 1148: The used command is not allowed with
this MySQL version
I need to convert a large Access DB to mySQL and I
Hi again,
I need to change cross 600 records that have 'Null' in the field and I need
to change it a value. What is the sql statement that will let me change that
field.
Chuck Payne
Magi Design and Support
-
Before posting,
On Thu, Sep 05, 2002 at 09:52:05AM -0400, Jamie Beu wrote:
I am attempting to setup MySQL replication between the ctiadb1 (master)
server and the ctiadb2 (slave) server.
When I look at the mysql.log file on the slave, I see the following
(repeated every 60 seconds):
020904 12:00:30
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Chuck,
If you need to change NULLs to a value all you need do is:
UPDATE table_name SET field_name = 'your_value' WHERE field_name IS
NULL;
HTH,
Bryant Hester
- -Original Message-
From: Chuck PUP Payne [mailto:[EMAIL PROTECTED]]
Sent:
Well I am glad for the help :). I am get an old table clean up but need to
re-index my table. I think there is on small problem. It's is ISAM table and
not myISAM.
Chuck Payne
Magi Design and Support
Mysql and sql
-
Before
Hello.
I'm running MySQL 3.23.29a-gamma on RH Linux 7.0. I would like to administer
my database from a Win98se client on the same network and installed EMS's
MySQL Manager 1.8. This appears to be an excellent tool and can't wait to
get started. Unfortunately I'm having a problem getting the
Hi
Generally root is only allowed access from local host for security.
Either use a GRANT statement to give access from the host you are using or
create another user with the appropriate permissions.
Not sure about the IP missmatch.
HTH
Peter
---
Odds are you have not granted your 'root' user rights to login from a node
on the network. Instea dof using root, I would suggest you create another
user with rights to login across the network.
- Original Message -
From: John Hanley [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday,
I got the file using load data infile (transfer)
[root@atsome host]# mysql -uroot db file.sql
ERROR 2006 at line 1: MySQL server has gone away
When i try to do this command it issues this error, whay is that?
I also tried doing integritycheck on my db.
No problem actually.
Thanks,
Louie...
Hi,
I'm new to this list, and have a few basic MySql questions:
* Is it safe to convert a timestamp field to a datetime one? ie: will this
'touch' each row and stuff up the ordering (hopefully not!).
* I'm building a BBS application that needs to keep track of 'child counts'.
Currently, I'm
Hello,
How can I determin what erros occur from an Insert into select from
statement? Namely, I'm looking for any duplicate record errors. It is
important to inform the user (in a web browser) whether or not a particular
insert would fail.
Must I perform a lookup first, or is there a way to
Hi!
I have a number of tables in development in 3.22.32
(running in apache_1.3.12 on a linux kernel)
I'd really like to upgrade to 3.23.49a but my installs in both rpm and
binary have not succeeded in taking over from my previous install.
I've read quite a bit at the mysql.com site, but
Update: Now, after rebooting the server, the site can't connect...that's
more like it ;)
-Original Message-
From: Richard W. Berriman [mailto:[EMAIL PROTECTED]]
Sent: Sunday, September 08, 2002 4:43 PM
To: [EMAIL PROTECTED]
Subject: Upgrading
Hi!
I have a number of tables in
I wrote an application that will be using MYSQL as the backend database.
The software will be meant to run on a single non networked, Windows
machine. Does anyone have any ideas on how I might install the MYSQL server
software and the odbc drivers without having the user installing it and
The command
LOAD DATA LOCAL INFILE C:\\MO10.txt
INTO TABLE stud1
fields terminated by /
lines terminated by '\r\n';
produces:
ERROR 1148 at line 1: The used command is not allowed with this MySQL vers
Could someone explain why??
I'm running version MYSQL Ver 11.18 Distrib 3.23.51, for
One can disable all LOAD DATA LOCAL commands in the MySQL server by starting
mysqld with --local-infile=0.
In the case that LOAD DATA LOCAL INFILE is disabled in the server or the
client, you will get the error message (1148):
The used command is not allowed with this MySQL version
I am having trouble with an sql query. I have a table with a column that
has an '#' sign in the name. The problem is I can't seem to escape the
column name to be able to select it.
IE:
select test#1 from test or select `test#1` from test
Both don't work and i get the error Unknown column
Jeremy Zawodny ([EMAIL PROTECTED]) wrote:
On Sun, Sep 08, 2002 at 03:30:35AM +, Sam Przyswa wrote:
Jeremy Zawodny ([EMAIL PROTECTED]) écrivait:
On Fri, Sep 06, 2002 at 03:52:24PM +, Sam Przyswa wrote:
Hi,
Does the next MySQL 4.x version will support cross replications
between
On Sun, Sep 08, 2002 at 11:53:41PM +, Sam Przyswa wrote:
Jeremy Zawodny ([EMAIL PROTECTED]) wrote:
Does multi-master mean master to master, imagine you have 3 MySQL
servers, A, B, C, with a load balancer in front end, if we make an
update on A, is it possible to replicate/sync the
After a year of doing database programming, try to actually normalize. Read
a couple online tutorials (phpbuilder, devshed) and the book mysql 2nd
edition and it just can't seem to stick. Understanding the concept/theory
but freeze up every time I try to implement. Trying to go from
I had that once and it was due to the fact that the data I was trying to
put into the database was bigger the 1M (1M is the default) per insert
I had to start mysqld with ' -O max_allowed_packet=3M'
On Mon, 9 Sep 2002, louie miranda wrote:
I got the file using load data infile (transfer)
Ben Goodwin said:
[Charset iso-8859-1 unsupported, filtering to ASCII...]
Based on the prefix for your MySQL installation (--prefix=/usr/local/mysql
'), you're not using the right paths. You need to set the -Idirectory to
be where your mysql.h file is, and the -Ldirectory to be where your
rm said:
Steve,
in this line:
MYSQLLIBS = -L /work/doctools/mysql-3.23.52/lib -lmysqlclient
Try eliminating the space between -L and /work/
that format always works for me using gcc.
Other than that, I don't see anything that looks wrong.
Thanks for the suggestion. I just
I'm not doing that. I'm doing
C:mysql -r -N fall02 \mysqluw\mysql.txt
(i.e. using the mysql command from DOS, and running a batch file)
And I didn't change any configuration defaults since installing mySQL on
this machine.
- Original Message -
From: Sqlcoders.com Programming Dept
Can't your deployment package include all the required files? Visual Basic
does this nicely.
.b
--
ben joyce // [EMAIL PROTECTED] // +44 (0)7958 933718
Quoting Aaron [EMAIL PROTECTED]:
I wrote an application that will be using MYSQL as the backend database.
The software will be meant to
Spiros,
linux:/home/db/TMPOUT # rpm -q mysql
package mysql is not installed
linux:/home/db/TMPOUT # rpm -qa | grep MySQL
MySQL-shared-4.0.3-0
MySQL-client-4.0.3-0
MySQL-devel-4.0.3-0
MySQL-4.0.3-0
linux:/home/spiros/TMPOUT #
Ok.
mypc@linux:~ /usr/bin/mysql
ERROR 2002: Can't
Jeremy Zawodny ([EMAIL PROTECTED]) wrote:
http://jeremy.zawodny.com/mysql/managing-mysql-replication_files/slide0121.htm
Just make B a slave of A, C a slave of B, and A a slave of C.
This is a good approach.
Except that it's fragile. One machine can go down and break the
cycle
Hello
I just installed mysql 4.0.3-beta for innoDB
1.I deleted my existing mysql4.0.3, my.ini and my.cnf files
2.I created a new my.cnf file and copied to c:\winnt directory
The contents being
# Example mysql config file.
# Copy this file to c:\my.cnf to set global options
#
# One can use all
That path isn't where mysql is installed. I checked the paths; my makefile
has the correct path. CC can find the header files, and the linker can
find
the lib (using truss I can see the linker open the file).
I'm not sure where the --prefix cam frome. Is that a compile-time option?
I
Thanks
It's 2.4.18
So, I will try to unistall and install from the
tarball, yes?
Spiros,
linux:/home/db/TMPOUT # rpm -q mysql
package mysql is not installed
linux:/home/db/TMPOUT # rpm -qa | grep MySQL
MySQL-shared-4.0.3-0
MySQL-client-4.0.3-0
MySQL-devel-4.0.3-0
Hmmm,
(mysql, query)
Thanks
That's OK.
It's 2.4.18
Sorry, I meant distribution...eg is it RedHat, Slackware ;-?
So, I will try to unistall and install from the
tarball, yes?
It wouldn't hurt. How did you install it in the first place?
DSL
--
Con te partiro, su navi per mari
Che io
46 matches
Mail list logo