but it can be run only on the same machine where the database directories are located.

##</code><code>##

mysqldump -acQ -h "$cfg{db_host}" -u "$cfg{db_user}" --password="$cfg{db_pass}" --add-drop-table --allow-keywords "$cfg{db_prod}" > $cfg{cgi_root}/$cfg{backups}/$cfg{prod}_$block_date.sql

##</code><code>##

mysqldump -h "$cfg{db_host}" -u "$cfg{db_user}" --password="$cfg{db_pass}" -acQ --add-drop-table --allow-keywords "$cfg{db_dev}" | mysql -s -D "$cfg{db_prod}" -h "$cfg{db_host}" -u "$cfg{db_user}" --password="$cfg{db_pass}"