Automatic Backup script problem

Automatic Backup script problem

Posted by: dubberdan
Posted on: 2007-02-17 11:49:00

I'm following the steps listed in the Wiki here but have come up with an error when testing the mysql.sh script. I get the error:

mysqldump: Got error: 2005: Unknown MySQL server host 'drupal_lbc.lightbeingcreations.co.uk' (1) when trying to connect

So I'm guessing the problem is when I edited the script for my database details:

mysqldump --opt -uUser -ppass -h mysqlA.domain.com db_nameA > mysql/db_nameA.$suffix.sql

I changed:

mysqlA.domain.com db_nameA

to

drupal_lbc.lightbeingcreations.co.uk drupal_lbc (I think it's the first bit that's wrong)

Any suggestions?



Re: Automatic Backup script problem

Posted by: anonymous2
Posted on: 2007-02-17 12:08:00

Most likely your http://drupal_lbc.lightbeingcreations.co.uk/ subdomain hasn't propagated yet. Unless you forgot to create it. laugh

Re: Automatic Backup script problem

Posted by: dubberdan
Posted on: 2007-02-17 12:28:00

In that case I've got the syntax wrong as it's not a sub-domain.

Have played around and I had the hostname wrong!

Tis running fine now.

Just struggling now with the contrab stage :(

Re: Automatic Backup script problem

Posted by: anonymous2
Posted on: 2007-02-17 12:46:00

> Just struggling

It's easier if you don't try hard. smile

Re: Automatic Backup script problem

Posted by: dubberdan
Posted on: 2007-02-17 12:48:00

very true....


got that set up...

now the automated ftp to do....

Tags: mysqldumpserver hostmysql serverscript problembackup scriptautomatic backupdrupaloptwikish