nixCraft

brothers · #11 (**permalink**) 10-25-2007, 01:47 PM

I have ssh access no problem what I do not understand is how to command should I command all those codes you provided?
or just this part

Code:

#!/bin/bash
DBNAME="phpbb"
DBPASS="myPassWord"
DBUSER="admin"
DBHOST="localhost"
BACKUP="out.sql"

nixcraft · #12 (**permalink**) 10-25-2007, 05:06 PM

You only set correct value for following 3 variables

DBNAME="phpbb" -> mysql data base name where all 500 tables exists
DBPASS="myPassWord" -> Password to connect $DBNAME
DBUSER="admin" -> Username to access to $DBNAME

Login to server using ssh

Save script as backup.db.sh

Code:

 #!/bin/bash
DBNAME="brothers"
DBPASS="1234"
DBUSER="me"
DBHOST="localhost"
BACKUP="out.sql"
>$BACKUP
echo ""
echo -n "*** Dumping tables to $BACKUP file : "
TABLES=$(mysql -ss -h $DBHOST -u $DBUSER -p$DBPASS $DBNANE -e'show tables like "phpbb_%";')
for t in $TABLES
do
 echo -n " $t "
 mysqldump -h $DBHOST -u $DBUSER -p $DBPASS $DBNAME --tables "$t" >> $BACKUP
done
echo " *** Done."

Run backup.db.sh as follows

Code:

chmod +x backup.db.sh
./backup.db.sh

Your backup should be dumped to out.sql file.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to do MYSQL online backup of huge database	manish_2479	Databases servers	4	07-12-2008 12:36 PM
need to convert text files into mysql database	zafar466	Databases servers	2	07-12-2008 12:31 PM
MySql FTP server backup script	zafar466	Shell scripting	3	09-25-2007 05:43 PM
MySQL Backup Script	krisa	Shell scripting	1	02-02-2007 11:57 PM
How do I backup MySQL Databases?	chiku	All about FreeBSD/OpenBSD/NetBSD	2	08-19-2006 07:15 PM

nixCraft

ssh backup particular mysql table / database

ssh backup particular mysql table / database

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads