MySQL dump with low disk space

disk-spaceMySQLmysqldump

I have an asterisk PBX that has call recordings stored in a SQL database table.

This table has 9199 rows and is consuming 21GB on my server. I want to dump the data in this table to restore space on the server. I also only have 2GB of space left on my server. So could someone please help me with the following:

Is there an issue if I start to flush the table with only 2GB of space on my disk?
What would be the best command to use to flush this table?

Best Answer

Try cleaning the logs if you don't need them.

there is something freak in 9199 rows and consuming 21GB

see Freeing up disk space in 'mysql\data'

Related Solutions

Mysql dump restore doing some funny stuff

I think you meant this:

mysql -u root -p fms < /device.sql

This will import SQL from /device.sql into the fms database

mysqldump only outputs and is not designed to input anything

Doing this

mysqldump -u root -p fms

will echo the mysqldump all all tables currenly in the fms database

Postgresql – Freeing disk space after dropped database

Try sudo lsof| grep deleted and check if any PostgreSQL process appears. This command looks for files which have been deleted but its file descriptors are still open by any process. Another side effect is that df -h and du -sh / differs. This is because du looks at the file system and sum up the size of all files, and df looks at the physical device.

I have just had an issue with a database which didn't free any space after a DROP table and that was the cause.

The only solution I know is to restart the database. Maybe you can try to send a reload (SIGHUP).

Best Answer

Related Solutions

Mysql dump restore doing some funny stuff

Postgresql – Freeing disk space after dropped database

Related Question