1. SSH into your instance.
2. Edit /etc/ssh/sshd_config and set PasswordAuthentication to yes.
One way to do this is to enter the command vi /etc/ssh/sshd_config, then scroll down toPasswordAuthentication. Press i to go into text insert mode and change the no to yes. Then press ESC, and type :wq and press enter to save and quit.
3. Enter the command /etc/init.d/sshd reload. (for Ubuntu, enter the command reload ssh)
4. Set your password if you haven’t already, with the passwd command.
Note: This was tested with SUSE Linux. Directory and file names may be slightly different depending on your flavor of Linux.
mysqldump is an effective tool to backup MySQL database. It creates a *.sql file withDROP table, CREATE table and INSERT intosql-statements of the source database. To restore the database, execute the *.sql file on destination database. For MyISAM, usemysqlhotcopy method that we explained earlier, as it is faster for MyISAM tables.
Using mysqldump, you can backup a local database and restore it on a remote database at the same time, using a single command. In this article, let us review several practical examples on how to use mysqldump to backup and restore.
For the impatient, here is the quick snippet of how backup and restore MySQL database using mysqldump:
backup: # mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql
restore:# mysql -u root -p[root_password] [database_name] < dumpfilename.sql