Restored MySQL backups, now less free space on hard drive

[nemesis_256]

So I had to restore a backup on my server (twice, the first one wasn't right) and now I've lost a bunch of free space on the server. It seems the data wasn't overwritten. How can I delete the old data so I can get my space back? I used the following command to restore the backup.

mysql --user=root --pass=password --host=localhost -e "source /backups/daily/backup.sql" database

[chazzy]

you probably want to drop and recreate the database first.

[nemesis_256]

So if I drop the database now, will I gain all the space from my 2 restores or only from the current database?

[chazzy]

to be honest, i have no idea. it sounds like you restored twice. so if you drop and restore only once, then yeah, probably.