Tekil Mesaj gösterimi - Veritabanı Tablo Karakter Setini değiştirmek için MySQL Sorgusu

Konu Veritabanı Tablo Karakter Setini değiştirmek için MySQL Sorgusu
17-07-2010, 23:47:41
FSK
Arkadaşlar, mybb 'ye geçiş için veritabanı karakter setimi utf8 yapmam gerekti ve bir mysql sorgusu oluşturdum. Tek tek bütün veritabanı isimlerini yazdım. Bende vBSeo ve diğer eklentiler de vardı onlarda araya karıştı. Olur da veritabanı karakter setinizi dönüştürmek isterseniz aşağıdaki sorguyu çalıştırmanız yeterlidir
Önce kendi veritabanı tablolarınızla karşılaştırın. Listede olmayan tablo isimlerinin bulunduğu satırı komple silin.
ALTER TABLE `adminhelp` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `administrator` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `adminlog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `adminmessage` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `adminutil` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `album` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `albumpicture` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `albumupdate` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `announcement` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `announcementread` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `attachment` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `attachmentpermission` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `attachmenttype` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `attachmentviews` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `avatar` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `bbcode` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `bookmarksite` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `calendar` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `calendarcustomfield` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `calendarmoderator` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `calendarpermission` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `cpsession` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `cron` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `cronlog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `customavatar` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `customprofilepic` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `cyb_chatbox` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `datastore` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `deletionlog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `discussion` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `discussionread` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `editlog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `event` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `externalcache` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `faq` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `forum` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `forumpermission` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `forumprefixset` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `forumread` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `groupmessage` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `groupmessage_hash` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `groupread` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `holiday` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `humanverify` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `hvanswer` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `hvquestion` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `icon` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `imagecategory` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `imagecategorypermission` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `impexerror` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `infraction` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `infractionban` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `infractiongroup` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `infractionlevel` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `language` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `mailqueue` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `moderation` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `moderator` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `moderatorlog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `notice` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `noticecriteria` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `noticedismissed` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `passwordhistory` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `paymentapi` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `paymentinfo` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `paymenttransaction` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phrase` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phrasetype` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `picture` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `picturecomment` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `picturecomment_hash` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `plugin` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `pm` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `pmreceipt` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `pmtext` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `pmthrottle` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `podcast` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `podcastitem` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `poll` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `pollvote` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `post` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `postedithistory` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `posthash` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `postindex` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `postlog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `postparsed` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `post_thanks` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `prefix` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `prefixpermission` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `prefixset` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `product` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `productcode` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `productdependency` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `profileblockprivacy` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `profilefield` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `profilefieldcategory` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `profilevisitor` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `ranks` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `reminder` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `reputation` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `reputationlevel` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rssfeed` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `rsslog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `search` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `session` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `setting` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `settinggroup` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `sigparsed` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `sigpic` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smilie` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `socialgroup` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `socialgroupcategory` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `socialgroupicon` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `socialgroupmember` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `socialgrouppicture` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `spamlog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `stats` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `strikes` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `style` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `subscribediscussion` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `subscribeevent` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `subscribeforum` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `subscribegroup` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `subscribethread` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `subscription` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `subscriptionlog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `subscriptionpermission` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `tachyforumcounter` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `tachyforumpost` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `tachythreadcounter` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `tachythreadpost` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `tagsearch` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `tagthread` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `template` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `templatehistory` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `thread` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `threadrate` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `threadread` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `threadredirect` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `threadviews` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `upgradelog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `user` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `useractivation` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `userban` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `userchangelog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `usercss` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `usercsscache` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `usergroup` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `userfield` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `usergroupleader` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `usergrouprequest` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `userlist` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `usernote` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `userpromotion` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `usertextfield` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `usertitle` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `vbfields` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `vbseo_blacklist` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `vbseo_linkback` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `vbseo_serviceupdate` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `visitormessage` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `visitormessage_hash` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `word` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;