Hello Paul,
Thank you for a quick reply.
It doesn't look "same way" :(. Normally I've read data from a file on a client's
machine
using Perl's read function like this
while(read($file, $data, 1024))
{
print TO $data;
}
to write it from $file on client's computer to a file associated with
Warning
Unable to process data:
multipart/mixed; boundary="--==_846811060==_"
sql query
Hello Folks,
Hello, I am trying to convert this weird cobol style number into a
regular integer. I got it from a fixed length text file.
From the description file:
Amount
Columns 131-137
Numeric
In the fixed width text file, the amounts are in COBOL format.
If the valu
Hello all,
After install XDarwin in Mac OSX and experimenting installing the GIMP
and some other xapps I have tried to compile MySQL GUI unsuccesfully.
Would somebody show me a link with some advice?
TIA,
Luque
-
Before pos
At 00:02 2002-03-10, you wrote:
>Is this me or the mysql lists,
>
>I am getting a lot of double messages, are people sending double, or is
>it me and my outlook..
>
>Just checking it's kind of annoying.
>
>Later
>Kacey A. Murphy
>netBuilder's, Inc.
Methinks it's You, or the beer... ;)
---
On Saturday 09 March 2002 10:38 am, Jeremy Zawodny wrote:
> Sasha,
>
> Running the latest binary I just built, I had a single core dump and
> auto-restart early this morning.
Jeremy:
I've made a few more updates to the source and pushed it to the public
repository. The most important one is th
Is this me or the mysql lists,
I am getting a lot of double messages, are people sending double, or is
it me and my outlook..
Just checking it's kind of annoying.
Later
Kacey A. Murphy
netBuilder's, Inc.
-
Before posting, ple
A quick diagnostic?
Try the page phpinfo.php in the phpMyAdmin directory - this will give you
the 'whole picture' in terms of your php installation...
Even easier? Any php page which contains the code:
Will give you this full info report. Very useful!
Lou Picciano
>
> Thanx Lou, this rea
At 18:29 09/03/2002 -0700, Michael Halcrow wrote:
Hi!
>I use standard C++ (with some STL in there) and calls to
>mysql_real_connect, mysql_query, etc. However, when I tried to import my
>code into a Microsoft Visual C++ project (copy files in, add a
>'/I"c:\path\to\header\files\from\http://www.my
ok, disregard this, i worked out what i did wrongly.
> -Original Message-
> From:
> Sent: Sunday, March 10, 2002 2:38 AM
> To: [EMAIL PROTECTED]
> Subject: bad table in fields list; mysql fails to update
>
>
> >Description:
> When selecting from multiple recently added tables, mys
>Description:
When selecting from multiple recently added tables, mysql returned a "table
does not exist error".
table blatantly exists, i recently added it.
nb: output from mysql (and mysqlbug) sanitized to protect IP.
>How-To-Repeat:
mysql> show tables;
+---
sorry to cross post.
Actually I also want to achive the same thing for virtual hosting.
Would you tell me how you will create a database in $home/mysql ?
What I know is when you say create database , it creates under
$mysqlhome/var/
Please calrify the doubts.
Praful
- Original Message -
Hi,
If your hosting compamy provide PHP support then make a php page,
---
view this page in browser and you will see lot of information including the
HOSTNAME variable.
Then use that host name in your connection string.
Other wise it is always better to try
Thanx Lou, this really helps out. One question though and maybe this runs
deeper then I think.
When I start my machine, and run phpMyAdmin (VD in IIS5) it works fine.
When I close the browser window after making changes to a user, and then
try to re-open it, I PHP is no longer working. I am n
You should use mysqldump[.exe] to export/import, on the respective systems:
4.8.5 mysqldump, Dumping Table Structure and Data
http://www.mysql.com/doc/m/y/mysqldump.html
C:1
-Original Message-
From: David yahoo [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 09, 2002 2:
I wrote a MySQL client program using GCC in Linux. It works beautifully.
However, I need to integrate it with a Windows-only Bluetooth stack, which
means that I need to port my code to Windows. I am not happy about this
situation, but I find myself in it nonetheless.
I use standard C++ (with some
I've tried to export some data from my MySQL database (3.23.49) using
mysqldump -X to a XML file.
And I've got something like that:
1572160047
American Gothic Cookbook
ppress
0
0
0
1-57216-004-7
1999-10-21
Why some of the elements have a valid ending tag and some not?
R
(BTW, mysqldumpslow does not seem to be in the RPMs for v4.)
mysqldumpslow (perl itself, I guess) dumps core and acts incorrectly
when dealing with simplifying strings.
Fix:
Change:
s/'([^\\\']|\\.|\'\')+'/'S'/g;
s/"([^\\\"]|\\.|\"\")+"/"S"/g;
To:
s/''/'S'/g;
s/""
Dear All,
Since I did some online updating from the SuSE website, only ssh and
mod_php stuff, I'm unable to start the MySQL deamon. The error log says:
020310 00:08:00 mysqld started
/usr/sbin/mysqld-max: Fatal error: Error message file
'/usr/share/mysql/english/errmsg.sys' had only 212 erro
Hi
Thanks for the tip! it works fine.
Now all i need to do is modify my create database code to use $HOME/mysql
and make symbolic link
Mark
--
Obantec Support
www.obantec.net
WebHosting and Domains
Nominet UK Tag Holder
- Original Message -
From: "Andreas Frøsting" <[EMAIL PROTECTED]>
T
Stange I make a ps :
mysql 6337 0.0 5.4 27588 15608 ? S23:22 0:00
/usr/sbin/mysqld
--basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/
www.
sassandra-conseil.com.pid --skip-locking
mysql server is reunnig with mysql user.
I make a su mysql :
this works
Hi all,
I developp a site with some mysql table which are files myd myi n frm under
windows x86 arch.
I copy my table into a liinux box x86 arch too.
Bu when trying to modidy tables I get an Error: 1036 - Table country is read
only
I manage the rigth of new created tables.
I get things like tha
I am glad you asked that. I think for my application, I am going to set up
a blank set of tables in the database, and as a new user subscribes, simply
move the blank database into their personal directory, that way I can keep
all of their data segregated from other users. It may take addition
p
Hi,
> Anyone know if its possible to have mysql databases under
> $HOME for users.
> I am running RH7.2 and have virtualhosts under apache 1.3.22
> so i am hoping
> i can put databases under each user account in order to
> control (quota's)
> etc.
You can put them under each users homedir and
Hi
Anyone know if its possible to have mysql databases under $HOME for users.
I am running RH7.2 and have virtualhosts under apache 1.3.22 so i am hoping
i can put databases under each user account in order to control (quota's)
etc.
Mark
--
Obantec Support
www.obantec.net
WebHosting and Domains
>Description:
2 problems with MySQL-3.23.49a-1 (linux x86 rpm)
1) binaries not stripped (= 40MB !!!)
2) mysqlshow doesnt work properly
>How-To-Repeat:
from /etc/my.cnf:
[client]
socket = /tmp/.mysql.sock
(work)~$ mysqlshow
mysqlshow: Can't
Thanks, Rob. Yeah, I just figured it out myself. I think I convinced myself
that it couldn't be that easy!
--jeff
- Original Message -
From: "Rob" <[EMAIL PROTECTED]>
To: "Jeff Kilbride" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]>
Sent: Saturday, March 09, 2002 1:26 PM
Subject: Re:
Aha! Figured it out...
SELECT COUNT(DISTINCT ipAddress)
FROM table
WHERE initDate >= DATE_ADD(now(), INTERVAL -60 MINUTE)
AND id = [whatever id I'm looking for...];
Works semantically like it sounds. Probably the only variation I didn't try
before posting! (always works that way...)
Thanks,
--j
I asked almost the exact same question just a few days ago.
As of MySQL 3.23.2 you can use COUNT and DISTINCT together:
SELECT COUNT(DISTINCT ipAddress) ...
On 9/3/02 at 1:16 pm, Jeff Kilbride <[EMAIL PROTECTED]> wrote:
> I have a table with 3 fields:
>
> initDate datetime not null
> id int u
I have a table with 3 fields:
initDate datetime not null
id int unsigned not null
ipAddress int unsigned not null
I'm trying to find the number of distinct ipAddresses associated with a
particular id over a specified time frame -- for simplicity, let's say the
time frame is the last 60 minutes.
On Sat, Mar 09, 2002 at 10:59:52PM +0200, Jarkko Toivonen wrote:
>
> I have a column defined as varchar(255) in my MySql-database. Now I
> realized that there's not enough room for my inserts. Is there any
> chance to change it's datatype to tinytext without making an
> entirely new database and i
Hi,
Take a look here :
http://www.mysql.com/doc/A/L/ALTER_TABLE.html
Regards,
Jocelyn Fournier
- Original Message -
From: "Jarkko Toivonen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, March 09, 2002 9:59 PM
Subject: Changing datatypes "on the fly"?
> I have a column d
I have a column defined as varchar(255) in my MySql-database. Now I realized
that there's not enough room for my inserts. Is there any chance to change
it's datatype to tinytext without making an entirely new database and
inserting data from the old one to it?
-Jarkko
___
On Sat, Mar 09, 2002 at 01:21:44PM -0700, Sasha Pachev wrote:
> On Saturday 09 March 2002 12:46 pm, Jeremy Zawodny wrote:
> > That reminds me of an easy feature request. ?Would it be possible to
> > have a slave-auto-start=no option (or something like that) in my.cnf?
> > There have been cases whe
Hi Theresa,
Your MySQL installation is most likely on the same box. Have you tried
"localhost" as the hostname in the connection string?
If that doesn't work, do you have shell access to this machine? If so, you
can also look inside the phpMyAdmin directory for a file called
config.inc.php. This
OK..here is my intention and my dilemma.
I work with a new not-for-profit organization and I am creating a database
for contact information. I would like this to be a dynamic DB in that it is
available to the rest of the board members so they may search and view info
on various types of contacts
On Saturday 09 March 2002 12:46 pm, Jeremy Zawodny wrote:
> That reminds me of an easy feature request. ?Would it be possible to
> have a slave-auto-start=no option (or something like that) in my.cnf?
> There have been cases when I want to start a server but do not want
> replication to start on i
Note: I am temporarily unsubscribed from this list, so please Cc me at
[EMAIL PROTECTED] if you reply to this message.
Moodss (a modular monitoring application, graphical and daemon) fully
supports the MySQL database and great efforts are made in collaboration
with the MySQL AB developer Sinisa M
On Sat, 2002-03-09 at 13:13, James Cox wrote:
> Matt,
>
> Are you suggesting development of a wrapper around MySQL to convert XML to
> SQL and back, so that you would have a pseudo XML front end to mysqld?
James,
Well 'wrapper' and 'pseudo XML front end' are kind of nebulous terms and
phrases.
On Sat, Mar 09, 2002 at 12:31:20PM -0700, Sasha Pachev wrote:
>
> Jeremy:
>
> I think I now understand what happened, or at least I have a
> pausilble theory that explains what I see in the logs.
>
> When I had you kill the broken mysqld last time it went down in the
> middle of updating db3-re
On Thursday 07 March 2002 10:48 pm, Jeremy Zawodny wrote:
> The 4.0.x slave I had just rebuilt the other day died about 40 minutes
> ago and produced a core file each time. ?It got caught in the cycle of
> "core dump, restart, core dump, restart..."
Jeremy:
I think I now understand what happened
Matt,
Are you suggesting development of a wrapper around MySQL to convert XML to
SQL and back, so that you would have a pseudo XML front end to mysqld?
James
> -Original Message-
> From: Matt Wagner [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, March 09, 2002 7:07 PM
> To: [EMAIL PROTECT
On Sat, 2002-03-09 at 11:52, Jeremy Zawodny wrote:
> On Sat, Mar 09, 2002 at 05:37:28PM -, James Cox wrote:
> > Anyhow,
> >
> > Mysql can return data in XML.
>
> The client can, but not the server, right?
Jeremy,
Correct, currently only the 'mysql' (-X option in MySQL 4.x) and
'mysqldu
At 16:39 +0200 3/9/02, [EMAIL PROTECTED] wrote:
>Hello.
>
>How to load binary data into a table using
>Perl DBI module (the data is uploaded from a HTML
>form)?
Same way you load any other kind of data. Use placeholders or the quote()
function.
>
>I failed to find any information on MySQL site
This 'developer' is feeding you some BS.
MySQL handles XML data as well as any other type of data. The functioanlity
of a particular database has a lot to do with the programmer who designs the
schema. Maybe this 'developer' doesn't know how to design an XML/MySQL
application ... but that doesn't
Frankly, it sounds like this guy understands neither XML nor relational
databases.
XML is a general-purpose structured data format.
The term "relational database" also connotes a way of storing data, but is
usually used to refer more to the way the data is organized and efficient
ways for accessin
Well, I assume the server can do it too - - i haven't checked the C api
lately on that.
James
> -Original Message-
> From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, March 09, 2002 5:52 PM
> To: James Cox
> Cc: [EMAIL PROTECTED]; Javier Gonzalo Gloria Medina
> Subject: R
You can't log as root because a password has been set. You need to log like
this
# mysql -u root -p
It will then ask you for a password
If you ever have to log onto another box use a -h hostname.
| Chuck Payne |
| Magi Design and Support |
| www.
Can someone help and tell how can i fix this error .
Warning: MySQL Connection Failed: Access denied for user: 'root@localhost'
(Using password: YES)
Thanks .
Carlos Arnt .
--
Use o melhor sistema de busca da Internet
Radar UOL - http://www.radaruol.c
Hi!
On Feb 19, Alexander Belyaev wrote:
>
> Hello,
>
> Sergey, thanks for the patch, I applied it for 4.0.1 and seems like
> mentioned bug closed.
>
> But I found new bug :)
>
> Strange, but the query WORKS AS EXPECTED without fulltext index!
>
> The results for 4.0.1 with latest fulltext p
On Sat, Mar 09, 2002 at 05:37:28PM -, James Cox wrote:
> Anyhow,
>
> Mysql can return data in XML.
The client can, but not the server, right?
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQ
Sasha,
Running the latest binary I just built, I had a single core dump and
auto-restart early this morning. Here's the backtrace:
---snip---
Core was generated by `mysqld'.
Program terminated with signal 6, Abort trap.
Reading symbols from /usr/lib/libz.so.2...done.
Reading symbols from /usr/
Anyhow,
Mysql can return data in XML.
> -Original Message-
> From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, March 09, 2002 5:29 PM
> To: Javier Gonzalo Gloria Medina
> Cc: [EMAIL PROTECTED]
> Subject: Re: xml
>
>
> On Sat, Mar 09, 2002 at 09:21:35AM -0800, Javier G
On Sat, Mar 09, 2002 at 09:21:35AM -0800, Javier Gonzalo Gloria Medina wrote:
> hi everybody:
>
> i was talking with a developer and he told the next
> thing:
>
> "if you have a database and you need to do joins to
> make your quaries between tables... your database and
> tables are not full f
hi everybody:
i was talking with a developer and he told the next
thing:
"if you have a database and you need to do joins to
make your quaries between tables... your database and
tables are not full functional, your tables were
created under a bad configuration"
then he says.
"the best datab
Hi,
Try this request:
grant all on db.bsd
to shadowgrl@'%'
identified by "testing123"
with grant option;
Regards,
Sébastien
> -Message d'origine-
> De : Michael Sharp [mailto:[EMAIL PROTECTED]]
> Envoyé : samedi 9 mars 2002 13:08
> À : [EMAIL PROTECTED]
> Objet : adding a user to a dat
Hello.
How to load binary data into a table using
Perl DBI module (the data is uploaded from a HTML
form)?
I failed to find any information on MySQL site.
Thanks in advance.
-
Before posting, please check:
http://www.mysq
Jianping Zhu <[EMAIL PROTECTED]> wriites:
> mm.mysql.jdbc-1.2c.tar.gz
> mm.mysql-2.0.4-bin.jar
> Which of these two database driver for MySQL is better?
> Thanks
Neither? They're both pretty old. Why don't you check out MM.MySQL 2.0.11
from http://sourceforge.net/projects/mmmysql/
-Mark
>From my point of view, I can learn from anybody, and Lasso users will
>contribute knowledge to the group, which we should all welcome. So 'Welcome'
>Jim.
Thanks Peter. :-)
>A couple of points for Blue World
>If you want your company to be respected, show respect for others.
Though I can't spe
Gabriele Carioli writes:
> Hi!
>
> > Our (MySQL AB) recommendation is to NOT compile
> > *mysql* with RedHat's 2.96 compiler. Instead,
> > in the case of RedHat, you should use 2.91
> > EGCS or 2.95 GCC compilers.
>
> Your (MySQL AB) source rpm does not build at all with
> the egcs/gcc 2.91 comp
I'm using MySQL 3.23 on FreeBSD 4.5-STABLE, and I am kinda new to MySQL.
I created the database " bsd " as root. I need a remote user, connecting
from any IP and logging in with " shadowgrl " and giving the password "
testing123 " to have full access to the bsd database only.
After making the bs
Jiankang,
Friday, March 08, 2002, 10:28:49 PM, you wrote:
JZ> Every time I run safe_mysqld, I get the following
JZ> error message:
JZ> # ./safe_mysqld
JZ> chown: unknown user id mysql
JZ> Starting mysqld daemon with databases from
JZ> /usr/local/mysql/var
JZ> Killed
JZ> 020308 22:12:04 mysqld e
Chuck,
Friday, March 08, 2002, 5:56:59 PM, you wrote:
CR> Hi. We have Solaris 2.8 and just got Mysql 3.23. We installed the
CR> files and are now trying to run the mysql/configure or
CR> mysql/scripts/mysql_install_db scripts but I get an error
CR> "Command not found." I logged in as "chuck", the
zlab,
Saturday, March 09, 2002, 6:23:24 AM, you wrote:
zz> Hi,
zz> I¡¦m a new user of MySQL verison 4.01 and found that the following
zz> statement not working:
zz> CREATE TABLE test TYPE = HEAP SELECT * FROM customer
zz> If omit TYPE = HEAP, or using TYPE = INNOB or TYPE = MYISAM will
Felix,
Friday, March 08, 2002, 1:29:36 PM, you wrote:
FR> I could not find any documentation about the BETWEEN function. Am I just
FR> blind? Please point me to it. Or is it not stable yet? How does it
FR> perform in comparison to "field1 >= x AND field1 <= y"?
You can find description of this f
Hi
A few points
1. 1 (?)Spam, 40 people filling my in box with complaints about it. We get
very little Spam on this list, if you don't like it, bin it.
2. MySql users are diverse. We have php, perl, c++, Delphi, Access and VB
mentioned regularly. So why shouldn't we be interested in another
66 matches
Mail list logo
