backup mysql data using mysqldump

mysqldump -u root -p Ror232_PROD_HR
此法必需輸入root passwd後方能執行

mysqldump (-h hostname) -u root --password=xxxx Ror232_PROD_HR
此法不需手動輸入root passwd

以上會Create Tables 但不會Create Databases

mysqldump (-h hostname) -u root --password=xxxx -B Ror232_PROD_HR Ror232_PROD_SYS |more
以上會Create Tables & Create Databases