Bob,
> he trick is - I want multiple bacups and therefore a different filename
> each time, preferably related to the date. so rather than dbname_backup it
> would be something like 20010720 and tomorrow it would be 20010721 and so
> on. Is there a way to do this in a bash script? (or any way at all for that
Try something like the following:
# mysqldump -h myhost -u root -pmypass dbname >dbname_`date +%y+m+d`
The single quote around the date command is that one on the top-left
of your keyboard (well, most anyway) that causes shell to execute
the stuff inside the quotes as a command and feed the results into
original command line before evaluating that.
/rgds/jim
--
Jim Lawton Silicon & Software Systems
Email: jim.lawton at s3group.com Cork, Ireland
Phone: +353-21-2302446 Fax: +353-21-2302401 http://www.s3group.com
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!
