Hello forum dwellers, my first post here and i'm afraid it's one asking for help.

 

I've just paid for a vps for my hosting and i'm struggling to work out how to backup and restore my databases with SSH.

 

I have google commands and stuff but as a complete newb at this i'm getting lost.

 

Can anyone provide dummies guidance? THANKS!!

you can do it remotely.

 

download something like putty.

 

enter the server ip or the web domain,

 

login as root, it'll then request your password, type the password (it'll be hidden, you won't see stars or anything, but its typed) once you've entered your pass hit enter.

 

enter your commands.

 

Normal mysql backup/restore is something along the lines of

 

backing up/exporting

mysqldump -p -u database_username database_name > file_you_want_to_backup_to.sql

restoring/importing

mysql -p -u database_username database_name < file_you_want_to_restore.sql

let me know if ya need more help

Hi John, it depends on your operating system. If you have Linux or apple OS, you can use SSH directly from your terminal, otherwise you'll need programs such as putty or remoteSSH.

As above, although if this is something you are going to be doing regularly, you may wish to consider installing tools like phpMyAdmin to make the job a little easier.

 

There is also the option of Idera ServerBackup (formerly R1Soft CDP). You can use it to do automated backups of both files and databases, although you would require another machine from which to run it.

 

Hope this helps.

 

Jon

you can do it remotely.

 

download something like putty.

 

enter the server ip or the web domain,

 

login as root, it'll then request your password, type the password (it'll be hidden, you won't see stars or anything, but its typed) once you've entered your pass hit enter.

 

enter your commands.

 

Normal mysql backup/restore is something along the lines of

 

backing up/exporting

mysqldump -p -u database_username database_name > file_you_want_to_backup_to.sql

restoring/importing

mysql -p -u database_username database_name < file_you_want_to_restore.sql

let me know if ya need more help

 

Going to give this a try -thanks.

As above, although if this is something you are going to be doing regularly, you may wish to consider installing tools like phpMyAdmin to make the job a little easier.

 

There is also the option of Idera ServerBackup (formerly R1Soft CDP). You can use it to do automated backups of both files and databases, although you would require another machine from which to run it.

 

Hope this helps.

 

Jon

 

I tried phpmyadmin but the databse is too big it just times out. Am I doing something wrong?

Edited July 6, 201313 yr by JohnH70

Cron jobs anyone?

 

I don't even know how to setup a cron job - thats my next Q!

I tried phpmyadmin but the databse is too big it just times out. Am I doing something wrong?

no that's usual behaviour for big databases.

i wud recommend if this is ur frst time hire a linux admin or ask tht host if they have managed vps service