I had just move from an other webhost there i had all my sql databases and everything and now i want to move the site, mysql and verything to this webhost without lost anything. I have taken an backup both in the website ( i use php fusion) and in phpmyadmin, and i have now got the file. But when I try to load it up on my phpadmin in this webhosting (frihost) phpmyadmin just says this: #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' at line 9. Anyone know why this happend and how i can move without lose anyting
BTW: before i used AwardSpace and they were the worst webhost i everr had tryd!
Okey i tryd that you said first but it didnt work. I also tryd to export an databse that i have on this webhost and then insert it in an new databse also in this host but that didnt work either...
Oh... I remember having a silly error like this when I backed up my last MySQL database between different versions.
I never found out why it happenned but to correct it I "find and replaced" all the information to do with Character Sets. I think I just removed the information but I may have changed it to the most basic set possible (latin1?).
Okey, but how do I chnage from latin1 to something els because the error messenger says that it is latin1 or something it is wrong on..
sorry for my bad english..
Can you not just create the database again and just import the tables? Otherwise try just deleting all "default character set" & "collate" from the sql file
I suggest you just use a search & replace for the things that is bugs on, search for the errors and replace with a blank space. I had the same problem that fixed it.
why do people use mysql? mysql is not meant for storing huge amount of data it is efficient only when the data is in small quantities. I screwed up one project my choosing this database. Only good thing about it is Simplicity and its free.
MySQL is perfectly fine for average web use. You're right that it's not good for large quantities of data but the definition of "large" in this case is for huge companies who have Terrabyte databases!