First need to alias mysql on locahost .See where you mysql.exe file is located in xampp folder.Make a correct path and add into below command and run it.

    alias mysql='D://xampp/mysql/bin/mysql.exe'
    $ alias php='D://xampp/php/php.exe'
    mysql -h localhost -u username databasename < dump.sql

    $ alias php=’D://xampp/php/php.exe’

    alias mysql=’D://xampp/mysql/bin/mysql.exe’

    php -dmemory_limit=5G bin/magento setup:static-content:deploy -f
    php bin/magento fl32:minify:make

    php -dmemory_limit=5G bin/magento setup:di:compile

    export PATH=/opt/plesk/php/7.1/bin:$PATH;

    php bin/magento indexer:reindex mst_sorting

    Enable Dev path hints
    php bin/magento dev:template-hints:enable

    Find in all directory sudo find / -name ‘my.cnf’ 2>1
    searching my.cnf
    Go to
    on last line add
    Then restart server and done

    sudo service mysqld stop
    sudo service mysqld start

    Now CHECK Innodb buffer pool size
    SELECT @@innodb_buffer_pool_size

    for speed To minify all js and css install this module
    Then run the command given in github

    For speed use keycdn in magento

    To check header curl -sD – -o /dev/null
    to login as roo su

    List your jobs

    Bring a job to the foreground

    fg 1

    Magento 2 Code analysis for duplication

    Fix for category url magento 2

    Before starting xampp we need these configuration

    To increase buffer pool size

    not working reinding than check it especialty if product eav not working
    SELECT * FROM catalog_product_entity_varchar where attribute_id = 264 and entity_id = 8781

    What is the difference between Preference and Plugin?
    Although both of them are used for overriding the core modules, the way to use them is completely different.

    With Preference, it must extend a core class. Preference can rewrite function. When you declare a Preference, your new class is expected to be a complete implementation of the class you want to override.

    While a plugin allows you to execute your functions before, after or around (before & after) the core function is executed. It’s NOT really rewritten function like Preference.

    Since your plugin class doesn’t replace the core class, in case there are many plugins hooked onto a target class, Magento 2 just executes them sequentially based on the sortOrder parameter in your file di.xml.

    JAVASCRIPT Require config js magento 2
    Fortunately, there is a solution. The RequireJS shim configuration directive allows you to configure what I’ll call “load order” dependencies. i.e., you can say
    Hey RequireJS — when you load the jquery.cookie module? Make sure you’ve completely loaded the jquery module first.
    var config = {

    RewriteCond %{THE_REQUEST} .html
    RewriteRule ^(.*).html$ /$1 [R=301,L]

    create custom button for share this

    update shopbybrand_slide set seo_url = replace(seo_url, ‘.html’, ”)

    chmod 777 -R pub/*


    List of free extension for every store

    CMS FRONTend builder

    About Author

    You may also like

    No Comment

    You can post first response comment.

    Leave A Comment

    Please enter your name. Please enter an valid email address. Please enter a message.