How to sync database between local or staging and the live store
I am coming from Wordpress and the way I sync my database there is by using a plugin to pull and push databases between too environments, and I was wondering if there is a similar approach with Magento 2 if not than what is the best way?
Also I want to know what are they tables that I need to change once I pushed or pulled a database. From what I can see I only need to change the links on core_config_data
Thanks
magento2 database extensions
edited 50 mins ago
Shoaib Munir
1,083521
asked Dec 14 '18 at 12:40
Wushu06 Wushu06
1
add a comment |
I am coming from Wordpress and the way I sync my database there is by using a plugin to pull and push databases between too environments, and I was wondering if there is a similar approach with Magento 2 if not than what is the best way?
Also I want to know what are they tables that I need to change once I pushed or pulled a database. From what I can see I only need to change the links on core_config_data
Thanks
magento2 database extensions
edited 50 mins ago
Shoaib Munir
1,083521
asked Dec 14 '18 at 12:40
Wushu06 Wushu06
1
add a comment |
I am coming from Wordpress and the way I sync my database there is by using a plugin to pull and push databases between too environments, and I was wondering if there is a similar approach with Magento 2 if not than what is the best way?
Also I want to know what are they tables that I need to change once I pushed or pulled a database. From what I can see I only need to change the links on core_config_data
Thanks
magento2 database extensions
edited 50 mins ago
Shoaib Munir
1,083521
asked Dec 14 '18 at 12:40
Wushu06 Wushu06
1
I am coming from Wordpress and the way I sync my database there is by using a plugin to pull and push databases between too environments, and I was wondering if there is a similar approach with Magento 2 if not than what is the best way?
Also I want to know what are they tables that I need to change once I pushed or pulled a database. From what I can see I only need to change the links on core_config_data
Thanks
magento2 database extensions
magento2 database extensions
edited 50 mins ago
Shoaib Munir
1,083521
asked Dec 14 '18 at 12:40
Wushu06 Wushu06
1
edited 50 mins ago
Shoaib Munir
1,083521
asked Dec 14 '18 at 12:40
Wushu06 Wushu06
1
edited 50 mins ago
Shoaib Munir
1,083521
edited 50 mins ago
Shoaib Munir
1,083521
edited 50 mins ago
Shoaib Munir
1,083521
1,083521
asked Dec 14 '18 at 12:40
Wushu06 Wushu06
1
asked Dec 14 '18 at 12:40
Wushu06 Wushu06
1
asked Dec 14 '18 at 12:40
Wushu06 Wushu06
1
1
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
The easiest way to achieve what you are after to is to export/copy the latest database and then import it to the old database, this way all your data will be up to date.
You are also correct in saying the only thing that needs to change is in the core_config_data table, the these are the 2 fields relating to the base url (secure & unsecure).
EDIT:
SELECT * from core_config_data WHERE path = 'web/unsecure/base_url';
SELECT * from core_config_data WHERE path = 'web/secure/base_url';
Run these commands to find the urls you require and make changes accordingly
answered Dec 14 '18 at 16:54
vmpvmp
14613
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
});
}
});
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
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f253675%2fhow-to-sync-database-between-local-or-staging-and-the-live-store%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
The easiest way to achieve what you are after to is to export/copy the latest database and then import it to the old database, this way all your data will be up to date.
You are also correct in saying the only thing that needs to change is in the core_config_data table, the these are the 2 fields relating to the base url (secure & unsecure).
EDIT:
SELECT * from core_config_data WHERE path = 'web/unsecure/base_url';
SELECT * from core_config_data WHERE path = 'web/secure/base_url';
Run these commands to find the urls you require and make changes accordingly
answered Dec 14 '18 at 16:54
vmpvmp
14613
add a comment |
The easiest way to achieve what you are after to is to export/copy the latest database and then import it to the old database, this way all your data will be up to date.
You are also correct in saying the only thing that needs to change is in the core_config_data table, the these are the 2 fields relating to the base url (secure & unsecure).
EDIT:
SELECT * from core_config_data WHERE path = 'web/unsecure/base_url';
SELECT * from core_config_data WHERE path = 'web/secure/base_url';
Run these commands to find the urls you require and make changes accordingly
answered Dec 14 '18 at 16:54
vmpvmp
14613
add a comment |
The easiest way to achieve what you are after to is to export/copy the latest database and then import it to the old database, this way all your data will be up to date.
You are also correct in saying the only thing that needs to change is in the core_config_data table, the these are the 2 fields relating to the base url (secure & unsecure).
EDIT:
SELECT * from core_config_data WHERE path = 'web/unsecure/base_url';
SELECT * from core_config_data WHERE path = 'web/secure/base_url';
Run these commands to find the urls you require and make changes accordingly
answered Dec 14 '18 at 16:54
vmpvmp
14613
The easiest way to achieve what you are after to is to export/copy the latest database and then import it to the old database, this way all your data will be up to date.
You are also correct in saying the only thing that needs to change is in the core_config_data table, the these are the 2 fields relating to the base url (secure & unsecure).
EDIT:
SELECT * from core_config_data WHERE path = 'web/unsecure/base_url';
SELECT * from core_config_data WHERE path = 'web/secure/base_url';
Run these commands to find the urls you require and make changes accordingly
answered Dec 14 '18 at 16:54
vmpvmp
14613
answered Dec 14 '18 at 16:54
vmpvmp
14613
answered Dec 14 '18 at 16:54
vmpvmp
14613
answered Dec 14 '18 at 16:54
vmpvmp
14613
14613
add a comment |
add a comment |
Thanks for contributing an answer to Magento Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f253675%2fhow-to-sync-database-between-local-or-staging-and-the-live-store%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
