I use the following Script to backup a remote MySQL-Server.
DATUM=`date +"%Y_%m_%d__%H_%M"`
BACKUPDIR="/home/jochen/SICHERUNG/MySQL_Dumps/debby/$DATUM"
echo ""
echo "Erzeuge Sicherungvereichnis $BACKUPDIR..."
echo ""
mkdir -p $BACKUPDIR
for DB in db1 db2
do
echo ""
echo "Erzeuge lokele Sicherung der Datenbank $DB..."
echo ""
/usr/bin/mysqldump -uroot -pXXX -hxxx.xxx.xxx.xxx --opt $DB >
$BACKUPDIR/$DB.sql
echo ""
echo "Entferne moegliche Sicherungsduplikate..."
echo ""
rm -rf $BACKUPDIR/$DB.sql.gz
echo ""
echo "Komprimiere aktuelle Sicherungsdateien..."
echo ""
gzip $BACKUPDIR/$DB.sql
done
and I always get the following error:
/usr/bin/mysqldump: Got error: 2003: Can't connect to MySQL server
on '212.87.142.236' (111) when trying to connect
Permissions are ok and I can modify the complete db with my php
scripts.
where's the error?
--
Jochen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
