Re: CVS for Databases?
- From: "matt@xxxxxxxxxxxxxx" <matt@xxxxxxxxxxxxxx>
- Date: 10 Aug 2005 07:28:28 -0700
I use these bash scripts to commit DB changes to CVS:
//----Dump DB--------------------------------------
#!/bin/sh
clear
db[0]="db_bplot"
db[1]="db_jobs"
db[2]="db_print_supplies"
db[3]="db_tracker"
db[4]="db_intranet"
for x in "${db[@]}"
do
echo -n "Dumping $x..."
mysqldump -u XXX -pXXX --add-drop-table -B $x > $x.sql;
echo " Done."
done
echo -n "Creating dbs.tar.bz2..."
tar cjpf dbs.tar.bz2 db_*;
echo " Done."
for x in "${db[@]}"
do
rm $x.sql;
done
//-------------Import DB--------------------------------------------
#!/bin/sh
clear
db[0]="db_bplot"
db[1]="db_jobs"
db[2]="db_print_supplies"
db[3]="db_tracker"
db[4]="db_intranet"
echo -n "Extracting dbs.tar.bz2..."
tar jxf dbs.tar.bz2
echo " Done."
for x in "${db[@]}"
do
echo -n "Updating $x..."
mysql -u XXX -pXXX --execute="drop database $x"
mysql -u XXX -pXXX --execute="create database $x"
mysql -u XXX -pXXX < $x.sql
rm $x.sql
echo " Done."
done
Hope this helps!
.
- References:
- CVS for Databases?
- From: Nimit
- CVS for Databases?
- Prev by Date: Re: Do I need a course on data structures?
- Next by Date: Re: minimal (?) optimization (Was Re: String manipulation, optimize)
- Previous by thread: Re: CVS for Databases?
- Next by thread: Sablotron error
- Index(es):
Relevant Pages
|
