Exporting/Importing MySQL database from/to Remote Server

Byalexrusin June 20, 2017June 21, 2017

Export database
mysqldump -u dbuser -p databasename -h rds.amazonaws.com > backup.sql

Import database
mysql -u username -p -h rds.amazon.com databasename < backup.sql mysql --host=rds.amazonaws.com --user=dbuser --password=password databasename < backup.sql

Share this article

Laravel | PHP MySQL Development

Debugging Webhooks
Byalexrusin August 26, 2018September 22, 2018

A webhook is an HTTP callback, that occurs when something happens (a resource changes its state). Webhooks provide a way to build event-driven apps, because you can be notified about changes. Since webhooks require a publicly accessible URL to function they can be hard to test from your local machine. There are three main problems…

Share this article

Read More Debugging Webhooks
PHP MySQL Development

Extracting SKUs from Shopify Products
Byalexrusin September 15, 2018September 15, 2018

Let’s assume we have a use case. We create products at someotherwebsite.com. In the end of each day we want to sync newly created products to Shopify store using API. Each product that we are creating has a unique code to identify it. This code corresponds to Shopify product’s sku. This is how we link…

Share this article

Read More Extracting SKUs from Shopify Products
PHP MySQL Development

API Client Design
Byalexrusin September 22, 2018September 23, 2018

When you extensively work with certain APIs, like Shopify’s for example, you will end up with bunch of functions that map to API’s endpoints. One of the approaches I have seen so far is to create an API class ShopifyApi and make those functions class methods. So it looks something like the figure below. I…

Share this article

Read More API Client Design
Laravel | PHP MySQL Development

Running Artisan Command as a Separate PHP Process in Laravel
Byalexrusin September 9, 2017September 9, 2017

In Laravel framework you can create commands and call them from php application. One command can call another command, and another command, and so on. But if an exception is thrown in one of the commands in this chain the whole chain breaks. In order to avoid this problem and run each artisan command as…

Share this article

Read More Running Artisan Command as a Separate PHP Process in Laravel
Laravel | PHP MySQL Development

Composer: Path Repositories
Byalexrusin October 30, 2017July 15, 2019

When working on a php package it is inconvenient to push the package to github (or other repository) and then wait for the package to update using composer update. For package development, composer has such feature as path repositories. Let’s imagine we have a two folders on the same level: my-app and package. my-app is an app — a test…

Share this article

Read More Composer: Path Repositories
Laravel | PHP MySQL Development

SSH Key Set Up for Multiple GitHub Accounts
Byalexrusin September 21, 2018September 22, 2018

A great article on how to set up and manage ssh keys for multiple github accounts/repositories SSH Keys with Multiple GitHub Accounts Share this article

Share this article

Read More SSH Key Set Up for Multiple GitHub Accounts

Similar Posts