Run cmd command
Type c: or d: on command prompt. This will be based on your WAMP server installations.
Assuming you have installed Wamp on C: drive.
To backup:
To import:
Type c: or d: on command prompt. This will be based on your WAMP server installations.
Assuming you have installed Wamp on C: drive.
C:>cd wamp
C:\wamp>cd bin
C:\wamp\bin>cd mysql
C:\wamp\bin\mysql>cd mysql15. 5.8
C:\wamp\bin\mysql\mysql15.5.8>cd bin
C:\wamp\bin\mysql\mysql15.5.8\bin>mysql.exe -u root
To backup:
mysqldump -u user -p database > backup.sql
To import:
mysql -u user -p database < backup.sql
No comments