MySQL CMD

 mysql -h 127.0.0.1 -P 3305 -u admin -p

mysql> SHOW DATABASES; # 데이터베이스 리스트 조회
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select user, host from user;
+------------------+-----------+
| user             | host      |
+------------------+-----------+
| analyzer         | %         |
| root             | 127.0.0.1 |
| root             | ::1       |
| debian-sys-maint | localhost |
| root             | localhost |
+------------------+-----------+
5 rows in set (0.00 sec)
출처: https://technote.kr/32 [TechNote.kr:티스토리]

mysqldump --no-create-info .. # schema dump는 안함.

# example
mysqldump --host host -u admin 
-p --no-create-info itgo_dev user app_binary 
app_package app_resource app_type bank_code broker > dump.sql

# restore 
sql 파일이 존재하는 경로에서 mysql 실행 후
# source <sql 파일이름>


mysqldump --host <host>
-u admin -p --no-create-info itgo_dev 
user broker call_destination call_grade call_info call_request_black_driver 
call_request_favorite call_request_info call_route caller 
caller_group carrier_consignor carrier_driver_group \
company delivery_receipt driver driver_group driver_location \
driver_work_hours event freight freight_call_request loading_information \
location_information membership_contract membership_corporation membership_franchise \
 membership_oauth membership_screening notice order_info \
  passbook resident_number screening settlement \
  tax_invoice_info term_agreement term_content \
  transport_plan transport_step user_status \
  vehicle withdrawal_user > dump.sql