Monday, January 1, 2018

MySQL dump on remote host

Backup remove MySQL database to local file can be done with a simple interactive command that asks you for password in following step:
mysqldump -P [portnumber] -h [host] -u [user] -p [databasename] > C:\data\my.sql 

No comments:

Post a Comment