Simplest way to split the backup file is to use a software sqldumpsplitter, which allows you to split the db file into multiple db files. Download here Or else use this terminal command. /path/to/dest/file-SQL Dump Splitter is the ultimate tool for database administrators and developers to split massive SQL dump files into smaller, manageable files. Support MySQL, PostgreSQL, SQL Server, Oracle, DB2, SQLite, preserve SQL syntax integrity, and work seamlessly on Windows, Linux, macOS. Handle large WooCommerce or Shopify exports without import failures or broken transactions. Fast, memory-efficient, multi-dialect. PHP upload limits are not an issue anymore. Just split your dumps into pieces and upload it. The advantage of breaking up the backup into many smaller files is that you can copy the smaller files around your network or to smaller storage devices. Split, merge, convert, validate, sample, shard, diff, redact, and query SQL dump files.
[PDF Version]