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?
>
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to