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!