Ttdfjt

Should 2FA be enabled on service accounts?

HackerRank Implement Queue using two stacks Solution

Is the EU really banning "toxic propellants" in 2020? How is that going to work?

Why are prop blades not shaped like household fan blades?

What do the screens say after you are set free?

What is the most 'environmentally friendly' way to learn to fly?

How to avoid a lengthy conversation with someone from the neighborhood I don't share interests with

Is verification of a blockchain computationally cheaper than recreating it?

Can birds evolve without trees?

Who's behind community AMIs on Amazon EC2?

Why is “deal 6 damage” a legit phrase?

Gold Battle KoTH

Need help identifying how to open this bolt/screw

How to trick a fairly simplistic kill-counter?

How were x-ray diffraction patterns deciphered before computers?

How do I solve such questions on paramagnetism and ferromagnetism?

Define tcolorbox in math mode

Does the use of a new concept require a prior definition?

Plotting Chebyshev polynomials using PolarPlot and FilledCurve

Has J.J.Jameson ever found out that Peter Parker is Spider-Man?

What is the difference between 2/4 and 4/4 when it comes the accented beats?

Protect a 6 inch air hose from physical damage

Is Illustrator accurate for business card sizes?

Matrix condition number and reordering

Migrate Static Blocks and multi stores from One Magento to Another

Magento 2 migerationHow to: Export data from Magento 1.x and import in 2.0?How can I create and update static blocks via a module install script?Is there a way to export static blocks and cms pages in mass from local to online?Migrate Magento 1.7 separate store to Magento 2 multistore (just customers and history)How to migrate data from 2.0.X to 2.2.XHow to manually import/migrate orders & customers from Magento1 to Magento 2 database tables?Magento2 Migrate Orders History and Product Catalog Including MediaMagento 2.3: Show content block in terms & agreement popup at checkoutMigrate data from 3 websites to one multisite

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

What is the best way to migrate Magento Content i.e Blocks, Pages, and All content from one Magento instance to another. I have 2 Magento setups. One of which has all data and another is fresh Magento. Both have same Magento version. I do not want to migrate the complete DB as I have many junk orders/customers/products etc.. All I want to migrate is the stores, Content blocks, pages, and basically all content related data.

What is the best way to achieve this?

magento2 magento2.3 data-migration static-content

share|improve this question

edited Jul 24 at 7:04

Waqar Ali

4491616 bronze badges

asked Jul 24 at 6:17

TesterTester

771010 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  firebearstudio.com/blog/…
  
  – Hafiz Arslan
  Jul 24 at 7:40
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Extensions use I am trying to avoid
  
  – Tester
  Jul 24 at 7:45
  

  
  
  
  

add a comment | 

0

What is the best way to migrate Magento Content i.e Blocks, Pages, and All content from one Magento instance to another. I have 2 Magento setups. One of which has all data and another is fresh Magento. Both have same Magento version. I do not want to migrate the complete DB as I have many junk orders/customers/products etc.. All I want to migrate is the stores, Content blocks, pages, and basically all content related data.

What is the best way to achieve this?

magento2 magento2.3 data-migration static-content

share|improve this question

edited Jul 24 at 7:04

Waqar Ali

4491616 bronze badges

asked Jul 24 at 6:17

TesterTester

771010 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  firebearstudio.com/blog/…
  
  – Hafiz Arslan
  Jul 24 at 7:40
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Extensions use I am trying to avoid
  
  – Tester
  Jul 24 at 7:45
  

  
  
  
  

add a comment | 

What is the best way to migrate Magento Content i.e Blocks, Pages, and All content from one Magento instance to another. I have 2 Magento setups. One of which has all data and another is fresh Magento. Both have same Magento version. I do not want to migrate the complete DB as I have many junk orders/customers/products etc.. All I want to migrate is the stores, Content blocks, pages, and basically all content related data.

What is the best way to achieve this?

magento2 magento2.3 data-migration static-content

share|improve this question

edited Jul 24 at 7:04

Waqar Ali

4491616 bronze badges

asked Jul 24 at 6:17

TesterTester

771010 bronze badges

share|improve this question

edited Jul 24 at 7:04

Waqar Ali

4491616 bronze badges

asked Jul 24 at 6:17

TesterTester

771010 bronze badges

share|improve this question

edited Jul 24 at 7:04

Waqar Ali

4491616 bronze badges

asked Jul 24 at 6:17

TesterTester

771010 bronze badges

edited Jul 24 at 7:04

Waqar Ali

4491616 bronze badges

edited Jul 24 at 7:04

Waqar Ali

4491616 bronze badges

asked Jul 24 at 6:17

TesterTester

771010 bronze badges

