Jochen,
what's the result of
prompt> mysql -uroot -pXXX -hxxx.xxx.xxx.xxx
when you do it on the client host? (I still suspect that permissions are
not properly granted).
Regards, Thomas Spahni
On Wed, 17 Mar 2004, Jochen Kaechelin wrote:
> 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?
>
>
