performing backup of cmsmadesimple site

[davids355]

I want to run a test backup and restore of my cms site from one server to another. I know there is documentation for this, but Im still not 100% sure on how to do it.

On the current server for my site I have linux hosting and ssh access. On the test server I dont have ssh but it is still linux hosting. I have a spare sql database.

I would like someone to Meet me on msn or something and just run through the process of doing a backup and a restore - I can quite happily navigate cms, I am fluent in browsing my server via ftp, seting up sql databases etc but I just want someone to walk me through the process and Id like to see a copy of my site successfuly restored to a different server and perhaps see it working (under a temporary domain name, which I also have).

Wondering if someone would help me with this for a small fee?

Also at some point I would like to get towards having an automatic backup of my site done every so often  but I would rather just have some advice on how to do this myself.

Many thanks in advance

Dave
Shareworld

[applejack]

You really need to have ssh access on both servers to do it the best way, which is also need to install updates at times. For automated daily backups including database archived for 7 days then I can provide a script to do that (for a fee).

Alternatively see the FileBackup module I haven't tried it myself.

[davids355]

Ok I will think about upgrading my server to include ssh. How much for the script and how much for help getting it installed and running?

[applejack]

You got Webmin installed by any chance. Cost of script for daily automated backups including database £100. You will have to be able to run scripts as root

[davids355]

No Havnt, whats webmin?

[applejack]

webmin is a server control panel gui which allows you complete control over the server. Very dangerous in the wrong hands but I use it for setting up cron jobs amongst other things.

www.webmin.com/

[davids355]

Dont have this and dont think I can get it. My server is hosted with 1and1. We just have ssl access or whatever its called. If I get the same on my backup server, would you walk me through doing a backup and restore, and if so how much?

[applejack]

do you have root ssh access?

[JohnnyB]

Hi,

I install CMSMS on dev servers and move them regularly just using FTP b/c most clients use shared hosting and do not have the luxury of SSH.  I've built and moved about 20 this year from various hosts.  I'll run down the steps I take to see if they help you.

1. Backup the database using phpmyadmin.  Select the database on the left side and then use the Export option. The default settings are usually ok.  Save as a .sql on your computer.
2.  Delete the files under tmp/templates_c and tmp/cache
3.  Backup the entire CMSMS directory as it is on the server.  I simply use FTP to copy all of the files and directories to my computer if I don't already have one.
4. Assuming you've already created a database for the new server, import the .sql using phpmyadmin.
5. Upload all files and directories to the new server via FTP
6. modify the config.php file to match the new server:
you will need to know the full domain (example: http://www.domain-name.com)
you will need to know the server path to CMSMS (example: /home/account-name/public_html/)
If you don't know the path, upload a phpinfo script and browse to it:

create a file called phpinfo.php that contains the following line:



This process usually takes less than 30 minutes.  Sometimes, you need to reinstall the captcha module because it throws an error and if you are using the image picker module, you'll need to go into the database via phpmyadmin and correct the image paths.  But for the most part the 6 steps above will do it.

[applejack]

You can often do it using FTP but tar.gzip is better and quicker and more certain, depends on the file permissions whether or not you can use FTP

[davids355]

Thanks MWW. To import the only thing I see is in the sql query window it has option to upload file, is this it? I will try with these instructions later.

Applejack yes I do have ssh access not sure if its root. Also have ability to run cron jobs. I may try it with ftp but I do also want to setup something automated.

[applejack]

You need to find out whether or not you are allowed to run cron jobs as root.

[davids355]

Ok will check that.

[davids355]

MWW when I try and import the sql file I get this error:
#1044 - Access denied for user:'dbo259808534@%' to database 'db247610179'

??

[applejack]

Have you tried using the CMS module MySQL dump?