TechSpot

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: 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 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 New Comment

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