OK, I found the answer. The binary log files were filling up (/usr/ local/mysql/data on OS X/mysql-bin.0000x). Easy fix:

        mysql> reset master;

And all the disk space is recovered

On 15-Mar-09, at 10:47 AM, René Fournier wrote:

It seems MySQL isn't releasing disk space on my laptop after I copy a database from one machine to it. From the server, I'm running something like this:

gzip -dc /Backup/Latest/alba2_2009-03-10_00h45m.Tuesday.sql.gz
| mysql -h 192.168.0.224 -u root -p alba2

...every night. And the remaining disk space on my laptop is reduced daily by the size of the database tables I'm dropping and then adding.

Is there something I can do to reclaim that space? I've restarted MySQL and my computer (OS X 10.5.6) to no avail. Thanks.

...Rene


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org

Reply via email to