mark,
you need to actually write the code somehow in frontpage. i've not dealt
w/ frontpage in a LONG time (mainly cos i can't stand it, but that's
personal opinion so i'll refrain from commenting) ... but i believe there
is a way you can write raw html or php code in there somewhere. that part
Is this possible with 2.0 version (type 4 I think) MM driver found on
www.gjt.org? Also how do the file reading privileges for this work because
I tried doing it and it gave me an authorization error even though my mysql
user has FILE on it's privileges. Also, the file to read is chmod 774, s
Is the filter no longer working?
PS database
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL P
On Wed, Aug 01, 2001 at 10:46:39PM -0500, Chris Hilbert wrote:
>
> I noticed an issue with MySQL v3.23.40 on my Linux box where after a
> random amount of time (usually over an hour) MySQL runs a hell of a
> lot of threads for no apparent reason. I watched it when i ran
> mysqladmin -uroot -i 5 s
Hello,
I am creating a web based table that when users request or want
information they list the information in a form. This works great but
the problem I am having is that I cannot link MySQL table with the form.
I am using FrontPage 2000 and the only tables that it wants to create
are result t
Hi !
Check the following link and see whether it helps you.
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:80405:200107:lajclcaepgpafkcfp
gpm
Regards
venu
--
For technical support contracts, go to https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Venu <[EMAIL
Can any one help me with this mysql error.
"MySQL dead but subsys locked" I goofed in setting up the root user and tried a
couple of not too bright things. Now I cannot even get MySQL started.
reply to [EMAIL PROTECTED]
Thank you
Doug
*
I noticed an issue with MySQL v3.23.40 on my Linux box where after a
random amount of time (usually over an hour) MySQL runs a hell of a lot
of threads for no apparent reason. I watched it when i ran mysqladmin
-uroot -i 5 status as it went from 1 or 2 threads to 10, 20, 40, 50, 60,
70...(and had
-
This ad is being sent in compliance with Senate bill 1618, Title
3, section 301.
Here is a more detailed version of the legal notice above:
This message is sent in compliance of the new e-mail bill:
SECTION 301. Per Section 301,
On 8/1/01 4:49 PM, "Silver Fox" <[EMAIL PROTECTED]> wrote:
> Hello, everyone,
>
> I'm Tony. I'm new to this mailing list and I have a question. I'm
> currently running MySQL and Apache webserver. My partner needs to connect
> to my MySQL database using JDBC to input data. But every time he t
I have five tables. Each has a primary key on the field Number.
I would like to determine how many tables -- just the count -- that any
given $Number populates.
Every $Number will populate at least two tables, some possibly all five.
I just want a count(*)
I appreciate the advice.
Robert
-
Hi,
I installed a RH 7.1, and I installed all the packages for
apache, php and mysql. I don't know how to check if mysql
server is running. On my machine cannot connect to mysql
server.
Thanks in advance for all advices if can help me out!
Regards,
Alex shi
Garth:
I would go for the current version (3.23.39a).
The current version went on the stable list a long time ago, and has a
boat-load of function/feature improvements that either did not exist in
3.22.xx or were not fine-tuned to the extent they are in the current stuff.
Gerald Jensen
- O
Garth:
I would go for the current version (3.23.39a).
The current version went on the stable list a long time ago, and has a
boat-load of function/featur eimprovements that either did not exist in
3.22.xx or were not fine-tuned to the extent they are in the current stuff.
Gerald Jensen
- O
Garth:
I would go for the current version (3.23.39a).
The current version went on the stable list a long time ago, and has a
boat-load of function/featur eimprovements that either did not exist in
3.22.xx or were not fine-tuned to the extent they are in the current stuff.
Gerald Jensen
- O
Garth:
I would go for the current version (3.23.39a).
The current version went on the stable list a long time ago, and has a
boat-load of function/featur eimprovements that either did not exist in
3.22.xx or were not fine-tuned to the extent they are in the current stuff.
Gerald Jensen
- O
Hello, everyone,
I'm Tony. I'm new to this mailing list and I have a question. I'm
currently running MySQL and Apache webserver. My partner needs to connect
to my MySQL database using JDBC to input data. But every time he tries to
do that, it tells him "access denied for [EMAIL PROTECTED]"
Hello,
I can't help you, I just wanted to register the same problem to
help you someone to help us!
On Tue, 31 Jul 2001, Peter Au Yeung wrote:
> I got core dump on mysql which broke my sql connection or say mysqld keep restarting
>
> anyone got the same problem?
>
> Peter Au
Paul DeBois book knows the answer if you have other VARCHAR fields in the
table:
...you need to change all the columns (of type VARCHAR) at once in the same
alter table statement.The reason is that if you change a single column
at a time, MySQL notices that the table still contains variable-l
>Your message cannot be posted because it appears to be either spam or
>simply off topic to our filter. To bypass the filter you must include
>one of the following words in your message:
>
>database,sql,query,table
>
>If you just reply to this message, and include the entire text of it in the
>rep
When submitting a form to insert/replace data into my database with
values loaded from the previos page I show that everything is entered
except for these fields: Why? I am using version mysql-3.23.32-1.7
| Field| Type | Null | Key | Default |
Extra |
rating
It might depend on the other columns in your table definition. Have you
looked at the Silent Column Specification Changes?
http://www.mysql.com/doc/S/i/Silent_column_changes.html
If you have ANY varchar() columns, all char columns greater than three
characters are changed to varchar(). Perhaps
I upgraded my running 3.23.39 to 3.23.40 in hopes of taking advantage of the
replication bug fix, however, once I upgraded, I found that the master
wouldn't run.
My my.cnf read
log-bin=/usr/local/mysql-3.23.40/bin-log/db1-bin
and I get the error message
010801 10:49:27 Could not use /usr/loca
On Tuesday, July 31, 2001, at 06:54 AM, Michael Widenius wrote:
> The reason for is that the we don't have access to a new Mac OS X
> server to building binaries. The machine we are now using is owned by
> a MySQL user that has kindly given us remote access to it to build
> MySQL distributions
I use urSQL, available from http://www.urbanresearch.com/ursql, to connect
to remote MySQL servers from my Windows box...
There is also the mysqlgui client and many more available from the MySQL
website (www.mysql.com).
On Wed, 1 Aug 2001, Faiz Khan wrote:
> Hi there,
>
> I am having problem
Ken,
Thanks as always for your very helpful support. I did a 'truss -p' on
the PID and it came back empty handed. I did do a 'truss
/usr/local/libexec/mysqld' which spat back all sorts of goodies. I
have included the output bellow. Also, as requested, below is the
output of mysqlbug.
Once ag
Please disregard previous cry for help.
I was able to compile after completing
the following steps:
make clean
rm config.cache
configure --prefix=/home/kcurry/util/mysql-3.23.40
--with-mit-threads=no
make
But encountered the following error when the Make
tried to link:
make[3]: E
Quick question for everyone
Which is the most stable version of MySQL for Windows NT Server version 4.0
SP6?
I have conflicting information as to which is more stable, and want to be
sure I use the most appropriate version for what we are trying to do.
Also, if there is some major reasons to
Hi Michael,
Umm very odd behavior, I prresume you have already killed and
restarted this process? But if not can use use 'truss' to trace the
system calls being made by the process now? (truss -p
pid-of-process -o output-file). Just get a few seconds worth. Also
can you run the 'mysqlbug' c
I'm running 3.21.33b (yes, I know it's old), and I run the command:
alter table branch change codebase codebase char(32) not null default
"IPriori";
where column codebase has type varchar(32) - but the type does not change to
char(32).
There's no error message or other indication of what we
Ken and all,
I wrote around a month back about some problems I was having with my
MySQL install in a freeBSD 4.2 system. I received allot of helpful
advice on troubleshooting the problems (memory hogging issues).
Thanks to all. To date, we have recently upgraded to mysqld Ver
3.23.39 for freebs
Hi,
> mysql> select * from logezboo;
> ERROR 1016: Can't open file: 'logezboo.MYD'. (errno: 145)
shut down your mysql, change to your MySQL data directory (as root or the user
MySQL runs as) and run:
myisamchk -r */*.MYI
and then restart MySQL after that and you should be back and running.
We have a project that will require some MySQL/Cold Fusion/ASP
development. We are looking for an offsite developer. There is already
some development that has been done. The developer will have to do an
analysis of the work that has already been done and finally complete the
remaining tasks.
On Wednesday 01 August 2001 10:13, Bernard Bross wrote:
> Hello
>
> I am trying to install the lastest version of mysql on Linux (Suse, uname -r
> = 2.2.14), without success.
> I have downloaded both the 3.23.38 and 3.23.40 binary tar balls, they crash
> the same way (I have tried on several mach
Hi there,
I am having problem finding "MySQL Client software" to connect to Web Hosts
server so i can create tables and run queries at their server remotely. I am
running windows so any related softwares would be great help.
Please reply soon as i need to proceed on project and really need
afore
When I try and install mysql on an RS6000 Aix 4.3.2 I get the following
errors
exec(): 0509-036 Cannot load program ./bin/my_print_defaults because of the
foll
owing errors
Dear Sir,
I'm new to mysql. So please forgive me if I may sound so stupid.
I did install mysql database. I also downloded you
Sun Solaris 2.7 Sparc static binary of MySQLGUI 1.6
After I unziped what should I do? How can this to work?
My database is running on Sun Solaris 2.8. Your help is al
This is the email I recieved from tech support of the host i'm using, in
reference to using MyOdbcand MyAccess to connect from Access on a windoze
machine to MySql on a unix machine.
"All remote db connections are blocked so
phpmyadmin or using ssh to connection (secure telnet) is the two databas
Hi Sinisa,
I've downloaded the gnu make, installed it OK and tried to compile again
MySQL. This is the new err msg:
make[1]: Entering directory `/usr/local/mysql-3.22.32/sql/share'
make[1]: Nothing to be done for `all'.
make[1]: Leaving directory `/usr/local/mysql-3.22.32/sql/share'
make[1]: Ente
hostname.err says
(Got an error reading communication packets)
(Got an error writing communication packets)
I had to shut down the server. What does this mean?
This relates to SHOW PROCESSLIST
Id Command Time State Info
6 Query 81 Locked SELECT * FROM staticStrings
> Adam Douglas writes:
> > Correct 6 tables are being joined. Here's the explain of
> the query below
> > (btw, I'm not getting a index on CompanyShipInfo and
> PostalCodeInfo not
> > CompanyRep like I previous said). Excuse me if this seems
> dumb but I'm not
> > sure what you are saying in th
Peronaly I like the new logo! Very nice..Are there going to be any restrictions on
putting it on web sites like before?
Cheers
M;)
-Original Message-
FROM: Justin Farnsworth
TO: MySQL
DATE: Wed 8/1/01 10:58
SUBJECT: Hippies hijack cetecean...
[ sql, database, mysql ]
SEE: http://
Sinisa,
I have found gcc 2.95.2:
orion:kcurry:/home/kcurry/util/mysql-3.23.40/ -> gcc
-v
Reading specs from
/home/jcrouch/gnu/lib/gcc-lib/sparc-sun-solaris2.7/2.95.2/specs
reran config:
configure --prefix=/home/kcurry/util/mysql-3.23.40
--with-mit-threads=no
and I get the following error:
mak
Hello eveyone,
Newbie Alert!
I am having trouble with one of my tables in a MySQL database. After I had
a power outage and restarted my system was not able to read info from that
table. Below is the Error messages I get when I try to access the table
from the command line client.
Help!
Thanks
You also need read and execute premissions on the directories leading to
the socket.
chmod 755 /var/lib/mysql
Lars Freymark wrote:
> Hi Karel!
>
> Thanks for your suggestion. The rights are now:
> srwxrwxrwx1 mysqlmysql 0 Aug 1 11:02 mysql.sock
> But I still can't access mys
I didn't go to school... but it adds up to 10110110... right off the top of my head...
:-P
My brain is ready to explode... please forgive me...
John Shipp
[EMAIL PROTECTED]
- Original Message -
From: Geoff Blake
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, J
Hello
I am trying to install the lastest version of mysql on Linux (Suse, uname -r
= 2.2.14), without success.
I have downloaded both the 3.23.38 and 3.23.40 binary tar balls, they crash
the same way (I have tried on several machines with the same configuration,
and got the same result):
./scrip
Hi all
We currently have our internet store & intranet site running on seperate
access databases one products & one customers DB online and one of each
offline, we have recently invested in a RAQ4i co located web server running
red hat, Chiliasp & mysql 3.22.32, in house we are running dual PIII w
I have a mysql server 3.23.34a running on my valinux 700Mhz PIII with 1GB
Ram.
I have found that after running for a while mysqld starts to increase the
number of threads running.
For example today I had 20 threads running but only 6 processes in my
"mysqladmin processlist". Each of the threads
At 12:30 PM +0100 8/1/01, Mark Tully wrote:
> However it just won't die!
> kill doesn't work on either the mysql process or the script, the
> "mysqladmin -u root shutdown" command similarly fails and the
> "mysql.server stop" command times out. The only way I can st
www.unixodbc.com
>> Original Message <<
On 8/1/01, 7:10:48 AM, muruganandam <[EMAIL PROTECTED]> wrote
regarding driver for mysql :
> i want to connect mysql DB through C++ code(on linux)..
> can any one give me the necessary URL from which i can download the
d
Werner Stuerenburg writes:
>
> > You have turned binary logging or replication ON.
>
> True. How did I do that?
>
> my.cnf says
>
> # Start logging
> log
> log-slow-queries
>
> Oh, I see ... some place else: log-bin
>
> Sorry for the confusion.
>
>
> --
> Herzlich
> Werner Stuerenburg
muruganandam writes:
> i want to connect mysql DB through C++ code(on linux)..
> can any one give me the necessary URL from which i can download the driver..
> and the related info about the drivers(like most stable.etc.,)
>
> thanks in advance
>
> muruganandam
Try using our 3.23 C API and MyS
Sinisa Milivojevic schrieb am Mittwoch, 1. August 2001, 16:04:45:
> Werner Stuerenburg writes:
>> To track down problems, I downloaded hostname.err, hostname.log
>> and hostname-slow.log and, as these were quite big (log = 350
>> MB), I deleted them on the host.
>>
>> I remember that I turned
[ sql, database, mysql ]
SEE: http://www.theregister.co.uk/content/28/20750.html
_jef
--
Justin Farnsworth
Eye Integrated Communications
321 South Evans - Suite 203
Greenville, NC 27858 | Tel: (252) 353-0722
-
Before posting,
Have you tried setting CXX to gcc and CXXFLAGS to "-fno-rtti
-fno-exceptions" ??
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca,
Jose Vilmar Estacio de Souza writes:
> Hi,
> Sorry by my dumb question.
> Could you tell me where I could find this manual? Also in what section of the
>manual could I find the info about the patches for hp-ux 10.20?
> Many thanks in advance!
Our manual comes with both binary and source
Hi,
Sorry by my dumb question.
Could you tell me where I could find this manual? Also in what section of the manual
could I find the info about the patches for hp-ux 10.20?
Many thanks in advance!
- Original Message -
From: "Sinisa Milivojevic" <[EMAIL PROTECTED]>
To: <[EMAIL PROT
Hi everyone! I am fairly new to this list, and a new MySQL user. The
software company I work for just developed a new product which uses MySQL to
house its data. But we are experiencing a strange problem, so I thought I
would toss it out there...
We have a product that reports text data files
Mark Tully writes:
> From: Mark Tully <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: mySQLd won't die under Darwin (Mac OS X 10.0.4)
>
> >Description:
> Downloaded source archive, compiled as of instructions.
> The mySQLd server is started as root and it switches down to t
Date |Wed, 1 Aug 2001 02:51:02 -0400
>From |"John Woodward" <[EMAIL PROTECTED]>
Hello!
JW> Dear sirs,
JW> Possible (minor?) bug?
JW> I'm a newbie to MySQL and MySQLGUI, but I have a fair amount of experience
w/Paradox and MS Access.
JW> I am using www.phpwebhosting.com to host my web site (w
Date |Tue, 31 Jul 2001 21:03:23 -0400
>From |[EMAIL PROTECTED]
Hello!
I> say i am running a server with mysql and phpmyadmin and i have some
I> dbs (including of course the mysql db)...
I> so when someone says to "set them up a 'MySQL account'" what exactly
I> do they mean? and how do i do it?
Chris Hilbert writes:
> I have been able to crash my server by doing a FLUSH TABLES in MySQL
> 3.23.36 on Linux. Any ideas why it would die like this during normal
> use? Or how to fix it?
>
> Thanks,
>
> Chris Hilbert
There have been numerous bugs fixed since .36.
Try our 3.23.40 binary a
Date |Tue, 31 Jul 2001 18:39:35 -0400 (EDT)
>From |Paul Southworth <[EMAIL PROTECTED]>
Hello!
PS> On a system running two separate instances of mysqld (different
PS> versions) I need to have one of them (special version for one
PS> customer) ignore the system-wide /etc/my.cnf file. I would pre
Date |Tue, 31 Jul 2001 16:40:06 -0400
>From |"ROSS MCCORMICK" <[EMAIL PROTECTED]>
Hello!
RM> What about having symbolic links in the same directory as the original file? I
have a situation where a broken Windoze application has different queries embedded,
with some using tablename(lower case)
Date |Tue, 31 Jul 2001 21:48:24 +0200
>From |"lasse" <[EMAIL PROTECTED]>
Hello!
L> Hello again!
L> Is there no way a program like netadmin could alter databases .. and create tables?
L> i really like the looks of that GUI
L> I dont wanna install mysql on the win2k box.. i'd like to keep it on
kevin curry writes:
> SEND-PR: -*- send-pr -*-
> SEND-PR: Lines starting with `SEND-PR' will be removed
> automatically, as
> SEND-PR: will all comments (text enclosed in `<' and
> `>').
> SEND-PR:
> From: kcurry
> To: [EMAIL PROTECTED]
> Subject: [50 character or so descriptive subject here
> (fo
Werner Stuerenburg writes:
> To track down problems, I downloaded hostname.err, hostname.log
> and hostname-slow.log and, as these were quite big (log = 350
> MB), I deleted them on the host.
>
> I remember that I turned on slow query logging and did not create
> the log myself. Therefore, I ass
hi ,
i'm writing a simple java program that i want to access mysql with.
the error i'm getting is :
"Server configuration denies access to data source"
the code is :
String url = "jdbc:mysql://localhost:3306/mysql";
Connection con;
String query = "SELECT Teacher F
Date |Tue, 31 Jul 2001 11:59:29 -0500
>From |"Chuck Barnett" <[EMAIL PROTECTED]>
Hello!
CB> Hello, I am getting this error in the .err file
CB> 010731 9:48:22 Can't start server: Bind on TCP/IP port: Address already in
CB> use
CB> 010731 9:48:22 Do you already have another mysqld server runn
i want to connect mysql DB through C++ code(on linux)..
can any one give me the necessary URL from which i can download the driver..
and the related info about the drivers(like most stable.etc.,)
thanks in advance
muruganandam
- Original Message -
From: Lee Harvey <[EMAIL PROTECTED]>
To:
Date |Tue, 31 Jul 2001 11:18:42 -0400
>From |"Roy" <[EMAIL PROTECTED]>
Hello!
R> Hi
R> I am using Linux7.1 operation system.
R> I would like to install Mysql on this system.
R> I downloaded the Linux(intel libc6 systems)[pc-linux-gnu-i686].
R> Is it correct?
R> I installed it many time, but they
I've never had this much trouble compiling mysql before. I've done it at
least a dozen times and most are virtually trouble free but this 3.23.40
version is being stubborn.
The error I'm having (or should I say the "current" error) is this:
gcc -O3 -DDBUG_OFF -O3 -felide-constructors -fno-excep
From: Mark Tully <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: mySQLd won't die under Darwin (Mac OS X 10.0.4)
>Description:
Downloaded source archive, compiled as of instructions.
The mySQLd server is started as root and it switches down to the
mysql user. It can be
Date |Tue, 31 Jul 2001 13:32:26 -0300
>From |"Pessin" <[EMAIL PROTECTED]>
Hello!
P> When I try to start the mysql I get :
C:\mysql\bin>>mysqld
P> 010731 13:25:51 Can't init databases
C:\mysql\bin>>
P> What can I do ?
P> Pessin
Do you create initiail database with mysql_install_db ?
http://
Date |Tue, 31 Jul 2001 14:32:30 +0100
>From |"Martin Moss" <[EMAIL PROTECTED]>
Hello!
MM> Hi,
MM> Just a quick high level design question?
MM> Is mirroring only a one way action?
MM> i.e. one in use database and one backup database?
MM> Or is it possible to use both databases and they'll both
I have been able to crash my server by doing a FLUSH TABLES in MySQL
3.23.36 on Linux. Any ideas why it would die like this during normal
use? Or how to fix it?
Thanks,
Chris Hilbert
Date |Tue, 31 Jul 2001 12:05:50 +0100
>From |"Lee Harvey" <[EMAIL PROTECTED]>
Hello!
LH> Hi
LH> I have installed mySQL 3.22.32 client & server rpms on our co located RAQ 4
LH> server, however due to a few issues with ODBC drivers we have been advised
LH> to remove the rpms and install from a pk
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed
automatically, as
SEND-PR: will all comments (text enclosed in `<' and
`>').
SEND-PR:
From: kcurry
To: [EMAIL PROTECTED]
Subject: [50 character or so descriptive subject here
(for reference)]
>Description:
Whe
To track down problems, I downloaded hostname.err, hostname.log
and hostname-slow.log and, as these were quite big (log = 350
MB), I deleted them on the host.
I remember that I turned on slow query logging and did not create
the log myself. Therefore, I assumed that MySQL would create all
these
I posted this message in the Delphi/Kylix newsgroups but didn't get a
definitive answer so I'll try it here.
I'm using Delphi 6 Enterprise and DBExpress to access a MySQL database
running on a Suse box. I'm using a MySQL-Max distribution and InnoDB table
types that support transactions. Unfortuna
from http://www.mysql.com/doc/M/i/Miscellaneous_functions.html:
DECODE(crypt_str,pass_str)
Descrypts the encrypted string crypt_str using pass_str as the password.
crypt_str should be a string returned from ENCODE().
hope this helps.
~shawn
On Wed, 1 Aug 2001, saraswathy saras wrote:
> hai
>
Hi
I have a table
table name : shtrack
columns :
contnum (STRING)
actdate (DATE)
actseq (INTEGER)
acttype (STRING)
there can be multiple rows with the same data for contnum, but I want a
query that will give me the newest row by date (actdate) for each contnum
en
Hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Robert Cross writes:
>>
>> I've got a wierd problem with 3.23.38, built from source, running on RedHat
>> v6.2 (Intel). Put simply the wildcard character for user access doesn't
>> work. From my reading of the docs an
Hi!
> "Scott" == Scott Stevenson <[EMAIL PROTECTED]> writes:
Scott> I'm curious why you guys are still distributing binaries for Mac OS X
Scott> Server 1.x ([apple-rhapsody5.5-powerpc] ), when there are clearly more
Scott> users of Mac OS X 10.x/Mac OS X Server 10.x/Darwin 1.3.x. They all
Hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Uwe Heldt writes:
>> Hi Venu,
>>
>> it ' s hard to send you sample code. The database access is coded over more
>> then one class which dynamicly build sql statements. The only thing i know
>> is, that first a simple
I'm having an issue with mysql 3.23.36 where it crashes every 1 hour to
2 hours on Linux 2.4.3 kernel. Once it locks up, I cannot kill the
process and must reboot. Any attempts to connect (or shutdown) don't
error out, but sit there waiting. Any ideas what the problem can be or
how to resolve t
Hi
I have problem with load data to field longtext. Size of data more then
20M.
Version of MySql is 3.23.37.
I use "load data infile" for loading data. There are no warnings or
errors during loading. But after that I can't read data from table. The
select statement issue the following error:
134
This poster should be removed from the list, he's just placing trash in the
list
---
Sherwin Ang
Web Programmer
Yesmynet Internet
- Original Message -
From: Heidi Fredel <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 30, 2001 8:50 PM
Subject: Valuable inf
Hi Karel!
Thanks for your suggestion. The rights are now:
srwxrwxrwx1 mysqlmysql 0 Aug 1 11:02 mysql.sock
But I still can't access mysql with linux user freymark. The eroor code is
the same.
thanks
Lars Freymark
Tel.: 0431/ 66870-0
Fax : 0431/ 66870
Rafal Jank writes:
> hi,
> since analyze table doesn't work for Innodb tables, where does optimizer get
> statistics needed for making proper query plan from?
> For example, how does it know which index is more selective or in which order
> tables should be joined?
> --
> _/_/ _/_/_/ --
Hello,
I need some help for database optimization ... is there any documentation
about tuning server parameters except this one in MySQL-documentation which
ist not very detailed I think especially in case of effects on server or
threads.
TIA
Stephan
--
***
Michael Collins writes:
> Perhaps Marc Liyanage would be willing to do it? He already has some
> great packages available for easy install to Mac OS X:
>
> http://www.entropy.ch/software/macosx/
>
> BTW, thanks Marc!
>
> Michael
>
> --
> __
> ||| Michael Collins |||
> ||| Kuwago Web
John Woodward writes:
> Dear sirs,
>
> Possible (minor?) bug?
>
> I'm a newbie to MySQL and MySQLGUI, but I have a fair amount of experience w/Paradox
>and MS Access.
>
> I am using www.phpwebhosting.com to host my web site (www.Rebates4Sure.com).
>
> I can telnet to Rebates4Sure.com, login i
Excerpt from MySQL manual :
===
NAME Returns a reference to an array of column names. Example:
$names = $sth->{NAME};
===
$names contains nothing.
I suppose this is not normal behaviour.
==
hi,
since analyze table doesn't work for Innodb tables, where does optimizer get
statistics needed for making proper query plan from?
For example, how does it know which index is more selective or in which order
tables should be joined?
--
_/_/ _/_/_/ - Rafał Jank [EMAIL PROTECT
c cw_1 writes:
> Hello,
>
> We have a Stratus HP-UX 64 bits (version B11.0) machine,
> I would like to know if MySQL can run on the Stratus Box.
> If it can, will it cause any problem?
> Can MySQL be configured to the 64 bits to run on the Stratus?
>
> Thanks in advance.
>
> Connie
What HP-UX
look at the access privileges to the file
'/var/lib/mysql/mysql.sock' and change them so that you can
write to it
On Wed 1. August 2001 11:44, Lars Freymark wrote:
> Hi everyone!
>
> I have installed mysql 3.23.22. The Distribution is from the redhat cd. My
> problem is the following:
>
> I ca
Ing. Gustavo Edelstein writes:
> Hi list members,
>
> After
> ./configure --prefix=/usr/local/mysql
>
> I do a make and when change dir to mit-pthreads, I got following err msg:
>
> Making all in mit-pthreads
> Make: Must be a separator on rules line 26. Stop.
>
> Thanks for any help.
>
> In
hello,
I have problems by dumping an table with the options
--quick --compress -v --extended-insert --opt
I put the dump command into an script, then, not allways, the dump fails
and breaks up. If I start the dump command again trough the commandline
the dump make everything OK including a full
1 - 100 of 114 matches
Mail list logo
