The tarball seems to be missing libmysqlclient.so, I can get the database
server started fine, and can connect to it using client applications.
However, any attempt at using the dynamic client libs fails for obvious
reasons. Am I missing something? Maybe downloading the wrong tarball? Or
do I ne
Hi all,
I hava a mysql database wich contain some country name only country names
some a old
like USSR ...
I have to add some field into this db from the file found at the ripe net
ftp.ripe.net
file : iso3166-countrycodes.txt
see part of this file :
Some Codes from ISO 3166
Updated by the RIPE
- Original Message -
From: "sdfine" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 28, 2002 12:06
Subject: Accessing MySQL Using ASP
>
> Does anyone have a good example of accessing and displaying data in a
MySQL
> database using ASP and displaying it on a web page? I
Carsten Hammer writes:
> Hi,
> I just experienced the following bug in tables created as berkeley
> tables:
>
> on bdb tables:
> mysql> SELECT
> jobs.number,jobs.status,jobs.filename,jobs.source_file,verarbeitung.name
> FROM verarbeitung right join jobs on (verarbeitung.verarbeitung =
> jobs.vera
At 20:14 +0100 1/29/02, Lutz, Helmuth wrote:
>Paul,
>I do not know why, but it did not work. Please see yourself:
>This lines I could not copy and paste because the results are on a not
>connected Mac and this is a windows machine. So I had to write it by hand
>(- but looked 2 times at the text)
>
I m franch a little latin,
no u re not an error.
see at www.mysql.com if u can found doc into your language have a look at
grant / revoke command to make 'fire1.uniube.br' allowed to query the
server.
GRANT ALL ON database.* TO [EMAIL PROTECTED] IDENTIFIED BY "password"
"all" is too much u can
Paul,
I do not know why, but it did not work. Please see yourself:
This lines I could not copy and paste because the results are on a not
connected Mac and this is a windows machine. So I had to write it by hand
(- but looked 2 times at the text)
Your example:
>% ps ax | grep mysql
> 251 ?? S
Tod Harter writes:
>
> What would be the performance considerations? Considering it theoretically if
> I (for instance) set things up so that I had an ftp server for the images and
> stored filenames in a column then as far as raw data transfer efficiency its
> tcp either way. I guess the ques
Hi everybody!
I am developing a site under PHP and Mysql
which is now in the first steps.
My question is, (since I don't administer the server), how can I calculate
the resources
that the system will need to run as smothly as possible?
I mean, for example I am planning to use temporary table to
On Tuesday 29 January 2002 12:40, Sinisa Milivojevic wrote:
> Tod Harter writes:
> > Hi Guys
> >
> > I've been using MySQL for a few years now, but always on medium sized
> > projects. I think the biggest thing I ever did has maybe 200k records in
> > it.
> >
> > Now all of a sudden I have a clien
Hi, my problem is that when i do a
show table status like "al%"
one of my innodb tables (named
'aluno') says to have 255 rows.
But, in fact, it have 286 rows, by:
select count (*) from aluno;
Someone can help me ?
__
Hi,
I'm brasiliam, so..
my english is very bad
I'm a error:
Warning: Host 'fire1.uniube.br' is not allowed to connect to this MySQL
server
Tanks
Joabe
-
Before posting, please check:
http://www.mysql.com/manual.php
Hi!
MySQL Control Center (MyCC) is the new GUI client for MySQL databases.
MyCC is developed and provided by MySQL AB - a commercial company that
builds its business providing services around the MySQL database.
MyCC is a platform independent graphical client which is based on
Trolltech's QT too
Scott -
I recently had a similar problem with a JSP application I built using MySQL
on the backend.
Don't know what the issue is/was but I did notice that if I was updating
rows in a table on a regular basis - PHPmyAdmin 2.2 says I have a lot of
"overhead" in the table. I'm not sure what is causi
Tod Harter writes:
> Hi Guys
>
> I've been using MySQL for a few years now, but always on medium sized
> projects. I think the biggest thing I ever did has maybe 200k records in it.
>
> Now all of a sudden I have a client with a requirement for a database that we
> estimate will be in the ran
mysql must be in your PATH. Is it?
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 29, 2002 8:30 AM
To: [EMAIL PROTECTED]
Subject: [NEWBIE]Can't run mysql client
Stephane,
Monday, January 28, 2002, 1:29:40 PM, you wrote:
SP> I've installed mysql
I am using mysql verison 3.23.41-nt
I am working with the following two tables.
mysql> show create table table1;
| Table | Create Table
-
| table1 | CREATE TABLE `table1` (
`Column1` varchar(63) NOT NULL default '',
`Column2` varchar(31) default NULL
P
--On Tuesday, January 29, 2002 2:08 AM -0600 Ed Carp <[EMAIL PROTECTED]> wrote:
>> What seems to be happening is that the "open" of the db hangs. So, when
>> you attempt to connect with a client, mysql tries to look at the grant
>> tables and hangs waiting for access. This is just a guess thoug
Frank,
Tuesday, January 29, 2002, 5:30:33 PM, you wrote:
FRSE> the "./configure --with-low-memory" works but I don't FRSE> understand why the
same version of mysql compilesFRSE> successfully on smaller system with less
FRSE> swap ?
God knows. Compiling such a complicated system like MySQL
Samy,
Tuesday, January 29, 2002, 4:54:24 PM, you wrote:
>> SE> ./configure --prefix=/ussr/loca/mysql
SE>
SE> Typo I used /usr/local/mysql
SE> To make a long stroty short , I downloaded the source
SE> rpm and started over , now I have the mysql.sock file.
SE>
Hi Guys
I've been using MySQL for a few years now, but always on medium sized
projects. I think the biggest thing I ever did has maybe 200k records in it.
Now all of a sudden I have a client with a requirement for a database that we
estimate will be in the range of 1 to 4 TERABYTES of data...
{ Am I to assume there is no solution to my problem? }
Greetings,
I have two large tables in a database with a few million entries. There is only one
column in each table.
Everything was working okay until today. The size of the table files is 1gb+ but
PHPMyAdmin says it has no records.
> Hi all,
>
> I can't find a description of the algorithm used in the mySQL PASSWROD
> function. I understand it's a hashing algorithm of some kind, but I
> don't know which algorithm (and I suspect it's *not* MD5.)
>
> Can anyone tell me what algorithm PASSWORD uses? The reason I ask is
> th
Billy,
Where is the source code you are trying to compile located? Is it same as
where you keep your .jar file? If not, give java_home/jre/lib/ext path to
javac as an -classpath option ...
The drivers don't know where to find the databases.. Your program specifies
them the server IP, username,
I think mysql uses the system crypt() function. This is, no-doubt, available
through some well hidden Java class. Just do "man crypt" to learn about
crypt().
Chris
On Tue, 29 Jan 2002 10:59:55 -0500
John Kemp <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I can't find a description of the algorithm
Ed,
Have you checked out phpMyAdmin? It can be downloaded at:
http://phpwizard.net/projects/phpMyAdmin/
I use it with all my clients and it's great! For when I want a bit
more control I Telnet, but most of the time I use this to help my
with my databases.
>I used to use some php scripts t
Has anyone on this list used Veritas Cluster Server to build an HA MySQL
solution? If so, please email me. I am in the process of attempting to do
this. So far, I have been able to deal well with the hardware agents
(network, disk, nfs, cpu). However, when it comes to creating software
agents for
You could find a useful tool at
http://www.phpwizard.net/projects/phpMyAdmin/
Hy Moreno
-Messaggio originale-
Da: Ed Lazor [mailto:[EMAIL PROTECTED]]
Inviato: martedi 29 gennaio 2002 16.54
A: [EMAIL PROTECTED]
Oggetto: mysql web-based admin tool?
I used to use some php scripts that allo
Phpmyadmin is pretty good for what you ar elooking for.
You can find it at:
http://www.phpwizard.net/projects/phpMyAdmin/
Gurhan
-Original Message-
From: Ed Lazor [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 29, 2002 10:54 AM
To: [EMAIL PROTECTED]
Subject: mysql web-based admin
John Kemp writes:
> Hi all,
>
> I can't find a description of the algorithm used in the mySQL PASSWROD
> function. I understand it's a hashing algorithm of some kind, but I
> don't know which algorithm (and I suspect it's *not* MD5.)
>
> Can anyone tell me what algorithm PASSWORD uses? The rea
In the last episode (Jan 29), John Kemp said:
> Hi all,
>
> I can't find a description of the algorithm used in the mySQL PASSWROD
> function. I understand it's a hashing algorithm of some kind, but I
> don't know which algorithm (and I suspect it's *not* MD5.)
The algorithm is in the sql/pass
Palmer,
Tuesday, January 29, 2002, 5:19:00 PM, you wrote:
Peoen> I am a new user to MySQL. The server is running, but I keep getting the
Peoen> following error:
Peoen> Host 'www.usapa.army.mil' is not allowed to connect to this MySQL
Peoen> server.
[]
Peoen> Why am I getting Host is n
admin,
Tuesday, January 29, 2002, 4:38:56 PM, you wrote:
bash>>mysqladmin -u root ?
Find your answers at:
http://www.mysql.com/doc/D/e/Default_privileges.html
and at:
http://www.mysql.com/doc/G/R/GRANT.html
--
For technical support contracts, goto https://order.mysql.com/
Thi
Hi,
On Tuesday 29 January 2002 16:53, Ed Lazor wrote:
> I used to use some php scripts that allowed me to work on my database. I'm
> trying to find them again... anyone know what they might have been called
> or where to find them?
> -Ed
Maybe it's phpMyAdmin...
http://phpmyadmin.sf.net/
Regar
Hi,
The most widely used tool to reach MySQL over PHP is phpMyAdmin. You can
obtain it from http://www.phpwizard.net/projects/phpMyAdmin/
- Original Message -
From: "Ed Lazor" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 29, 2002 5:53 PM
Subject: mysql web-based
Hello,
I have two servers under a mutual master-slave relationship. I need to
ignore certain databases when replicating. I tried to use
replicate-ignore-db but according to the MySQL manual this won't work for
cross database updates. The manual suggests using
replicate-wild-ignore-table instead.
I am trying to install the jdbc driver to work with MySQL. I have added the
file: mm.mysql-2.0.8-bin.jar to the directory: java_home/jre/lib/ext. The
problem is when I run my class i get a class not found error even though the
mm.mysqlbin.jar is in the lib/ext directory. What am i doing wro
Hi all,
I can't find a description of the algorithm used in the mySQL PASSWROD
function. I understand it's a hashing algorithm of some kind, but I
don't know which algorithm (and I suspect it's *not* MD5.)
Can anyone tell me what algorithm PASSWORD uses? The reason I ask is
that we're trying
I used to use some php scripts that allowed me to work on my database. I'm
trying to find them again... anyone know what they might have been called
or where to find them?
-Ed
-
Before posting, please check:
http://www.mys
I compiled mysql 3.23.47 from source and still can't shutdown the daemon
with a "mysql.server stop" or a simple kill command. Only way to stop it is
with a kill -9. I previously installed the precompiled binary and had the
same problem. I guess this isn't fully fixed with the .45 version as was
po
At 16:25 +0100 1/29/02, Lutz, Helmuth wrote:
>Paul,
>
>thanks for answering. Because of my job I have to succeed this
>correspondence from within another location and machine.
>
>Could you please give some more explaination to a bloody guy to Unix and
>the terminal like me:
>
>1)
>>Kill the server
Hi Egor,
the "./configure --with-low-memory" works but I don't understand why the
same version of mysql compiles successfully on smaller system with less
swap ?
There surely can't be a requirement for >500 Megs swap for an ultra 2
and >1.5 Gigs for a starfire ?
thanks,
-- frank
Egor Egorov wr
>Description:
slaves does not honore the mysqlimport --lines-terminated-by='\n\n' switch
>How-To-Repeat:
i've set up two machines as master - slave. i start out with a running
replication in a sane state.
now i do on the master:
mysql -e '
drop table TOR5;
I am a new user to MySQL. The server is running, but I keep getting the
following error:
Host 'www.usapa.army.mil' is not allowed to connect to this MySQL
server.
When I enter the mysqladmin version command, I get the following:
mysqladmin Ver 8.23 Distrib 3.23.47, for pc-linu
Chetan,
Tuesday, January 29, 2002, 4:06:30 PM, you wrote:
CL> thanks for your quick reply !!
CL> that's fine !! I have done the max.RPM installation part.
CL> but what is "fix up the startup scripts so that
CL> binary will be the one started."
CL> When I am trying "show variables like "have_%"
David,
Monday, January 28, 2002, 10:43:38 PM, you wrote:
DS> REALFROM: David Shields <[EMAIL PROTECTED]>
DS> HOUR: 2002012901
DS> You wrote:
DS> What about mysqldump? See http://www.mysql.com/doc/m/y/mysqldump.html
DS> for more info about mysqldump.
DS> well, no, not really :
DS> site1 - ha
Hi!
> "Ulf" == Ulf Harnhammar <[EMAIL PROTECTED]> writes:
Ulf> On Sun, 27 Jan 2002, Michael Widenius wrote:
>> One way to do this is to do as follows:
>> SELECT something FROM sometable WHERE somevar=somevalue ORDER BY
>> RAND() LIMIT 10
Ulf> OK. I still think that my extended LIMIT syntax
Hi all,
there must be some kinds of technical difficulties as I'm also not
able to unsubscribe at the moment.
At 14:28 29.01.02 +, you wrote:
>could you be subscribed under two (or more) email addresses?
>
>Peter
>
> > -Original Message-
> > From: Yuxia Li [mailto:[EMAIL PROTECTED]]
Tried that , but I used the source to compile , and
put it into /usr/local/mysql
So every thing is diffrent. Haveing relied on YaST I
do not know how to do it manualy , where and what
files to edit. I came from the windows world an jumpt
on to linux back during suse 5.1 days. Tells you how
good
Hi there,
I wish to setup replication between a pair of mysql servers. However
since my slave only has an ADSL connection to the master I want to
compress the data between them. A small wrapper around zlib does this for
me. My slave mysql must therefore connect to a port on the local machine
th
> SE> ./configure --prefix=/ussr/loca/mysql
Typo I used /usr/local/mysql
To make a long stroty short , I downloaded the source
rpm and started over , now I have the mysql.sock file.
Looks like the download was currupt. I nned to use the
sourcee as I am c
bash>mysqladmin -u root ?
Thanks
Edakom Internet Sorumlusu
Gokce Akkaya
could you be subscribed under two (or more) email addresses?
Peter
> -Original Message-
> From: Yuxia Li [mailto:[EMAIL PROTECTED]]
> Sent: 29 January 2002 06:15
> To: [EMAIL PROTECTED]
> Subject: Re: Trouble in unsubscribing
>
>
>
> Hi:
>
> Does anyone know how to unsubcrib from
Jessica,
Monday, January 28, 2002, 3:13:11 PM, you wrote:
JR> Can anyone help me -
JR> I am trying to extract data on the availability of a holiday villa using the
JR> statement
JR> 'SELECT PossDate from JuneDates where not exists(SELECT PossDate FROM
JR> Reservation WHERE PossDate Between Arr
Joachim,
Monday, January 28, 2002, 2:15:51 PM, you wrote:
JH> I have installed MySQL Version 3.23.47 on Suse Linux 7.2 (Kernel 2.4.4)
JH> After the installation of mysql I run the mysql_install_db script
JH> I could change the passwords for root so I reset the GRANT table using
JH> ../safe_my
Torkil,
Monday, January 28, 2002, 5:47:48 PM, you wrote:
TJ> A friend of mine is having a problem with the 3 norwegian characters æ Æ, ø
TJ> Ø and å Å. (html: æ ø and å)
TJ> When a string is inserted with either of these characters, and later
TJ> selected and returned, they do not appear as the
Chetan,
Tuesday, January 29, 2002, 7:02:18 AM, you wrote:
CL> thanks for reply,
CL> but I have installed MySQL on Linux using the RPM files and while using
CL> RPM files should I have to give the option while installing? As while
CL> using the RPM files there is no compilation.
CL> It is no whe
Frank,
Tuesday, January 29, 2002, 12:33:03 PM, you wrote:
FRSE> I have an Sun Ultra 2 with 500Megs of swap and I constantly get the
FRSE> following swap space messages when I try to install mysql-3.23.39.
[]
FRSE> --
F
Matthew,
Tuesday, January 29, 2002, 6:37:32 AM, you wrote:
MW> You can only do this while compiling it from source.
MW> Matthew Walker
MW> Ecommerce Project Manager
MW> Mountain Top Herbs
MW> -Original Message-
MW> From: Chetan Lavti [mailto:[EMAIL PROTECTED]]
MW> Sent: Monday, Janua
Ed,
Monday, January 28, 2002, 11:26:44 PM, you wrote:
EC> Hi! I'm having a problem with mysql hanging. I'm running mysql-3.23.36 on
EC> a Linux 2.2.17 kernel. It ran just fine last week, but when we rebooted the
EC> box, mysql will start, but connections to the database just hang.
EC> mysqldm
Samy,
Monday, January 28, 2002, 8:09:37 PM, you wrote:
SE> Hope some of you could help me here.
SE> I have done
SE> ./configure --prefix=/ussr/loca/mysql
SE> --localstatedir=/usr/loca/mysql/data
SE> --withunix-socket-path=/tmp/mysql.sock
SE> make
SE>
Stephane,
Monday, January 28, 2002, 1:29:40 PM, you wrote:
SP> I've installed mysql 3.23.47 (Binaries) on a Linux RedHat 7.0 box.
SP> Everything seems to be OK (the server runs) but I cannot connect to it using
SP> mysql client:
SP> When I enter "mysql -u etc..."
SP> I've got a "bash: mysql: c
Cindy,
Tuesday, January 29, 2002, 1:28:59 AM, you wrote:
CY> Hello,
CY> Can anyone tell me how to load data into non-empty tables? Can you
CY> give me an example?
CY> Any help appreciates!
Look in the manual about LOAD DATA at: http://www.mysql.com/doc/L/O/LOAD_DATA.html
--
For technical
xgao,
Tuesday, January 29, 2002, 3:45:30 AM, you wrote:
x> Hi all
x> I try to connect mysql on turbolinux with my windows mysql client but the
x> client tells me my host is not allowed to connect the mysql server.
Please refer the following link:
http://www.mysql.com/doc/C/o/Connecting.html
thanks for your quick reply !!
that's fine !! I have done the max.RPM installation part.
but what is "fix up the startup scripts so that
binary will be the one started."
When I am trying "show variables like "have_%";
+---+---+
| Variable_name | Value |
+---+---+
I'm developing in asp and connect to databases using something like this:
(using ODBC)
set db = Create.ServerObject("ADODB.Connection")
db.open "databaseName;"
This works fine and I can get and insert data with no trouble. However,
when I do:
db.close
set db=nothing
Nothing happens. The conn
Hello,
I'm developing an application with MySQL using the C API. I would like
to implement a mechanism to prepare some queries in advance and just
bind the parameters before execution. I have found in the documentation
a way to do that using the DBI Interface but not for C API. Is it
possible to
Eric,
Monday, January 28, 2002, 2:30:47 PM, you wrote:
ETK> Eric here from South Africa.
ETK> I'm fairly new at using mysql and need to access images via a php website.
ETK> What is the best way to store images or reference to images like jpg and
ETK> gifs in a mysql db? Also what would the s
On 28 Jan, Paul DuBois wrote:
>On 28 Jan John A. Murdie wrote:
>>I decided that it was probably simpler just to build from source - I'm
>>on a Solaris 2.8 system - and so it proved to be. I was careful to use
>>the recommended configure options.
>>
>>I found that I had to build in the installation
Hi,
I have an Sun Ultra 2 with 500Megs of swap and I constantly get the
following swap space messages when I try to install mysql-3.23.39.
-
Note: The following compile may take a long time.
If it fails, re-run confi
On Sun, 27 Jan 2002, Michael Widenius wrote:
> One way to do this is to do as follows:
> SELECT something FROM sometable WHERE somevar=somevalue ORDER BY
> RAND() LIMIT 10
OK. I still think that my extended LIMIT syntax would be a good idea,
because ORDER BY RAND() does not seem to be very fast
Hi,
It is said that if the connection is lost then there will be an entry of
the .err file.
But nothing of that sort is happening here.
Connection is not lost, and replication is also not taking place.
Can any one help to get the solution.
On Tue, 29 Jan 2002, Jai Kumar Shinde wrote:
> Hi,
>
Check out this program. Just wish there was an OS X version :-(
http://www.datanamic.com/dezign/index.html
-- greg willits
-- [EMAIL PROTECTED]
From: Steven Wren <[EMAIL PROTECTED]>
Date: Tue, 29 Jan 2002 16:22:12 +1000 (EST)
To: Paul DuBois <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED]
Subject:
Tuesday, January 29, 2002, 1:57:21 AM, David Piasecki wrote:
> I have a server here that is troubling me -
> I have a database server that is lagging no matter what I do. When I
> start the server, I can watch CPU usage slowly creep up to 99% and it
> never drops. The queries that are hitting t
Hello Mr.Venu,
yes, of course, I took a look at it and I checked this out. It was quite
useable for mass-mailings, but not for single letters.
e.g. My database contains a lot of adresses. I created a dialogbox, where I
enter a name and now the corresponding adress will be looked up in th DB.
now
101 - 175 of 175 matches
Mail list logo
