I've moved servers, so i need to transfer my database for my site and forums to my new host. I have made back-ups of both and have tried to use PHPMyAdmin on my new host to upload the SQL back-ups. When ever i try to do this is get an error. I have tried it with both databases and get the same error. I have checked the SQL version on the old host which is 4.1.13 and on the new host it's 4.0.25. If this is the problem is there any other way i can upload my database without having to start all over again?
The error:
MySQL said:
#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 '-- phpMyAdmin SQL Dump
-- version 2.6.3-pl1
-- [www....]
