Restore MySQL script problems,

I am using a shell script to backup my database once a day and ftp to a failover site I have with a shared host. My gziped database gets over there fine. The problem I am is trying to run a cronjob script on the shared host to restore the database on a daily basis

I am using this code which I was told would work but does not
PHP Code:
gunzip < xxx.sql.gz | mysql -u xxx -p xxx xxx 
do I have this problem because on the site I am trying to restore from I do not have root access to the MySql since I have a shared account as my backup failover?

Or is it in the syntax of the command.

Any help would be appreciated.

Should I use php instead.

 

 

 

 

Top