Hi Murthy,
murthy gandikota wrote:
Can someone please tell me how to manage multiple disk partitions in mysql?
BTW, the mysql is version 4 or something like that.
When using InnoDB you can just add another tablespace on /var [1]. With
MyISAM it gets a bit more difficult, at least in pre
Hi,
in case you have MyIsam tables you can also use LVM.
Nils Meyer napsal(a):
Hi Murthy,
murthy gandikota wrote:
Can someone please tell me how to manage multiple disk partitions in
mysql? BTW, the mysql is version 4 or something like that.
When using InnoDB you can just add another
Hi !
murthy gandikota wrote:
Hi
[[...]] Mysql is storing data in the /usr partition of Redhat 9.
The /usr partition is about 50% full.
Within a year it will outlast the available space on /usr.
The MySQL data should all be below /usr/local, right ?
It is trivial in Linux (or any
Hi,
I am currently using SuSE and like to be able use myisamcheck when start
up mysql. Is there a command that I can added to my init.d script that
would do that.
Thanks,
Payne
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Guys,
Below is a select query which I'm stuggling with, so I'd be grateful for any
help you could give me.
select distinct TraderPersonalInfo.TraderID,PlatformMap.PlatformID from
TraderPersonalInfo,Locations,PlatformMap,Platforms where
(TraderPersonalInfo.TraderID = PlatformMap.TraderID) and
Perhaps you can add the sql command version of myisamchk to the server
init file to run at startup. Where a line in this file was: myisamchk
tbl_name
[mysqld]
init_file=/path/to/data-directory/mysqld_init.sql
Ed
-Original Message-
From: Payne [mailto:[EMAIL PROTECTED]
Sent: Tuesday,
You need to embed the PlatformMap and Platforms tables twice
Use PM2 as the PlateformMap where PlatformID=2
Use PF2 for PlatformID check of 2
Use PM4 as the PlateformMap where PlatformID=4
Use PF4 for PlatformID check of 4
Join PM2 and PM4 where TraderIDs are equal
select distinct
Hello All,
Does anyone know a quick reference which details a list of ports which are
used my various machine in the MYSQL cluster environment.
We just installed the MYSQL cluster and have the IPTABLES shutdown as we are
not sure which ports are being used by each of these machines. We want to
select distinct
TraderPersonalInfo.TraderID,PM2.PlatformID,PM4.PlatformID
from TraderPersonalInfo,Locations,Platforms PF2,Platforms PF4,
PlatformMap PM2,PlatformMap PM4
where (TraderPersonalInfo.TraderID = PM2.TraderID)
and (PM2.PlatformID = PF2.PlatformID)
and PM2.PlatformID = 2
and
Hi;
I successfully installed MySQL 5.1 from FreeBSD port on both my home server and
the new production server I'm building. Then, stupidly, I taught myself that
one can delete actual files when deleting symlinks :( I wiped out my entire
/usr/local/include dir. Since I had a duplicate on my home
On Tue, Feb 27, 2007 at 06:01:44PM -0500, [EMAIL PROTECTED] wrote:
Hi;
Hi
have you run mysql_install_db on your production server?
Greetings
Mario
--
-
| havelsoft.com - Ihr Service Partner für Open Source |
| Tel: 033876-21 966
MySql 4.1.21
ISAM table
The table has a many fields and a number of rows with auto-incremented ID
I need to set the value in particular fields for some rows to NULL.
Is there a simpler way of doing this than by setting the value for each
of the particular fields to NULL using an UPDATE
20Hi;
I had a working installation of MySQL, and then I zapped it. I found out the
hard way that when you delete symlinks, you also delete the files to which they
are linked :( I wiped my entire /usr/local/include dir. I'm using ports on
FreeBSD 6.2. As it happens, I had a complete copy of the
The log files are named hostname.err and must be located inside your
data dir, which can be inside your /usr/local directory or in the /var/
Carlos
Scott Johnson wrote:
20Hi;
I had a working installation of MySQL, and then I zapped it. I found out the
hard way that when you delete
Hi;
[After waiting 4 hours, I don't think my post posted, so I'm re-posting]
I
had a working installation of MySQL, and then I zapped it. I found out
the hard way that when you delete symlinks, you also delete the files
to which they are linked :( I wiped my entire /usr/local/include dir.
I'm
I have table with next data:
Col.A | Col.B | Col.C
-10 | A | D
-2 | A | R
-3 | B | D
-1 | B | R
What I want is to get next result:
Col.B | Col.A | Desription not in result query
A | -8 | -10-(-2)
B | -2 | -3-(-1)
I am trying for several days without any progress. Can anybody halp me?
Actualy I
16 matches
Mail list logo