Register or have you forgotten your password?
Get the most out of Surmunity, read our tips here! Need an interesting blog to read? You've got to read the Surpass Blog!
| Welcome! Please register to access all of our features.
| PHP, MySQL General PHP questions. Or go to our PHPsuexec Forum >> |
 |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread |
December 2nd, 2007, 12:06 AM
|
#1 (permalink) |
|
Registered User
Seasoned Poster
Joined in Nov 2007
Lives in Conneaut, Ohio
Hosted on SH108
41 posts
Gave thanks: 4
Thanked 0 times
|
SQL character set question
I am moving a forum and I have a copy of the database. I am trying to upload it with phpmyadmin. It ask what the character set is. How can i find out what the character set is??
__________________
|
|
    
|
|
December 2nd, 2007, 12:31 AM
|
#2 (permalink) |
|
Registered User
Seasoned Poster
Joined in Nov 2007
Lives in Conneaut, Ohio
Hosted on SH108
41 posts
Gave thanks: 4
Thanked 0 times
|
Ok I found out what the character set is. But I got this error in phpmyadmin.
Code:
Error SQL query: INSERT INTO `smf_forumlog_actions` ( `ID_ACTION` , `logTime` , `ID_MEMBER` , `ip` , `action` , `extra` ) VALUES # -------------------------------------------------------- # # Table structure for table `smf_forumlog_activity` # DROP TABLE IF EXISTS `smf_forumlog_activity` ; MySQL said: #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 'DROP TABLE IF EXISTS `smf_forumlog_activity`' at line 5
__________________
|
|
|
|
