#!/bin/bash
#export data from db
#options skip drop and create table

server_number="S10001"

dest_path="./export/"

mysql_password="111111"

#_USER
mysqldump -uroot -p${mysql_password} ${server_number}_USER > ${dest_path}${server_number}_USER.sql --skip-add-drop-table --no-create-info

#_USER 0 ~ 9
for loop in 0 1 2 3 4 5 6 7 8 9
do
	mysqldump -uroot -p${mysql_password} ${server_number}_USER_${loop} > ${dest_path}${server_number}_USER_${loop}.sql --skip-add-drop-table --no-create-info
done