Page MenuHomePhabricator
Paste P5067

(An Untitled Masterwork)
ActivePublic
Actions

Authored by Marostegui on Mar 17 2017, 9:15 AM.
Tags
None
Referenced Files
F6807297:
Mar 21 2017, 7:30 AM
F6662174:
Mar 17 2017, 9:22 AM
F6662154:
Mar 17 2017, 9:20 AM
F6662066:
Mar 17 2017, 9:15 AM
Subscribers
None
root@db1046:/home/marostegui# for i in `cat tables_to_rename.txt`; do echo "mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table $i to ${i}_15423246;'";done
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table CentralAuth_5690875 to CentralAuth_5690875_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table ChangesListFilters_16174591 to ChangesListFilters_16174591_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table ChangesListFilters_16403617 to ChangesListFilters_16403617_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table CommandInvocation_15243810 to CommandInvocation_15243810_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table ContentTranslation_11628043 to ContentTranslation_11628043_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table ContentTranslationCTA_16017678 to ContentTranslationCTA_16017678_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table ContentTranslationError_11767097 to ContentTranslationError_11767097_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table ContentTranslationSuggestion_16344900 to ContentTranslationSuggestion_16344900_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table CookieBlock_16241436 to CookieBlock_16241436_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table EchoInteraction_15823738 to EchoInteraction_15823738_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table EchoMail_5467650 to EchoMail_5467650_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table Edit_13457736 to Edit_13457736_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table EditConflict_8860941 to EditConflict_8860941_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table EditorActivation_14208837 to EditorActivation_14208837_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table ExternalLinksChange_15716074 to ExternalLinksChange_15716074_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table FlowReplies_10561344 to FlowReplies_10561344_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table GeoFeatures_12914994 to GeoFeatures_12914994_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table GettingStartedRedirectImpression_7355552 to GettingStartedRedirectImpression_7355552_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table GuidedTourButtonClick_13869649 to GuidedTourButtonClick_13869649_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table GuidedTourExited_8690566 to GuidedTourExited_8690566_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table GuidedTourExternalLinkActivation_8690560 to GuidedTourExternalLinkActivation_8690560_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table GuidedTourGuiderHidden_8690549 to GuidedTourGuiderHidden_8690549_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table GuidedTourGuiderImpression_8694395 to GuidedTourGuiderImpression_8694395_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table GuidedTourInternalLinkActivation_8690553 to GuidedTourInternalLinkActivation_8690553_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table ImageMetricsCorsSupport_11686678 to ImageMetricsCorsSupport_11686678_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table Kartographer_16132745 to Kartographer_16132745_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MediaViewer_10867062 to MediaViewer_10867062_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MediaWikiPingback_15781718 to MediaWikiPingback_15781718_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileAppCategorizationAttempts_5359208 to MobileAppCategorizationAttempts_5359208_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileAppLoginAttempts_5257721 to MobileAppLoginAttempts_5257721_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileAppShareAttempts_5346170 to MobileAppShareAttempts_5346170_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileAppUploadAttempts_5334329 to MobileAppUploadAttempts_5334329_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileOptionsTracking_14003392 to MobileOptionsTracking_14003392_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWebLanguageSwitcher_15302503 to MobileWebLanguageSwitcher_15302503_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWebMainMenuClickTracking_11568715 to MobileWebMainMenuClickTracking_11568715_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWebSearch_12054448 to MobileWebSearch_12054448_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWebUIClickTracking_10742159 to MobileWebUIClickTracking_10742159_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppAppearanceSettings_10375462 to MobileWikiAppAppearanceSettings_10375462_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppArticleSuggestions_10590869 to MobileWikiAppArticleSuggestions_10590869_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppArticleSuggestions_11448426 to MobileWikiAppArticleSuggestions_11448426_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppArticleSuggestions_12443791 to MobileWikiAppArticleSuggestions_12443791_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppArticleSuggestions_15302212 to MobileWikiAppArticleSuggestions_15302212_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppCreateAccount_8240702 to MobileWikiAppCreateAccount_8240702_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppCreateAccount_9135391 to MobileWikiAppCreateAccount_9135391_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppDailyStats_12637385 to MobileWikiAppDailyStats_12637385_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppEdit_16256587 to MobileWikiAppEdit_16256587_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppEdit_9003125 to MobileWikiAppEdit_9003125_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppFeed_15734713 to MobileWikiAppFeed_15734713_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppFindInPage_14586774 to MobileWikiAppFindInPage_14586774_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppInstallReferrer_12601905 to MobileWikiAppInstallReferrer_12601905_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppIntents_15237384 to MobileWikiAppIntents_15237384_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppLangSelect_12588733 to MobileWikiAppLangSelect_12588733_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppLinkPreview_12143205 to MobileWikiAppLinkPreview_12143205_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppLinkPreview_14095177 to MobileWikiAppLinkPreview_14095177_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppLinkPreview_15730939 to MobileWikiAppLinkPreview_15730939_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppLogin_8234533 to MobileWikiAppLogin_8234533_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppLogin_9135390 to MobileWikiAppLogin_9135390_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppMediaGallery_10923135 to MobileWikiAppMediaGallery_10923135_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppMediaGallery_12588701 to MobileWikiAppMediaGallery_12588701_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppNavMenu_12732211 to MobileWikiAppNavMenu_12732211_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppOnboarding_9123466 to MobileWikiAppOnboarding_9123466_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppPageScroll_14591606 to MobileWikiAppPageScroll_14591606_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppProtectedEditAttempt_8682497 to MobileWikiAppProtectedEditAttempt_8682497_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppReadingLists_15520526 to MobileWikiAppReadingLists_15520526_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppSavedPages_10375480 to MobileWikiAppSavedPages_10375480_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppSearch_10641988 to MobileWikiAppSearch_10641988_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppSearch_15729321 to MobileWikiAppSearch_15729321_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppSessions_14031591 to MobileWikiAppSessions_14031591_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppSessions_15522505 to MobileWikiAppSessions_15522505_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppShareAFact_11331974 to MobileWikiAppShareAFact_11331974_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppShareAFact_12588711 to MobileWikiAppShareAFact_12588711_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppStuffHappens_8955468 to MobileWikiAppStuffHappens_8955468_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppTabs_12453651 to MobileWikiAppTabs_12453651_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppToCInteraction_10375484 to MobileWikiAppToCInteraction_10375484_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppToCInteraction_11014396 to MobileWikiAppToCInteraction_11014396_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppToCInteraction_14585319 to MobileWikiAppToCInteraction_14585319_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppWidgets_11312870 to MobileWikiAppWidgets_11312870_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MobileWikiAppWiktionaryPopup_15158116 to MobileWikiAppWiktionaryPopup_15158116_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MultimediaViewerAttribution_9758179 to MultimediaViewerAttribution_9758179_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MultimediaViewerDimensions_10014238 to MultimediaViewerDimensions_10014238_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MultimediaViewerDuration_10427980 to MultimediaViewerDuration_10427980_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MultimediaViewerNetworkPerformance_15573630 to MultimediaViewerNetworkPerformance_15573630_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table MultimediaViewerVersusPageFilePerformance_7907636 to MultimediaViewerVersusPageFilePerformance_7907636_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table NavigationTiming_15485142 to NavigationTiming_15485142_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table NavigationTiming_16305090 to NavigationTiming_16305090_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table NewEditorEdit_6792669 to NewEditorEdit_6792669_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table PageContentSaveComplete_5588433 to PageContentSaveComplete_5588433_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table PageCreation_7481635 to PageCreation_7481635_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table PageDeletion_7481655 to PageDeletion_7481655_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table PageMove_7495717 to PageMove_7495717_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table PageRestoration_7758372 to PageRestoration_7758372_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table Popups_16208085 to Popups_16208085_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table Popups_16364296 to Popups_16364296_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table PrefUpdate_5563398 to PrefUpdate_5563398_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table ReadingDepth_16325045 to ReadingDepth_16325045_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table RelatedArticles_14496900 to RelatedArticles_14496900_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table RelatedArticles_16352530 to RelatedArticles_16352530_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table SaveTiming_15396492 to SaveTiming_15396492_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table ServerSideAccountCreation_5487345 to ServerSideAccountCreation_5487345_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table TestSearchSatisfaction2_15357244 to TestSearchSatisfaction2_15357244_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table TestSearchSatisfaction2_15700292 to TestSearchSatisfaction2_15700292_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table TestSearchSatisfaction2_15922352 to TestSearchSatisfaction2_15922352_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table TestSearchSatisfaction2_16270835 to TestSearchSatisfaction2_16270835_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table TranslationRecommendationAPIRequests_16261139 to TranslationRecommendationAPIRequests_16261139_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table TranslationRecommendationUIRequests_15484897 to TranslationRecommendationUIRequests_15484897_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table TranslationRecommendationUserAction_15858947 to TranslationRecommendationUserAction_15858947_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table UniversalLanguageSelector_7327441 to UniversalLanguageSelector_7327441_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table UploadWizardErrorFlowEvent_11772725 to UploadWizardErrorFlowEvent_11772725_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table UploadWizardExceptionFlowEvent_11772722 to UploadWizardExceptionFlowEvent_11772722_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table UploadWizardFlowEvent_11772723 to UploadWizardFlowEvent_11772723_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table UploadWizardStep_11772724 to UploadWizardStep_11772724_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table UploadWizardTutorialActions_5803466 to UploadWizardTutorialActions_5803466_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table UploadWizardUploadFlowEvent_11772717 to UploadWizardUploadFlowEvent_11772717_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table WikimediaBlogVisit_5308166 to WikimediaBlogVisit_5308166_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table WikipediaPortal_14377354 to WikipediaPortal_14377354_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table WikipediaPortal_15890769 to WikipediaPortal_15890769_15423246;'
mysql --skip-ssl log -e 'set session sql_log_bin=0; rename table WikipediaZeroUsage_14574251 to WikipediaZeroUsage_14574251_15423246;'
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL