Restore many files sql files in a guided way. Will import any sql fils.
- MYSQL
- PV
cd [path to folder with sql files]
wget https://github.com/raw/Eideen/restoreMySQL/master/db_restore.sh
chmod +x ./db_restore.sh
./db_restore.sh
or
./db_restore.sh [path to folder with sql files]
$ll -h -rw-r--r-- 1 root root 8.3M Nov 7 22:22 db1.sql -rw-r--r-- 1 root root 299M Nov 7 22:22 db2.sql $./db_restore.sh Input username for mysql server [USER]: Input password for mysql server: Input hostname for mysql server [localhost]: list of databases before: * information_schema * mysql * performance_schema Warning: importing database will overwrite your exsisting data! Are you sure, you wanted to import db1 [y/N]y db1 exist importing data in db1 8.24MiB 0:00:16 [ 519KiB/s] [====================================================>] 100% Are you sure, you wanted to import db2 [y/N] db2 exist importing data in db2 298MiB 0:02:39 [1.87MiB/s] [====================================================>] 100% list of databases after: * information_schema * db1 * mysql * db2 * performance_schema