Magento – How to i retrieve database name into Magento

database

i'm going to clean an hosting where different databases and magento sites exist. My target is to delete everything but the one i need. The problem is that database manager prompts me different database (5), 2 of them are not connected to my magento choosed installation, the others 3 seems to be equals. I tried to explore tables that could help me, like admin_user and core_config_data, but those 3 databases seems to be the same themselves. My question is: how can i retrieve the database currently used by my installation in Magento? Another question is: these 3 dbs could be connected each other?

Thank you

Best Answer

You should be able to check the local.xml file in app/etc/. The database name should be listed around the middle of the file and should list the database name as well as other useful info.

Related Solutions

Magento – Convert a production database into test data

1) DB Dump

When you do the export, you can export only the structure for the following tables:

core_cache
core_cache_option
core_cache_tag
log_customer
log_quote
log_summary
log_summary_type
log_url
log_url_info
log_visitor
log_visitor_info
log_visitor_online
enterprise_logging_event
enterprise_logging_event_changes
index_event
index_process_event
report_event
report_viewed_product_index
dataflow_batch_export
dataflow_batch_import

Also core_url_rewrite can be imported only with the structure and run a Catalog URL Rewrites reindex after the import, unless you need all those records (for various tests).

You can also clean abandoned carts (hint: sales_flat_quote), you can also remove orders if you don't need them and just keep a limited number

2) Config Settings

web/(unsecure|secure)/base_url
contact email addresses
disable email (system/smtp/disable) so you don't send emails by mistake

3) Anonimize customer information

you can use Anonygento module for Magento
write your own script to obfuscate customer information/sales orders/etc

4) Module Settings

you can enable sandbox mode for payment/shipping modules and make the proper settings
check modules used for various integration (either disable or set them to sandbox mode)

Magento 1.9 – Insert Form Data into Database

    <?php
    class Sigmasolve_Pricenegotiate_IndexController extends Mage_Core_Controller_Front_Action
    {
        public function indexAction()
        {
                $this->loadLayout();
                $this->renderLayout();
        }
        public function saveAction(){
              $data = $this->getRequest()->getPost();
              $connection = Mage::getSingleton('core/resource')->getConnection('core_write');
              $query = "INSERT INTO table_name (`first_name`, `last_name`, `email`, `telephone`,`request_price`,`quantity`,`note`)
VALUES ('".$data['first_name']."', '".$data['last_name']."', '".$data['email']."', '".$data['telephone']."', '".$data['request_price']."', '".$data['quantity']."', '".$data['note']."')";
$connection->query($query); 
        }

    }

this is simple insertion method us just create saveAction

in form just add action url of your controller. U can escape the query prevent sql injection

<!--
<div class="add-to-cart-buttons">
<input type="Button" name="negotiate" value="Negotiate">
<button class="button btn-cart" type="button" title="Negotiate" data-target="#myModal" data-toggle="modal">Negotiate</button>
</div>
-->
<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
  <script src="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
</head>
<body>

<div class="container">

    <button class="" style="font-size:20pt;color:black;background-color:sky-blue;border:2px solid #336600;padding:3px" type="button" title="Negotiate" data-target="#myModal" data-toggle="modal">Negotiate</button>
  <!-- Modal -->
  <div class="modal fade" id="myModal" role="dialog" class="btn btn-info btn-lg">
    <div class="modal-dialog">

      <!-- Modal content-->
       <div class="modal-content">
        <div class="modal-header">
          <button type="button" class="close" data-dismiss="modal">&times;</button>
          <h4 class="modal-title">Negotiate Price</h4>
        </div>
        <div class="modal-body">
            <form name="form" action="<?php Mage::getBaseUrl('') ?>[controller_first_name]/save" method="post">
                <div class="form-group">
                  <label for="firstname">First Name :</label>
                  <input type="text" name='first_name' class="form-control" id="firstname" placeholder="Enter First Name" required>
                </div>

                <div class="form-group">
                  <label for="lastname">Last Name:</label>
                  <input type="text" name= "last_name" class="form-control" id="lastname" placeholder="Enter Last Name">
                </div>

                <div class="form-group">
                  <label for="email">Email:</label>
                  <input type="email" name="email" class="form-control" id="email" placeholder="Enter email">
                </div>

                <div class="form-group">
                  <label for="telephone">Telephone:</label>
                  <input type="number" name="telephone" class="form-control" id="telephone" placeholder="Enter Number" maxlength="10" min="0" max="9">
                </div>

                <div class="form-group">
                  <label for="requestedprice">Requested Price:</label>
                  <input type="number" name="request_price" class="form-control" id="requestedprice" placeholder="Enter Your Price" min="0">
                </div>

                <div class="form-group">
                  <label for="qty">Quantity:</label>
                  <input type="number" name="quantity" class="form-control" id="qty" placeholder="Enter Quantity">
                </div>

                <div class="form-group">
                  <label for="note">Note:</label>
                  <input type="textarea" name="note" class="form-control" id="note" placeholder="Enter Note">
                </div>

                <button type="submit" class="btn btn-default">Place Request</button>
            </form>
         </div>
        <div class="modal-footer">
          <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
        </div>
      </div> 

    </div>
  </div>

</div>

Best Answer

Related Solutions

Magento – Convert a production database into test data

Magento 1.9 – Insert Form Data into Database

Related Topic