首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >我想在mysql中打开lower_case_table_names,但plesk10停止工作

问我想在mysql中打开lower_case_table_names,但plesk10停止工作
EN

Stack Overflow用户
提问于 2011-05-31 21:31:10
回答 1查看 1.9K关注 0票数 3

我想分享我对上述问题的解决方案,这样你就可以节省一些时间。解决方案很简单。您只需重命名PLESK 10使用的所有表(数据库psa)。使用您首选的mysql客户端并连接到数据库,然后执行以下sql脚本:

代码语言:javascript
复制
<!-- language: sql -->
    USE psa ;
    RENAME TABLE APSApplicationItems to apsapplicationitems ;
    RENAME TABLE APSCatalogUpdates to apscatalogupdates ;
    RENAME TABLE APSClientApplicationItems to apsclientapplicationitems ;
    RENAME TABLE APSLicenseTypes to apslicensetypes ;
    RENAME TABLE APSLicenses to apslicenses ;
    RENAME TABLE ApiRpcCallsStat to apirpccallsstat ;
    RENAME TABLE BackendCache to backendcache ;
    RENAME TABLE BackupsRunning to backupsrunning ;
    RENAME TABLE BackupsScheduled to backupsscheduled ;
    RENAME TABLE BackupsSettings to backupssettings ;
    RENAME TABLE Cards to cards ;
    RENAME TABLE ClientsTraffic to clientstraffic ;
    RENAME TABLE Components to components ;
    RENAME TABLE Configurations to configurations ;
    RENAME TABLE DashboardPreset to dashboardpreset ;
    RENAME TABLE DashboardPresetConfig to dashboardpresetconfig ;
    RENAME TABLE DatabaseServers to databaseservers ;
    RENAME TABLE DomainServices to domainservices ;
    RENAME TABLE DomainsTraffic to domainstraffic ;
    RENAME TABLE GL_remote_domains to gl_remote_domains ;
    RENAME TABLE GL_settings to gl_settings ;
    RENAME TABLE IP_Addresses to ip_addresses ;
    RENAME TABLE IpAddressesCollections to ipaddressescollections ;
    RENAME TABLE IpCollections to ipcollections ;
    RENAME TABLE Limits to limits ;
    RENAME TABLE Logos to logos ;
    RENAME TABLE MailLists to maillists ;
    RENAME TABLE MailMessagesStat to mailmessagesstat ;
    RENAME TABLE Modules to modules ;
    RENAME TABLE Notes to notes ;
    RENAME TABLE Notifications to notifications ;
    RENAME TABLE PMM to pmm ;
    RENAME TABLE PMMDefault to pmmdefault ;
    RENAME TABLE Parameters to parameters ;
    RENAME TABLE Permissions to permissions ;
    RENAME TABLE PersistentCache to persistentcache ;
    RENAME TABLE PlanItemProperties to planitemproperties ;
    RENAME TABLE PlanItems to planitems ;
    RENAME TABLE PlansSubscriptions to planssubscriptions ;
    RENAME TABLE PleskPagesStat to pleskpagesstat ;
    RENAME TABLE Repository to repository ;
    RENAME TABLE SBConfig to sbconfig ;
    RENAME TABLE SBResellers to sbresellers ;
    RENAME TABLE SBSites to sbsites ;
    RENAME TABLE SSOBranding to ssobranding ;
    RENAME TABLE SiteAppFiles to siteappfiles ;
    RENAME TABLE SiteAppPackages to siteapppackages ;
    RENAME TABLE SiteAppResources to siteappresources ;
    RENAME TABLE SiteApps to siteapps ;
    RENAME TABLE SiteAppsHitsStat to siteappshitsstat ;
    RENAME TABLE SitePagesStat to sitepagesstat ;
    RENAME TABLE Skins to skins ;
    RENAME TABLE SubscriptionProperties to subscriptionproperties ;
    RENAME TABLE Subscriptions to subscriptions ;
    RENAME TABLE Templates to templates ;
    RENAME TABLE TmplData to tmpldata ;
    RENAME TABLE WebApps to webapps ;
    RENAME TABLE Webmails to webmails ;
    RENAME TABLE externalWebmails to externalwebmails ;
    RENAME TABLE smb_apsBundleFilterItems to smb_apsbundlefilteritems ;
    RENAME TABLE smb_apsBundleFilters to smb_apsbundlefilters ;
    RENAME TABLE smb_apsCategories to smb_apscategories ;
    RENAME TABLE smb_apsContexts to smb_apscontexts ;
    RENAME TABLE smb_apsImportedResources to smb_apsimportedresources ;
    RENAME TABLE smb_apsImportedSettings to smb_apsimportedsettings ;
    RENAME TABLE smb_apsInstanceErrors to smb_apsinstanceerrors ;
    RENAME TABLE smb_apsInstances to smb_apsinstances ;
    RENAME TABLE smb_apsMetas to smb_apsmetas ;
    RENAME TABLE smb_apsPackageUpdates to smb_apspackageupdates ;
    RENAME TABLE smb_apsPackages to smb_apspackages ;
    RENAME TABLE smb_apsPackagesCategories to smb_apspackagescategories ;
    RENAME TABLE smb_apsProvisionEnvironments to smb_apsprovisionenvironments ;
    RENAME TABLE smb_apsProvisions to smb_apsprovisions ;
    RENAME TABLE smb_apsResourceParameters to smb_apsresourceparameters ;
    RENAME TABLE smb_apsResources to smb_apsresources ;
    RENAME TABLE smb_apsSettings to smb_apssettings ;
    RENAME TABLE smb_componentUpdates to smb_componentupdates ;
    RENAME TABLE smb_emailAliases to smb_emailaliases ;
    RENAME TABLE smb_fileSharingUnlistedFiles to smb_filesharingunlistedfiles ;
    RENAME TABLE smb_generalPermissions to smb_generalpermissions ;
    RENAME TABLE smb_productUpgrades to smb_productupgrades ;
    RENAME TABLE smb_roleGeneralPermissions to smb_rolegeneralpermissions ;
    RENAME TABLE smb_roleServicePermissions to smb_roleservicepermissions ;
    RENAME TABLE smb_serviceEntryPoints to smb_serviceentrypoints ;
    RENAME TABLE smb_serviceInstances to smb_serviceinstances ;
    RENAME TABLE smb_servicePermissionAccounts to smb_servicepermissionaccounts ;
    RENAME TABLE smb_servicePermissions to smb_servicepermissions ;
    RENAME TABLE smb_serviceProviders to smb_serviceproviders ;
    RENAME TABLE smb_userServicePermissions to smb_userservicepermissions ;

然后找到您的my.cnf文件(通常位于- unix: /etc/mysql/my.cnf;windows: /conf/my.cnf)并更改(如果不存在,则添加)以下行:

代码语言:javascript
复制
 lower\_case\_table\_names = 1
EN

回答 1

Stack Overflow用户

回答已采纳

发布于 2011-07-05 20:49:09

脚本化:

  1. 生成rename_psa.sql:

对于表中的表;执行echo "RENAME TABLE $table TO $(echo $table | tr A-Z a-z);“;完成> rename_psa.sql

  • Backup表并运行脚本scriptmysqldump -opt psa > psa.sql

mysql psa < rename_psa.sql

  • 编辑/etc/my.cnf & done
票数 1
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/6188348

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档