Skip to main content

Magento Cloud - Export Data from Production Database

When working for an organization, there are times when you need to export data from the production database. Ideally, you should build a report or export option in Magento admin for this information. However, these are one-time data for which developing a module or backend functionality is not worthwhile. So, for this circumstance, follow the procedures below to retrieve data from the database.

Assuming you already know how to do ssh login to the production server. So let's start with logging into your server. Once you log in follow the below steps:

Get Database credentials

Once you log in, open your env.php file and get the database credentials stored on the server. You will find an array in the env file and get the credentials from the key with the name "db".

Prepare SQL Query

Prepare your query whatever you want to export and then save it in a SQL file. You can prepare this file directly on the server or locally. If you want to move this file from local to production then you can execute the below command to directly upload the file to the server.
rsync -azvP path-to-local-file 1.ent-abcs-production-abcc@ssh.eu-3.magento.cloud:path-to-upload

Execute SQL Query in Server

Now you already have your MySQL credentials and you are logged in to your server. You have also prepared your query file. Once you are done with this, you can execute the below command on the server.

mysql -h 127.0.0.1 -u username -ppassword db_name < query.sql | sed 's/\t/,/g' > export-data.csv

Download the Export File to Local

To download the export file, execute the below command from the local environment's terminal.
rsync 1.ent-abcs-production-abcc@ssh.eu-3.magento.cloud:paht-of-the-file/filename local-path-to-download
Conclusion: It's not always necessary to prepare a feature to generate one-time data. You can use your database skills to get the data fastly and quickly.
Labels:

Comments

Post a Comment

Popular posts from this blog

How to call a Phtml file in another Phtml file?

Sometimes while developing new pages we need to use some blocks repetitively and for this, there are multiple options in Magento to call a block in another block. But here we are going to discuss a specific way to call a Phtml file from another Phtml file. For this, you need to open the Phtml file in which you want to call another Phtml and the below code: $this->getLayout()->createBlock("Magento\Framework\View\Element\Template")->setTemplate("MageInsight_ModuleName::template.phtml")->toHtml(); In this, you can change the block class with your block class OR you can use the same one if you don't have any block class to be included in it. If you want to pass a variable or call any function of your block in phtml then you can use the below code: $customBlock = $this->getLayout()->createBlock("Magento\Framework\View\Element\Template"); $customBlock->functionName(); $customBlock->setTemplate("MageInsight_ModuleName::template.ph
Post a Comment
Read more

Disable Hover on main menu and make it work on click

The main menu in an eCommerce website holds significant importance as it serves as the primary navigational tool for users to explore and access various sections, products, and features of the online store. The main menu helps users discover products, services, and content they might not have been aware of. By presenting various categories and sections prominently, the menu can drive users to explore different parts of the website, increasing the chances of making a sale. The style and layout of the main menu contribute to the website's overall aesthetic & attractiveness. Magento essentially makes use of a jQuery menu widget to deliver all of its default features. By default, the menu appears when you mouse over it. I had a requirement in which I needed to open the menu only when the customer clicked. Because we were using Megamenu, and when it opened, it took up half of the screen. And this might be annoying for customers at times.  So to solve this, I have created a JS mixin
Post a Comment
Read more

How to add a dynamic homepage in Magento 2?

Magento provides the ability to have multiple homepages or a homepage with dynamic blocks that alter based on demand. However, there may be times when different homepages must be displayed based on customer groups/segments. This is possible with the dynamic block functionality, which is available in the Enterprise and Cloud editions. However, there is a constraint in that you have to maintain numerous blocks for multiple customer groups/segments. In that situation, you can alter the default functionality by using the code below: Step 1: Create a plugin for "Magento\Cms\Controller\Index\Index" by adding the below code in your module di.xml file. <type name="Magento\Cms\Controller\Index\Index"> <plugin name="dynamicHomepage" type="Mageinsight\Module\Plugin\DynamicHomepage" sortOrder="1"/> </type> Step 2: Add the plugin file as below: <?php namespace Mageinsight\Module\Plugin; use Magento\Framework\App\Config;
Post a Comment
Read more