Print Page | Close Window

Error MySql DB (Migration Server Hosting)

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=31063
Printed Date: 28 November 2022 at 2:33pm
Software Version: Web Wiz Forums 12.05 - http://www.webwizforums.com


Topic: Error MySql DB (Migration Server Hosting)
Posted By: Allan Douglas
Subject: Error MySql DB (Migration Server Hosting)
Date Posted: 26 August 2014 at 12:21am
Hello guys, 

I'm upgrading hosting server, however I am having trouble importing MYSQL database to the new server, could someone help?

Erro

Comando SQL:

# HeidiSQL Dump 
#
# --------------------------------------------------------
# Host:                 200.219.235.xxx
# Database:             golc_golforummmxii
# Server version:       5.1.55-community
# Server OS:            Win64
# Target-Compatibility: Standard ANSI SQL
# HeidiSQL version:     3.1 RC1 Revision: 1064
# --------------------------------------------------------

/*!40100 SET CHARACTER SET latin1;*/
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ANSI';*/
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;*/


#
# Database structure for database 'golc_ golforummmxii'
#

CREATE DATABASE /*!32312 IF NOT EXISTS*/ "golc_golforummmxii" /*!40100 DEFAULT CHARACTER SET latin1 */;

Mensagens do MySQL :

#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 @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ANSI';*/
/*!40014 SET @OLD_FOREIGN_KEY_' at line 13 




Replies:
Posted By: WebWiz-Bruce
Date Posted: 26 August 2014 at 10:00am
Try removing line 13 which is causing the error and see if that fixes the issue.


-------------
http://www.facebook.com/WebWiz" rel="nofollow - Find Web Wiz on Facebook
http://twitter.com/WebWizUK" rel="nofollow - Follow Web Wiz on Twitter



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.05 - http://www.webwizforums.com
Copyright ©2001-2022 Web Wiz Ltd. - https://www.webwiz.net