What about issueing first drop index, then add index? Should do
the job. Or repair table. What does check table or myisamchk say?
shawn reed schrieb am Montag, 30. Juli 2001, 07:44:15:
> hi all,
> i apologize for the utterly newbie-ish question, but i've yet to find an
> answer to it after havi
On Sun, Jul 29, 2001 at 03:42:41PM -0600, Chris Cameron wrote:
> I sent this before, but it never made it..
>
> Does anyone here have any advice on controlling the size of user
> databases?
There's not a lot you can do about it today, short of (1) symlinks
onto a filesystem with user quotas wher
I'll give you an example, step-by-step.
I didn't do that kind of thing myself yet, so I had a look at the
manual. First, I discovered that mysql can take all kinds of
separators (I read that before, but forgot about it), so you
don't have to convert at all, as you can signal different
separators
You should use the 'startup script' supplied with the 'source' distribution
(named "server.sh" in the subdirectory "support-files").
To 'boot' without starting any applications or daemons, type "boot -s" at
the 'boot prompt' (Lilo's boot prompt if you have installed "lilo"). This
will boot the
hi all,
i apologize for the utterly newbie-ish question, but i've yet to find an
answer to it after having spent quite some time searching mysql's web site
(especially since half the links i click on now seem to be giving me 404
errors...)
how does one reindex a table containing fulltext indexes
On Mon, Jul 30, 2001 at 01:36:29AM +0200, Sander Pilon wrote:
>
>
> I'd like it as well. Perhaps turn logging on/off on a
> database-basis.
>
> Say, I want to debug/view the queries on database X but don't want
> the stuff that's happening on database Y.
The impression I got is that this may a
On Fri, Jul 27, 2001 at 03:13:58PM -0400, [EMAIL PROTECTED] wrote:
>
> Is it possible to have a single mysql server with multiple data
> directories? I would like to be able to specify where a database is
> physically located. I know that I can do this for all databases by
> setting the 'datadir'
On Wed, Jul 25, 2001 at 03:19:03PM +0200, Sebastiaan Smit wrote:
> Hello,
>
> I'm having a problem with MySQL when it runs for a couple of
> days. At some time mysqld 'forgets' where it's databases are and
> searches for them in the mysql temp dir. (In my case /var/tmp). In
> the tmp dir there is
On Sat, Jul 21, 2001 at 06:51:37AM -0700, Donald wrote:
>
> Im running FBSD ver 2.2.8 and need to know what version of mysql
> installs ans runs best on this platform. At this time upgrading in
> not an option.
I never saw a reply, so...
I've run a few versions of MySQL 3.22.xx (where xx is pro
Dear,
I'd like to use some temp table (not establish from create new table and
could delete itself when finished job) when I grab data from any real
table. Please describe with MySQL console, PHP or programming language
with API.
Sommai Fongnamthip
--
On Mon, Jul 30, 2001 at 11:51:25AM +0800, winnie wrote:
>
>I have a question in MySQL Replication?
>
>I have 3 different databases running on 3 servers. Then I want
>replicate them to one single server. How can I do? Need I run 3
>mysql on the slave server?
Yes. A slave can
Try this
save any file format to .csv and use this statement in your program
load data local infile 'c:\\dir-in-harddisk\\filename.csv' into table
hr.trn fields terminated by '\,'
this command was in MySQL Manual
Sommai Fongnamthip
At 04:47 27/7/2001 -0400, Glyndower wrote:
>Hi,
>
>I'm using
Hi Sir,
I have a question in MySQL Replication?
I have 3 different databases running on 3 servers. Then I want replicate them to
one single server. How can I do? Need I run 3 mysql on the slave server?
Winnie
-
B
Hello Tom Cruickshank:
re: mysql -related install of apache and php4
-
I'm running *BSD, not Linux, but very recently installed Apache with PHP,
from source. I usually make a shell script, and check it through for all the
steps, then run the script. I had saved the script, so maybe this will
Hello-
You need to place mysqld in the background by adding a & after the
command. Something like this:
/usr/local/mysql/bin/safe_mysqld &
As to the problem after it starts mysqld in the foreground, have you tried
CTRL-C? Otherwise try going to a different console with ALT-F2, ALT-F3,
etc.
Hi Everyone,
I have a small problem here(I think :-) ), but I still can't figure our how
to fix it.
I am not so familiar with Linux 6.0's Boot Shell.
Here is the problem:
After I successfully installed MySql 3.23 into my Linux system,
I added the following lines into /etc/rc.d/rc.local to enab
>
> On Mon, Jul 16, 2001 at 05:50:53PM -0700, Jim Matzdorff wrote:
> >
> > >difficult to do (add the necessary code to MySQL),
> provided that the
> > >logging code is as straightforward as the binary logging code.
> >
> > i figured something like that, though i don't know the
> internals.
Sometimes it just helps to ask someone.
I forgot I'm not running this database on THIS machine. I'm running it on
the one beside it. That machine had a clock set 12 hours ahead. Thanks for
your help.
David
> -Original Message-
> From: Don Read [mailto:[EMAIL PROTECTED]]
> Sent: Sunday,
As an example...
mysql> select now();
+-+
|now()|
+-+
| 2001-07-30 06:33:10 |
+-+
1 row in set (0.00 sec)
mysql>_
That time is about twelve hours from now here on the East Coast of the USA.
> -Original Message
On 29-Jul-2001 Tom Cruickshank wrote:
> Hello,
> I am not sure if this is the right mailing list but since it's a
> mysql related problem,
> I thought I'd give it a shot..
>
>
> I am installing apache on my linux box with php4 capabilities. When I
> configured php4
> I added the mysql o
On 29-Jul-2001 dpowellLLC wrote:
> Apologies as this question has probably been asked before.
> I am new to mysql. I run it on Windows NT4. I am using version 3.23.39a.
> The function NOW() doesn't appear to work. Is there a fix?
> I've checked my computer and time zone, etc. Everything seems
On Sun, Jul 29, 2001 at 06:15:20PM -0400, dpowellLLC wrote:
> Apologies as this question has probably been asked before.
If you check the mail archives before posting, there's no reason to
aplogize.
> I am new to mysql. I run it on Windows NT4. I am using version
> 3.23.39a. The function NOW
Hello,
I am not sure if this is the right mailing list but since it's a
mysql related problem,
I thought I'd give it a shot..
I am installing apache on my linux box with php4 capabilities. When I
configured php4
I added the mysql option...in short..something like this...
gunzip apache_
Apologies as this question has probably been asked before.
I am new to mysql. I run it on Windows NT4. I am using version 3.23.39a.
The function NOW() doesn't appear to work. Is there a fix?
I've checked my computer and time zone, etc. Everything seems to be in
order.
Thanks in advance,
David
On Sun, Jul 29, 2001 at 03:10:14PM -0700, Vincent Janelle wrote:
>
> But configuring mysql to point to a diff directory is just better
> administration.
Unfortunately, it only gets you so far. What if you want to spread
your data across several physical disks (without hardware/software
RAID)? O
On Mon, Jul 16, 2001 at 05:50:53PM -0700, Jim Matzdorff wrote:
>
> >difficult to do (add the necessary code to MySQL), provided that
> >the logging code is as straightforward as the binary logging code.
>
> i figured something like that, though i don't know the internals.
> it seems it knows wha
Depends on the handler. You'll get the file pointer returned.. I guess I
wasn't thinking this completely through. Ah oh well =) I keep thinking in
terms of files getting opened and closed a lot.
But configuring mysql to point to a diff directory is just better
administration.
- Original Me
On 29-Jul-2001 Vincent Janelle wrote:
> Uh, don't symlink. That'll just cause massive amounts of issues later on if
> you have to deal with performance (added syscalls to check to valid
> symlinks).
For extremely small values of massive. 'real_data_home' is resolved once at
server startup in my
On Sun, Jul 29, 2001 at 02:21:43PM -0700, Vincent Janelle wrote:
>
> Uh, don't symlink. That'll just cause massive amounts of issues
> later on if you have to deal with performance (added syscalls to
> check to valid symlinks).
Doesn't that apply to the time that a table is opened? If tables ar
I sent this before, but it never made it..
Does anyone here have any advice on controlling the size of user
databases?
I've heard talk of symlinks before, anyone had any luck with that?
Thanks,
Chris
-
Before posting, please
After being tested for a week, he new version is finally available for
downloading. This new version has some bugs fixed and a totally new Server
Manager. Here is the list of the changes:
- New Server Manager integrated, you can add, delete or change the
parameters at any time you want. You can al
Uh, don't symlink. That'll just cause massive amounts of issues later on if
you have to deal with performance (added syscalls to check to valid
symlinks).
If you read the docs on mysql.com, they tell you the command line options
you can set to change the directory. You can put these into my.cnf
On 29-Jul-2001 Brian Thompson wrote:
> I have my /var/ partition set to 400mb, but I need about 4 gigs for a mysql
> database im setting up
>
> how can I relocate the data files in the users /home directory, or how can I
> fix this?
>
Assume the datadir is /var/db/mysql
make a backup
shutdow
I got several of them in my mailbox as well, even when I asked him to stop,
so I K-lined his domain from my mail server...silly butt head..
Cheers
M;)
-Original Message-
From: Sebastiaan J.A. Kamp [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 29, 2001 11:26 AM
To: [EMAIL PROTECTED]
Subj
I have my /var/ partition set to 400mb, but I need about 4 gigs for a mysql
database im setting up
how can I relocate the data files in the users /home directory, or how can I
fix this?
-
Before posting, please check:
http:
filter: mysql
I don't have the original post any more, but you will have some
kind of file where the records are lines and the fileds in the
record are separated by some kind of character, say tab or blank
or anything else, but you will know what.
So let's say the filename is $filename and the s
If you're looking for support you can contact MYSQL AB (the creators of
MYSQL) checkout www.mysql.com to see which supportcontracts they offer.
But you could also try your luck on this list.
Bye,
B.
At 15:00 29-7-01 -0400, Thomas Bernthaler wrote:
>Hi,
>I have mysql-3.23.40-sun-solaris2.
>Does anyone have any information on running MySQL on a windows CE handheld?
Try it and let us know as soon as you've got it up and running..
Good luck.
/me wouldn't even try.. but me wouldn't even try to run MySQL on any M$
product..
mysql, query
Bye,
B.
---
Hi,
I have mysql-3.23.40-sun-solaris2.7 on Sun and I have quite a few
problems I try to find somebody that I can pay to help me get this
running the way it should. If anyone is good with the produce and is
interested to earn some extra money please contact me. I need someone
fast.
Thomas Bernthal
>From other mailings on the list and my own experience, it seems
"[EMAIL PROTECTED]" is (has been?) sending these out to any poster
to the list.
If things aren't fixed yet, I'll probably have another one in a couple of
minutes...
Anyhow, "no" SJS, it seems to me this 'no spam' crap has nothing
to
> Example I have a file name stored in database as: john's - song.mp3
>
> When I click on the link to the song in a web browser I get file not
> found.
http://www.php.net/rawurlencode
-
Before posting, please check:
http:/
Hi Kit,
I am not sure whether you deliberately choose to send the email not to the
list, but it might have been a wise thing considering the long list of
emails. ;-) (which I deleted right away for your privacy).
Unfortunately I am no PHP expert but rather familiar with Perl but I don't
think th
Hi,
Many many thanks to all who had replied.
I tried using mysqlc.exe but windows complained that a
.dll file was required, CYGWINB19.dll file not found.
Thanks in advance.
JH
--- Sinisa Milivojevic <[EMAIL PROTECTED]> wrote: > Oh
junhui writes:
> > Hi,
> > I am currently using mySQL 3.2
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 select is performed. After that one update on the
same table row and then a select again. Could id be that there
Does anyone have any information on running MySQL on a windows CE handheld?
Thanks
Joel
Hi !
Can you please send us the reproducible sample code ? So that we can figure
out the things.
Thanks in advance
Venu
> -Original Message-
> From: Uwe Heldt [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, July 29, 2001 6:28 AM
> To: [EMAIL PROTECTED]
> Subject: driver problem
>
>
> Hi all,
This maybe more of a PHP question. I have a problem with file names
that have white space or special characters stored in the database. When
I try to link to them from a webpage I get file not found error which is
probably because of whitespace in filename
Example I have a file name stored in da
hi all
i am running mysql 3.23.40 and tomcat 3.2.3 on FreeBSD
when i try to connect to the local mysql server in jsp using mm driver
it says:
Server configuration denies access to data source
the user&pass i provide is right
i can connect to local mysqld use ./mysql -u root -p
also php+mysql
Carsten Gehling writes:
> I'm back now, and have tested the 3.23.40. It works like a charm :-) Nice
> work!
>
> Now I only wait for the Win32 binary to be released. I didn't think there
> were any delays between the releasins anymore?
>
> - Carsten
>
Thanks for the compliments.
Win32 binaries
Hi all,
i have a problem with the mysql driver. I have developed some java classes to read and
write from the database. These classes uses very simple sql statements like insert or
update. But sometimes (50%) when i perform a update a got the following exception.
java.sql.SQLException: Communi
I'm back now, and have tested the 3.23.40. It works like a charm :-) Nice
work!
Now I only wait for the Win32 binary to be released. I didn't think there
were any delays between the releasins anymore?
- Carsten
- Original Message -
From: "Sergei Golubchik" <[EMAIL PROTECTED]>
To: "Carst
Nik Belajcic writes:
> I had similar experience with MySQL GUI although my connection is over
> 1.5Mbs ADSL. If I use MySQL WinAdmin the response is instantaneous. I know
> that applications with ported Unix interfaces can be slightly sluggish, but
> not 20-30 seconds - so it has to be something e
I had similar experience with MySQL GUI although my connection is over
1.5Mbs ADSL. If I use MySQL WinAdmin the response is instantaneous. I know
that applications with ported Unix interfaces can be slightly sluggish, but
not 20-30 seconds - so it has to be something else. My client is W2K and web
Roger Larsson writes:
> I'm posting to this general list because there doesn't seem to be any
> list to report a spontaneous crash to.
>
> Have tested MySQL 3.23.39-nt for some days by implementing a small
> project. It has been running fine up to now when I after having dropped
> a column from a
Håkan Elmqvist writes:
> My MySQLGUI running on a Windows system is invariably much slower(typically
> 30 seconds) than a MSAccess database with tables linked with MyODBC to the
> same Linux-hosted Mysql-database (typically less than 1 second) when
> executing the same query over a telephone i
Dave Fogle writes:
> Thanks for responding, but the full path is not the answer.
>
> I have tried every conceivable full path (see original message) and it does
> not help. In fact, the only thing that has ever worked was using no path
> info and putting the file in the root of the C: drive on m
Moutasem Dana wrote:
>
> hi,
>
> i have two MySQL servers and i need to run a query that retreives data
> from both servers (join two tables on different servers), how can i do
> this.
>
> Thanks.
>
> -
> Before posting, pleas
On Sun, Jul 29, 2001 at 12:41:46PM +0300, Moutasem Dana wrote:
>
> i have two MySQL servers and i need to run a query that retreives
> data from both servers (join two tables on different servers), how
> can i do this.
You cannot do that in a single query.
--
Jeremy D. Zawodny, <[EMAIL PROTECTE
On Fri, Jul 27, 2001 at 03:45:07PM -0600, Robert Leach wrote:
>
> Is there a standard for that in SQL?
I don't think so. And if there is, MySQL doesn't do it.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (4
Already done my friend - works like a dream.
best, Graham
-Original Message-
From: Jeremy Zawodny <[EMAIL PROTECTED]>
To: Graham Nichols <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: 29 July 2001 10:39
Subject: Re: DISTINCT problem
>On Thu, Jul 26, 2001 at 09:3
hi,
i have two MySQL servers and i need to run a query that retreives data
from both servers (join two tables on different servers), how can i do
this.
Thanks.
-
Before posting, please check:
http://www.mysql.com/manual.php
On Thu, Jul 26, 2001 at 09:31:29PM +0100, Graham Nichols wrote:
>
> Distinct can only be used with count
>
> count(distinct field_name) --- OK for 3.23 NOT for 3.22
>
> from MYSQL version 3.23. I have only version 3.22. How can I get
> around this please?
Upgrade? :-)
--
Jeremy D. Zawo
Hello Ardani,
an INSERT works only on one selected table...
You must insert the values separately for each table...
where is the problem?
Christian
-
Before posting, please check:
http://www.mysql.com/manual.php (the manua
Hi!
>On Wed, Jul 25, 2001 at 10:32:38PM -0600, Chris Bolt wrote:
>> > I am currently trying to examine the benefits of continuing to
>> > use MySQL over Oracle. I need to know what MySQL's features are
>> > vs. those of Oracle.
It is totaly useless to compare Oracle vs. MySQL.
Oracle is somethi
On 29-Jul-2001 martin wrote:
> Hello.
>
> Just installed on FreeBSD. No database created yet, just a straight install
>
> I was surprised at the amount of memory the daemon is taking
>
> 25.7MB - Is that correct ?
>
>
Thats about right for an idle daemon.
Mine shows 26.6M, 13.7M in memor
> I am creating a database server with mysql.
> I have an adaptec 2100s card which is not supported by debian 2.2 (my
first
> choice in Linux OSs)
>
> The card seems to say that it is only supported by Red hat and SuSe
Linuxes.
>
> Any ideas on what would be the best OS to run a database server
R
66 matches
Mail list logo
