Membro desde: 03/06/2007 00:00:00
Mensagens: 140
Offline
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
08/08/2007 02:58:37
Assunto:
marcossousaPJ
GUJ Master
Membro desde: 14/01/2004 00:00:00
Mensagens: 1835
Offline
Você está usando qual aplicação para gerar o backup. Use aquele Tools do Mysql. Tem um administrator lá muito bom. Só o query browser que é horrível.
![[Post New]](/templates/default/images/icon_minipost_new.gif){kind=icon}
![[Up]](/templates/default/images/icon_up.gif){kind=icon}
![[Avatar]](/images/avatar/1)
![[WWW]](/templates/default/images/icon_www.gif){kind=icon}
![[ICQ]](/templates/default/images/icon_icq_add.gif){kind=icon}
![[Avatar]](http://www.marcossousa.com/wp-content/uploads/2009/10/dsc075651.jpeg)
![[Avatar]](/images/avatar/0)