Web Wiz - Solar Powered Eco Web Hosting

  New Posts New Posts RSS Feed - Error MySql DB (Migration Server Hosting)
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Error MySql DB (Migration Server Hosting)

 Post Reply Post Reply
Author
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Poole
Status: Offline
Points: 9740
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Topic: Error MySql DB (Migration Server Hosting)
    Posted: 26 August 2014 at 10:00am
Try removing line 13 which is causing the error and see if that fixes the issue.
Back to Top
Allan Douglas View Drop Down
Groupie
Groupie


Joined: 14 August 2007
Location: Brazil
Status: Offline
Points: 62
Post Options Post Options   Thanks (0) Thanks(0)   Quote Allan Douglas Quote  Post ReplyReply Direct Link To This Post 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 

Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.05
Copyright ©2001-2022 Web Wiz Ltd.


Become a Fan on Facebook Follow us on Twitter Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Policy

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2022 Web Wiz Ltd. All rights reserved.