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

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

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 
  • info/concrete5/58/exportcsv.txt
  • Dernière modification: 2018/07/18 09:45
  • par radeff