Cant access Backend! Read out Orders and Registered Users data

[none_none3]

Hey there,

i cant access to the magento 1.9. backend since days, i need the orders made and the user data in order to migrate to a new website.

I have access to MYSQL> phpmyadmin

where can i read out the given information

[BioMag]

Hello,

You should check these tables :

Orders :

sales_flat_order

sales_flat_order_items

Customers:

customer_entity

(split in  customer_entity_datetime,customer_entity_decimal,int,customer_entity_varchar beacause of magento eav system)

Customer address:

customer_address_entity  

(split incustomer_address_entity_datetime,customer_address_entity_decimal,customer_address_entity_int,customer_address_entity_varchar)

[Dhiren Vasoya]

Create one php file say "Orderinfo.php" into your magento root with the following code.

<?php
$mageFilename = 'app/Mage.php';
if (!file_exists($mageFilename)) {
    echo $mageFilename." was not found";
    exit;
}
require_once $mageFilename;
Mage::app();

try {
     $collection = Mage::getModel('sales/order')->getCollection()
          ->addAttributeToSort('entity_id','DESC');  
     foreach($collection as $order)
     {
         // YOU CAN ACCESS ALL THE DETAIL OF ORDER WHICH YOU WANT HERE.
     }
} catch (Exception $e) {
    echo $e->getMessage();
    exit;
} 

 
Now you need to access this file from browser "http://yourmagento/Orderinfo.php