/mnt/data
> Is it a bug?
add --defaults-file=/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 Sela
daemon with databases from
> /opt/mysql/data
> 021112 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 .err file for detail description.
--
Dicky Wahyu P
> doesn't
> > return); instead all is normal 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 A
ile at slave, and compare the
"show slave status" run from slave server with "show master status" run from master
server
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone: +62 21 79199577 - HP: +62 8158787286
W
ion (or mysql base dir) ...
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:
min process.
mysqladmin is not (main) mysql server 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:
create table table2 select * from table1;
mysql> insert into table1 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. Tende
nnect("", "", "")
if it is, so you should remove the "<>" sign, and looks like this :
$link = mysql_connect("localhost", "root", "mypassword")
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Ja
ck and point it to current location...
--
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
-
Be
e the problem remains the same ;)
ups ... sorry ... :))
my 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
x27;help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> repair Collaborate;
> ERROR 1064: You have an error in your SQL syntax near
> 'Vodafone_Collaborate' at line 1
> mysql>
on syntax, your forgot to add ... table ...
sho
code 127: Unknown error 127
127 = Record-file is crashed
Table corrupt ... do
mysql> repair table ;
or
shell# mysqlcheck -r -p
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone: +62 21 79199577 - HP: +62 8158787286
ck -or -A -p
You should avoid kill -9 (safe_mysqld/mysql) ... it's only for "desperate" move ... :D
--
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
-
sometimes we run mysqld more than once ... (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
e more than 2 million records per table and a lot of connections,
it's really depend on your table design and also my.cnf configuration.
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Jakarta Se
ld like to help me :D
--
Write clearly - don't be too clever.
- 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 - Ja
t for preventive action, you can create a scheduled job/task 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 -
--
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 12790
Phone
. if bofhlog found a line with one of these keywords,
then it will alarm you via anything you want (using other tools).
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).
--
f("Detected PenguinPages, getting out of here.\n");
2.0.38 /usr/src/linux/arch/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 127
re.
-- Larry Wall
MySQL 3.23.51 : up 76 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
ccomplished?
from mysql :
mysql> show processlist;
mysql> kill ;
or from shell :
shell> mysqladmin -p processlist
shell> mysqladmin -p kill
or use mytop or mtop ;-)
--
Write clearly - don't be too clever.
- The Elements of Programming Style (Kernighan & Plaugher)
- The Elements of Programming Style (Kernighan & Plaugher)
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
query do want to do ?
shell> mysql -p DB_A
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 Administra
on't be too clever.
- The Elements of Programming Style (Kernighan & Plaugher)
MySQL 3.23.51 : up 74 days, Queries : 358.074 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt.
quot; query on Innodb slower than on
MyISAM ?
What are the reasons ?
Thanks.
--
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
that's why i found your slave
status is a little not "normal" to me :D
as long as what you need is working, then everything is ok ;-)
--
Let's call it an accidental feature.
-- Larry Wall
MySQL 3.23.51 : up 73 days, Queries : 357.245 per sec
column 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 K
mitted by Pancrazio De Mauro, paraphrasing some well-known sales talk
MySQL 3.23.51 : up 68 days, Queries : 358.692 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790
Phone :
DELETE * FROM tablename;
>
> To drop tables ...
> DROP TABLE [IF EXISTS] tablename1 [, tablename2,...] [RESTRICT |
> CASCADE]
... or you just do :
truncate table ;
--
Let's call it an accidental feature.
-- Larry Wall
MySQL 3.23.51 : up 67 days, Queries : 3
x27;%John%' OR Field4 LIKE '%John%' OR Field5 LIKE
> '%John')' part is the problem.
have you try to remove the ORDER BY Field6 ? and compare the query time ?
--
All language designers are arrogant. Goes with the territory...
-- Larry Wall
MySQL 3.23.51
if i specify only a few columns. If i run 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 s
the field on table creation : firstname varchar not null
try to : insert into (firstname) values (NULL); select * from where
firstname is NULL;
--
Write clearly - don't be too clever.
- The Elements of Programming Style (Kernighan & Plaugher)
MySQL 3.23.51 : up 66 d
run the mysqldump :D
--
Write clearly - 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 - Jakar
you notice that you've 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 Admini
d4 from tablename;
or
select * 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
mming 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
Phone : +62 21 79199577 - HP : +62 8551044244 - Web : http://www.1rstwap.com
-
he result.
just do echo "bla bla bla bla
",ereg_replace("$keyword","$keyword",$fetch[field])," ... end of bla bla
bla";
--
Write clearly - don't be too clever.
- The Elements of Programming Style (Kernighan & Plaugher)
MySQL 3.23.51
tion like '%marve%'
What was the error message displayed 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 pe
this command).
>
> Will
http://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
dress to bind to
--
Write clearly - don't 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
ySQL 3.23.51 : up 39 days, Queries : 354.555 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
---
Wall
MySQL 3.23.51 : up 39 days, Queries : 355.458 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
-
code with comments - make every comment count.
- 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)
P
he server - even the
> "mysql"-DB.
grant on . to @ identified by "";
--
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 -
panic("kmem_cache_init(): Offsets are wrong - 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
ver.
- The Elements of Programming Style (Kernighan & Plaugher)
MySQL 3.23.51 : up 37 days, Queries : 353.647 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone : +62 21 79199577 - Web : http://
/local/mysql/var
> on BOTH the mysql daemons.
well, you should check your /etc/init.d/mysql_server or your my.cnf file 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 s
rt 3306 from other computer, 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 Se
processlist only once per hour ---> see my signature ... still
holding 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
olved by repairing the table.
and also to avoid this sleeping threads, you can set 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.5
h password : mysql -u -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 791995
's based on
>directory structure on your filesystem OS. eventhough it's mysql bug and your db
>corrupt, the directory should be still exist and you can see from show databases.
--
printk("??? No FDIV bug? Lucky you...\n");
2.2.16 /usr/src/linux/include/asm-i3
ate !!
-- 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
is ok ... do query "check table
extended" and if it's corrupt ... you have to repair the table ;-)
--
panic("esp: what could it be... I wonder...");
2.2.16 /usr/src/linux/drivers/scsi/esp.c
MySQL 3.23.51 : up 33 days, Queries : 353.747 per seco
linux/drivers/usb/ohci.c
MySQL 3.23.51 : up 33 days, 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
;);
2.2.16 /usr/src/linux/include/asm-i386/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
d":" -f 2`
mysql -e 'insert into wald_data values
("$f_name","$t_name","$sub_p","$sub_g","$date")' -u -p DB_NAME
--
Let's call it an accidental feature.
-- Larry Wall
MySQL 3.23.51 : up 32 day
nd do the query line by line into mysql server
I hope my idea can help u :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
is restarting during your idle activity on client
--
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 K
qladmin -uroot password " ;-)
--
Write clearly - 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
--
Write clearly - don't be too clever.
- The Elements of Programming Style (Kernighan & Plaugher)
MySQL 3.23.51 : up 32 days, Queries : 354.189 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790
??
don't botter the error from make test try to continue with make install,
and start your mysqld ... ;-)
--
Let's call it an accidental feature.
-- Larry Wall
MySQL 3.23.51 : up 32 days, Queries : 354.179 per second (avg).
--
Dicky Wahyu Purnomo - System Admini
design ... not mysql application / OS ;-)
--
Write clearly - don't be too clever.
- The Elements of Programming Style (Kernighan & Plaugher)
MySQL 3.23.51 : up 32 days, Queries : 354.126 per second (avg).
--
Dicky Wahyu Purnomo - System
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 g
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 quer
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 acti
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 confi
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_r
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 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 tri
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 wi
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 ... "sel
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 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 expe
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
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 /usr/src/linu
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 ;
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 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
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: l
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
http://saint
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
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
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 passwo
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 fiel
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 y
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, 04 Jun 2002 08:04:01 +0100
adam <[EMAIL PROTECTED]> wrote:
> Apologies for posting such a basic query, but I couldn't find an
> archived version of the mailing list, or a fix to my problem. Using
> Linux Mandrake 8.2.
>
> It's the problem with mysql.sock, which I've tried to make the /
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 ha
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 poss
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 runni
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 Tue, 14 May 2002 18:49:48 -0400
Augey Mikus <[EMAIL PROTECTED]> wrote:
> what are the -bin.001 002 003 etc.. files in the /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 need the fil
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 phpmy
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_connectio
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 c
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 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. A
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
1 - 100 of 123 matches
Mail list logo