=/mnt/data/my.cnf inline option when running mysqld,
or just edit your safe_mysqld file, you'll find why it's always search in $prefix/var
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone: +62 21 79199577 - HP: +62 8158787286
Web
under 3.53.
Which is the problem ?
maybe the slave still running some processes, so the slave stop will wait until its
turn. :D (check show processlist on slave side)
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone: +62 21
11:59:15 mysqld ended
what system r u using now ?
better to use start-stop init script, can be found inside support-files directory with
name : mysql.server
also see error messages in hostname.err file for detail description.
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP: Jl Kapt
) ...
but remember to move out all the data before you delete the directory if your datadir
is in mysql basedir ;-)
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone: +62 21 79199577 - HP: +62 8158787286
Web: http://www.1rstwap.com
server
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone: +62 21 79199577 - HP: +62 8158787286
Web: http://www.1rstwap.com
-
Before posting, please check:
http
127 = Record-file is crashed
Table corrupt ... do
mysql repair table tablename;
or
shell# mysqlcheck -r -p db table
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone: +62 21 79199577 - HP: +62 8158787286
Web: http://www.1rstwap.com
;
ERROR 1064: You have an error in your SQL syntax near
'Vodafone_Collaborate' at line 1
mysql
on syntax, your forgot to add ... table ...
should be like this :
mysql repair table Collaborate;
but it's only working if you're using MyISAM table type.
--
Dicky Wahyu Purnomo - System Administrator
mistake :D thx jocelyn ... ;-)
sql,query
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone: +62 21 79199577 - HP: +62 8158787286
Web: http://www.1rstwap.com
...
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone: +62 21 79199577 - HP: +62 8158787286
Web: http://www.1rstwap.com
-
Before posting, please check:
http
, root, mypassword)
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone: +62 21 79199577 - HP: +62 8158787286
Web: http://www.1rstwap.com
-
Before posting, please check
select * from table2;
you can also do something like this :
insert into table1(col1,col2,col3) select(col1,col2,something) from table2;
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone: +62 21 79199577 - HP: +62 8158787286
Web
application, it's only for administration (or
control panel).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone: +62 21 79199577 - HP: +62 8158787286
Web: http://www.1rstwap.com
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone: +62 21 79199577 - HP: +62 8158787286
Web: http://www.1rstwap.com
-
Before posting, please check:
http
... (the second one will remove the
mysql.sock but the daemon is still running)
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone: +62 21 79199577 - HP: +62 8158787286
Web: http://www.1rstwap.com
table design and also my.cnf configuration.
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone: +62 21 79199577 - HP: +62 8158787286 - Web: http://1rstwap.com
.
- The Elements of Programming Style (Kernighan Plaugher)
MySQL 3.23.51 : up 2 days, Queries : 340.607 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790
Phone: +62 21 79199577 - HP: +62 8158787286 - Web: http
.
- The Elements of Programming Style (Kernighan Plaugher)
MySQL 3.23.51 : up 2 days, Queries : 459.342 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790
Phone: +62 21 79199577 - HP: +62 8158787286 - Web: http
for repairing your
tables.
--
Write clearly - don't be too clever.
- The Elements of Programming Style (Kernighan Plaugher)
MySQL 3.23.51 : up 2 days, Queries : 459.342 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan
/sparc/mm/srmmu.c
MySQL 3.23.51 : up 0 days, Queries : 773.778 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790
Phone: +62 21 79199577 - HP: +62 8158787286 - Web: http://www.1rstwap.com
).
It's real time monitoring ;-)
--
C is quirky, flawed, and an enormous success
-- Dennis M. Ritchie
MySQL 3.23.51 : up 0 days, Queries : 776.454 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790
Phone: +62 21
)
MySQL 3.23.51 : up 76 days, Queries : 359.985 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790
Phone: +62 21 79199577 - HP: +62 8158787286 - Web: http://www.1rstwap.com
:
shell mysqladmin -p processlist
shell mysqladmin -p kill thread_id
or use mytop or mtop ;-)
--
Write clearly - don't be too clever.
- The Elements of Programming Style (Kernighan Plaugher)
MySQL 3.23.51 : up 76 days, Queries : 359.985 per second (avg).
--
Dicky Wahyu Purnomo
days, Queries : 360.006 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790
Phone: +62 21 79199577 - HP: +62 8158787286 - Web: http://www.1rstwap.com
.
--
Don't patch bad code - rewrite it.
- The Elements of Programming Style (Kernighan Plaugher)
MySQL 3.23.51 : up 74 days, Queries : 357.886 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790
Phone : +62 21
3.23.51 : up 74 days, Queries : 358.074 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790
Phone : +62 21 79199577 - HP : +62 8551044244 - Web : http://www.1rstwap.com
mysql select * from DB_B.Table_B1;
it's crossing other DB ;-)
--
Let's call it an accidental feature.
-- Larry Wall
MySQL 3.23.51 : up 75 days, Queries : 358.102 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790
on show slave status : empty ;-)
--
Write clearly - don't be too clever.
- The Elements of Programming Style (Kernighan Plaugher)
MySQL 3.23.51 : up 73 days, Queries : 357.128 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34
: up 73 days, Queries : 357.245 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790
Phone : +62 21 79199577 - HP : +62 8551044244 - Web : http://www.1rstwap.com
68 days, Queries : 358.692 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790
Phone : +62 21 79199577 - HP : +62 8551044244 - Web : http://www.1rstwap.com
the ORDER BY Field6 ? and compare the query time ?
--
All language designers are arrogant. Goes with the territory...
-- Larry Wall
MySQL 3.23.51 : up 67 days, Queries : 358.251 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta
...
DROP TABLE [IF EXISTS] tablename1 [, tablename2,...] [RESTRICT |
CASCADE]
... or you just do :
truncate table tablename;
--
Let's call it an accidental feature.
-- Larry Wall
MySQL 3.23.51 : up 67 days, Queries : 357.694 per second (avg).
--
Dicky Wahyu Purnomo - System
://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Column_types
--
Write clearly - don't be too clever.
- The Elements of Programming Style (Kernighan Plaugher)
MySQL 3.23.51 : up 66 days, Queries : 356.361 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT
on update query ?
From the syntax, it's ok for me :D
--
Write clearly - don't be too clever.
- The Elements of Programming Style (Kernighan Plaugher)
MySQL 3.23.51 : up 66 days, Queries : 356.361 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt
of bla bla
bla;
--
Write clearly - don't be too clever.
- The Elements of Programming Style (Kernighan Plaugher)
MySQL 3.23.51 : up 66 days, Queries : 356.493 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790
= something;
if the results is not 0 then there is someone book the caravan on that date.
--
Write clearly - don't be too clever.
- The Elements of Programming Style (Kernighan Plaugher)
MySQL 3.23.51 : up 66 days, Queries : 356.493 per second (avg).
--
Dicky Wahyu Purnomo
* from tablename group by fieldX;
--
Avoid unnecessary branches.
- The Elements of Programming Style (Kernighan Plaugher)
MySQL 3.23.51 : up 66 days, Queries : 356.521 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta
lost some
records ?
have you try to repair the table ?
;-)
--
Avoid unnecessary branches.
- The Elements of Programming Style (Kernighan Plaugher)
MySQL 3.23.51 : up 66 days, Queries : 356.521 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt
- don't be too clever.
- The Elements of Programming Style (Kernighan Plaugher)
MySQL 3.23.51 : up 66 days, Queries : 356.856 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790
Phone : +62 21 79199577 - HP
into table (firstname) values (NULL); select * from table where
firstname is NULL;
--
Write clearly - don't be too clever.
- The Elements of Programming Style (Kernighan Plaugher)
MySQL 3.23.51 : up 66 days, Queries : 356.880 per second (avg).
--
Dicky Wahyu Purnomo - System
the same join query with lots of
columns, it only fetches 8000 odd records.
could u show us both of the queries ? :D
--
Let's call it an accidental feature.
-- Larry Wall
MySQL 3.23.51 : up 67 days, Queries : 357.150 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT
be too clever.
- The Elements of Programming Style (Kernighan Plaugher)
MySQL 3.23.51 : up 40 days, Queries : 355.401 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone : +62 21 79199577 - Web : http
.
- The Elements of Programming Style (Kernighan Plaugher)
MySQL 3.23.51 : up 39 days, Queries : 354.818 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone : +62 21 79199577 - Web : http://1rstwap.com
... if there's, then the query just prompt an
error message ... and no data will be lost ... ;-)
but for extra backup, you can also do the first query :D
--
Let's call it an accidental feature.
-- Larry Wall
MySQL 3.23.51 : up 39 days, Queries : 355.458 per second (avg).
--
Dicky Wahyu
(avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone : +62 21 79199577 - Web : http://1rstwap.com
-
Before posting, please check:
http://www.mysql.com
to user@host identified by password;
--
printk(??? No FDIV bug? Lucky you...\n);
2.2.16 /usr/src/linux/include/asm-i386/bugs.h
MySQL 3.23.51 : up 38 days, Queries : 353.795 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta
or even you
/usr/local/mysql/bin/safe_mysqld ;-)
--
Let's call it an accidental feature.
-- Larry Wall
MySQL 3.23.51 : up 37 days, Queries : 353.656 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone
);
$string=whatevercolumns like \%$query%\;
select * from whatevertable where $string;
--
Write clearly - don't be too clever.
- The Elements of Programming Style (Kernighan Plaugher)
MySQL 3.23.51 : up 37 days, Queries : 353.647 per second (avg).
--
Dicky Wahyu Purnomo - System
- I've been messed with!);
2.2.16 /usr/src/linux/mm/slab.c
MySQL 3.23.51 : up 37 days, Queries : 353.644 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone : +62 21 79199577 - Web : http://1rstwap.com
with password : mysql -uusername -p
--
Let's call it an accidental feature.
-- Larry Wall
MySQL 3.23.51 : up 34 days, Queries : 355.101 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone : +62 21 79199577 - Web
the interactive_timeout to
reasonable value or run command to kill sleep/idle processes which sleeping over
sometimes.
--
Let's call it an accidental feature.
-- Larry Wall
MySQL 3.23.51 : up 35 days, Queries : 355.738 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP
on ;-)
--
Let's call it an accidental feature.
-- Larry Wall
MySQL 3.23.51 : up 35 days, Queries : 355.724 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone : +62 21 79199577 - Web : http://1rstwap.com
, the connection will be refused
:D
--
Let's call it an accidental feature.
-- Larry Wall
MySQL 3.23.51 : up 35 days, Queries : 355.724 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone : +62 21 79199577 - Web
see from show databases.
--
printk(??? No FDIV bug? Lucky you...\n);
2.2.16 /usr/src/linux/include/asm-i386/bugs.h
MySQL 3.23.51 : up 34 days, Queries : 354.952 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan
, Queries : 354.803 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone : +62 21 79199577 - Web : http://1rstwap.com
-
Before posting, please check
/drivers/scsi/esp.c
MySQL 3.23.51 : up 33 days, Queries : 353.747 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone : +62 21 79199577 - Web : http://1rstwap.com
!!
-- Felix von Leitner, [EMAIL PROTECTED]
MySQL 3.23.51 : up 33 days, Queries : 353.598 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone : +62 21 79199577 - Web : http://1rstwap.com
Plaugher)
MySQL 3.23.51 : up 32 days, Queries : 354.126 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone : +62 21 79199577 - Web : http://1rstwap.com
call it an accidental feature.
-- Larry Wall
MySQL 3.23.51 : up 32 days, Queries : 354.179 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone : +62 21 79199577 - Web : http://1rstwap.com
, Queries : 354.189 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone : +62 21 79199577 - Web : http://1rstwap.com
-
Before posting, please check
- don't be too clever.
- The Elements of Programming Style (Kernighan Plaugher)
MySQL 3.23.51 : up 32 days, Queries : 354.217 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone : +62 21 79199577 - Web
--
Don't stop with your first draft.
- The Elements of Programming Style (Kernighan Plaugher)
MySQL 3.23.51 : up 32 days, Queries : 354.225 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone : +62 21 79199577
:D
--
Manchmal stehe nachts auf und installier's mir einfach...
-- H0arry @ IRC
MySQL 3.23.51 : up 32 days, Queries : 354.247 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone : +62 21 79199577 - Web
)' -uuser -pyour_password DB_NAME
--
Let's call it an accidental feature.
-- Larry Wall
MySQL 3.23.51 : up 32 days, Queries : 354.257 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone : +62 21 79199577
/bugs.h
MySQL 3.23.51 : up 32 days, Queries : 354.631 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone : +62 21 79199577 - Web : http://1rstwap.com
Pada Wed, 10 Jul 2002 20:17:51 -0700
Bennett Haselton [EMAIL PROTECTED] menulis :
I have a database in which one MYD file has apparently been corrupted:
mysql use tracerlock;
Reading table information for completion of table and column names
You can turn off this feature to get a
Pada Mon, 8 Jul 2002 16:07:04 +0530
Arul [EMAIL PROTECTED] menulis :
Hi All
The Query below took around 175 Secs to return 22 Rows..Any way this query
can be optimized
try to use group by instead of distinct i usually found group by is faster ;-)
anyway ... performance of query is
Pada Sun, 7 Jul 2002 17:53:08 +0500
Impex Holidays Maldives / Hasan [EMAIL PROTECTED] menulis :
Hi,
This may be out of topic,but still I'm working on a mysql back up file.
Does any one have a shell script to ftp a file to another location, so that I can
schedule to run this file with cron.
Pada Sat, 06 Jul 2002 15:10:43 +
duo fu [EMAIL PROTECTED] menulis :
Dear Friends:
I have installed Apache 1.3.26, MySQL.3.23.51 successfully. However, I
failed to install tarball versions of PHP4.21 with Apache1.3.26 under my
REDHAT 6.2. I always got the error message when I tried to
Pada Sat, 6 Jul 2002 12:22:44 +0400
Papa Carlo [EMAIL PROTECTED] menulis :
mysqldump incorrectly export char/varchar binary and *BLOB fields.
it export binary fields like text strings
INSERT INTO users VALUES (7,'zk',1,'¦î¯¯Çbv','ó+:ºÐ','Ó]¦Ç\ZW¦{','T~âxÎË-','T
üc¦SüG\R-¦Íê');
Pada Sat, 06 Jul 2002 09:36:27 +0500 (IST)
VINOD [EMAIL PROTECTED] menulis :
I own a domain with MySQL support. I have created a database
lnet_cal on the web and also table yarntype, using PHP Myad-
min on the webspace and also granted all access privileges to
user lnet_root to the
Pada Fri, 05 Jul 2002 14:19:21 -0700
Desmond Lee [EMAIL PROTECTED] menulis :
Hi guys
I just managed to install mysql... yippy
But, i had to use the '--force option' when executing the
/usr/local/mysql/scripts/mysql_install_db .
I got a message saying that i needed to configure the
Pada Sun, 7 Jul 2002 13:04:02 -0400
sajiddalvi [EMAIL PROTECTED] menulis :
Is there a way to check which my sql user (who has logged into the database)
has inserted a row in a table?
I could add a logged_in_user column but that seems redundant.
you can set your mysqld to log all activities
Pada Thu, 4 Jul 2002 10:40:36 +0200
Simas Cepaitis [EMAIL PROTECTED] menulis :
Hello,
I have a problem that happens periodically on my FreeBSD 4.6 box.
Somehow MySQL (3.23.49) stops responding after some period. It
doesn't allow to connect any user except root ( and it's not
Pada Thu, 4 Jul 2002 11:34:12 +0200
W. Enserink [EMAIL PROTECTED] menulis :
Hi all,
is it possible to exclude columns in a query?
something like
select * from table except columnname ??
Nope, I don't think it's possible ...
You have to give columns list, like this ... select
Pada Wed, 3 Jul 2002 16:39:03 -0700
Eric Mayers [EMAIL PROTECTED] menulis :
Hello All,
I'm using mysql version 3.23.47 as a database in an embedded device. In
the startup scripts for the database I have it run :
myisamchk -o -s /usr/local/var/data/*/*.MYI
(to fix any possible problems)
Pada Wed, 3 Jul 2002 12:56:30 -0700
Jeff Kilbride [EMAIL PROTECTED] menulis :
Is this just a normal timeout error, because there's currently very little
activity on these machines? Or is there some other problem? The
slave_net_timeout value is at it's default of 3600, so I would expect to
Pada Mon, 1 Jul 2002 09:01:13 +0200
Wouter van Vliet [EMAIL PROTECTED] menulis :
I would use
WHERE skill LIKE %powerpoint% OR skill LIKE %PHP%
where skill REGEXP powerpoint or skill REGEXP php
--
#ifdef STUPIDLY_TRUST_BROKEN_PCMD_ENA_BIT
2.4.0-test2
On Thu, 27 Jun 2002 09:01:58 +0100
Simon Green [EMAIL PROTECTED] wrote:
Sorry I should have made this a bit clear.
I have to tables with users names in them.
All I need is a list on the Usernames that are in one column but not the
other.
The problem is like Mr DuBois said, is that I get
On Thu, 27 Jun 2002 17:37:24 -0700
Patelli Paolo [EMAIL PROTECTED] wrote:
mysql SHOW MASTER STATUS;
++--+--+--+
| File | Position | Binlog_do_db | Binlog_ignore_db |
++--+--+--+
On Fri, 28 Jun 2002 10:46:40 +0800
lorenzo.kh [EMAIL PROTECTED] wrote:
mysql select * from mytable' ( I key in ' instead of ; )
'
' ?
' what the key should i use to reset this?
'
'
'
'
'
just type another ' and close with ;
sample :
' ';
mysql
On Wed, 26 Jun 2002 18:13:07 -0700 (PDT)
Henry Hank [EMAIL PROTECTED] wrote:
Mysql has crashed twice in the last month with the same errors in the error
log (see log below). I attempted to resolve the stack dump, but when I do nm
-n libexec/mysqld /tmp/mysqld.sym I get a nm:
On Tue, 25 Jun 2002 15:49:41 +1000
Danny [EMAIL PROTECTED] wrote:
Besides using Phpmyadmin to edit the data. I actually prefer to use
something like webmin to manage my data.
Do a search on Webmin on the internet.
actually, i also created my own tools ... saintSQLadmin
On Sat, 22 Jun 2002 11:37:29 +0200 (CEST)
Careri Giuseppe [EMAIL PROTECTED] wrote:
DWP just do from mysql prompt :
DWP mysql repair table [tablename]
REPAIR TABLE doesn't repair BDB tables!
Infact I can not repair BDB table, but when a index is corrupted
what can I do ???
On Fri, 21 Jun 2002 14:36:28 +0700
ihwan [EMAIL PROTECTED] wrote:
Dear All,
I have a trouble with my database using mysql.
The problem is one of the table can not increase new record.
and I can not add new data to that table.
The last row is no. 226428
I don't use number field type for
On Fri, 21 Jun 2002 03:59:33 -0400
david [EMAIL PROTECTED] wrote:
[root@RR davidwri]# mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
[root@RR davidwri]# mysql -u root -p mysql
Enter password:
On Fri, 21 Jun 2002 09:51:35 +0200
Giuseppe Careri [EMAIL PROTECTED] wrote:
Hi,
i have a problem with an index of a BerkeleyDB table because this is corrupted
and crashes Mysql (v. 3.23.49).
The size of table file is correct 8Mb for 15.000 records but from a select
I view only the
On Tue, 11 Jun 2002 08:36:55 +0200
Leo De Geer [EMAIL PROTECTED] wrote:
im not abel to get mysql to use more then one thread on my freebsd 4.5-stable
any one having a klue that wrong?
from what method / tools, you get this information ?
try mysqladmin -p status
--
Linux is not
On Tue, 11 Jun 2002 09:04:36 +0100
Kaan Oglakci [EMAIL PROTECTED] wrote:
Thanks Dan And Okan for replying to my email but I have tried what you have
said but I still get the same problem.
GRANT ALL ON newstesting.* 'clients'@'%' IDENTIFIED BY '123';
ERROR 1064: You have an error in your
On Wed, 29 May 2002 11:24:36 +0100 (BST)
ritu singla [EMAIL PROTECTED] wrote:
Hello!
specifying a column as unique or primary in MySQL
creates indices automatically or do we need to do it
explicitly using INDEX(unique/primary_colname) in
CREATE TABLE command of MySQL??
yes, you have to
On Sun, 26 May 2002 23:15:22 +0200
Bjarne Jørgensen [EMAIL PROTECTED] wrote:
Hi!
I've watched the development of replication on mysql with great joy.
However I haven't been able to understand when og if mysql is going to
support 2 way replication. In other words.
Will it be possible to
On Thu, 16 May 2002 17:05:25 +0800
Jack [EMAIL PROTECTED] wrote:
Dear all
I had a mysql Database in one of my Server, now i want to transfer this
whole Database to another Server, what should i do?
1. How i can export this Database to a file
If your DB server (source) is not running ...
On Wed, 15 May 2002 01:33:47 +0200
Schoenland, Daniel \(intern\) im Auftrag von Schoenland, Daniel \(extern\)
[EMAIL PROTECTED] wrote:
Hi,
Well, I am new to the list.. so if i ask something stupid, just slap me
on the back of my head, k? =)
I was playing a little with my phpmyadmin and
On Tue, 14 May 2002 18:49:48 -0400
Augey Mikus [EMAIL PROTECTED] wrote:
what are the host-bin.001 002 003 etc.. files in the mysql_dir/var
directory? On my system they range in size from bytes to gigs. What
are they and can they be cleaned?
it's mysql binary log file ... if you don't
Hi,
I have short question ...
my mysql daemon sometimes restarted ... and the error message like this :
020429 11:19:36 Slave: connected to master '[EMAIL PROTECTED]:3306', replica
tion started in log 'austria_replication.048' at position 95670800
mysqld got signal 11;
This could be because
On Mon, 6 May 2002 15:21:54 +0900
Sven Bentlage [EMAIL PROTECTED] wrote:
Hi !
Just read about the possibility of replicating two databses.
Can you tell me how to do it or send me a (link to a) manual?
Actually is not only replicating 2 DB, but replication between several DB server.
You can
On Mon, 06 May 2002 12:56:52 -0400
Gurhan Ozen [EMAIL PROTECTED] wrote:
Hi,
Change the max_connections variable's value to a higher value. By default it
is set to 100. You can see what yours is set to with SHOW VARIABLES command.
See:
http://www.mysql.com/doc/T/o/Too_many_connections.html
On Mon, 6 May 2002 07:44:04 +0200
Ewan Sadie [EMAIL PROTECTED] wrote:
I have installed MySQL on two of my MS-Proxy servers. I am logging all
web browser logs to MySQL.
I want to replicate the database to a central server where I can do
queries on the data. I do not want to run select
On 3 May 2002 05:06:12 -
Jagadeesh Suryadevara [EMAIL PROTECTED] wrote:
When i check in the folder where it is loaded MySQL there are some
applications
with names MySQLManager,WinMysqladmin in bin directory.
When click on these applications it showing some screens but we
are unable
On Sat, 4 May 2002 07:23:46 +0400
support [EMAIL PROTECTED] wrote:
Hello, everybody!
Please give me a hint at some resources about synchronization of two
MySQL databases, situated in different places.
The point is, I have my local and providers' versions of the same
database. And need
On Thu, 02 May 2002 13:11:23 +0400
Sheni R. Meledath [EMAIL PROTECTED] wrote:
Using the second command I can't display all the records.
But using separate select statement I can select display any record which
is not displayed in the above case.
###
$result=mysql_query(select * from
1 - 100 of 121 matches
Mail list logo