Drupal Dump

We had on server this thing set
http-response set-header X-Frame-Options DENY

mysqldump -u user -p databasename > dump.sql

Then using SCP transfer the file to the remote server:

scp dump.sql user@remotehost.ip:

Then use the mysql client there to import the dump.sql with:

mysql -u user_name -p databasename

One of those things. We have spent 4 hours, 2 persons combined hunting down this problem. Google GTM code, which we for specific reason enabled on node add forms, broke all ajax forms and made crayze problem of opening new browser window instead of editing the node reference field with inline entity form. The same thing happened also on image upload widget.

First is to use hook_pathauto_pattern_alter and add some code to it like

So we make  query to get node ID from particular product ID

$query = new EntityFieldQuery;
        $query->entityCondition('entity_type', 'node', '=')
        ->propertyCondition('type', 'product_display')
        ->fieldCondition('field_product_reference', 'product_id', '1092', '=')
        ->range(0, 1);

If node is present, we do the array building

To make square brackets in JSON, which is basically array in JSON you need to write array twice. So make it
array(array('something'....

$data = json_encode(array(
    'list'=>array(array('commerce_price_aud' => array (....

Although there is an article here about it http://blog.ampli.fi/creating-drupal-7-nodes-with-php-via-the-restws-ap…
I will copy mine code I used to test, just in case.

Things to watch out for is NOT to include JSON suffix, when using CURL

For some time this has been in drupal 7, ported from drupal 8
https://www.drupal.org/node/2307505

But not really mentioned much. Its a nice feature where you get directly in your html template file names you can use for changing html.
Looking like this

There are different methods and bunch of modules to ajaxify links in drupal. There are different solutions with code, like this one
https://www.drupal.org/node/2046693
and there are more simple I would add, like this one

Having custom template or function to preprocess your custom form in module has few tricks.

First you need to define it in form

$form = array();
$form['#theme'] = 'my_form_theming_function';
....

then define hook_theme