mysqldump, DEV notes
-
Free tags:
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]