Ttdfjt

Folding basket - is there such a thing?

Has there been any indication at all that further negotiation between the UK and EU is possible?

What are the penalties for overstaying in USA?

Find the probability that the 8th woman to appear is in 17th position.

Why cruise at 7000' in an A319?

Should developer taking test phones home or put in office?

Links to webpages in books

Is there a way to split the metadata to custom folders?

What reason would an alien civilization have for building a Dyson Sphere (or Swarm) if cheap Nuclear fusion is available?

How risky is real estate?

Should my manager be aware of private LinkedIn approaches I receive? How to politely have this happen?

How can I politely work my way around not liking coffee or beer when it comes to professional networking?

3D Crossword, Cryptic, Statue View & Maze

Require advice on power conservation for backpacking trip

Is it possible writing coservation of relativistic energy in this naive way?

Fill NAs in R with zero if the next valid data point is more than 2 intervals away

Why is C++ initial allocation so much larger than C's?

C-152 carb heat on before landing in hot weather?

How do I respond to requests for a "guarantee" not to leave after a few months?

How does a blind passenger not die, if driver becomes unconscious

Computing a trigonometric integral

Should I prioritize my 401(k) over my student loans?

What is the legal status of travelling with methadone in your carry-on?

Trainee keeps missing deadlines for independent learning

How can we migrate the data and settings from one magento 2.3.0 to another 2.3.0

Magento 2.3 introduced a view table which causes issue with import of mysql dump. What's it for?$_product->isSaleable() shows different value in list page and view page magento 2Magento data from M1 to M2How to migrate data from 2.0.X to 2.2.XData migration tool : How can i use time zone handler for order purchase time for magento 1 server on IST timezoneMagento 2 Data Migration ToolCan't even migrate Magento 1.9 with sample data to Magento 2.2How we can remigrate data from M1 =>M2How to manually import/migrate orders & customers from Magento1 to Magento 2 database tables?How can we migrate magento 1 EE to magento 2 CEMagento Migration 1.9.2.2 to 2.2.6 Requested site not found error after settings migrationMigrate only products from Magento 1 to Magento2

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

0

There is some functionality issue with my site. And, I want to be sure that Is this issue in default Luma or not?

I want to migrate admin data on fresh Magento2.3.0

magento2.3.0 data-migration data-migration-tool

share|improve this question

edited Jun 14 at 13:43

Amit Bera♦

61.5k1616 gold badges8484 silver badges183183 bronze badges

asked Jun 14 at 12:21

Pratik KamaniPratik Kamani

89055 silver badges1818 bronze badges

add a comment | 

0

There is some functionality issue with my site. And, I want to be sure that Is this issue in default Luma or not?

I want to migrate admin data on fresh Magento2.3.0

magento2.3.0 data-migration data-migration-tool

share|improve this question

edited Jun 14 at 13:43

Amit Bera♦

61.5k1616 gold badges8484 silver badges183183 bronze badges

asked Jun 14 at 12:21

Pratik KamaniPratik Kamani

89055 silver badges1818 bronze badges

add a comment | 

There is some functionality issue with my site. And, I want to be sure that Is this issue in default Luma or not?

I want to migrate admin data on fresh Magento2.3.0

magento2.3.0 data-migration data-migration-tool

share|improve this question

edited Jun 14 at 13:43

Amit Bera♦

61.5k1616 gold badges8484 silver badges183183 bronze badges

asked Jun 14 at 12:21

Pratik KamaniPratik Kamani

89055 silver badges1818 bronze badges

share|improve this question

edited Jun 14 at 13:43

Amit Bera♦

61.5k1616 gold badges8484 silver badges183183 bronze badges

asked Jun 14 at 12:21

Pratik KamaniPratik Kamani

89055 silver badges1818 bronze badges

share|improve this question

edited Jun 14 at 13:43

Amit Bera♦

61.5k1616 gold badges8484 silver badges183183 bronze badges

asked Jun 14 at 12:21

Pratik KamaniPratik Kamani

89055 silver badges1818 bronze badges

edited Jun 14 at 13:43

Amit Bera♦

61.5k1616 gold badges8484 silver badges183183 bronze badges

edited Jun 14 at 13:43

Amit Bera♦

61.5k1616 gold badges8484 silver badges183183 bronze badges

asked Jun 14 at 12:21

Pratik KamaniPratik Kamani

89055 silver badges1818 bronze badges

asked Jun 14 at 12:21

Pratik KamaniPratik Kamani

89055 silver badges1818 bronze badges

1 Answer
1

active

oldest

votes

0

If you've got access to the command line use mysqldump:

To dump the database (-h [hostname] is optional)

mysqldump -u [username] –p[password] -h [hostname] [database_name] > [dump_file.sql]

To restore the database (the reverse):

