PhpMyAdmin/Sql problem when im trying to transfer database..

By Distance
Sep 4, 2006
  1. Yo.. im trying to export a database from one server and import to another..

    export phpmyadmin version: 2.6.1-pl3
    new server import phpmyadmin version:

    When i use the vB option.. go onto maintainance and backup downloading the file this error comes up..

    #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 'DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci' at line 7

    The same error comes up when i export from the old server :s :confused:

    On my old servers phpmyadmin.. when i export the database i have an option:
    SQL export compatibility:


    does this have anything to do with it... please help :s
  2. Mictlantecuhtli

    Mictlantecuhtli TS Evangelist Posts: 4,345   +11

    SQL export compatibility might have something to do with it, I'd select MySQL40 from that list.

    But I've had so many problems with PHPMyAdmin that I use command line instead, dump the database to a file with mysqldump and import it with source command in MySQL console.
  3. Distance

    Distance TS Rookie Topic Starter

    no its still coming up with the error... sql40 didnt work

    i think im gonna have to start again :(
  4. Mictlantecuhtli

    Mictlantecuhtli TS Evangelist Posts: 4,345   +11

    Can you post the whole SQL command causing the error?
Topic Status:
Not open for further replies.

Similar Topics

Create an account or login to comment

You need to be a member in order to leave a comment
TechSpot Members
Login or sign up for free,
it takes about 30 seconds.
You may also...

Get complete access to the TechSpot community. Join thousands of technology enthusiasts that contribute and share knowledge in our forum. Get a private inbox, upload your own photo gallery and more.