Hi guys,
I just have a problem since yesterday, RedHat 7.0 make standard a partition of 256 mb
for /var and mysql database are to big for this (so it crashes).
Can someone tell me how to change the /var/lib/mysql path to /home/lib/mysql.
I changed every file to this path (mysqld,
Hi guys,
I just have a problem since yesterday, RedHat 7.0 make standard a partition of 256
mb for /var and mysql database are to big for this (so it crashes).
Can someone tell me how to change the /var/lib/mysql path to /home/lib/mysql.
I changed every file to this path (mysqld,
Hi
The config file you are looking for is /etc/my.cnf, I believe. The paths for all mysql
related files and dirs are there.
Seung-woo Nam
"Didier Desmet (RSCA)" wrote:
Hi guys,
I just have a problem since yesterday, RedHat 7.0 make standard a partition of 256
mb for /var and mysql
Hi,
It's possible to create a database in a differents directories ? And how to
make it ?
Thanks
Carlo Carlini
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
No there is /etc/my.conf but this file is empty ?
- Original Message -
From: Seung-woo Nam [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, March 02, 2001 10:04 AM
Subject: Re: How to change the lib path ...
Hi
The config file you are looking for is /etc/my.cnf, I believe. The
On Thu, Mar 01, 2001 at 11:41:52PM +0100, Christiaan den Besten wrote:
Hi all,
Hi, the bugs list is the wrong list I suppose, so I replied to the
mysql list (and you in case you don't read it).
i've been using mysql for some time now and never had any serious problems I
could not solve
Hello
Any ideas?
-christian-
Package: mysql
Version: 3.23.33-1
Severity: normal
Greetings,
The build fails on ARM. Here's the end of the build log:
g++ -DMYSQL_SERVER-DDEFAULT_MYSQL_HOME="\"/usr\""
-DDATADIR="\"/var/lib/mysql\""
-DSHAREDIR="\"/usr/share/mysql\""
I think you can do it by running mysql as the following :
prompt mysqld --datadir='your_db_path/'
Or, you can create link from another directory to your data directory (using cp -l in
linux)
Progetto 2000 wrote:
Hi,
It's possible to create a database in a differents directories ? And how to
Hi,
I have two tables in a db called "univ". The tables are "student" and
"result_meaning".
Using the C API I want to run a query that SELECT's from "student" using the
field "studnum" as
the selection criteria.
In the "student" table their is a field called "code".
I want to then look up
Hi, All!
Please, give me an opinion about multiple-column index.
May I create the UNIQUE multiple-column index, which the index of each
column is not UNIQUE in?
If yes than how do it?
Best.
Nick.
-
Before posting, please
* I have create a field in MySQL like this:
+---+-+--+-+-+--
-+-+
| Field | Type| Null | Key | Default |
Extra | Privileges |
I have create a field in MySQL like this:
+---+-+--+-+-+--
-+-+
| Field | Type| Null | Key | Default |
Extra | Privileges |
I have heard from somebody that MySQL index is case insensitive. If this is
true, how can I set it to case sensitive?
Hello!
How do I express parentheses in a mysql regexp?
For example the expression
select * from Term where Term_name regexp "^[0-9\(\)A-Z\s\-]+$";
NATO (MILITRTEKNISKE SPM)
but returns
TV2
as well as
NORDISK SAMARBEID
Thanks
Michael
Description:
upgrading my old MySql version to the new one, all my C code doesn't compile
returning an ld error in resolving my_compress() and my_uncompress()
finctions.
I forced compilation coping the old libraries and include files from previus
version of MySql.
Server version
Do you have to do anything special to start putting Thai text into
MySQL?
Ta,
Dave
--
Dave Hodgkinson, http://www.hodgkinson.org
Editor-in-chief, The Highway Star http://www.deep-purple.com
Apache, mod_perl, MySQL, Sybase hired gun for, well, hire
I have been using MySQL for sometime now. However, i had been experimenting with
MySQL priviliges and have locked myself out. I cannot access the database to perform
any function. I cannot issue any command like mysqladmin ping or mysqlshow. Somehow
the command mysqlaccess doesnt execute
Hi!
"Peter" == Peter Zaitsev [EMAIL PROTECTED] writes:
Peter Hello monty,
Peter I'm trying to use merge table for logging - to have a possibility to
Peter Rotate log files and to quickly delete old data - for this I'm goint
Peter to setup a number of merge tables where each contains
Description:
I had a system crash today. The master log didn't get written after
some point (zeroed-out data).
The slave's log stated:
010302 12:59:47 Slave: Failed reading log event, reconnecting to retry, log
'mysql.138449' position 86713
010302 12:59:47 Slave:
Hi,
I like the look of the "mysqlgui" but I cannot get it to connect to
"mysql". I keep getting the error message:
cannot connect to local mysql server through socket (111).
Can you help?
Thanks,
Peter Lindsay
-
Before
Does anyone know if there an open-source OLAP product for MySQL?
The manual tells you how to reset a forgotten password.
It also tells you not to mess with these tables, but to use.
GRANT and REVOKE. We all have to explore everything,
dont't we?
Worst case, kill mysqld and reinstall privilege tables with
mysql_install_db --user=mysql
Asaf Maruf Ali wrote:
So sprach Entryon Corp., Chief Technical Officer - P. Hasenfratz am Thu, Mar 01, 2001
at 02:37:30PM +0100:
What's if you combine a timestamp with the client's IP address?
IP addresses can be easily forged, especially if you're writing some kind of
web application, so this is also not a good
Hi,
I want to have like in Access a column that is yes or no or true or false,
something on that line. I looked at www.mysql.com but could not find
anything. I don't know what exactly I am looking for. Could someone give me
a hand it will be greatly appreciated.
The ENUM field type will do
So sprach Gerhard Schmidt am Thu, Mar 01, 2001 at 04:02:54PM +0100:
Besides the fakt tha this ID not unique. There ist the Problem that
the ID you proposed ist an String ID and strings als Index are the
Well, but he could make a two column primary key, where the first is the
timestamp, and
"Thalis A. Kalfigopoulos" wrote:
Is there a boolean field type (Yes/No; True/False, 1/0) in MySQL or what is
closest to the boolean type
ShortInt: 0 == FALSE, 0 == TRUE
That's how I do it anyway.
Or maybe combine multiple bool fields to one and use binary logic.
Or
When you delete somthing... is there any way to recover the data??
mvh:
Pl Wester, programmerer
never.no as, stortingsgt 30, 0161 Oslo
direkte: 22 01 66 34, 906 900 62
tlf: 22 01 66 34, fax: 22 01 66 21
http://never.no - icq:103476059
~ innhold for internett ~
4.17 Installing many servers on the same machine
In some cases you may want to have many different mysqld deamons (servers)
running on the same machine. You may for example want to run a new version
of MySQL for testing together with an old version that is in production.
Another case is when you
Hi
I'm follwing all instructions to install mysql-3.23.33 on Solaris
8 to X86, and the compilers and programs installed are
gcc version 2.95.2 19991024 (release)
perl v5.6.0 built for i86pc-solaris
tcl tcl8.3
make 3.79
flex version 2.5.4
Like you, I too consider anything not 0 as true.
The cool thing about enum types is you can do it both ways (if you are simulating a
boolean). This flexibility it affords the best of both worlds.
It gives coders the ability to deal in binary AND/OR something more english like -
which in the
Hi!!
I have a system FreeBSD 3.5 - STABLE and I am trying to install the mysql
3.23.33
It is the first time that I install a mysql and let us meet with a problem
that I didn't know
as solving. During the compilation I send myself the following message:
hostname.o: In function
An index is an index and has nothing to do with case. This all depends on
how you define your columns. Look up the section on column types in the
manual.
- Original Message -
From: "Carfield Yim" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, March 02, 2001 18:42
Subject: Do
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
-
Before posting, please check:
http://www.mysql.com/manual.php (the
I notice some of you compile with gcc as you C-compiler (CC) and
C++-compiler (CXX). Configure generates an error message for me when I
try to do this. Can anyone help me with this?
Thanks,
Terry
--
__
Terry Babbey
Technical Support
I am trying to insert this into my table but mysql doesn't like my syntax.
alter table categoryminor solvalveyn enum('True','False');
When I press enter it does nothing it just goes to a greater than prompt.
What I want is for 1 to be true and 0 to be false.
What is the syntax that I am
On Thu, Mar 01, 2001 at 10:58:03AM -0500, [EMAIL PROTECTED] wrote:
HI, I sent this note a couple days ago and no one has commented. I am
trying to implement DBI-1.14.tar.gz Data-ShowTable-3.3.tar.gz
Msql-Mysql-modules-1.2215.tar.gz . The first two packages completed
successfully byt the
g++ works in the configure stage, but then when I do the gnumake using g++ I get
the following error:
g++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME="\"/usr/local/mysql
\"" -DDATADIR="\"/usr/local/mysql/var\"" -
We're doing some mysql benchmarking. For some reason it seems that ide
drives are currently beating a scsi raid array and it seems to be related
to fsync's. Bonnie stats show the scsi array to blow away ide as
expected, but mysql tests still have the idea beating on plain insert
speeds. Can
# find /usr -name gcc
/usr/local/bin/gcc
# echo $PATH
/sbin:/usr/sbin:/usr/bin:/usr/ccs/bin:/usr/bin/X11:/usr/local:/usr/local/bin
It seems to find gcc for the CC compiler though, and that part of the configure works.
"Matthew P. Marino" wrote:
OK. Much better. The configure can't find gcc.
--- Boulat Khakimov [EMAIL PROTECTED] wrote:
Making install in ./db-3.2.9a/build_unix
make[1]: Entering directory
`/usr/src/mysql-3.23.33/db-3.2.9a/build_unix'
install_include install_lib install_utilities install_docs
make[1]: install_include: Command not found
make[1]: *** [install] Error
Hi guys,
I'm wondering why you prefered mySQL overe Postgres , they are both open
source,
and accorting to many people Postgres is more powerful and stable than
mySQL.
I've been using mySQL for awhile myself, but recently, I've been
extremely frustrated
by mySQLs bugginess ... the BDB
Boulat Khakimov wrote:
Hi guys,
I'm wondering why you prefered mySQL overe Postgres , they are both open
source,
and accorting to many people Postgres is more powerful and stable than
mySQL.
I've been using mySQL for awhile myself, but recently, I've been
extremely frustrated
by
This is just a guess - I have significant experience of Scsi drives but none of Unix
internals. To
do a good sync, you have to force the data from the CPU to the disk, and from the disk
ram onto the
disk oxide. IDE disks are not very clever, and I do not think that they cache
unwritten data.
I'm wondering why you prefered mySQL overe Postgres , they are both open
source,
and accorting to many people Postgres is more powerful and stable than
mySQL.
Hmm... It's free, robust, damn fast, small footprint, lots of free add on software
available, it's free.
The other thing
Here's a strace -r on IDE:
0.001488 write(3, "\214\1\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56
0.000516 fdatasync(0x3)= 0
0.001530 write(3, "\215\1\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56
0.000513 fdatasync(0x3)= 0
0.001555 write(3,
Yeah, it's in the manual.
On Fri, 2 Mar 2001, Progetto 2000 wrote:
Hi,
It's possible to create a database in a differents directories ? And how to
make it ?
Thanks
Carlo Carlini
-
Before posting, please check:
Yes MySQL has excellent support :) Thats why I use MySQL and ASTA MySQL Server. Both
of these are excellent produtcs.
Cheers
Mike
-Original Message-
FROM: [EMAIL PROTECTED]
TO: [EMAIL PROTECTED]
DATE: Fri 3/2/01 11:08
SUBJECT: Re: Why MySQL?
I'm wondering why you prefered mySQL
On Fri, 2 Mar 2001, Nick Kostirya wrote:
Hi, All!
Please, give me an opinion about multiple-column index.
May I create the UNIQUE multiple-column index, which the index of each
column is not UNIQUE in?
If yes than how do it?
Best.
Nick.
When you create a multi-column unique index, it
Hi,
Hmm, MySQL in itself is a wonderful cornerstone for OLAP.
I've set up a MIS that's been running for 16 months now, without a glitch.
The 25 million rows in the main fact table are not a problem.
The trick reads: compressed tables.
But the interface is very poor, MS Query.
Perhaps it would
On Fri, 2 Mar 2001, Gerald L. Clark wrote:
The manual tells you how to reset a forgotten password.
It also tells you not to mess with these tables, but to use.
GRANT and REVOKE. We all have to explore everything,
dont't we?
Worst case, kill mysqld and reinstall privilege tables with
I have filled my hard drive by inserting data into a table (15 gigs).
The table was then corrupted.
I have freed 1 gigs to repair the table and there is nothing else to delete.
How can I repair my table?
__
Dave Loisel
DBA
Wanted technologies
[EMAIL PROTECTED]
It depends on your table type, check the manual, you will want
myisamchk or isamchk if you are using 3.23.x you can do SQL
REPAIR TABLE so long as your table is MyISAM.
Dave Loisel wrote:
I have filled my hard drive by inserting data into a table (15 gigs).
The table was then corrupted.
Hey,
Curious about the maximum string size for various field types. Eg.
VARCHAR or CHAR. It's not really only 255 is it?
Mike Richards
Network Administrator
Harmony Integrated
www.hi.ca
Yes, it really is 255.
need something bigger?
try:
TINYBLOB
MEDIUMBLOB
LONGBLOB
etc..
LONGBLOB will hold L+4 bytes, where L 2^32
2^32 is large enough for most things.
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.954.9133
-Original Message-
From:
Be so kind and read the archives :-). Do you happen to use PHP? If so, get
the newest release from http://snaps.php.net. You should be fine then.
Maciek
-Original Message-
From: Daniel Fritzler [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 5:07 AM
To: [EMAIL PROTECTED]
Hi,
I run into following problem while installing mysql-3.23.33 on Solaris 2.6,
with gcc 2.95.2.
checking return type of sprintf... configure: error: can not run test
program while cross compiling
Please advise.
Sally Guan
Aicent Inc.
408-965-5528 (voice)
408-965-5526 (fax)
[EMAIL PROTECTED]
At 11:05 AM 3/2/01 -0500, you wrote:
On Thu, Mar 01, 2001 at 10:58:03AM -0500, [EMAIL PROTECTED] wrote:
HI, I sent this note a couple days ago and no one has commented. I am
trying to implement DBI-1.14.tar.gz Data-ShowTable-3.3.tar.gz
Msql-Mysql-modules-1.2215.tar.gz . The first two
set your column something like: enum('0','1');
Curtis
On Fri, 2 Mar 2001, Scott Dunn wrote:
I want to have like in Access a column that is yes or no or true or false,
something on that line. I looked at www.mysql.com but could not find
anything. I don't know what exactly I am looking for.
SELECT request.id, request.date, request.type, request.status,
faculty.f_name, faculty.l_name, action.id, faculty.id FROM request INNER
JOIN
faculty ON request.requested_by=faculty.id LEFT JOIN request ON
action.request_id=request.id;
Chris Toth [EMAIL PROTECTED] wrote:
I'm trying to form a
Hi!
"Sasha" == Sasha Pachev [EMAIL PROTECTED] writes:
cut
Sasha I do have a patch for it now. From what I understood in the code, this is
Sasha actually a more correct way to do things, but I would like to get Monty's
Sasha approval to be sure. After the patch, MySQL still passes our test
On Fri, 2 Mar 2001, Evan James Dembskey wrote:
I chose MySQL for our products because I could NOT get postgres to run
on
SCO Openserver, even though it was supposed to be supported.
I tried for 2 months to get help on the postgress mailing list.
Nobody offered ANY help.
I had the same problem. Ensure that /var, /var/lib, and /var/lib/mysql have
permissions: drwxr-xr-x
This should solve your problem for item 1.
rick
-Original Message-
From: Paulus [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 4:09 PM
To: [EMAIL PROTECTED]
Subject: Cant
Tim Bunce wrote:
Only problem we know is that in our tests on ReiserFS is MySQL was 30%
faster on writes :/
How does it compare to FreeBSD with "soft updates" enabled?
Sorry, I use only linux and very rarely touch anything else. So this 30%
was meant under linux. Sorry for confusion. I
I am creating a couple of tables.
Some of the tables call for a column denoting the
entry's type or catagories.
The ENUM and SET types seems to be ideal for this
except for the fact that I wasn't able to add types or
categories dynamicly.
Is there anyway that the ENUM or SET types could be
used
Hello everyone. I am in a real bind. I am trying to get a list of names
from a table where for each name there are several specific entries.
For example, the table looks like this:
ContactID
FactName
Value
for each ContactID, there may be several entries with different fact/values
such as
Hello everyone,
I've figured out what the problem was with getting the configure script to
work (I needed to set the LDFLAGS environment variable to pass a -R
runpath to the compiler for some of the configure tests to build
properly), but now I have a different issue which has cropped up when
I have it running on a few servers here already but one has me
baffled.
O/S is FreeBSD 4.0-RELEASE #0
MySQL is mysql-3.23.33
I'm getting this error:
010302 00:20:57 mysqld started
/usr/libexec/ld-elf.so.1: /usr/lib/libstdc++.so.3: Undefined symbol
"__ti9exception"
010302 00:20:57 mysqld
Craig Ian Dewick wrote:
The build environment of the server machine is a Sun Sparc 20 running
Solaris 8 (aka SunOS 5.8) using gcc-2.95.2 as the compiler. The mysql
source version I'm trying to build is v3.23.33, and it's using
Berkeley DB v3.2.9.
Download BDB v3.2.9a from www.mysql.com
On Wed, Feb 28, 2001 at 02:38:40PM -0500, Michael Villalba wrote:
I have a rather large table (~130 million rows) running under MySQL
3.23.30 and have been very pleased with the performance of the
database. However, occasionally I have to delete millions of rows
from the table, and it
In the last episode (Mar 02), Richard Sexton said:
I have it running on a few servers here already but one has me
baffled.
O/S is FreeBSD 4.0-RELEASE #0
MySQL is mysql-3.23.33
I'm getting this error:
010302 00:20:57 mysqld started
/usr/libexec/ld-elf.so.1:
Hi, mysql users,
I have a problem to upgrade mysql to a newer stable version.
The problem is the database size. It's about 5.4GB.
I have noticed that the database structure has been changed between 3.22 and
3.23. So, I have to dump the whole database(5.4GB) to upgrade.
But, as you know, it is
In the last episode (Mar 03), ho-sang, yoon said:
Hi, mysql users,
I have a problem to upgrade mysql to a newer stable version. The
problem is the database size. It's about 5.4GB.
I have noticed that the database structure has been changed between
3.22 and 3.23. So, I have to dump the
hey,
i'm developing a product that heavily utilizes mysql databases through PHP. The
max number of connections that any server can handle is needed as i have to think of
scaleability issues. The servers are pretty powerful - it maxes out at 4G's 2x850
P-III. I need max performance out
hello All,
I am new to mysql database. I downloaded mysql and running on my
system.
For adminiatrative purpose the command i run as written in manual is
"mysql -u root mysql"
I am unable to understand why i have to write mysql after "-u root" why
not any other database name "test".
Hi,
The maximum number of connections that mysql can accept is restricted by
both: the OS and ulimit. In other words, you can set max_connections as
high as you want without bypassing the limits specified in ulimit.
If you do ulimit -n you should get the number of connections allowed (1024
by
Hello,
I just installed mysql (from source) on three machines,
and I have encountered the same problem on all of them.
Everything appears to work fine (including the benchmark
tests), but when I attempt to run the test suite (the
script mysql-test-run under the source directory), I get
something
76 matches
Mail list logo