Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column To disable safe mode, toggle the option...
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column To disable safe mode, toggle the option...
網路上搜尋了一下,找到了下面幾個方法,但是看起來還是用最後兩個方法比較安全
[方法1] 用RENAME指令
語法:RENAME DATABASE db_name TO new_db_name
(環境:Windows 7, MySQL 5.6)
-- 備份 --
備份所有DB
> mysqldump -u root -p --all-databases > backup.sql
備份DB
> mysqldump -u root -p db_name > backup.sql
備份table
> mysqldump -u root -p db_name table_name > backup.sql
只備份DB schema
> mysqldump -u root -p db_name --no-data > backup.sql
-- 復原 --
復原某個DB (需先建好DB,dump出來的sql裡沒有CREATE DB的指令)
> mysqladmin -u root -p create db_name
> mysql -u root -p db_name < backup.sql
復原多個DB (sql內有CREATE DATABASE指令,不需先建DB)
> mysql -u root -p < backup.sql