Ttdfjt

How to get maximum number that newcount can hold?

Return last number in sub-sequences in a list of integers

How were x-ray diffraction patterns deciphered before computers?

How do I solve such questions on paramagnetism and ferromagnetism?

Need help identifying how to open this bolt/screw

Protect a 6 inch air hose from physical damage

Backpacking with incontinence

Reasons for using monsters as bioweapons

Is this popular optical illusion made of a grey-scale image with coloured lines?

What sort of solar system / atmospheric conditions, if any, would allow for a very cold planet that still receives plenty of light from its sun?

Is Illustrator accurate for business card sizes?

How do people drown while wearing a life jacket?

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

Accurately recalling the key - can everyone do it?

Partial Fractions: Why does this shortcut method work?

linearization of objective function

Went to a big 4 but got fired for underperformance in a year recently - Now every one thinks I'm pro - How to balance expectations?

Can I say "Gesundheit" if someone is coughing?

What's the proper way of indicating that a car has reached its destination during a dialogue?

How to determine if result of process substitution is a file path

"Will flex for food". What does this phrase mean?

How is Sword Coast North governed?

What is Albrecht Dürer's Perspective Machine drawing style?

Adding a (stair/baby) gate without facing walls

Magento 2: Change DB Name Without affecting core files

Migrate Magento Database to Another ServerHow can I switch database from remote to localhostI created a custom module ,but getting error, not able to figure out what the error is about. How to get out of this error?Magento Module creation gives errorMagento 2 : after upgrading magento 2 with command site not working“There has been an error processing your request” in Admin area after installationMagento 2: Can't install or uninstall plugins in magento 2Magento Core doesnt work after transferMagento2 REST API get all customers detailsGetting Errors after MySQL database import

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

0

I'm running custom script on my Linux Server.

I don't want that script to affect my current database. Username/Password/Host will be same.

Only DB name is changed. How can I do that without changing in env.php?

// MAGENTO START
include(dirname(__DIR__) . '/app/bootstrap.php');

use MagentoFrameworkAppBootstrap;

$bootstrap = Bootstrap::create(BP, $_SERVER);
$objectManager = $bootstrap->getObjectManager();

$state = $objectManager->get('MagentoFrameworkAppState');
$state->setAreaCode('frontend');
$deploymentConfig = $objectManager->create('MagentoFrameworkAppDeploymentConfig');
$dbName = $deploymentConfig->get('db/connection/default/dbname'); // Get Current DB Name

On server my website is already running. Don't want to affect that. So need to run script for new DB only.

magento2 database

share|improve this question

edited Oct 20 '17 at 6:35

Teja Bhagavan Kollepara

3,05244 gold badges2121 silver badges5151 bronze badges

asked Jun 6 '17 at 8:36

Ankit ShahAnkit Shah

5,0991212 gold badges7878 silver badges149149 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Did you find out how to change the DB name?
  
  – Mohammed Joraid
  Aug 2 '17 at 23:44
  

  
  
  
  

add a comment | 

0

I'm running custom script on my Linux Server.

I don't want that script to affect my current database. Username/Password/Host will be same.

Only DB name is changed. How can I do that without changing in env.php?

// MAGENTO START
include(dirname(__DIR__) . '/app/bootstrap.php');

use MagentoFrameworkAppBootstrap;

$bootstrap = Bootstrap::create(BP, $_SERVER);
$objectManager = $bootstrap->getObjectManager();

$state = $objectManager->get('MagentoFrameworkAppState');
$state->setAreaCode('frontend');
$deploymentConfig = $objectManager->create('MagentoFrameworkAppDeploymentConfig');
$dbName = $deploymentConfig->get('db/connection/default/dbname'); // Get Current DB Name

On server my website is already running. Don't want to affect that. So need to run script for new DB only.

magento2 database

share|improve this question

edited Oct 20 '17 at 6:35

Teja Bhagavan Kollepara

3,05244 gold badges2121 silver badges5151 bronze badges

asked Jun 6 '17 at 8:36

Ankit ShahAnkit Shah

5,0991212 gold badges7878 silver badges149149 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Did you find out how to change the DB name?
  
  – Mohammed Joraid
  Aug 2 '17 at 23:44
  

  
  
  
  

add a comment | 

I'm running custom script on my Linux Server.

I don't want that script to affect my current database. Username/Password/Host will be same.

Only DB name is changed. How can I do that without changing in env.php?

// MAGENTO START
include(dirname(__DIR__) . '/app/bootstrap.php');

use MagentoFrameworkAppBootstrap;

$bootstrap = Bootstrap::create(BP, $_SERVER);
$objectManager = $bootstrap->getObjectManager();

