SQLè¯å¥å¤ä»½åæ¢å¤
SQL Server:
å¤ä»½å½ä»¤ï¼
BACKUP DATABASE test
TO disk = 'c:\test'
WITH FORMAT,
NAME = 'Full Backup of MyNwind'
解éå¦ä¸ï¼
NAME = 'Full Backup of MyNwind' --è¿ä¸ªæ¯å¤æ³¨ï¼é便åã
è¿åå½ä»¤ï¼
USE master
GO
RESTORE DATABASE test_wt
FROM disk = 'c:\test_wt'
GO
MySQL:
å¤ä»½:
mysqldump -u root -p database_name > d:\db.bak
æ¢å¤:
mysql -u root -p database_name < d:\db.bak
注æ:å¨WINä¸,è·¯å¾ç¨path/filename.sqlæ¯ä¸è¡ç,é£å°±ç¨path\filename.sql
温馨提示:答案为网友推荐,仅供参考