asked Jul 24 at 6:17

TesterTester

771010 bronze badges

1 Answer
1

active

oldest

votes

1

All CMS pages and static blocks are saved in the following 4 tables:

• cms_page


• cms_page_store


• cms_block


• cms_block_store

Hence, if you need to copy the content, just simply export data from these tables and then import again to your live site database.

Export:

mysqldump -u -p database_name cms_block cms_block_store cms_page
cms_page_store > content.sql

Import:

mysql -u -p database_name < content.sql

share|improve this answer

answered Jul 24 at 7:47

Hafiz ArslanHafiz Arslan

35011 silver badge1818 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  cms block/pages has reference to store tables also, won't there be any issue as the magento is fresh? Also if I dump these tables won't there be foreign key issues?
  
  – Tester
  Jul 24 at 8:05
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  have u checked ?
  
  – Hafiz Arslan
  Jul 24 at 8:10
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I mean even if I do this, there will be issue because the tables do not include the store tables.
  
  – Tester
  Jul 24 at 8:12
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i have do this at my end. Getting all cms and block content successfully :)
  
  – Hafiz Arslan
  Jul 24 at 8:19
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  if you get your result please accept my answer .
  
  – Hafiz Arslan
  Jul 24 at 10:08
  

  
  
  
  

 | 
show 2 more comments

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f283093%2fmigrate-static-blocks-and-multi-stores-from-one-magento-to-another%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

1

All CMS pages and static blocks are saved in the following 4 tables:

• cms_page


• cms_page_store


• cms_block


• cms_block_store

Hence, if you need to copy the content, just simply export data from these tables and then import again to your live site database.

Export:

mysqldump -u -p database_name cms_block cms_block_store cms_page
cms_page_store > content.sql

Import:

mysql -u -p database_name < content.sql

share|improve this answer

answered Jul 24 at 7:47

Hafiz ArslanHafiz Arslan

35011 silver badge1818 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  cms block/pages has reference to store tables also, won't there be any issue as the magento is fresh? Also if I dump these tables won't there be foreign key issues?
  
  – Tester
  Jul 24 at 8:05
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  have u checked ?
  
  – Hafiz Arslan
  Jul 24 at 8:10
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I mean even if I do this, there will be issue because the tables do not include the store tables.
  
  – Tester
  Jul 24 at 8:12
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i have do this at my end. Getting all cms and block content successfully :)
  
  – Hafiz Arslan
  Jul 24 at 8:19
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  if you get your result please accept my answer .
  
  – Hafiz Arslan
  Jul 24 at 10:08
  

  
  
  
  

 | 
show 2 more comments

1

All CMS pages and static blocks are saved in the following 4 tables:

• cms_page


• cms_page_store


• cms_block


• cms_block_store

Hence, if you need to copy the content, just simply export data from these tables and then import again to your live site database.

Export:

mysqldump -u -p database_name cms_block cms_block_store cms_page
cms_page_store > content.sql

Import:

mysql -u -p database_name < content.sql

share|improve this answer

answered Jul 24 at 7:47

Hafiz ArslanHafiz Arslan

35011 silver badge1818 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  cms block/pages has reference to store tables also, won't there be any issue as the magento is fresh? Also if I dump these tables won't there be foreign key issues?
  
  – Tester
  Jul 24 at 8:05
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  have u checked ?
  
  – Hafiz Arslan
  Jul 24 at 8:10
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I mean even if I do this, there will be issue because the tables do not include the store tables.
  
  – Tester
  Jul 24 at 8:12
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i have do this at my end. Getting all cms and block content successfully :)
  
  – Hafiz Arslan
  Jul 24 at 8:19
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  if you get your result please accept my answer .
  
  – Hafiz Arslan
  Jul 24 at 10:08
  

  
  
  
  

 | 
show 2 more comments

All CMS pages and static blocks are saved in the following 4 tables:

• cms_page


• cms_page_store


• cms_block


• cms_block_store

Hence, if you need to copy the content, just simply export data from these tables and then import again to your live site database.

Export:

mysqldump -u -p database_name cms_block cms_block_store cms_page
cms_page_store > content.sql

Import:

mysql -u -p database_name < content.sql

share|improve this answer

answered Jul 24 at 7:47

Hafiz ArslanHafiz Arslan

35011 silver badge1818 bronze badges

share|improve this answer

answered Jul 24 at 7:47

Hafiz ArslanHafiz Arslan

35011 silver badge1818 bronze badges

answered Jul 24 at 7:47

Hafiz ArslanHafiz Arslan

35011 silver badge1818 bronze badges

answered Jul 24 at 7:47

Hafiz ArslanHafiz Arslan

35011 silver badge1818 bronze badges