SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Hybrid View

  1. #1
    SitePoint Member
    Join Date
    Jan 2006
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Importing database problem

    I`m trying to import an SMF forums database. I`m using phpmyadmin as the file is rather small in size, at around 2mb.

    Problem is, the dump was created using mysql version 4.1.16-standard and the server I`m trying to import to is using an older version 4.0.25-standard. Naturally it`s causing problems, with syntax errors probably because of the charset differences.

    Now, I guess I could install a new SMF forum, and just run queries by pasting in the `INSERT INTO` portions only, but surely there`s an easier way to make the database compatible so I can import in one go? I also have another database to move, but again I can`t because of the syntax problems. It`s a pain going through the file and running queries!

    Thanks.

  2. #2
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    just delete the parts at the end of the table definitions that sepcify the charset. also, you will have to change where is says engine= to type= (or the other way around if i'm thinking about this backwards).


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •