Simplest backup procedure

herbshirt · **Joined:** Thu Jul 26, 2007 3:47 am **Posts:** 148

Yep I've done the search but it all looks a little complicated for someone like me.

I'm wondering what the simplest way to backup my cms ms site would be. I'm guessing an FTP download of the entire site??

OR is there something even simpler?

calguy1000 · **Posted:** Thu Aug 30, 2007 4:51 am

1.1 Do a mysqldump of the database to a file local to your install
1.2 ftp (or better) Absolutely every file from your remote install to

the restore procedure is:

2.1. FTP all the files up to the remote host
2.2. Create a database with the same name, and access privileges so that the
dump created from step 1.1 above will just import
2.3 remove all files from /tmp /tmp/cache and /tmp/templates_c
2.4 Restore the database from the mysqldump created in 1.1

Pierre M. · **Posted:** Thu Aug 30, 2007 11:13 am

What about making this thread sticky ?

It is very very very good because there is the restore/moving procedure too

Pierre M.

Dr.CSS · **Posted:** Thu Aug 30, 2007 3:56 pm

Database Backup Module is still the best! if it only worked in 1.1 and up...

just my 0.002 $usd....

alby · **Posted:** Thu Aug 30, 2007 7:59 pm

mark wrote:

Database Backup Module is still the best! if it only worked in 1.1 and up...

Have you try Archiver (check in SVN because one file has a problem)?

Alby

Dr.CSS · **Posted:** Thu Aug 30, 2007 9:39 pm

With the databasebackup module...
I can develop a site on my server...
when you like it I run the backup mod. then download the site folders add the install folder back into it zip it up send it to you...
you FTP it up to your site run install like a new CMSMS install...
then you go to backup mod. run restore and you have the exact site I built for you page structure and all...
and I have no access to it because you installed it fresh...

I have a site I'm setting up now and it has a ton of pages so I had to make a lot of empty pages to make sure the menus worked now that it all works I can only give them the template, which will only export/import one menu template and this has three custom menu templates, so I have to give them these separately, and we have to recreate the page structure and news items and GCB upload all the images yadda yadda ya

All the images in templates work, all GCB work all, the news items are there, everything in calendar is set, whatever you wanted...

Sorry, I just feel very strongly about this and I sure miss the little fella :'(

...

How much it cost to get fixed?... huh... I pay...

see waditellya... http://forum.cmsmadesimple.org/index.ph ... 665.0.html

herbshirt · **Joined:** Thu Jul 26, 2007 3:47 am **Posts:** 148

Call me dumbass but... what is 'mysqldump'?

Do you mean download the mysql d/b?

tsw · **Posted:** Mon Sep 03, 2007 3:15 pm

18:18 < tsw> cmsinfo: mysqldump?
18:18 < cmsinfo> somebody said mysqldump was the way to get my database "dumped" to a file.
usage "mysqldump -uUSERNAME -p DATABASENAME > FILENAME" (it will ask you for a
password). For more information and all optional parameters say "man mysqldump"

alby · **Posted:** Sat Sep 08, 2007 4:20 pm

mark wrote:

With the databasebackup module...
I can develop a site on my server...

.........................

How much it cost to get fixed?... huh... I pay...

One beer?

Untested!

EDIT: I tested in deep and there are still problems. Sorry

Alby

calguy1000 · **Posted:** Sat Sep 08, 2007 4:41 pm

The DB Backup module requires adodb (the full version) not the adodb_lite that we converted to in the 0.13 days
that's why it's not working.

alby · **Posted:** Sat Sep 08, 2007 7:25 pm

calguy1000 wrote:

The DB Backup module requires adodb (the full version) not the adodb_lite that we converted to in the 0.13 days
that's why it's not working.

Infact I have substitute "MetaTables" and "MetaColumns" with sql: "SHOW TABLES" and "SHOW COLUMNS FROM $tables"
with MysQL is not a problem with other I don't sure

Alby

calguy1000 · **Posted:** Sat Sep 08, 2007 11:10 pm

yep, it'll work for mysql users, but won't work for postgres users.
The other drawback is you have to maintain patches to yet another package (adodb_lite).

I have done similar things with sitepusher.... it currently only works with mysql.

alby · **Posted:** Sun Sep 09, 2007 7:06 am

calguy1000 wrote:

yep, it'll work for mysql users, but won't work for postgres users.
The other drawback is you have to maintain patches to yet another package (adodb_lite).

I don't use Backup module, it's a favor for mark (many thank for a reply my PM in April

) and if someone uses this.
In module help there is a warning for use this module with MySQL only.
I have found this for tables (but I don't have Postgresql for try):

Quote:

MySQL variant:
SHOW TABLES

PostgreSQL variant:
SELECT table_name FROM information_schema.tables WHERE table_schema = 'public';
Although the output does not exactly match what comes from MySQL, it does list every public table and nothing else on the lines (but it produces some header and footer information).

MySQL variant:
SHOW TABLES LIKE 'foo'

And PostgreSQL variant:
SELECT table_name FROM information_schema.tables WHERE table_schema = 'public' AND table_name LIKE 'foo'

And this for columns:

Quote:

foreach table
-------------
mysql: show tables

postgres: select table_name from information_schema.tables where table_schema = 'public')

foreach column
--------------
mysql: show columns from '%s'

postgres: select column_name from information_schema.columns where table_name = '%s')

Maybe this can help you

Alby

Hare · **Joined:** Sat Jun 03, 2006 11:46 am **Posts:** 87

alby wrote:

One beer?

Untested! Try this attach

Alby

Doesn't work. Doesn't output any actual db content, just the table names etc. I just tried it and it erased my whole site during backup restore

Of course this was on a dev server so no harm done.

Dr.CSS · **Posted:** Wed Oct 24, 2007 6:31 am

Damn and I was just going to get it to try... oh well...

Simplest backup procedure

Who is online