exporter une base de données concrete5.8 en csv
il peut être utile pour voir ce qui se passe de faire un diff ou un meld sur les données mysql suite à des opérations sur un site concrete5.8
malheureusement, vu la complexité des tables, en mysql c'est inutilisable
une astuce pour faire un export csv, qui facilite grandement le diff
c58.tables.list.txt
AreaLayoutColumns AreaLayoutCustomColumns AreaLayoutPresets AreaLayoutThemeGridColumns AreaLayouts AreaLayoutsUsingPresets AreaPermissionAssignments AreaPermissionBlockTypeAccessList AreaPermissionBlockTypeAccessListCustom Areas AttributeKeyCategories AttributeKeys AttributeSetKeys AttributeSets AttributeTypeCategories AttributeTypes AttributeValues AuthenticationTypes BannedWords BasicWorkflowPermissionAssignments BasicWorkflowProgressData BlockFeatureAssignments BlockPermissionAssignments BlockTypePermissionBlockTypeAccessList BlockTypePermissionBlockTypeAccessListCustom BlockTypeSetBlockTypes BlockTypeSets BlockTypes Blocks CollectionAttributeKeys CollectionAttributeValues CollectionSearchIndexAttributes CollectionVersionAreaStyles CollectionVersionBlockStyles CollectionVersionBlocks CollectionVersionBlocksCacheSettings CollectionVersionBlocksOutputCache CollectionVersionFeatureAssignments CollectionVersionRelatedEdits CollectionVersionThemeCustomStyles CollectionVersions Collections Config ConfigStore ConversationDiscussions ConversationEditors ConversationFeatureDetailAssignments ConversationFlaggedMessageTypes ConversationFlaggedMessages ConversationMessageAttachments ConversationMessageNotifications ConversationMessageRatings ConversationMessages ConversationPermissionAddMessageAccessList ConversationPermissionAssignments ConversationRatingTypes ConversationSubscriptions Conversations DownloadStatistics ExpressAttributeKeys ExpressEntities ExpressEntityAssociationSelectedEntries ExpressEntityAssociations ExpressEntityEntries ExpressEntityEntryAssociations ExpressEntityEntryAttributeValues ExpressForm170ExpressSearchIndexAttributes ExpressFormFieldSetAssociationControls ExpressFormFieldSetAttributeKeyControls ExpressFormFieldSetControls ExpressFormFieldSetTextControls ExpressFormFieldSets ExpressForms FeatureAssignments FeatureCategories Features FileAttributeKeys FileAttributeValues FileImageThumbnailPaths FileImageThumbnailTypes FilePermissionAssignments FilePermissionFileTypeAccessList FilePermissionFileTypeAccessListCustom FilePermissionFileTypes FileSearchIndexAttributes FileSetFiles FileSetSavedSearches FileSets FileStorageLocationTypes FileStorageLocations FileUsageRecord FileVersionLog FileVersions Files GatheringConfiguredDataSources GatheringDataSources GatheringItemFeatureAssignments GatheringItemSelectedTemplates GatheringItemTemplateFeatures GatheringItemTemplateTypes GatheringItemTemplates GatheringItems GatheringPermissionAssignments Gatherings GroupSetGroups GroupSets Groups JobSetJobs JobSets Jobs JobsLog LegacyAttributeKeys Logs MailImporters MailValidationHashes MultilingualPageRelations MultilingualTranslations NotificationAlerts NotificationPermissionSubscriptionList NotificationPermissionSubscriptionListCustom Notifications OauthUserMap Packages PageFeeds PagePaths PagePermissionAssignments PagePermissionPageTypeAccessList PagePermissionPageTypeAccessListCustom PagePermissionPropertyAccessList PagePermissionPropertyAttributeAccessListCustom PagePermissionThemeAccessList PagePermissionThemeAccessListCustom PageSearchIndex PageTemplates PageThemeCustomStyles PageThemes PageTypeComposerControlTypes PageTypeComposerFormLayoutSetControls PageTypeComposerFormLayoutSets PageTypeComposerOutputBlocks PageTypeComposerOutputControls PageTypePageTemplateDefaultPages PageTypePageTemplates PageTypePermissionAssignments PageTypePublishTargetTypes PageTypes PageWorkflowProgress Pages PermissionAccess PermissionAccessEntities PermissionAccessEntityGroupSets PermissionAccessEntityGroups PermissionAccessEntityTypeCategories PermissionAccessEntityTypes PermissionAccessEntityUsers PermissionAccessList PermissionAccessWorkflows PermissionAssignments PermissionDurationObjects PermissionKeyCategories PermissionKeys PileContents Piles PrivateMessageNotifications QueueMessages QueuePageDuplicationRelations Queues SavedFileSearchQueries SavedPageSearchQueries SavedUserSearchQueries Sessions SiblingPageRelations SignupRequests SiteAttributeKeys SiteAttributeValues SiteLocales SiteSearchIndexAttributes SiteTreeTrees SiteTrees SiteTypes Sites SocialLinks StackUsageRecord Stacks StyleCustomizerCustomCssRecords StyleCustomizerInlineStylePresets StyleCustomizerInlineStyleSets StyleCustomizerValueLists StyleCustomizerValues SystemAntispamLibraries SystemCaptchaLibraries SystemContentEditorSnippets SystemDatabaseMigrations SystemDatabaseQueryLog TopicTrees TreeFileNodes TreeGroupNodes TreeNodePermissionAssignments TreeNodeTypes TreeNodes TreeSearchQueryNodes TreeTypes Trees UserAttributeKeys UserAttributeValues UserBannedIPs UserGroups UserPermissionEditPropertyAccessList UserPermissionEditPropertyAttributeAccessListCustom UserPermissionViewAttributeAccessList UserPermissionViewAttributeAccessListCustom UserPointActions UserPointHistory UserPrivateMessages UserPrivateMessagesTo UserSearchIndexAttributes UserSignupNotifications UserSignups UserValidationHashes UserWorkflowProgress Users WorkflowProgress WorkflowProgressCategories WorkflowProgressHistory WorkflowProgressNotifications WorkflowRequestObjects WorkflowTypes Workflows atAddress atAddressSettings atBoolean atBooleanSettings atDateTime atDateTimeSettings atDefault atEmptySettings atExpress atExpressSelectedEntries atExpressSettings atFile atFileSettings atNumber atSelect atSelectOptionLists atSelectOptions atSelectOptionsSelected atSelectSettings atSelectedSocialLinks atSelectedTopics atSocialLinks atTextSettings atTextareaSettings atTopic atTopicSettings authTypeConcreteCookieMap btContentFile btContentImage btContentLocal btCoreAreaLayout btCoreConversation btCorePageTypeComposerControlOutput btCoreScrapbookDisplay btCoreStackDisplay btDateNavigation btDesktopNewsflowLatest btDesktopSiteActivity btExpressEntryDetail btExpressEntryList btExpressForm btExternalForm btFaq btFaqEntries btFeature btForm btFormAnswerSet btFormAnswers btFormQuestions btGoogleMap btImageSlider btImageSliderEntries btNavigation btNextPrevious btPageAttributeDisplay btPageList btPageTitle btRssDisplay btSearch btShareThisPage btSocialLinks btStuccoDefinitionListBlock btStuccoHeading btSurvey btSurveyOptions btSurveyResults btSwitchLanguage btTags btTestimonial btTopicList btVideo btYouTube gaPage
mysqldump2csv.sh
et le script bash, à placer dans le même répertoire
cat c58.tables.list.txt | while read i do echo $i mysqldump -T /var/lib/mysql-files --fields-terminated-by ',' --fields-enclosed-by '"' --fields-escaped-by '\' --no-create-info c58 $i done