Welcome to the home of Kuls 'FAQ's & One'Liner Scripts'

FAQ Section

• Using Crontab - for the un-initiated

One'Liners Section

Many of the One-Liners held here were originally written for the site 'freebies.omega-isp.com' which I plan to close completly over the comming months, with all its contents being moved here. If you have any old bookmarks, please update them to here as the domain 'omega-isp.com' will not be reregistered.

• Dumping Postgresql databases on RaQ3/4 (Backing up)
• Dumping Mysql databases (Backing up)

Dumping the Postgresql database on a Cobalt/Sun RaQ3/4 (postgresql = GUI backend)

How to dump the postgresql database - THE EASY WAY:
(you will need to be 'root' initially for this)
RaQ3

su --login --command="cd ~;echo 'local cobalt trust' > \
pg_hba.conf;pg_dump cobalt > mydumpfile.pgsql;echo \
'local cobalt crypt' > pg_hba.conf" postgres

su --login --command="cd ~;mv data/pg_hba.conf \
data/pg_hba.conf.bak;echo 'local cobalt trust' > \
data/pg_hba.conf;pg_dump cobalt > ~/data/mydumpfile.pgsql; \
mv data/pg_hba.conf.bak data/pg_hba.conf" postgres

Dumping all your MYSQL databases:

/usr/bin/mysqldump -uroot --password="the_mysql_root_pasword" \
--all-databases --all --force --opt > output_file.sql