problem using 'backup database'

[henpa]

I think I know what the problem is. SQLyog is allowing me to connect to a remote unix mysql server, but it asks for a local 'windows' directory path, and I get the error because this copy just isn't possible.

Code:

[16:28:44][   0 ms] show table status from `mysql`
[16:28:51][   0 ms] lock tables `mysql`.`columns_priv` read, `mysql`.`db` read, `mysql`.`func` read, `mysql`.`host` read, `mysql`.`tables_priv` read, `mysql`.`user` read
[16:28:51][   0 ms] backup table `mysql`.`columns_priv`, `mysql`.`db`, `mysql`.`func`, `mysql`.`host`, `mysql`.`tables_priv`, `mysql`.`user` to '/tmp/teste'
[16:28:53][   0 ms] unlock tables
[16:32:00][   0 ms] show table status from `mysql`
[16:32:04][   0 ms] lock tables `mysql`.`columns_priv` read, `mysql`.`db` read, `mysql`.`func` read, `mysql`.`host` read, `mysql`.`tables_priv` read, `mysql`.`user` read
[16:32:04][   0 ms] backup table `mysql`.`columns_priv`, `mysql`.`db`, `mysql`.`func`, `mysql`.`host`, `mysql`.`tables_priv`, `mysql`.`user` to 'c:/backup'
[16:32:05][   0 ms] unlock tables

Hmm.. thats not very intuitive.

Regards, Henrique.

[Ritesh]

BACKUP DATABASE… uses the MySQL's Backup Table SQL and will only take backup if the MySQL and SQLyog are installed in the same machine. It cannot take remote backups.

The best way to take backup's of a remote server is by using DB->Export Database As Batch Script…

HTH

[Author]

Posts