Save and Load Session, Saving/loading session, execute repeatly.
Command Line, Execute on command line.
Task Scheduler, Execute automatically at specific time.
Split SQL dump file by tables
Split SQL dump file by file size
How To
Split large SQL dump file into smaller SQL files