diff options
Diffstat (limited to 'Services/mariadb/sx')
| -rw-r--r-- | Services/mariadb/sx/mariadb.sh | 10 | ||||
| -rw-r--r-- | Services/mariadb/sx/mariadb_run.sh | 7 |
2 files changed, 10 insertions, 7 deletions
diff --git a/Services/mariadb/sx/mariadb.sh b/Services/mariadb/sx/mariadb.sh index af6124b..5b2857d 100644 --- a/Services/mariadb/sx/mariadb.sh +++ b/Services/mariadb/sx/mariadb.sh @@ -88,11 +88,11 @@ function update_rootuser { # Find all sqlfiles in /tmp/ and import then using admin user function import_sqlfiles { - local filedir=$1; local p=$MARIADB_ROOTPWD; + local filedir=$1; local p=$MARIADB_ROOTPWD; local del=$2; if [ "$(ls -1 $filedir | wc -l)" -ge "1" ]; then echo "=> Found SQL files to import ..." for filename in "$filedir"; do - import_sqlfile $filename + import_sqlfile $filename $del done; fi; return 0 @@ -100,10 +100,14 @@ function import_sqlfiles { # Find all sqlfiles in /tmp/ and import then using admin user function import_sqlfile { - local filename=$1; local p=$MARIADB_ROOTPWD; + local filename=$1; local p=$MARIADB_ROOTPWD; local del=$2; if [ -f "$filename" ]; then echo "===> Importing sql file : $filename" mysql -u root -p$p < $filename + if [ "$del" = "delete"]; then + rm -f $filename + echo "====> Deleting $filename after import" + fi; else echo "====> Could not find sql file $filename. Skip import..." fi; diff --git a/Services/mariadb/sx/mariadb_run.sh b/Services/mariadb/sx/mariadb_run.sh index 07a4c03..7dcf9b2 100644 --- a/Services/mariadb/sx/mariadb_run.sh +++ b/Services/mariadb/sx/mariadb_run.sh @@ -2,7 +2,6 @@ source /sx/mariadb.sh begin_config - ## if you wan't to add a new user with database #create_userdb 'dbuser1' 'password' ## if you wan't to add a new user with database (generated password) @@ -15,8 +14,8 @@ begin_config #mysql -u root -p$MARIADB_ROOTPWD -e 'select user, host FROM mysql.user;' ## Execute SQL scripts located into a directory #import_sqlfiles /tmp/sql/*.sql -## Execute a single SQL script -#import_sqlfile /tmp/sql/example.sql - +## Execute a single SQL script and delete it +#import_sqlfile /tmp/sql/example.sql delete end_config + start_daemon
\ No newline at end of file |