How to backup/restore database via SSH/Telnet

In order to back up your database via SSH/Telnet, you are required two things:

1. You have ROOT access to your server:

(VPS and Dedicated server only, thats not allowed on Shared hosting). Ask your hosting provider or check again the email they sent to you when your order was complete.

You need to know:

– Server ips

– Port (default: 22)

– Username (default: root)

– Password

2. An SSH/Telnet Client, such as PuTTy.

Download Putty here. (link)

Open Putty client then choose SSH connection type and enter your server ip address. (Host name or ip address)

putty client
Continue reading “How to backup/restore database via SSH/Telnet”