Unsupported Screen Size: The viewport size is too small for the theme to render properly.

problem using 'backup database'

forums › forums › SQLyog › Using SQLyog › problem using 'backup database'

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • May 29, 2003 at 7:26 pm #7983
      henpa
      Member

      Howdy!

      I need to copy a database from one server to another, and I decided to give SQLyog a try. I selected the database and used the “Backup Database” menu option, then selected a directory and I got the following error. I know how to do this without SQLyog :cool:, but I wonder what went wrong. Can someone help? 🙄

      Code:
      Table                             Op      Msg_type  Msg_text                          
      ——————————–  ——  ——–  ———————————–
      monitoracao.clientes              backup  error     Failed copying .frm file: errno = 2
      monitoracao.clientes              backup  status    Operation failed                  
      monitoracao.mdp                   backup  error     Failed copying .frm file: errno = 2
      monitoracao.mdp                   backup  status    Operation failed                  
      monitoracao.objetos               backup  error     Failed copying .frm file: errno = 2
      monitoracao.objetos               backup  status    Operation failed

      Source database is MySQL 3.23.52 (Solaris 8 / SUN). I also tried using 4.0.13 (another server – RH9 Linux / Intel) and got the same exact error.

      Thanks, Henrique Pantarotto.

    • May 29, 2003 at 7:38 pm #14413
      henpa
      Member

      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.

    • May 30, 2003 at 2:18 pm #14414
      Ritesh
      Member

      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
Viewing 2 reply threads
  • You must be logged in to reply to this topic.