Page 1 of 1
[SOLVED] How to backup the database
Posted: Fri Dec 17, 2010 11:16 am
by 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.
Re: How to backup the database
Posted: Fri Dec 17, 2010 3:03 pm
by Wishbone
Re: How to backup the database
Posted: Fri Dec 17, 2010 3:08 pm
by 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
Re: How to backup the database
Posted: Fri Dec 17, 2010 8:49 pm
by chrisbar
When trying to install de MYSQLbackup module I get the message No SQL installed on the server....
Re: How to backup the database
Posted: Fri Dec 17, 2010 8:52 pm
by Rolf
chrisbar wrote:
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
Re: [SOLVED] How to backup the database
Posted: Thu Jan 06, 2011 5:20 am
by 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.
Re: [SOLVED] How to backup the database
Posted: Thu Jan 06, 2011 1:17 pm
by 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) 
Re: [SOLVED] How to backup the database
Posted: Fri Jan 07, 2011 10:59 am
by exarchiasghost
Allright! I have a clear picture about it.
Thanks!
Re: How to backup the database
Posted: Sat Jan 08, 2011 1:10 pm
by replytomk3