$state = $objectManager->get('MagentoFrameworkAppState');
$state->setAreaCode('frontend');
$deploymentConfig = $objectManager->create('MagentoFrameworkAppDeploymentConfig');
$dbName = $deploymentConfig->get('db/connection/default/dbname'); // Get Current DB Name

On server my website is already running. Don't want to affect that. So need to run script for new DB only.

magento2 database

share|improve this question

edited Oct 20 '17 at 6:35

Teja Bhagavan Kollepara

3,05244 gold badges2121 silver badges5151 bronze badges

asked Jun 6 '17 at 8:36

Ankit ShahAnkit Shah

5,0991212 gold badges7878 silver badges149149 bronze badges

// MAGENTO START
include(dirname(__DIR__) . '/app/bootstrap.php');

use MagentoFrameworkAppBootstrap;

$bootstrap = Bootstrap::create(BP, $_SERVER);
$objectManager = $bootstrap->getObjectManager();

$state = $objectManager->get('MagentoFrameworkAppState');
$state->setAreaCode('frontend');
$deploymentConfig = $objectManager->create('MagentoFrameworkAppDeploymentConfig');
$dbName = $deploymentConfig->get('db/connection/default/dbname'); // Get Current DB Name

share|improve this question

edited Oct 20 '17 at 6:35

Teja Bhagavan Kollepara

3,05244 gold badges2121 silver badges5151 bronze badges

asked Jun 6 '17 at 8:36

Ankit ShahAnkit Shah

5,0991212 gold badges7878 silver badges149149 bronze badges

share|improve this question

edited Oct 20 '17 at 6:35

Teja Bhagavan Kollepara

3,05244 gold badges2121 silver badges5151 bronze badges

asked Jun 6 '17 at 8:36

Ankit ShahAnkit Shah

5,0991212 gold badges7878 silver badges149149 bronze badges

edited Oct 20 '17 at 6:35

Teja Bhagavan Kollepara

3,05244 gold badges2121 silver badges5151 bronze badges

edited Oct 20 '17 at 6:35

Teja Bhagavan Kollepara

3,05244 gold badges2121 silver badges5151 bronze badges

asked Jun 6 '17 at 8:36

Ankit ShahAnkit Shah

5,0991212 gold badges7878 silver badges149149 bronze badges

asked Jun 6 '17 at 8:36

Ankit ShahAnkit Shah

5,0991212 gold badges7878 silver badges149149 bronze badges

1 Answer
1

active

oldest

votes

0

In Magento, change the name of the database in app/etc/env.php and rename your mysql database this way:

mysqldump old_database > database_content.out
mysql -e "CREATE DATABASE new_database CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;"
mysql new_database < database_content.out 
mysql -e "DROP DATABASE old_database;"

share|improve this answer

edited Jan 31 '18 at 5:55

answered Jan 31 '18 at 3:03

maxagazmaxagaz

48666 silver badges2727 bronze badges

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%2f177602%2fmagento-2-change-db-name-without-affecting-core-files%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

In Magento, change the name of the database in app/etc/env.php and rename your mysql database this way:

mysqldump old_database > database_content.out
mysql -e "CREATE DATABASE new_database CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;"
mysql new_database < database_content.out 
mysql -e "DROP DATABASE old_database;"

share|improve this answer

edited Jan 31 '18 at 5:55

answered Jan 31 '18 at 3:03

maxagazmaxagaz

48666 silver badges2727 bronze badges

add a comment | 

0

In Magento, change the name of the database in app/etc/env.php and rename your mysql database this way:

mysqldump old_database > database_content.out
mysql -e "CREATE DATABASE new_database CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;"
mysql new_database < database_content.out 
mysql -e "DROP DATABASE old_database;"

share|improve this answer

edited Jan 31 '18 at 5:55

answered Jan 31 '18 at 3:03

maxagazmaxagaz

48666 silver badges2727 bronze badges

add a comment | 

In Magento, change the name of the database in app/etc/env.php and rename your mysql database this way:

mysqldump old_database > database_content.out
mysql -e "CREATE DATABASE new_database CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;"
mysql new_database < database_content.out 
mysql -e "DROP DATABASE old_database;"

share|improve this answer

edited Jan 31 '18 at 5:55

answered Jan 31 '18 at 3:03

maxagazmaxagaz

48666 silver badges2727 bronze badges

mysqldump old_database > database_content.out
mysql -e "CREATE DATABASE new_database CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;"
mysql new_database < database_content.out 
mysql -e "DROP DATABASE old_database;"

share|improve this answer

edited Jan 31 '18 at 5:55

answered Jan 31 '18 at 3:03

maxagazmaxagaz

48666 silver badges2727 bronze badges

answered Jan 31 '18 at 3:03

maxagazmaxagaz

48666 silver badges2727 bronze badges

answered Jan 31 '18 at 3:03

maxagazmaxagaz

48666 silver badges2727 bronze badges