mysqldump, DEV notes

DEV notes:

備份mysql:
mysqldump -u [user] -p [databasename] > [YYYYMMDDbackup.sql]

mysqldump -u [user] -p [databasename] [table1 table2] > [YYYYMMDDbackup.sql]

轉server, 抄DB:
mysqldump -u [user] --password=[password] [databasename] | mysql -u [user] --password=[password] [databasname2]

Google