mydump split

mydump split

sudo yum -y install gcc-c++

sudo yum -y install gcc

wget https://github.com/wdelfuego/mysqldumpsplitter/archive/refs/heads/master.zip
sudo yum install unzip zip -y
sudo yum -y install gcc-c++

Make sure the compiled file (in our case, ‘sqlsplitter’) is executable (‘chmod +x sqlsplitter’), then run the following single command:

./sqlsplitter input_filename max_output_filesize_in_bytes
For example, to split dump.sql into files of 1MB each:

./sqlsplitter dump.sql 1048576
Which will result in a list of files named 00000-dump.sql, 00001-dump.sql, et cetera.

https://github.com/wdelfuego/mysqldumpsplitter/

/home/etc/work/sqlsplitter 20220301031001.sql 524288000
500M