Check out the SMF Function DB!
Started by dxyy, November 26, 2008, 04:39:34 AM
Quote from: hugodiaz on December 26, 2009, 02:10:49 PMNorv thanks a lot for your suggestions. I have a quick question about exporting the database. Does structure only mean that I will not be compromising the data of my users?
Quote from: Norv on December 11, 2009, 06:45:24 PM2) connect with FTP to your account, and download to your computer the file Settings.php from your forum directory. Open it in a code editor and see if it contains a line like:Code Select Expand$db_character_set = 'utf8';Please tell if you have that line. (don't modify the file yet)3) In phpMyAdmin, select the "SQL" tab, and paste there the following SQL code:Code Select ExpandSELECT value FROM smf_settings WHERE variable = 'global_character_set';and post the result here.
$db_character_set = 'utf8';
SELECT value FROM smf_settings WHERE variable = 'global_character_set';
Quote from: hugodiaz on December 27, 2009, 07:02:34 AMI haven't modified anything on the regular forum as yet, but I already changed the database to utf-8 through phpMyAdmin on the test forum.
Quote from: JimM on January 26, 2010, 04:55:58 PMOnce you complete this be sure and mark this topic as solved.