mysqldump –u[user name] -p[password] -h [hostname] [database name] < [dump_file.sql]

One thing you need to watch for is that 2.3 includes a statement to create a view

Magento 2.3 introduced a view table which causes issue with import of mysql dump. What's it for?

share|improve this answer

answered Jun 14 at 12:29

Dominic XigenDominic Xigen

1,90011 gold badge33 silver badges1111 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Your solution will help to clone the site. But I need to check fresh vanilla migration.
  
  – Pratik Kamani
  Jun 14 at 12:32
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Please check this Question. I am looking for this question's solution magento.stackexchange.com/questions/278217/…
  
  – Pratik Kamani
  Jun 14 at 12:34
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  In that case there isn't going to be an easy solution. Once the site has been cloned maybe you can pick and choose what data you want by truncating tables. If you truncate enough (including setup_module) you may be able to trigger a reinstall using setup:upgrade. Probably going to be easier to just start with a fresh site and just apply your change on luma theme.
  
  – Dominic Xigen
  Jun 14 at 12:41
  

  
  
  
  

add a comment | 

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%2f278401%2fhow-can-we-migrate-the-data-and-settings-from-one-magento-2-3-0-to-another-2-3-0%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

If you've got access to the command line use mysqldump:

To dump the database (-h [hostname] is optional)

mysqldump -u [username] –p[password] -h [hostname] [database_name] > [dump_file.sql]

To restore the database (the reverse):

mysqldump –u[user name] -p[password] -h [hostname] [database name] < [dump_file.sql]

One thing you need to watch for is that 2.3 includes a statement to create a view

Magento 2.3 introduced a view table which causes issue with import of mysql dump. What's it for?

share|improve this answer

answered Jun 14 at 12:29

Dominic XigenDominic Xigen

1,90011 gold badge33 silver badges1111 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Your solution will help to clone the site. But I need to check fresh vanilla migration.
  
  – Pratik Kamani
  Jun 14 at 12:32
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Please check this Question. I am looking for this question's solution magento.stackexchange.com/questions/278217/…
  
  – Pratik Kamani
  Jun 14 at 12:34
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  In that case there isn't going to be an easy solution. Once the site has been cloned maybe you can pick and choose what data you want by truncating tables. If you truncate enough (including setup_module) you may be able to trigger a reinstall using setup:upgrade. Probably going to be easier to just start with a fresh site and just apply your change on luma theme.
  
  – Dominic Xigen
  Jun 14 at 12:41
  

  
  
  
  

add a comment | 

0

If you've got access to the command line use mysqldump:

To dump the database (-h [hostname] is optional)

mysqldump -u [username] –p[password] -h [hostname] [database_name] > [dump_file.sql]

To restore the database (the reverse):

mysqldump –u[user name] -p[password] -h [hostname] [database name] < [dump_file.sql]

One thing you need to watch for is that 2.3 includes a statement to create a view

Magento 2.3 introduced a view table which causes issue with import of mysql dump. What's it for?

share|improve this answer

answered Jun 14 at 12:29

Dominic XigenDominic Xigen

1,90011 gold badge33 silver badges1111 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Your solution will help to clone the site. But I need to check fresh vanilla migration.
  
  – Pratik Kamani
  Jun 14 at 12:32
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Please check this Question. I am looking for this question's solution magento.stackexchange.com/questions/278217/…
  
  – Pratik Kamani
  Jun 14 at 12:34
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  In that case there isn't going to be an easy solution. Once the site has been cloned maybe you can pick and choose what data you want by truncating tables. If you truncate enough (including setup_module) you may be able to trigger a reinstall using setup:upgrade. Probably going to be easier to just start with a fresh site and just apply your change on luma theme.
  
  – Dominic Xigen
  Jun 14 at 12:41
  

  
  
  
  

add a comment | 

If you've got access to the command line use mysqldump:

To dump the database (-h [hostname] is optional)

mysqldump -u [username] –p[password] -h [hostname] [database_name] > [dump_file.sql]

To restore the database (the reverse):

mysqldump –u[user name] -p[password] -h [hostname] [database name] < [dump_file.sql]

One thing you need to watch for is that 2.3 includes a statement to create a view

Magento 2.3 introduced a view table which causes issue with import of mysql dump. What's it for?

share|improve this answer

answered Jun 14 at 12:29

Dominic XigenDominic Xigen

1,90011 gold badge33 silver badges1111 bronze badges

share|improve this answer

answered Jun 14 at 12:29

Dominic XigenDominic Xigen

1,90011 gold badge33 silver badges1111 bronze badges

answered Jun 14 at 12:29

Dominic XigenDominic Xigen

1,90011 gold badge33 silver badges1111 bronze badges

answered Jun 14 at 12:29

Dominic XigenDominic Xigen

1,90011 gold badge33 silver badges1111 bronze badges