[SOLVED] How to backup the database

[chrisbar]

I would like to upgrade to the latest version of CMS Made Simple. Through Ftp I can backup all files, but when it comes to the backup of te database I wonder which files are meant with te database. Before I just only backup all folders and files on my server I would like to know for sure that I don't miss anything then.

[Wishbone]

http://mkrd.info/software-discussions/c ... cmsms.html

[Rolf]

Or use:
http://dev.cmsmadesimple.org/projects/mysqldump

But add a .htaccess file in the /admin/backups/ folder with:

Code: Select all

# To deny PHPs
<Files ~ "\.(php|php3|php4|php5|phtml|pl|cgi|txt|sql)$">                                                                              
  order deny,allow                                                                                                            
  deny from all                                                                                                               
</Files>

This to avoid direct access to the database dump file on the server.

Hope this helps,

Rolf 

[chrisbar]

When trying to install de MYSQLbackup module I get the message No SQL installed on the server....

[Rolf]

When trying to install de MYSQLbackup module I get the message No SQL installed on the server....

Ohh bummer, you can't use this module then...
You have to do it the manual way with phpmyadmin of by using the service website of your webhost.

Rolf

[exarchiasghost]

Hi all.
i am looking for full backup module. Not only for for Mysql data base but for all the contents, (templates, modules, plugins etc) there is anything usefull for this action?
I am using the last release of CMSms (CMS Made Simple 1.9.1)
Best regards
Robert.



ps i am really new user of CMSms.

[M@rtijn]

Actually all content (templates, modules, plugins etc) is stored in the database. You can use the MySQLDump module to back that up.

But I think you mean back up all the files and content:
Easiest option is to use the CustomerPanel most hosts provide, where you can easily backup all files on the ftp server and the database altogether.
If for some reason you do not have a cPanel, then you can manually copy all the files to a folder on your computer (but then you'd still have to use the mysqldump for the db backup)

(and actually 1.9.2 is the latest version of CMSMS)

[exarchiasghost]

Allright! I have a clear picture about it.
Thanks!

[replytomk3]

http://mkrd.info/software-discussions/c ... cmsms.html

Thanks, Wishbone.