Regular site backup

Next topic

Author	Message
Halvor M	Monday 25 July 2005 4:00:47 pm I have read around on this topic, and seen some different solutions... How do _you_ perform regular backups - and is this possible to do without having to use a lot of time every time you want to perform a backup? I have seen references to a module that supposedly performs an automatic backup - that sounds rather nice :-) The reason I am asking is that I am not very comfortable with sql, and would hate to lose the info already on my site... thanks !
Mikael Johansson	Monday 25 July 2005 10:36:12 pm Are you using windows or linux? We're running on Linux, where we have setup a cron job that does a mysqldump at regular intervals. It also backups the ezpublish folder. You should be able to do the same with windows scheduler or whatever it is called if you're running on windows. Mikael Johansson, Sweden
Gabriel Ambuehl	Tuesday 26 July 2005 12:53:57 am While not ultimately necessary for ezpublish IIRC, be sure to add -Q into the mysqldump params or you might not be able to reimport the generated SQL if the table names contained unusual (yet valid) chars. I've got bitten badly by this (why they don't do this by default I don't understand) a few weeks ago. Visit http://triligon.org
J-A Eberhard	Tuesday 26 July 2005 2:29:35 am Hi, I'm using the following contrib and I'm happy with it as it save also special templates and ini files in an archive. Grab it from http://ez.no/community/contribs/3rd_party/ezpublish_site_backup_script Open Source Solution Provider Open-Net Ltd Switzerland http://www.open-net.ch
Halvor M	Tuesday 26 July 2005 4:40:15 am Well, I am running my EZserver on a WinXP system using MySQL. The script Eberhard mentioned seemed very appropriate for my needs, but it looks like it was made for a linux system. Am I correct in asuming that in order to perform a backup, I would only need to: 1. Copy EZ folder from web server, and 2. make a sql dump What then, is the exact string I would need to write in sql (or can I use phpadmin interface?). Sorry that I am asking for such basic information, but some of us are getting by more due to sheer persistence and bloody-mindedness than you IT-gods out there :-)
Gabriel Ambuehl	Tuesday 26 July 2005 4:47:37 am I think you can do SQL dumps in phpmyadmin. It might take a while though. If you got shell access, read the docs for mysqldump. Visit http://triligon.org
Łukasz Serwatka	Tuesday 26 July 2005 5:07:31 am On Windows 2000 and XP it is possible to use the "Scheduled Tasks" mechanism to automatically run the maintenance file. You can create .bat file and write some simple commands like: cd C:\mysql\bin mysqldump something > file.sql copy file.sql d:\backups Personal website -> http://serwatka.net Blog (about eZ Publish) -> http://serwatka.net/blog
Halvor M	Thursday 28 July 2005 3:04:48 pm Thanks! I have both phpmyadmin and shell access to mysql. I have been trying various commands in the shell, but it doesnt seem to work. I am really scared of doing something wrong here that could put my existing info at risk (which is why I need the backup to start with). Exactly what is the backup line to use in mysql? alternatively: Is "export" the correct function to use in phpmyadmin, and could someone post a screenshot of the admin screen so I can see how to set the options? btw, this is what I tried in mysql: >mysql [name of database]-u [username] -p < file.sql I also tried: mysqldump [name of database]-u [username] -p < file.sql In both cases I get error message that the file was not found. I think a clear answer to this would be of benefit to others users who adhere to the same level of ineptitude as myself :-D Yours gratefully, Halvor
Konrad Mazurkiewicz	Thursday 28 July 2005 3:42:31 pm Hi, Lukasz show you right way. You shouldn't use '<' but '>'. ;) Konrad
Halvor M	Thursday 28 July 2005 4:11:38 pm OMG! It worked! I am a genius :-P Thanks for the help. A sql file was now generated, and I will follow Lukes advice and put this into my scheduler. What would be the sql command for importing this back into mysql if I do at some point have to move or rebuild the site?

eZ debug

Timing:	Jan 18 2025 11:28:29
Script start
Timing:	Jan 18 2025 11:28:29
Module start 'layout'
Timing:	Jan 18 2025 11:28:29
Module start 'content'
Timing:	Jan 18 2025 11:28:30
Module end 'content'
Timing:	Jan 18 2025 11:28:30
Script end

Main resources:

Total runtime	0.9405 sec
Peak memory usage	4,096.0000 KB
Database Queries	86

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0066	587.9063	152.6250
Module start 'layout'	0.0066	0.0034	740.5313	39.4297
Module start 'content'	0.0100	0.9290	779.9609	760.6719
Module end 'content'	0.9390	0.0015	1,540.6328	20.1875
Script end	0.9405		1,560.8203

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0037	0.3962	16	0.0002
Check MTime	0.0015	0.1642	16	0.0001
Mysql Total
Database connection	0.0010	0.1081	1	0.0010
Mysqli_queries	0.8612	91.5690	86	0.0100
Looping result	0.0009	0.0977	84	0.0000
Template Total	0.9047	96.2	2	0.4524
Template load	0.0023	0.2412	2	0.0011
Template processing	0.9024	95.9490	2	0.4512
Template load and register function	0.0002	0.0200	1	0.0002
states
state_id_array	0.0015	0.1581	1	0.0015
state_identifier_array	0.0017	0.1835	2	0.0009
Override
Cache load	0.0020	0.2139	57	0.0000
Sytem overhead
Fetch class attribute can translate value	0.0008	0.0864	6	0.0001
Fetch class attribute name	0.0014	0.1527	12	0.0001
XML
Image XML parsing	0.0019	0.1978	6	0.0003
class_abstraction
Instantiating content class attribute	0.0000	0.0023	12	0.0000
General
dbfile	0.0020	0.2112	23	0.0001
String conversion	0.0000	0.0007	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
10	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
14	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
5	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
2	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
3	content/datatype/view/ezxmltags/literal.tpl	<No override>	extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 36 Number of unique templates used: 7

Time used to render debug report: 0.0002 secs