[Maia-users] database issues

[Ryan Delany]

> 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