Jochen Kaechelin <jkt@stripped> 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?
>
Check
- that MySQL server is running
- that you use correct TCP/IP port when you trying to connect
- that MySQL server is not running with --skip-networking option.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ Victoria.Reznichenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
