How to install imported .sql database?

I have exported database from another computer, I want to install (add) it to my sql server

so when I run

mysql -u root -e "show databases();" 

it should show me database exported database name.

important: I have to install it from terminal, not fron phpmyadmin

mysql -u root -e "show databases;" +--------------------+ | Database           | +--------------------+ | information_schema | | mysql              | | performance_schema | | phpmyadmin         | | test               | +--------------------+ 

it should be:

+--------------------+ | Database           | +--------------------+ | information_schema | | mysql              | | performance_schema | | phpmyadmin         | | test               | | NEW_DATABASE       | +--------------------+ 

Error when flow imported

I have two tenants. On one tenant I have my flow which is attached to SharePoint lists. I want to move this flow between tenants so I exported the flow from first tenant as zip file and I was trying to import this package to new tenant. But every time I import this package this mysterious error occurs about MultipleErrorsOccurred and BadRequest.

I was trying to create new connection, assigning to old one from new tenant, but every time I have the same error.

Is there any solution to that?

Or I must every time edit package with flow?

Configurable products import doesn’t work configurable_variations not imported

I am trying to import configurable products using a script. All products imported successfully but child product is not associated with the parent in case of configurable. Please check below script & attached CSV.

$  this->eavConfig->clear();     $  importModel = $  this->importModel;     $  importModel->setData(         [             'entity' => 'catalog_product',             'behavior' => 'append',             'import_images_file_dir' => 'pub/media/catalog/product',             Import::FIELD_NAME_VALIDATION_STRATEGY =>                 ProcessingErrorAggregatorInterface::VALIDATION_STRATEGY_SKIP_ERRORS         ]     );      $  source = $  this->csvSourceFactory->create(         [             'file' => 'Setup/fixtures/product.csv',             'directory' => $  this->readFactory->create(                 $  this->componentRegistrar->getPath(ComponentRegistrar::MODULE, 'Custom_Catalog')             )         ]     );      $  currentPath = getcwd();     chdir(BP);     $  importModel->validateSource($  source);       try {         $  this->importModel->importSource();     } catch (\Exception $  e) {          $  e->getMessage();     }      chdir($  currentPath);      $  this->eavConfig->clear(); 

enter image description here My observations on the above code are as below 1)If I put qty more than 1 2)If I run the above script 2 times it is working.

How to evaluate a function on Imported data (.xlsx file)

I have imported an excel file, and I want to evaluate an expression on each point:

Data = Import["data.xlsx"] which gives output like this:


I want to evaluate following expression for each point:


where, a is some type constant. So far I am trying to use Evaluate function in mathemtica:

Evaluate[Rate, Data[[All, {1, 2}]]] Evaluate[Rate, Data[[All, {3, 4}]]] 

But couldn’t figure out how to obtained values for expression (Rate) for each value. Any help will be appreciated.

Set Order Of Imported Product Images Using CSV Magento 2.2

Does anyone know if there is a way to set the order of the images being imported in the additional_images column when running a CSV import?

When running some tests it seems that Magento 2 doesn’t import the images in the order that they appear in the CSV file. See below:

additional_images  "PROD1.jpg,PROD1-A.jpg,PROD1-B.jpg,PROD1-C.jpg,PROD1-D.jpg" 

After running a successful import the images appear in the following order:

  1. PROD1-C.jpg
  2. PROD1.jpg
  3. PROD1-D.jpg
  4. PROD1-A.jpg
  5. PROD1-B.jpg

Self signed ssl I created for localhost cannot be trusted even though I have already imported it to chrome

I generated a certificate using ssl by running the script from the following link:

The script ran just fine and I received all the expected files. I’ve imported the ca.crt to my chrome under the trusted root certification authorities but chrome still won’t trust it.

I get the following errors:

Certificate – Subject Alternative Name missing The certificate for this site does not contain a Subject Alternative Name extension containing a domain name or IP address.

Certificate – missing This site is missing a valid, trusted certificate (net::ERR_CERT_AUTHORITY_INVALID).

How do i fix these two issues and get my chrome to trust my self signed certificate?

How do I make jest transpile an imported javascript file in a different directory?

I have a jest project using a directory structure that looks like this

Project A | |- .babelrc |- package.json (with jest config) |  -components   |   |- Card.jsx   -__tests__   |   |- Card.test.jsx  shared | |- .babelrc | |- constants   |   | - user.js 

Card.jsx imports some values from user.js which uses ES6 modules. Card.jsx imports using a relative import path import { settings } from '../../shared/constants/users'. When I run jest, I get the following error when user.js attempts to import from another file:

    import { membershipStatuses } from './orgs';                       ^      SyntaxError: Unexpected token {        3 |        4 |      > 5 | import { settings } from '../../shared/constants/users';         | ^         at ScriptTransformer._transformAndBuildScript (node_modules/@jest/transform/build/ScriptTransformer.js:471:17)       at ScriptTransformer.transform (node_modules/@jest/transform/build/ScriptTransformer.js:513:25)       at Object.<anonymous> (components/SidenavContactCard.jsx:5:1) 

It seems to me that Jest is not transpiling files in other directories outside of the root of the jest project. How do I configure Jest to make this work?

Jest config in package.json:

"jest": {   "clearMocks": true }, 

I have imported around 90 million unique URLs as new targets and they get deleted with these setting

I have crawled myself quite a few URLs and made them unique

I import them into a fresh project

After a while target URLs of the project get deleted

Here my settings

Are there a maximum amount of URLs file size that GSA ser supports?

Imported target urls file is 6.13 GB

The import process is being success because i see target urls file in projects folder

The GSA ser starts with around fetching 16k urls

And today when i wake up after like 10 hours i see target urls in project folder got reset and there are only several megabytes target urls

I am trying again

the fresh project starts as 

Loaded 16777 URLs from imported sites

And damn target urls already got reset

Imported Image Style Edit Form Error

I am getting an error accessing the edit form for imported image styles.

*Tested on Drupal 8.6.13 and 8.7.3

  1. Create image style in UI.
  2. Export image style.
  3. Delete image style in UI.
  4. Import image style.
  5. Visit image style edit form.

(also true for image styles not created in UI)


Symfony\Component\Routing\Exception\InvalidParameterException: Parameter "image_effect" for route "image.effect_edit_form" must match "[^/]++" ("" given) to generate a corresponding URL. 

I see the same issue reported here for the Retina Image project:, but I have not found any reports for Drupal core.

Is there an issue report open for this? How can I resolve this error?