#!/bin/bash
#import server data into db
#options skip drop and create table

server_number="S10001"

dest_path="./import/"

cd ${dest_path}

mysql_password="111111"

#_USER
mysql -uroot -p${mysql_password} ${server_number}_USER < ${server_number}_USER.sql

#_USER 0 ~ 9
for loop in 0 1 2 3 4 5 6 7 8 9
do
	mysql -uroot -p${mysql_password} ${server_number}_USER_${loop} < ${server_number}_USER_${loop}.sql
done


#back
cd ..