DB Migration failure

Permalink
I recently downloaded and installed Concrete5 into a Wamp system for testing and after messing around with it and creating a test site, and being I liked it, I checked with my hosting provider if they have Concrete5 as an installable option, for which they did, so I installed it on to a test folder within my document root on my hosting provider's server, now, first using mysqldump I created an sql file in my local hard drive, then using my hosting providers CPanel PhPMyAdmin, I attempted to import that file into the already existing DB created by Concrete5 during installation, but, the biggest problem now is the import constantly fails with:-
SQL query:
-- MySQL dump 10.13 Distrib 5.7.19, for Win64 (x86_64) -- -- Host: localhost Database: concrete_cms -- ------------------------------------------------------ -- Server version   5.7.19 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
MySQL said: Documentation
#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 '-' at line 1


So I tried on my local mysql server by using these commands within the mysql console:-
mysql> create database testdb;
Query OK, 1 row affected (0.00 sec)
mysql> use testdb;
Database changed
mysql> \.testdb.sql;
ERROR:
ASCII '\0' appeared in the statement, but this is not allowed unless option --binary-mode is enabled and mysql is run in non-interactive mode. Set --binary-mode to 1 if ASCII '\0' is expected. Query: ' ■-'.
Bye


So importing back to another DB fails too.

It seems the onmly way to really mkae sure this work, is to start from scratch on the hosting provider server, there is no way in hell that Concrete5 DB can be imported, all other DB's can, including E107, Drupal, Wordpress, but NOT Concrete5

 
hutman replied on at Permalink Reply
hutman
On your WAMP server, can you export the SQL without comments? It looks like the comments might be breaking the import.

Also, you should empty the database on your host and then import, but it looks like you already did that.