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

Regular backups

forums › forums › SQLyog › Using SQLyog › Regular backups

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • June 3, 2003 at 12:15 pm #8001
      berthelemy
      Member

      Hi,

      I'm trying to setup a daily backup of one of the MySQL databases. It seems that there is no way to do this within SQLyog (?) so I'm using mysqldump to create an optimised dump file and then importing it using the Execute Batch file option.

      The mysqldump command is: mysqldump –opt –user #### –password=#### databasename > databasedump.sql

      But I'm getting an error on running the Execute Batch file:

      — MySQL dump 8.21

      —

      — Host: localhost Database: databasename

      — Server version 3.23.49-max

      —

      — Table structure for table 'contacts'

      —

      DROP TABLE IF EXISTS contacts

      Error : Something is wrong in your syntax près de '

      — Se' à la ligne 4

      Am I barking up the wrong tree?

      Thanks,

      Mark

    • June 3, 2003 at 12:37 pm #14450
      Shadow
      Member

      SQLyog is not able to schedule backups, it is a db front end and expects user interaction. You should use Win's built in scheduler with mysql dump.

      About the error in “Execute batch file”: you should remove the line containing

      …,and the import will be done!

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.