This is where we find several problems. The first one, is the price for
such equipment here in Argentina (more than double in US Dollars), which
is the main reason we try to get around with software.
The second issue, is that the local DB may have to work synchronized
with an on-line one in the n
Hey Everyone,
I have a strange problem.
I have been working with mysql and dbi most of the day, as I am sure
some of you know ;p
I was able to connect to the database using the DBI module. When I run
the script on my command line it runs fine, and I get the data that I
asked for. But. when I
Hi,
mysql> select version();
+-+
| version() |
+-+
| 3.23.51-max-log |
+-+
1 row in set (0.00 sec)
Yesterday I sent a message to the list regarding MySql/BDB support for
recovery procedures.
I could not make sense of the binary log and I co
>Description:
MySQLd 3.23.51 receives a SIGSEGV (aborting the backtrace with an
"fp=(nil)") connecting via TCP/IP when compiled with "--with-libwrap".
Connecting via a Unix socket works. MySQLd 3.23.49 and below are not
affected.
I've spent the entire day compiling with various options, and on
I think you're confused. the only WinGate I know of is an alternative
to windows' internet connection sharing. It's not a web server.
and what's a T connection?
On Thu, 20 Jun 2002 19:26:37 -0300, César Aracena wrote:
>Hello all,
>
>I have this client who has a T connection and would like to run
Hi,
I am currently running MySQL-3.23.51 on RedHat Linux
7.2 and would like to gradually switch to
MySQL-Max-3.23.51. My question is, would I be able to
install them both if I only run one at a time?
I am really looking forward to trying out transations
and foreign keys using InnoDB and am in
Hello to everyone!
I'm using mysql-3.23.41 and initially able to use it without any problem. However,
after I issued this command, "grant all privileges on *.* to root@localhost
identified by 'mypassword' with grant option; ", mysql will simply display the message
"Ignoring query to other da
At 19:36 -0700 6/20/02, Emma Grant wrote:
>Hi,
>
>Thanks for your help.
>
>I tried to run both the commands that you gave me on the command line. I
>got the following message back from the shell:
>
>Superuser must not run /usr/bin/perldoc without security audit and taint
>checks.
>
>Do you know wh
Hi,
Thanks for your help.
I tried to run both the commands that you gave me on the command line. I
got the following message back from the shell:
Superuser must not run /usr/bin/perldoc without security audit and taint
checks.
Do you know what this means?
Thanks,
Emma
-Original Mes
I'm very new to mysql. Just learning. I'm trying to correctly set up the
permissions for the files under the mysql/ directory. I've included a
list. I would appreciate it if some one could look over it and recommend
changes. Thank you.
Michael Sellers
Hello.
On Thu 2002-06-20 at 18:29:35 -0700, [EMAIL PROTECTED] wrote:
> Does mounting ext3 MySQL data directories with the noatime option improve
> performance? I ran across an article that said it really helped with ext2
> and was wondering if the same benefits applied with ext3.
Yes, of course.
At 18:51 -0700 6/20/02, Emma Grant wrote:
>Hey all,
>
>I have decided to go with CGI for my programming language. Reason being
>is that I know it a tiny bit better then I do PHP.
>
>Does anyone know a command line command (?) to find out if I have a DBI
>for mysql support installed?
% perldoc DBI
Hey all,
I have decided to go with CGI for my programming language. Reason being
is that I know it a tiny bit better then I do PHP.
Does anyone know a command line command (?) to find out if I have a DBI
for mysql support installed?
I am attempting to connect to a mysql database using a quic
Does mounting ext3 MySQL data directories with the noatime option improve
performance? I ran across an article that said it really helped with ext2
and was wondering if the same benefits applied with ext3.
Thanks,
--jeff
-
Bef
Hi.
On Thu 2002-06-20 at 14:50:07 -0700, [EMAIL PROTECTED] wrote:
> Friends,
>
> I am designing a MySql DB schema that will use foreign
> keys similar to:
>
> create table orders(id int auto_increment primary key,
> amount double(7,2) );
>
> create table orderItems(id int, item char(20), price
Hi.
On Thu 2002-06-20 at 17:24:53 +0100, [EMAIL PROTECTED] wrote:
> To list mysql list administrator:
> Why do I receive this auto responder after posting to this list
I am not a list administrator, but know the answer anyhow. ;-)
You get this mail, because someone with a very poor auto-respond
> -Original Message-
> From: Gerald R. Jensen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, June 20, 2002 7:10 PM
> To: Emma Grant; [EMAIL PROTECTED]
> Subject: Re: Using web forms and webpages to access/view mysql data
>
> It really depends on the language you wish to use ... could be Pe
Emma:
It really depends on the language you wish to use ... could be Perl, ASP,
PHP, etc.
If you choose PHP, check out http://www.phpbeginner.com. You can obtain PHP
(and find other useful links) from http://www.php.net
Gerald Jensen
- Original Message -
From: "Emma Grant" <[EMAIL PROT
Hi all,
I successfully created and added data to my database!
Does anyone know any good websites where I can learn to insert, update
data using a web form and CGI?
How does mysql perform when displaying images (jpg, gif) on a web page,
that have been stored as BLOB file?
I am new to this stuf
On Thu, Jun 20, 2002 at 07:26:37PM -0300, César Aracena wrote:
> Hello all,
>
> I have this client who has a T connection and would like to run a PHP /
> MySQL based program in local mode, but also be able to make the data
> available from the web but hosted in a remote server
kinda strange u
>
Hola Javier,
It is difficult to tell because you did not include
the table structures, relationships, indices, etc.
But... at a first glance we is killing you query
anyways is this:
> FROM
> Bill b, Hour h
The poor db engine is probably creating a huge
temporary table with all
In MySQL 4.0.x:
DELETE order_details FROM order_details LEFT OUTER JOIN order_header ON
(order_details.order_number = order_header.order_number) WHERE
order_header.order_number IS NULL;
-JF
> -Original Message-
> From: Gurhan Ozen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, June 20, 200
Hi,
I want to migrate data from SQL Server 2000 to Mysql.
My problem is to migrate big fields which had type varchar(7900) or so
I tried using Text datatype of mysql, then I cant migrate data in that
field
I used command
LOAD DATA INFILE "c:/mysql/roma/mailmessagetext_table.txt" INTO TABLE
mai
The problem is that you don't have permissions to create the database test2.
Therefore you can't grant yourself any permissions on it becuase it does not
exist yet.
Have you mysql administrator give you permission to create databases or have
him/her create it for you and give you access to it.
=
On Thu, 20 Jun 2002, Flavio Reis wrote:
> Hi Galen!
> The problem is that command act on client, I need a command to act on server
> (mysqld)!
> Thanks
> []s
> Flavio
>
select_limit is a client variable, not a server variable. A second look at the
documentation suggests adding the line "set-va
Friends,
I am designing a MySql DB schema that will use foreign
keys similar to:
create table orders(id int auto_increment primary key,
amount double(7,2) );
create table orderItems(id int, item char(20), price
double(5,2), quantity int, key(id), foreign key id
references orders (id));
I am cu
> -Original Message-
> From: Joshua J.Kugler [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, June 20, 2002 4:30 PM
> To: Kiss Dániel; [EMAIL PROTECTED]
> Subject: Re: MD5
>
> If you are running Linix, at the prompt type:
>
> md5sum filename
>
> I'm sure you can get md5sum for other Unices as
Short answer:
You don't. That's not the way SQL databases work. When you hear of 'row
level locking' it means something different than you are used to if you are
coming from Access/Foxpro.
If you are using InnoDB tables then you can:
BEGIN TRANS
statement
statement
statement
COMMIT or ROLL
Hi, I am just starting out with mysql.
MySQL allows anon access so I don't have to log on to the sql just the
linu server.
I am trying to create a test database 'test2'. I am logged on as my user
'emil' (not root) on a test linux server. When I go to create the
database:
mySQL> CREATE DATAB
If you are running Linix, at the prompt type:
md5sum filename
I'm sure you can get md5sum for other Unices as well.
j- k-
On Thursday 20 June 2002 13:00, Kiss Dániel wrote:
> Hi everyone,
>
> Can anyone tell me how to create an MD5 checksum on a file.
> I tried to do this by using the
Hi!
- Original Message -
From: "Galen Wright-Watson" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, June 20, 2002 11:32 PM
Subject: Re: locking on row level ...
>
> On Wed, 19 Jun 2002, Silmara Cristina Basso wrote:
>
> > I'm newbie MySQL and I'm using MySQL-max
Hi Galen!
The problem is that command act on client, I need a command to act on server
(mysqld)!
Thanks
[]s
Flavio
-Mensagem original-
De: Galen Wright-Watson [mailto:[EMAIL PROTECTED]]
Enviada em: quinta-feira, 20 de junho de 2002 18:18
Para: Flavio Reis
Cc: [EMAIL PROTECTED]
Assunto: Re
On Thu, 20 Jun 2002, Flavio Reis wrote:
> Hi.
> I have an urgent question:
> How can I set the variable sql_select_limit as a global variable, which
> everytime that I open the MySQL it's set to the value that I determinated. I
> want to know how set this variable in the mysql.conf (where and h
Hi everyone,
Can anyone tell me how to create an MD5 checksum on a file.
I tried to do this by using the MySQL MD5 function, but it does not work on
too big files (above 650MB), even if I set max_allow_packet size very big.
Is there any small program to do this, anyway?
Thx
Daniel
-
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Morris Ford wrote:
| Mark,
| I verified that I am using the latest version. I
| have written a small test java program using jdbc
| to test updating through a resultset and whenever
| I use resultSet.updateString(x, y), I get an
| exception that
On Thu, 20 Jun 2002, Seth Yount wrote:
> Hello experts
I'm glad you think so highly of us.
>
>I am trying to decide which would be the most efficient way of
> retrieving data, Subselects (nested queries?) or Temporary Tables?
>
> Does MySQL even support these yet?
MySQL supports tempo
On Thu, 20 Jun 2002, Javier Campoamor wrote:
> Hi,
>
> I have a problem with the next query because it's too slow (>10 seconds) and
> I need to do 10 queries like this one to show a page.
>
>
>
> SELECT
> h.Hour, count(c.Amount) As NumberOfCalls, sum(c.Amount) As Amount
>
On Wed, 19 Jun 2002, Silmara Cristina Basso wrote:
> I'm newbie MySQL and I'm using MySQL-max 4.0.1(Innodb), with one application
> developed in Delphi and connect through MyODBC. The question is ...
> How can i do to lock one row so that it is editing in the application?
>
>
The impression I g
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Robert Kutter wrote:
| I have a pre-compiled ODBC program that creates tables and expects them to
| be transaction-safe. I have set up the mysql-max server to support InnoDB
| tables. However, since the program knows nothing about InnoDB tables, it
i asked the same very question just yesterday
& heres the reply i got for it ... i hope it helps u too
good luck ...
toby
Not natively (i.e. you can't sort on a Unicode field, for example), but
you can sti
Hello
I have a system where users are able to buy tickets to shows etc.
Right now I use the MyISAM as tabletype but I would like to try InnoDB to
make safe transactions. For the moment I use a TABLE LOCK to make sure that
the same ticket isn't sold twise.
One of the table consists on these 3 f
On 20 Jun 2002, at 11:35, Richard DeWath wrote:
> Just a thought on something I was reading with temp tables:
>
> 1. extract the records you want to change the date on from your existing
> table to a temp table.
> 2. update the date in the temp table
> 3. insert the "new" records back into t
Yes it is..
For a list of reserved words, see:
http://www.mysql.com/doc/R/e/Reserved_words.html
Gurhan
- Original Message -
From: "Peter Lovatt" <[EMAIL PROTECTED]>
To: "Me" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, June 20, 2002 2:29 PM
Subject: RE: Creation query problem!
No problem
I have a mysql server sited 150 miles from the php server (more by accident
than design, but it works day in day out)
Just set the connection parameter with the IP of the Mysql server and it
works. php doesn't know or care whether mysql is on the same machine or one
the other side of
Which driver are you using? I use
mm.mysql-2.0.4-bin.jar
Which IDE are you using? If you are using JBuilder 5,
you have to go to required library and add one
pointing to that file. If you are building a jar file
from your classes, you have to make sure that you tell
the library to include this JD
Yes...
You can just use \' to denote single quotes..
See: http://www.mysql.com/doc/S/t/String_syntax.html
Gurhan
- Original Message -
From: "Theodore Morse" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 20, 2002 11:48 AM
Subject: escape characters
> Hello everyone!
>
Hi.
I have an urgent question:
How can I set the variable sql_select_limit as a global variable, which
everytime that I open the MySQL it's set to the value that I determinated. I
want to know how set this variable in the mysql.conf (where and how), not
inside the BD!
Thank you!!!
Flávio
--
Just a thought on something I was reading with temp tables:
1. extract the records you want to change the date on from your existing
table to a temp table.
2. update the date in the temp table
3. insert the "new" records back into the original table.
This avoids the csv extract and changing
is read a reserved word?
---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
tel. 0121-242-1473
---
> -Original M
Take a look at:
http://www.mysql.com/doc/T/O/TODO.html and
http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html
You can do what you want to do easily by using an API (PHP, Perl, etc.) Is
it possible for you to use an external program, or does it have to be SQL
only?
Gurhan
- Original Me
I have a question to which I'm pretty sure the answer will be "no", but
I would like to hope I'm wrong...
I've developed a very simple Content Management tool--called
"Europa"--that even retarded monkeys can use to change/update text in
their web site. It's web-based, user-authenticated (sessi
I have a pre-compiled ODBC program that creates tables and expects them to
be transaction-safe. I have set up the mysql-max server to support InnoDB
tables. However, since the program knows nothing about InnoDB tables, it
creates normal tables and fails when it attempts a rollback. I can fix th
I got caught this morning, now it's your turn. "read" is a reserved word in
MySQL
-Original Message-
From: Me [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 20, 2002 12:59 PM
To: [EMAIL PROTECTED]
Subject: Creation query problem!!
Hello, will someone please point out what I am missing
Hello, will someone please point out what I am missing
here for these creation query, one uses backquotes,
while the other does not, for some reason, the one
without back quotes errors!! What am i missing??
Is there a reserved word I am missing??
MySQL 3.23.41
CREATE TABLE email (
emailid int(
perror 12
Error code 12: Cannot allocate memory.
Either :
1. Add memory ( good )
2. Add swap ( Not so good )
3. Tune for less memory usage.
David BORDAS wrote:
>Hi list,
>
>just have this when connecting to my mysql dedicated server :(
>The server is like this :
>bi PIII 1 Ghz
>1Go of ram
>Ra
Hi.
On Wed 2002-06-19 at 20:03:32 -0600, [EMAIL PROTECTED] wrote:
[...]
> But when I run 20 million rows into the dataset, it really slows down.
> (pretend the commas aren't there)
> SELECT a FROM b LIMIT 20,000,000, 1,000,000
>
> Why would it slow down? We're dealing with a fixed-length table
agreed...
-Original Message-
From: Gelu Gogancea [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 20, 2002 12:06 PM
To: Nilesh Shah; [EMAIL PROTECTED]
Subject: Re: Separate List For administration
..Subscribe
- Original Message -
From: "Nilesh Shah" <[EMAIL PROTECTED]>
To
Hi list,
just have this when connecting to my mysql dedicated server :(
The server is like this :
bi PIII 1 Ghz
1Go of ram
Raid 5 scsi hdds
Here is a tail of the error log :
020619 08:03:09 mysqld started
/usr/local/mysql/bin/mysqld: ready for connections
The system don't swap.
Using Linux 2.4
On Wed, Jun 19, 2002 at 04:27:59PM -0400, Nilesh Shah wrote:
> MySQL Team,
>
> Can we have separate list for MySQL administration and replication?.
You can start any mailing you'd like; no one's stopping you.
> I am sure there are lots of people here are only interested in Advance
> things in
Can anyone help me with monitoring locks?
mysql, sql, query
___
Alvaro Online Mail (c) 2001
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.my
To list mysql list administrator:
Why do I receive this auto responder after posting to this list
-- start
We acknowledge with thanks your email and thanking you once again in showing
your interest with our organization.
Our HRD Team will get back to you as soon as possible.
Best Regards
Te
At 09:03 PM 6/19/2002, you wrote:
>I am using MySQL 3.23.51 on Linux. I have a fixed-length table with 45
>million rows. It appears MySQL has an efficiency issue with the LIMIT
>command. When I run SELECT a FROM b LIMIT 0, 100 <-- that's one
>million
>The query finishes almost immediately
> I have a problem with the installation of the JDBC driver for Mysql.
> I have Windows XP and Java2 SDK 1.4.01
> I tried to install the JDBC driver org.gjt.mm.mysql.Driver but every time
I
> try to connect to my database, I get a ClassNotFoundException:
> org.gjt.mm.mysql.Driver error, although
..Subscribe
- Original Message -
From: "Nilesh Shah" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 19, 2002 11:27 PM
Subject: Separate List For administration
MySQL Team,
Can we have separate list for MySQL administration and replication?.
I am sure there a
Oladapo,
Following Rafal's suggestion, I've tried this and it worked like a charm:
DELETE Customers, orderdetails, orders FROM
Customers, orderdetails, orders
WHERE Customers.customerid =20 AND
orders.CustomerID =20 and
orderdetails.orderid=orders.OrderId;
Thank you
- Original Message
Hello everyone!
I have an SQL insert statement that contains "'" symbols in it, however
as I use the "'" symbol to denote the differences between columns in the
VALUES(...) part, I was wondering if there was another way of doing it
so I could include more characters like "'" in the statment, a s
I think you have to specify the join from the customers table to the other
tables ..
-Original Message-
From: Anibal Cascais Santos [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 20, 2002 3:38 PM
To: [EMAIL PROTECTED]
Subject: multi-table delete
Hi,
I'm rather new to mySQL, so maybe
67 matches
Mail list logo
