Re: database issues

Karl Latiss wrote:
> On Wed, 2007-08-29 at 19:44 -0700, Ryan Delany wrote:
> > > Well, I hope you have a word of advice here.
I've done:
> > >
> > > ----------
> > >      mysqldump -Q --add-drop-table -u root -p
maia 
> /mnt/dump/maia.sql
> > >      mysql -u root -p
> > >           drop database maia;
> > >           quit;
> > >      /usr/local/etc/rc.d/mysql-server stop
> > > -----------
> > >
> > > After that, I took a look at /var/db/mysql,
and still see 
> 88 mysql-bin.*
> > > files in there with 57g worth of data. Should
that have 
> disappeared? I
> > > assume I can't just nuke them, because the
other databases, namely
> > > information_schema, cluster, mysql, and test
- correct?
> > >
> > > I then followed with
> > >
> > > ----------
> > >      /usr/local/etc/rc.d/mysql-server stop
> > >      mysql -u root -p
> > > ----------
> > >
> > > to start mysql back up again.
> > >
> > > "Now what?", is my plaintive cry.
> > >
> > > Kurt
> > 
> > Kurt,
> > 
> > I'm 99% sure you can just delete the mysql-bin.*
files if 
> you aren't doing
> > any database replication.  If I recall, I had the
same 
> problem as you and
> > almost ran out of disk space before realizing
those files 
> aren't even
> > really necessary.  In fact, you can also turn off
binary 
> logging in my.cnf
> > so those files don't get created anymore.  Google
mysql-bin for more
> > details.
> > 
> > Regards,
> > 
> > Ryan
> 
> That's correct - if you're not replicating to another
MySQL database
> server then you can disable the binary file creation by

> making sure you
> don't have a log-bin entry in my.cnf. If you don't
replicate you can
> stop the database server, remove the binary log files,
remove log-bin
> setting and re-start the database server.
> 
> Also, assuming you don't have innodb_file_per_table set
all your
> databases will live in one file (something like
ibdata1). That's the
> file you probably don't want to delete at this stage.
> 
> Karl.

I've modified the my.cnf to comment out the log-bin line.

Once I restart mysql, can I delete the  mysql-bin.00000x
files, and potentially the  mysql-bin.index files?

Kurt
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users