Estou com um grande problema ao fazer um backup do meu banco no mysql
Estou utilizando o SQLyog e o mysqldump para gerar.
Quando abro SQLyog e tento restaurar ele simplemente dá o erro:
“There was an error while executing a query. The query and the error message has been logged at: $LOG DE ERRO$. Please click on Open error file to open the error file.”
O log me mostra isso:
Query:
/!40101 SET NAMES utf8 //!40101 SET SQL_MODE=’’/
Error occured at:2007-07-11 22:32:08
Line no.:10
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘SET SQL_MODE=’’*/’ at line 1
Query:
/!40101 SET NAMES utf8 //!40101 SET SQL_MODE=’’/
Error occured at:2007-07-28 01:19:23
Line no.:10
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘SET SQL_MODE=’’*/’ at line 1
Query:
/!40101 SET NAMES utf8 //!40101 SET SQL_MODE=’’/
Error occured at:2007-07-28 01:19:31
Line no.:10
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘SET SQL_MODE=’’*/’ at line 1
Query:
DROP TABLE IF EXISTS icrm_abertura
Error occured at:2007-07-28 01:20:18
Line no.:3
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
DROP TABLE IF EXISTS icrm_abertura’ at line 1
Query:
/!40101 SET NAMES utf8 //!40101 SET SQL_MODE=’’/
Error occured at:2007-08-02 10:42:52
Line no.:10
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘SET SQL_MODE=’’*/’ at line 1
Query:
/!40101 SET NAMES utf8 //!40101 SET SQL_MODE=’’/
Error occured at:2007-08-03 18:13:58
Line no.:10
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘SET SQL_MODE=’’*/’ at line 1
Query:
DROP TABLE IF EXISTS icrm_abertura
Error occured at:2007-08-07 19:13:23
Line no.:2
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
DROP TABLE IF EXISTS icrm_abertura’ at line 1
Query:
DROP TABLE IF EXISTS icrm_abertura
Error occured at:2007-08-07 19:26:18
Line no.:2
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
DROP TABLE IF EXISTS icrm_abertura’ at line 1
Query:
DROP TABLE IF EXISTS icrm_abertura
Error occured at:2007-08-07 19:26:41
Line no.:2
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
DROP TABLE IF EXISTS icrm_abertura’ at line 1
Query:
DROP TABLE IF EXISTS icrm_abertura
Error occured at:2007-08-08 00:48:23
Line no.:2
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
DROP TABLE IF EXISTS icrm_abertura’ at line 1