Re: Redo logs take to much disk space

2007-05-15 Thread asv
> One question about this, is it safe to turn of log_bin? i think, you can. the log is necessary for data replication and sometimes for data recovery. you can read about it here: http://dev.mysql.com/doc/refman/5.0/en/binary-log.html > Or can you tweak it somehow so that it won't' take some much

Re: Redo logs take to much disk space

2007-05-15 Thread asv
> What can I do to stop this kind of behavior? and is > its safe to delete all the files with a cronjob? and witch files are > recommend to delete if so? just commet log-bin option of [mysqld] section in your my.cnf file (/etc/my.cnf) you can also remove these files manually -- it will not affect

Re: Could query muti sql?

2007-04-13 Thread asv
> Hi, > Could query multi SQLs in a query? How? select x,y,z from foo union select x,y,z from boo; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SQL restore deleted records

2007-04-13 Thread asv
> SQL > Hello, All. > > There is a problem. > Ones many records from MyISAM table are deleted. > Nobody change this table after this. > The records have variable length. > > How can I restore it? > The table format isn't well described in manual, as for me. is not it possible to recover data from m

how to dump triggers separately

2007-03-23 Thread asv
I need to create dump of all triggers in my database (This means that ONLY triggers must be dumped and nothing more: no data and no table structure). Is there any direct (or simple) way to do that? Mysqldump seems to be unable to do that. The only two ways i see -- to create a script that gets t