At 10:23 PM -0700 5/10/01, Nathan Boley wrote:
>Hi, I was interested in implementing size limitations on specific databases.
>I've searched the mysql docs for an mention of quota support, but I am not
>able to find any. I found that by chown the individual database directories
>and their files an
Hi, I was interested in implementing size limitations on specific databases.
I've searched the mysql docs for an mention of quota support, but I am not
able to find any. I found that by chown the individual database directories
and their files and then chmod them to be world readable I can access
>Description:
Your tar binary distribution mysql-3.23.37-pc-linux-gnu-i686.tar.gz does not
work for compiling proftpd (unless and -lz is added in proftpd's Make.rules)
because of references to 'compress' and 'uncompress' in mysqlclient where
those functions aren't found. The same failure happens
At 10:31 AM +0800 5/11/01, Mark Lo wrote:
>Hi,
>
> I have make a my.cnf file in /etc and the permission is set to 644 and
>the ownership is set to root. When I try to restart MySQL. I got the
>following error.
>
>error: Found option without preceding group in config file: /etc/my.cnf at
>li
In the last episode (May 10), Eric J. Schwertfeger said:
> Also, my initial testing shows that INNOBASE tables are even faster
> than MyISAM, at least for insertions, though the same tupples in a
> similar table seem to take up more room. Aside from the restrictions
> mentioned in 8.7.4 of the re
Dear Johan,
I would really appreciate it if you can share it with us.
Best regards,
Allen Zhao
On Thursday, May 10, 2001, at 07:47 AM, Johan Andersson wrote:
> Hi,
>
> Recently I've mailed a question to the list about Oracle=>MySQL
> migration-HOWTO.
> I didn't get an
Hi,
I have make a my.cnf file in /etc and the permission is set to 644 and
the ownership is set to root. When I try to restart MySQL. I got the
following error.
error: Found option without preceding group in config file: /etc/my.cnf at
line: 1
Program aborted
Would you please tell me wha
> We have a database of size 10GB and its index is also
> almost of the same size. Now we want this database in MYSQL.
> Please let me know how we can slpit it across 3-4 hard
> disks.We are using Linux 6.2
Hi there,
My self I have a machine runnig RH Linux 6.0 with a 70Gb database.
And it works
I've never heard of Uniface but if you can connect through ODBC, you can use
MyODBC to connect to MySQL.
- Original Message -
From: "Baeumle Etienne" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 10, 2001 20:03
Subject: MySQL and Uniface 7.206
> Hello
>
> we have a web
> The tables are fine when opened on linux. Is there something called as
changing of ownership of tables in NT. I have used the standard binary
version for windows.
I haven't used the NT version but wouldn't the normal GRANT and REVOKE
statements fill your needs?
> 3.23.37.
>
> Is it possible
On Thu, 10 May 2001, Dan Nelson wrote:
> > The first two are as expected, the third isn't. However, this is
> > with a mysqld that was configured with --with-innobase. So why is
> > have_innodb=NO?
>
> The name of the option changed in 3.23.37. Use --with-innodb instead.
Never trust printed
Generally, mysql should work fine with any of the kernels you've mentioned.
Your problem may be the result of the latest changes to the 2.4 kernel
series. You should attempt to custom compile the newest 2.4.4-ac series
kernel (ac6 is the newest, i believe). 2.4.3 and below had issues with
rw_sem
I compiled and installed MySQL 3.22.32 on RadHat 7.0 and I am having some strange
behavior when it comes to double datatype fields. Please see the examples below. I
have the exact same version loaded on RedHat 6.2 and it works fine. What gives?
Here is the table and the data in it
mysql> SELE
Hmm, pretty interesting
> netstat -an | grep 3306
gives:
tcp0 0 0.0.0.0:33060.0.0.0:*
LISTEN
I guess this is because I am a DHCP client.
I tried again with the --bind-address option and it seems to work.
As you said, pretty simple, I must have done some
At 4:05 PM -0600 5/10/01, Jacob - amoc Special Projects wrote:
>Hello Group,
>
>This is an inquiry which might need to eventually be directed to more
>specific lists but I will start here. I am currently developing a shopping
>cart with PHP and MySQL and my client was wanting to integrate Listserv
Hello Group,
This is an inquiry which might need to eventually be directed to more
specific lists but I will start here. I am currently developing a shopping
cart with PHP and MySQL and my client was wanting to integrate Listserv (a
highend mailing list program) with the MySQL database to create
At 18:52 10-5-01 -0300, Gleidson Henriques wrote:
>Hello list,
>
> I want to install a mysql with a ftp server, is it possible ?!
If you mean you want to authenticate users with the userinfo from your
database.. sure www.proftpd.org might need so work from the developers..
Bye,
B.
-
Hello list,
I want to install a mysql with a ftp server, is it possible ?!
Thanks in Advance.
That SQL statement provided should work just fine without any escape
sequences (at least as far as MySQL is concerned). The semicolons (;)
should be treated as part of a literal string, and therefore, inserted
into the image_data table.
Perhaps you're running this script from some utility or som
Hmmm, my apologies all. I just retried the problem using the mysql command
line in place of the ODBC utility that I usually use and the string was
inserted just fine.
Thanks for the help
Dave
> -Original Message-
> From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 10
I'm doing an insert via a SQL script:
insert into image_data (title)
values ("“Blue Clearwing” (Dulcedo polita)");
The error returned is:
Error: (-1) You have an error in your SQL syntax near '"$#147' at line 1
State:42000,Native:1064,Origin:[TCX][MyODBC]
> -Original Message-
> From
On Thu, May 10, 2001 at 05:16:42PM -0400, Dave Emerson wrote:
> I'm trying to store strings the database that contain html character
> entities in them. It appears that the insert fails when it sees the
> semicolon that terminates the entity. I've tried escaping it with \
> but that doesn't wor
I opened a very large .sql file with pico and well it seems to have hung
up MySQL for some reason. If you type mysqladmin shutdown you just get a
blank response same as if you use any mysql command. I tried kill the
PID's but it won't kill them they just stay there. Even tried kill -9.
Any help ap
How are you inserting the strings (ie C, Perl, etc)?
What is the exact string you're tying to insert?
What is the exact error message returned?
On Thu, 10 May 2001, Dave Emerson wrote:
> I'm trying to store strings the database that contain html
> character entities in them.
> It appears that
I'm trying to store strings the database that contain html
character entities in them.
It appears that the insert fails when it sees the semicolon that
terminates
the entity. I've tried escaping it with \ but that doesn't work. What's
the proper way to escape a semicolon embedded in a string?
In the last episode (May 10), Eric J. Schwertfeger said:
> On Thu, 10 May 2001, Jeremy Zawodny wrote:
> >
> > What does "SHOW VARIABLES" say? There should be a have_innobase
> > record.
>
> Thank you, that is exactly the first step I was looking for!
> (confirmation one way or the other that I h
On Wed, May 09, 2001 at 03:32:50PM -0500, carlos ospina wrote:
>
> High Availability, that what meant,
>
> I already have LVS working for WEB with 2 servers , and i was
> thinking in put a round replication between them and use the virtaul
> IP address.
>
> Is there any better way to do that?
Y
for a long time we were running 3.23.x on a solaris 2.7 machine with 4
cpu's at 400mhz each and 3 gigs of ram. the latest release we made it up
to was 3.23.36. we get fairly decent traffic to our site it keeps the
database busy. we recently switched to redhat with 2 cpu's at 1ghz each
and 1.5 g
On Thu, 10 May 2001, Jeremy Zawodny wrote:
> On Thu, May 10, 2001 at 11:29:06AM -0700, Eric J. Schwertfeger wrote:
> >
> > I'm trying to get INNOBASE tables working with MySQL on FreeBSD and
> > I've run into something unusual.
> >
> > Basically, when I create a table with "type = innobase" the
On Thursday 10 May 2001 19:38, Peter Pentchev wrote:
> The MySQL root user, the one created as superuser, comes with the username
> 'root' :)
>
> Just start your MySQL server, and try:
>
> mysql -u root
>
> This shall bring you to the MySQL prompt, if you have not configured
> a password with mysq
I have such proble: I use MySQL and textual fields contain non-US characters (Latvian
have extended English caracters, such as āšķļ e.t.c - Baltic encoding) When I access
data thru ODBC connection and asks MsAccess sort textual field ascending or
descending, sorting is in wrong order.
Never I
On Thu, May 10, 2001 at 11:29:06AM -0700, Eric J. Schwertfeger wrote:
>
> I'm trying to get INNOBASE tables working with MySQL on FreeBSD and
> I've run into something unusual.
>
> Basically, when I create a table with "type = innobase" then do a
> stat on the table, it returns a table type of M
On Thu, May 10, 2001 at 03:52:02PM -0300, Trelio wrote:
>
> What are the license requirements in windows platform ? Everything
> that regards mysql on linux applies to mysql on windows ?
MySQL is licensed under the GPL. You may use it freely. The manual
describes the available support arrangemen
On Thu, May 10, 2001 at 04:11:33PM -0400, Iasen Hristov wrote:
>
> I am not able to make mysqld to bind to a TCP port. It works with
> UNIX sockets just fine, but not with TCP.
>
> Bellow you will see the output of the version command.
>
> I have Mandrake 7.2. First I tried with the installation
I am not able to make mysqld to bind to a TCP port. It works with UNIX
sockets just fine, but not with TCP.
Bellow you will see the output of the version command.
I have Mandrake 7.2. First I tried with the installation that came with
Mandrake (3.23.23). Then I installed the 3.23.37 version. Aga
I would like to use MySQL for a high-availability application (available
24 hours per day, 7 days per week) using replication to minimize down
times. The volume of transactions will be about one million per week.
Can anyone share experiences with me about high-availability
applications with
What are the license requirements
in windows platform ?
Everything that regards mysql on linux
applies to mysql on windows ?
thx
Tulio Relio
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]]
> Sent: jueves, 10 de mayo de 2001 6:00
> To: Christian Jaeger; David J. Potter; [EMAIL PROTECTED]
> Subject: Re: Having success with 20 million rows
>
>
> At 11:00 PM +0200 5/9/01, Christian Jaeger wrote:
> >Was the tab
I'm trying to get INNOBASE tables working with MySQL on FreeBSD and I've
run into something unusual.
Basically, when I create a table with "type = innobase" then do a stat on
the table, it returns a table type of MyISAM. I've verified that this is
what the table really is by looking for the app
Patrick--
yes, it might take hours, nothing wrong with your setup.
Vadim.
Patrick Goetz wrote:
>
> I recently installed MySQL 2.23.37 from the unstable Debian package on a
> dual-processor PII 350 w/ 128MB SDRAM running linux 2.4.2
>
> For fun (since I've never tried running any of the benchm
- Original Message -
From: <[EMAIL PROTECTED]>
To: "carlos ospina" <[EMAIL PROTECTED]>
Sent: Thursday, May 10, 2001 8:10 AM
Subject: Re: Mysql and High availability
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the fi
ok, what am I doing wrong here:
[alow@cs:~]$ maketest
g++ test.cc -I/usr/local/include/mysql++ -I/usr/local/include/mysql
-lsqlplus
/usr/include/g++-2/streambuf.h: In method `struct streampos
streambuf::pubseekof
f(streamoff, enum _seek_dir, int = 3)':
In file included from /usr/include/g++-2/
On Thu, May 10, 2001 at 10:16:33AM -0700, Simon Chan wrote:
> In 6.13 of the mysql manual (Setting up th initial Mysql Privileges), it mentions
>that "the Mysql
> root user is created as a superuser who can do anything. The Initial root password
>is empty, so
> anyone can connect as root withou
Hi,
Make sure that MySQL on your OS supports 5000 connections !
Check OS specific restrictions in MySQL documentation.
Regards
--
Joseph Bueno
NetClub/Trader.com
John Barton wrote:
>
> Try putting a line like the following in your my.cnf file:
> This has always worked for me, including 3.23.37
At 10:16 AM -0700 5/10/01, Simon Chan wrote:
>In 6.13 of the mysql manual (Setting up th initial Mysql
>Privileges), it mentions that "the Mysql
>root user is created as a superuser who can do anything. The
>Initial root password is empty, so
>anyone can connect as root without a pasword and be
In 6.13 of the mysql manual (Setting up th initial Mysql Privileges), it mentions that
"the Mysql
root user is created as a superuser who can do anything. The Initial root password is
empty, so
anyone can connect as root without a pasword and be granted all privileges."
How is this mysql super
I recently installed MySQL 2.23.37 from the unstable Debian package on a
dual-processor PII 350 w/ 128MB SDRAM running linux 2.4.2
For fun (since I've never tried running any of the benchmarks) I compiled
sql-bench and executed run-all-tests as root (didn't feel like setting up
the required prem
There is a grammar error on the GUI page, just as an FYI.
http://www.mysql.com/downloads/gui-clients.html
MySQLGUI is the graphical sql client for MySQL developed by MySQL
AB.
This software is in beta testing. If you problems with it, please
mail to [EMAIL PROTECTED]
should be
MySQLGUI is the gra
At 5:49 PM +0100 5/10/01, VVM Ravikumar Sarma Chengalvala wrote:
>Can some one let me know all possible ways to provide
>escape characters in MYSQL inserts.
>
>I am using C API.
If you're asking how to escape special characters:
http://www.mysql.com/doc/m/y/mysql_escape_string.html
http://www.my
Try putting a line like the following in your my.cnf file:
This has always worked for me, including 3.23.37
set-variable = max_connections=
John Barton
Unix Systems Administrator
Primary Networks, Inc.
[EMAIL PROTECTED]
On Thu, 10 May 2001, Mark Lo (3) wrote:
> Hi,
>
> I would like to
Can some one let me know all possible ways to provide
escape characters in MYSQL inserts.
I am using C API.
Regards,
Ravi
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at h
At 9:08 AM -0700 5/10/01, Chris Nichols wrote:
>Can anyone help point me to a good resource for finding out if particular
>functions supported by MySQL are ANSI SQL standard functions or if they
>are MySQL specific? I'm particularly wondering about:
>
>concat()
>if()
>length()
http://www.mysql.
>Description:
Replication master updates it's binary log based on current database,
not on tables being updated. This leads to replication problems
if not all your databases on the server are replicated.
>How-To-Repeat:
Prerequisites:
Two databases created,
Can anyone help point me to a good resource for finding out if particular
functions supported by MySQL are ANSI SQL standard functions or if they
are MySQL specific? I'm particularly wondering about:
concat()
if()
length()
Thanks,
-Chris
---
[EMAIL PROTECTED]
At 10:37 AM -0400 5/10/01, Bernie Cosell wrote:
>On 10 May 2001, at 10:26, Scott Abbotts wrote:
>
>> I see most of you are experienced developers. Can someone point me in a
>> direction (tutorial..) to learn MySQL? ...
>
>I'm not sure there's a better place to go than Paul Dubois's book on
>MyS
At 11:18 AM + 5/10/01, Prachi Nadgouda wrote:
>The tables are fine when opened on linux. Is there something called
>as changing of ownership of tables in NT. I have used the standard
>binary version for windows.
I'm guessing from the preceding command and your original message below
that
At 5/10/01 10:37 AM, Bernie Cosell wrote:
>On 10 May 2001, at 10:26, Scott Abbotts wrote:
>
> > I see most of you are experienced developers. Can someone point me in a
> > direction (tutorial..) to learn MySQL? ...
>
>I'm not sure there's a better place to go than Paul Dubois's book on
>MySQL. I
It is a good book - I have a copy sitting open on the desk in front of me
right now. :)
However, IIRC devshed.com has some good introductory material.
Ciao,
Zak
- Original Message -
From: "Bernie Cosell" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 10, 2001 8:37 AM
this one's okay:
http://www.devshed.com/Server_Side/MySQL/Intro/
as well as various ones from here:
http://www.google.com/search?q=mysql+tutorial
-ravi.
-Original Message-
From: Scott Abbotts [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 10, 2001 10:27 AM
To: [EMAIL PROTECTED]
Subject:
On 10 May 2001, at 10:26, Scott Abbotts wrote:
> I see most of you are experienced developers. Can someone point me in a
> direction (tutorial..) to learn MySQL? ...
I'm not sure there's a better place to go than Paul Dubois's book on
MySQL. It's about $35 and more than worth every penny...
I see most of you are experienced developers. Can someone point me in a
direction (tutorial..) to learn MySQL? I've successfully set up phpMyAdmin
on my site, but I'm afraid I'm still lost..
-
Before posting, please check:
I have a problem using ucase function with russian letters - it's
not work correctly.
i set default-character-set=cp1251, and sorting procedures begin
to work correctly, but not ucase and lcase functions. the version
of the mysql and OS (windows 98 or Windows NT) does not have
I would be very intested in finding out more about the hardware being
used here, as well as load on the server (queries/sec, etc.), and maybe
the amount of data (Megabytes, Gigabytes, Terabytes). Twenty million
records is a lot but that number in itself may not give the application
the credit
Hi,
Recently I've mailed a question to the list about Oracle=>MySQL migration-HOWTO.
I didn't get any complete solutions for this, so now I've written a program in perl
that has
almost the same options / command line syntax as mysqldump.
It's named oracledump and dumps out information about eit
We have a large database with two tables of around 31.5 million rows each.
When I did an alter table, again to modify a column, it took 17 hours.
I noticed that the table was still readable and writes were blocked.
However, during the ALTER table MySQL repaired the table using a keysort.
This see
Hello
we have a webapplication written in Uniface 7.206. Until now we used Sybase
as RDBMS. I would like to test the application on the web with MySQL. Does
there exist any possibility to run our application on MySQL? Does there
exist a DB-driver for Uniface?
Any remarks about that will be appr
On 09-May-01 [EMAIL PROTECTED] wrote:
> Does anyone know how mysql behaves when a client CGI script quits? Does
> the SQL query march on through? I wondering if anyone knows of ways to
> protect against browser reloads and other forms of similar
> abuseespecially if the the sql query is ex
Hi,
I would like to set a higher values in max_connections for mysql.
I have tried to use the following command "mysqld --set-variables
max_connections=900 -u root -ppassword". Then, it shows that I have
successfully changed the variable of max_connections. But, when I check it
with the c
The tables are fine when opened on linux. Is there something called as changing of
ownership of tables in NT. I have used the standard binary version for windows.
3.23.37.
Is it possible that some of the files can be corrupt? When I write the query as
select count(*) from table_name I get th
On 10-May-01 AVDHUT SHEDGE wrote:
> in SQL query can we use sysdate to get System date like Oracle
mysql> select SYSDATE();
+-+
| SYSDATE() |
+-+
| 2001-05-10 05:46:28 |
+-+
Does Orkcle have manuals ?
Regards,
--
Don Read
On 09-May-01 Darla Baker wrote:
> I have a text file which is extracted from a non-sql
> database each night and then a cron sql script runs to
> insert the text data into the mysql database tables.
>
> My problem is that the date data in the text file is
> formatted incosistently (12/31/00 or 1
Dear Y'all -
Paul DuBois writes:
> At 9:53 AM -0400 5/9/01, Brian Cuttler wrote:
> >
> >The developers that want to use the database would like ownership
> >of the files and daemon so that they can modify and restart at will.
>
> Tell them to pick one of their accounts to be used for run
>Description:
Unpackaged 3.23.37 and ran configure:
...
checking size of char... 0
configure: error: No size for char type.
A likely cause for this could be that there isn't any
static libraries installed. You can verify this by checking if you have libm.a
in /lib, /usr/lib or some other standard
On Thu, May 10, 2001 at 10:24:11AM -, AVDHUT SHEDGE wrote:
> in SQL query can we use sysdate to get System date like Oracle
What's wrong with NOW(), as seen in the manual?
Reference >> Functions >> Date and Time Functions
Next time, take a look there :)
G'luck,
Peter
--
"yields falsehood,
in SQL query can we use sysdate to get System date like Oracle
_
Chat with your friends as soon as they come online. Get Rediff Bol at
http://bol.rediff.com
-
Before postin
On Thu, 10 May 2001 09:43:10 +0200
"indrek siitan" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> > Tried doing isamchk on the .ISM files and got that following error
> > The Exception Integer division by zero
> > (0xc094) occured in the application at the location 0x0040224a.
>
> getting such errors
Hello
We have a database of size 10GB and its index is also
almost of the same size. Now we want this database in MYSQL.
Please let me know how we can slpit it across 3-4 hard
disks.We are using Linux 6.2
Kind Regards
Pawan
---
Can you please elaborate on how can I correct this problem. I have windows nt on my
machine. OR is there and problem with the installation of my sql
bye
p
- Original Message --
"indrek siitan" <[EMAIL PROTECTED]> wrote:
To:"Prachi Nadgouda" <[EMAIL PROTECTED]>, <[EMAIL
Joe:
AFAIR, as an ex NT4 sysadmin, system error 5 is access denied - you have a
permissions problem somewhere.
On NT4 these can be a swine to solve. Check out your NT system error logs
as a starting point.
HTH.
David
>By the way, I once first tried to set up the slave on a NT machine. But f
Hi,
> we have to migrate a database from Lotus Domino (.nsf format)
> to MySQL. Is there anybody out there having had experience on
> this kind of job? Let we know, we are a bit .. desperate ...
the easiest way is to try to make SQL dumps from your current
database (Domino) and then work around
Hi,
> Tried doing isamchk on the .ISM files and got that following error
> The Exception Integer division by zero
> (0xc094) occured in the application at the location 0x0040224a.
getting such errors usually means you've got hardware (bad memory?)
or some serious software installation probl
Hya All,
we have to migrate a database from Lotus Domino (.nsf format) to MySQL.
Is there anybody out there having had experience on this kind of job?
Let we know, we are a bit .. desperate ...
--
Dr. Corrado Topi
Responsabile Sezione Progetti Speciali
Elbi International S.p.A. - Gruppo Bitro
Tried doing isamchk on the .ISM files and got that following error
The Exception Integer division by zero
(0xc094) occured in the application at the location 0x0040224a.
thanks
- Original Message --
"indrek siitan" <[EMAIL PROTECTED]> wrote:
To:"Prachi Nadgouda" <[E
Hi,
> I have a project which need to synch our mysql db with external
> Oracle DB.
> It requires that anytime DB admin modifies their Oracle DB, the
> change should be synched remotely with our DB in mysql. To make
> thing easy, we could use the same table structure on both end.
just a quick i
84 matches
Mail list logo