It's B

Category: blogs

  • Download folder/files from server using ssh terminal

    You will need SCP installed on your system.

    Run the following command from your terminal

    scp -r username@host:/path/to/folder /Destination/path/of/local/machine/

    If you access the server via pem key, then command will be

    scp -r -i /path/to/pemkey.pem username@host:/path/to/folder /Destination/path/of/local/machine/

    That’s it.

  • How to setup Stripe test account on MemberPress

    MemberPress forces to have a valid account to connect with stripe which is great for the LIVE site.

    But when it comes to testing payment using a test account, then also MemberPress forces to have a valid account.

    But there is a workaround to setup test account without an account which has not all the data filled in the Sandbox account.

    When you open your MemberPress -> Settings -> Payments tab, the URL will end up like:

    /wp-admin/admin.php?page=memberpress-options#mepr-integration

    Then change it manually to /wp-admin/admin.php?page=memberpress-options&display-keys and click back to the Payments tab.

    You’ll see the fields where you’ll be able to add the keys manually. Copy/paste them from your Stripe and then go to Stripe DashBoard -> Developers -> Webhooks and click “Add Endpoint” button: https://prntscr.com/rsgtw9

    Then paste the Webhook URL from MemberPress and add these events: https://prntscr.com/rsguc1

    Save everything and you should have the manual test connection completed.

    If you use any caching plugin, don’t forget to set it as explained in How to Set Up Popular Caching Plugins with MemberPress? and you should be good to go. 🙂

     

    That’s it

  • Fix – ERROR 2006 (HY000) while importing database in MySQL

    While importing big database in MySQL, you might get the error as shown below:

    ERROR 2006 (HY000) at line 3387 in file: 'path_to_the_db_dump.sql': MySQL server has gone away

    Step 1:

    Open a terminal and find a config file for MySQL by command locate my.cnf.

    You will get the list of files. Open your responsible file.

    If you don’t know the responsible file then open all the files ;). There is no harm to add our solution in all the related config file.

    Step 2:

    Add following line to my.cnf file.

    max_allowed_packet=64M

    Restart your MySQL using below command.

    sudo service mysql restart 
OR
brew services restart mysql

    That’s it!!!!

  • Fix – upstream sent too big header while reading response header from upstream in Nginx

    For this fix please visit below link.

    https://bhargavb.wordpress.com/2020/02/28/fix-404-error-on-nginx/

  • Fix – ERROR 1031 Table storage engine for ‘table_name’ doesn’t have this option

    Sometimes you get the below error while importing the database.

    ERROR 1031 (HY000) at line 5643 in file: '/Users/username/Downloads/database.sql': Table storage engine for 'table_name' doesn't have this option

    Now let’s fix this.

    Step – 1

    Open your sql file in your favourite editor and go to SQL query of that table.

    You will see ROW_FORMAT=FIXED at the last of the query and remove that.

    Step – 2

    Save your file and try to import the database. This should fix the error.

     

    That’s it