performing backup of cmsmadesimple site

A place to make for-pay "CMS made simple" job offerings
davids355
Power Poster
Power Poster
Posts: 279
Joined: Fri Apr 04, 2008 10:08 am
Location: UK

performing backup of cmsmadesimple site

Post by 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
Power Poster
Power Poster
Posts: 1014
Joined: Fri Mar 30, 2007 2:28 am
Location: London

Re: performing backup of cmsmadesimple site

Post by 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.

Website Design & Production
http://www.applejack.co.uk
davids355
Power Poster
Power Poster
Posts: 279
Joined: Fri Apr 04, 2008 10:08 am
Location: UK

Re: performing backup of cmsmadesimple site

Post by 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
Power Poster
Power Poster
Posts: 1014
Joined: Fri Mar 30, 2007 2:28 am
Location: London

Re: performing backup of cmsmadesimple site

Post by 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

Website Design & Production
http://www.applejack.co.uk
davids355
Power Poster
Power Poster
Posts: 279
Joined: Fri Apr 04, 2008 10:08 am
Location: UK

Re: performing backup of cmsmadesimple site

Post by davids355 »

No Havnt, whats webmin?
applejack
Power Poster
Power Poster
Posts: 1014
Joined: Fri Mar 30, 2007 2:28 am
Location: London

Re: performing backup of cmsmadesimple site

Post by 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/

Website Design & Production
http://www.applejack.co.uk
davids355
Power Poster
Power Poster
Posts: 279
Joined: Fri Apr 04, 2008 10:08 am
Location: UK

Re: performing backup of cmsmadesimple site

Post by 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
Power Poster
Power Poster
Posts: 1014
Joined: Fri Mar 30, 2007 2:28 am
Location: London

Re: performing backup of cmsmadesimple site

Post by applejack »

do you have root ssh access?

Website Design & Production
http://www.applejack.co.uk
JohnnyB
Dev Team Member
Dev Team Member
Posts: 731
Joined: Tue Nov 21, 2006 5:05 pm
Location: OH, USA

Re: performing backup of cmsmadesimple site

Post by 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.
"The art of life lies in a constant readjustment to our surroundings." -Okakura Kakuzo

--
LinkedIn profile
--
I only speak/write in English so I may not translate well on International posts.
--
applejack
Power Poster
Power Poster
Posts: 1014
Joined: Fri Mar 30, 2007 2:28 am
Location: London

Re: performing backup of cmsmadesimple site

Post by 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

Website Design & Production
http://www.applejack.co.uk
davids355
Power Poster
Power Poster
Posts: 279
Joined: Fri Apr 04, 2008 10:08 am
Location: UK

Re: performing backup of cmsmadesimple site

Post by 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
Power Poster
Power Poster
Posts: 1014
Joined: Fri Mar 30, 2007 2:28 am
Location: London

Re: performing backup of cmsmadesimple site

Post by applejack »

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

Website Design & Production
http://www.applejack.co.uk
davids355
Power Poster
Power Poster
Posts: 279
Joined: Fri Apr 04, 2008 10:08 am
Location: UK

Re: performing backup of cmsmadesimple site

Post by davids355 »

Ok will check that.
davids355
Power Poster
Power Poster
Posts: 279
Joined: Fri Apr 04, 2008 10:08 am
Location: UK

Re: performing backup of cmsmadesimple site

Post by davids355 »

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

??
applejack
Power Poster
Power Poster
Posts: 1014
Joined: Fri Mar 30, 2007 2:28 am
Location: London

Re: performing backup of cmsmadesimple site

Post by applejack »

Have you tried using the CMS module MySQL dump?

Website Design & Production
http://www.applejack.co.uk
Post Reply

Return to “Help Wanted (commercial)”