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

By Distance
Sep 4, 2006
Topic Status:
Not open for further replies.
  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: 2.8.0.2

    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:

    NONE
    ANSI
    DB2
    MAXDB
    MSSQL
    MYSQL323
    MYSQL40
    ORACLE
    POSTGRESQL
    TRADITIONAL

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

    Mictlantecuhtli TechSpot Evangelist Posts: 4,916   +9

    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 Newcomer, in training Topic Starter

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

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

    Mictlantecuhtli TechSpot Evangelist Posts: 4,916   +9

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


Add New 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.