Make sure you have a folder called public_html, your webserver’s document root. You can create a folder like this using Midnight Commander. In case it’s not there.
Step 1 – Creating a back up of your wordpress databases
Go to phpmyadmin:
Login as root using your mysql root password.
Click on wordpress and go to export.
It will give you two options:
Maybe it would be wise to start with custom. But I chose for the lazy quick option. Choose sql under format (the default value) and click on the Go button. It will ask you now to save the file as an sql file.
This sql file is the back up of your word press databases.
Click on it and go to export.
But I chose for the quick option again. Choose sql under format (the default value) and click on the Go button. It will ask you now to save the file as an sql file.
Step 2 – Back up the rest of your wordpress
Make sure that on the left side you can see what is on your actual pc, while on the right side your vps is shown.
Now we have to copy all wordpress files from your vps to for example the desktop of your actual pc.
Select all files under the user directory you previously created in /home/username/public_html.
Step 3 – Restore your wordpress html files and database
Now you have to copy the wordpress html files from your back up to the location /home/username/public_html
Click on the logo to see the mainpage.
Go to Users .
Choose a user name and select the option local under Host. Then type in a pass word. Select . Don’t touch global privileges.
Now select the database wordpress you just created on the left side by clicking it once.
Then go to Import.
Select your wordpress sql file on your pc and click on go.