huge sql dump even after deleting large number of rows of data

Question

The size of sql dump is same(30GB) even if I delete large number of rows from mysql (myisam) table

note: this variabe is innodb_file_per_table ON

mysql> delete from radacct where YEAR(acctstarttime)='2014';
Query OK, 1963534 rows affected (1 hour 30.58 sec)

Maybe this will help: http://stackoverflow.com/questions/3456159/how-to-shrink-purge-ibdata1-file-in-mysql — mitkosoft, Jun 22 '16 at 13:29

score 0 · Answer 1 · edited May 23 '17 at 12:00

what it the question ? if you have troubles with storin bakup in once.

maybe it will be esyer to transport it for you if it was smaller in size, bud more parts ?

part 1

select *  from radacct where YEAR(acctstarttime)='2014' and id<100000000 order by id asc;

part 2

select *  from radacct where YEAR(acctstarttime)='2014' and id<200000000 order by id asc;

etc ...

And after you cound compres it

PS: I cant add replay to your comment. so i will add it here:

1 Answers1