SQL to List All Categories and Products (SKUs) in Category in Magento 1.9

The easiest way to move a database is to backup and restore, you can choose to remove all your orders on the new install. The total time (Depending on the server) would be less than 10 minutes!

mysqldump -p'PASSWORD' -uuser -hyourhost database1 > mydumpfile.sql
mysql -p'PASSWORD' -uuser -hyourhost database2 < mydumpfile.sql

All you need to do now is change the url for the site: Something like

Here is an easy way to find them

select * from core_config_data where value like 'http%';

Find the config_id's for your secure and unsecure address

then

update core_config_data set value = 'http://my.newdomain.com/' where config_id in (You list of ids');

• List of id's must be something like this (6,7) etc

I can post a delete orders script if you want - The entire process is quick and efficient.

Do it clean!

<?php

require_once 'app/Mage.php';
umask(0);
Mage::app();

$collection = Mage::getResourceModel('reports/product_collection')
    ->addAttributeToSelect('*')
    ->addStoreFilter()
    ->setVisibility(Mage::getSingleton('catalog/product_visibility')->getVisibleInCatalogIds());

foreach ($collection as $product) {
    // build your JSON here
}