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
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 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".
I
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 of
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
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 i
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: /usr/lib/libs
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 a
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.c
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 end
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
tr
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 hair
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 to
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 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 conec
1)
I've installed mysql from rpm.
When i try to connect with database using:
mysql database_name -uusername -ppassword from a root account it works.
When i log in as other user and i type
mysql database_name i got the message :
Cant connect to local mysql server using socket.
User 'us
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.
>
>
>
Hi!
> "Sasha" == Sasha Pachev <[EMAIL PROTECTED]> writes:
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
Maciek,
I read the whole list but the solution wasn't there. I'm using an
application written in C and it does a mysql_close() each time the
application exits.
Thank you.
Dan
> -Original Message-
> From: Maciek Uhlig [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 02, 2001 5:26 PM
> T
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
I'm trying to form a select statement that will match up all relevent data
from a database for a trouble-ticket system. The select statement below is
the only way I can figure out how to do it. However, the last line " AND
action.request_id=request.id" worries me, because what if there are no
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
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
Hi Sasha,
The patch you sent me seems to have created other problems,
or simply has allowed to find new ones :)
I'm working on isolating exactly which query makes the bdb
tables crash. Full bug report on the way.
So far, it looks like left joins on bdb tables does something weird.
I was using
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]
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]
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:
Dave Loisel wrote:
>
> 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?
>
If you mean that 1 gig is not enough free space, the
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
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 corrupte
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]
---
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
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 ma
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 i
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 o
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 chec
I'm going to do a site involving a "shopping cart." I'm planning to use
mysql for back-end DB stuff already (other than shopping cart).
Does anybody recommend building a CCVS "shopping cart" or recommend a
particular software package to help with this??
Price is not really the primary issue, si
> 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
> 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.
Funny, I had the same experience. The only reason I
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. If
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 frustrate
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, "\216\
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 transactio
--- 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
# 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.
Hi,
> I am trying to insert this into my table but mysql doesn't like my syntax.
>
> alter table categoryminor solvalveyn enum('True','False');
You missed something from the query. It should be:
ALTER TABLE categoryminor ADD COLUMN solvalveyn ENUM('True', 'False');
^^
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\"" -
DSHAREDIR="\"/usr/local/mysql/sha
On Fri, Mar 02, 2001 at 11:30:31AM -0500, Terry Babbey wrote:
> Here is my configure statement and the generated error message ( I am using
> GCC2.95.2):
>
> CC="gcc" CXX="gcc" ./configure --prefix=/usr/local/mysql
Have you tried CXX="g++"? The C++ compiler of the GNU Compiler Suite
is g++, you
Here is my configure statement and the generated error message ( I am using
GCC2.95.2):
CC="gcc" CXX="gcc" ./configure --prefix=/usr/local/mysql
checking whether the C++ compiler (gcc ) works... no
configure: error: installation or configuration problem: C++ compiler cannot cre
ate executables
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 an
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 t
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 needin
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
_
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 manua
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
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 `ip_to_hostname(i
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 lo
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
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
I guess the mysqld is already running on port 3306(default port). I aldo had the same
problem.
The solution is
shell> MYSQL_UNIX_PORT=/tmp/mysqld-new.sock
shell> MYSQL_TCP_PORT=3307
shell> export MYSQL_UNIX_PORT MYSQL_TCP_PORT
shell> scripts/mysql_install_db
shell> bin/safe_mysqld &
It is given
When you delete somthing... is there any way to recover the data??
mvh:
Pål 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 ~
-
"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 l
So sprach Robert Vetter am Thu, Mar 01, 2001 at 04:55:34PM +0100:
> 1 or 2 bytes, depending on the number of enumeration values (65535
> values maximum). I've read this in the _MANUAL_ !
Heh, okay, thanks *G*
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (
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
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
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 ch
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:
>
On Fri, 2 Mar 2001 14:00:21 - , Jon Haworth <[EMAIL PROTECTED]>
wrote:
You can use the datatype:
col_name ENUM('True','False') # True or False
or
col_name SET('True','False') # only these value will be excepted
>>I usually use a tinyint with a value of 1 for true, and 0 for false. There
>>do
You need to include libz.
add -lz to your library list in your cc command
Maurizio wrote:
>
> 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 cop
I usually use a tinyint with a value of 1 for true, and 0 for false. There
doesn't appear to be a boolean datatype in MySQL, but I may have missed it
:-)
HTH
Jon
-Original Message-
From: Scott Dunn [mailto:[EMAIL PROTECTED]]
Sent: 02 March 2001 13:55
To: Mysql
Subject: yes/no
I want
You need only one SELECT statement, a join:
SELECT s.fname, s.sname, s.studnum, s.subject, s.result, s.code, r.dbox
FROM student s, result_meaning r
WHERE s.code = r.code
AND s.studnum =
The results returned by mysql_use_result() and mysql_fetch_row()
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.
-
I would like to know how you can stop logging without exiting the mysql session. For
example in SQL you have the spool command and when you want to stop logging you just
type spool off. Is there anything similar in mysql?
I look forward to hearing from you soon.
Thanks in advance.
George
Within safe_mysqld, you can assign any pathname you want to the pid file and
then just make sure that the command to launch mysqld includes it as an
argument. After doing this, you will have what you want.
safe_mysqld:
---
:
:
$pid_file = /tmp/whateveryouwant.pid
:
:
:
if test "$#" -eq 0
peter lindsay writes:
> 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
>
>
Hi!
All you h
Gerhard Prilmeier writes:
> Hello,
>
> Unfortunately I don't have much Unix experience by now and don't know
> how to use make commands. I downloaded the mysql++ source from
> www.mysql.com but couldn't get it to work with vc++. The version
> compiled for Borland also just produced lots of
On Fri, Mar 02, 2001 at 09:27:50AM +1300, Quentin Bennett wrote:
> Hi,
>
> Would
>
> ALTER TABLE mytable ADD INDEX (somecol, othercol), ADD INDEX (othercol);
>
> do this in one sweep of the table, creating one temporary copy, or go
> through the table twice, one for each index?
>
One run for
Does anyone know if there an open-source OLAP product for MySQL?
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 pos
Hello,
Unfortunately I don't have much Unix experience by now and don't know
how to use make commands. I downloaded the mysql++ source from
www.mysql.com but couldn't get it to work with vc++. The version
compiled for Borland also just produced lots of errors.
Can you help me to configure the mys
>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: reco
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 co
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
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
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 3.23.
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 (MILITÆRTEKNISKE SPM)
but returns
TV2
as well as
NORDISK SAMARBEID
Thanks
Michael
-
I have heard from somebody that MySQL index is case insensitive. If this is
true, how can I set it to case sensitive?
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 |
+
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 chec
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 the
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 t
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\""-DHAVE_CO
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
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.
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/
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 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, my
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, mysql_config,
99 matches
Mail list logo
