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

Add your comment to this article

You need to be a member to leave a comment. Join thousands of tech enthusiasts and participate.
TechSpot Account You may also...