need help to automate tasks using shell scripts

Next topic

Author	Message
Alexandre Cunha	Tuesday 25 May 2004 4:56:53 pm Hello Im looking to a simple and secure way to download mysql dump from a site made with ezpublish every time i need copy/backup the online database to my local machine. Want do this using one shell script. What that shell script need do ? - receive some paramaters (remote server, remote database name, localdatabase name, ...) - connect to the remote server, - get the database dump, - zip/tar and download it, - then on my local host, unzip/unpack and override the dump to a local database. All connect/transfer tasks using ssh/scp. Use linux on remote server (host company) and win + cygwin on my local machine. I what extend this idea to update the design/templates folders of my sites: - local zip/tar, - copy to remote server in a secure way, - unzip/untar on remote, - replace the changed/new files. I need some help and if possible, examples. I have knowledge todo some basic tasks (use ssh, scp, get mysql dump, untar) but can build the complete solution. So, if other users use scripts and other tecniques to update remote/local servers (templates, databases) I really apreciates sugestions and samples. Thanks axel http://AlexandreCunha.com
Egil Fujikawa Nes	Sunday 06 June 2004 11:57:34 pm Hi I assume that you are using mysql database. The easiest way to do this is to have your remote server as a master server and the local server as a slave server. This will give you the possibility to have a “fresh” slave database all the time, but you will not be able write anything to the local (slave) database. More information about how to configure can you find here: http://dev.mysql.com/doc/mysql/en/Replication.html To move templates and other files I would recommend rsync (http://samba.anu.edu.au/rsync/) to do this job. Rsync is doing this job for me today. Egil Fujikawa Nes http://www.webdeal.no

Author

Message

Tuesday 25 May 2004 4:56:53 pm

Hello

Im looking to a simple and secure way to download mysql dump from a site made with ezpublish every time i need copy/backup the online database to my local machine.

Want do this using one shell script.

What that shell script need do ?
- receive some paramaters (remote server, remote database name, localdatabase name, ...)
- connect to the remote server,
- get the database dump,
- zip/tar and download it,
- then on my local host, unzip/unpack and override the dump to a local database.

All connect/transfer tasks using ssh/scp.

Use linux on remote server (host company) and win + cygwin on my local machine.

I what extend this idea to update the design/templates folders of my sites:
- local zip/tar,
- copy to remote server in a secure way,
- unzip/untar on remote,
- replace the changed/new files.

I need some help and if possible, examples.
I have knowledge todo some basic tasks (use ssh, scp, get mysql dump, untar) but can build the complete solution.

So, if other users use scripts and other tecniques to update remote/local servers (templates, databases) I really apreciates sugestions and samples.

Thanks

axel

http://AlexandreCunha.com

Egil Fujikawa Nes

Sunday 06 June 2004 11:57:34 pm

I assume that you are using mysql database. The easiest way to do this is to have your remote server as a master server and the local server as a slave server. This will give you the possibility to have a “fresh” slave database all the time, but you will not be able write anything to the local (slave) database. More information about how to configure can you find here: http://dev.mysql.com/doc/mysql/en/Replication.html

To move templates and other files I would recommend rsync (http://samba.anu.edu.au/rsync/) to do this job. Rsync is doing this job for me today.

Egil Fujikawa Nes
http://www.webdeal.no

eZ debug

Timing:	Jan 18 2025 15:12:19
Script start
Timing:	Jan 18 2025 15:12:19
Module start 'layout'
Timing:	Jan 18 2025 15:12:19
Module start 'content'
Timing:	Jan 18 2025 15:12:20
Module end 'content'
Timing:	Jan 18 2025 15:12:20
Script end

Main resources:

Total runtime	0.6643 sec
Peak memory usage	4,096.0000 KB
Database Queries	54

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0045	589.1563	152.6406
Module start 'layout'	0.0045	0.0033	741.7969	39.4766
Module start 'content'	0.0078	0.6550	781.2734	492.1797
Module end 'content'	0.6628	0.0016	1,273.4531	8.1250
Script end	0.6643		1,281.5781

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0031	0.4625	16	0.0002
Check MTime	0.0013	0.1885	16	0.0001
Mysql Total
Database connection	0.0007	0.1003	1	0.0007
Mysqli_queries	0.6217	93.5792	54	0.0115
Looping result	0.0005	0.0748	52	0.0000
Template Total	0.6367	95.8	2	0.3183
Template load	0.0019	0.2929	2	0.0010
Template processing	0.6347	95.5424	2	0.3174
Template load and register function	0.0002	0.0309	1	0.0002
states
state_id_array	0.0008	0.1198	1	0.0008
state_identifier_array	0.0009	0.1400	2	0.0005
Override
Cache load	0.0016	0.2462	30	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0006	0.0895	2	0.0003
Fetch class attribute name	0.0013	0.1979	2	0.0007
XML
Image XML parsing	0.0002	0.0332	2	0.0001
class_abstraction
Instantiating content class attribute	0.0000	0.0011	2	0.0000
General
dbfile	0.0006	0.0902	10	0.0001
String conversion	0.0000	0.0011	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
2	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
6	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
4	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 14 Number of unique templates used: 5

Time used to render debug report: 0.0001 secs