I'm trying to move a CMSMS website... I export a database from one phpmyadmin, then import it into another phpmyadmin on a different server.
Now, I try and import the database and I get this error:
I just get:
Error
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem
(lots of coding here)
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 '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w' at line 1
Is this something I'm doing wrong or is a hosting issue?
[solved] Problem importing database
-
robinmarek
- Forum Members
- Posts: 208
- Joined: Thu Nov 13, 2008 4:02 pm
[solved] Problem importing database
Last edited by robinmarek on Wed Jan 07, 2009 8:23 pm, edited 1 time in total.
-
robinmarek
- Forum Members
- Posts: 208
- Joined: Thu Nov 13, 2008 4:02 pm
Re: Problem importing database
Don't worry, problem solved! After I exported it with no 'zipping' it seemed to import just fine!
Re: [solved] Problem importing database
http://www.cmsmadesimple.org/about-link/features/Dr.CSS wrote:http://lmgtfy.com/?q=export+import+database
Friendly support in forums and irc
