I don't seem to be able to import a database into phpmyadmin,i tried to upload a database for wordpress,yet it timed out,and said an error had occured,i tried again by sql inject,but it still wouldnt have it.
The database i was trying to upload was from another host so i thought maybe there was something in the code,so i then tried to re-upload the one i i had just created on here,only for it to come up with errors again. strange. maybe its a timing out issue,but creating 10 tables with little info on them should't time you out all the time.
Maybe there's a mismatch in terms of the version of MySQL? Or perhaps you should check the encoding.
How big is the database? There might also be an option to upload a gzipped database, maybe that one might work.
I always import database by Mysql Management on DirectAdmin. That's much faster and easier.
He said SQL not MySQL...
I think the change you made is a compatibility thing between SQL and MySQL or so it looks.
Some databases are not compatible with eachother. Different language used to get MySQL to do what SQL will do, and sometimes MySQL won't do it at all. You are lucky if you were able to make this kind of transition.
What you did, I think, is take out the statements that were not MySQL compatible. You did it the hard way, congrats!!
Just make sure that the default character set for the database is something like "latin1" and you'll be fine. If you don't have any problems, then you don't have to do this at all...I'm just trying to let you know how to fix the parts that you excluded. If you are using it and you get weird characters instead of what you are expecting, then you might need to go in and tell the database latin1 is default character set. You would have had a lot more troubles if you were doing this in some asian dialect. But because you are using latin1 characters anyway then you won't even know the difference.
