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 | System Administration

Laravel Jenkins CI
Byalexrusin November 26, 2017

This article covers installation of Jenkins on Ubuntu server and its usage to continuously integrate a Laravel application. Besides LAMP/LEMP stack we need to install Java, Git, Composer, and Node to successfully use Jenkins. Before starting to install this software, let’s take care of miscellaneous stuff. Miscellaneous (can skip this). Create mysql user and database….

Share this article

Read More Laravel Jenkins CI
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
Laravel | PHP MySQL Development

API Server Logging with Laravel
Byalexrusin September 11, 2020September 11, 2020

When you work with APIs it is usually a good idea to log requests and responses. I already covered how to do logging when you are consuming an API. You can read about it in this post. Here we will cover how to do it when building an API service with Laravel. For example, you…

Share this article

Read More API Server Logging with Laravel
Magento | PHP MySQL Development

Magento 2 Data Migration Notes
Byalexrusin December 4, 2016December 16, 2016

Recently I was assigned to do data migration from Magento 1.8.1.0 to Magento 2.1.0 In this article, I will share some points you must look out for when migrating to Magento 2. There are several things you must be aware of before you start migration: Magento 2 is a memory hog. So, suggested 2GB RAM…

Share this article

Read More Magento 2 Data Migration Notes
PHP MySQL Development

Complex Eloquent Query
Byalexrusin April 30, 2018April 30, 2018

A query below selects products that need to be updated in a remote application. It takes quantities of products in host application that are connected to source products application. On top of that it looks at all the orders that are in “Pending” status and reserves quantities for those products. SELECT products.quantity_available, connector_products.stock_id, products.id, connector_products.sku,…

Share this article

Read More Complex Eloquent Query
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

Similar Posts