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

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

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
Laravel | PHP MySQL Development

Adding Email Headers in Laravel Application
Byalexrusin October 2, 2020September 17, 2023

Adding email headers in Laravel application is quite simple. SwiftMessage can be customized using withSwiftMessage method of Mailable base class: https://laravel.com/docs/8.x/mail#customizing-the-swiftmailer-message However you have to remember to do it every time you create a new “mailable” class. Some mail APIs require you to put a special header each time you send an email. In this…

Share this article

Read More Adding Email Headers in Laravel Application
PHP MySQL Development | WordPress Development

Create WordPress User with Admin Privileges in MySQL
Byalexrusin July 23, 2017July 23, 2017

INSERT INTO `wp_users` (`user_login`, `user_pass`, `user_nicename`, `user_email`, `user_status`) VALUES (‘admin’, MD5(‘password’), ‘User Admin’, ‘user@admin.com’, ‘0’); INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, (Select max(id) FROM wp_users), ‘wp_capabilities’, ‘a:1:{s:13:”administrator”;s:1:”1″;}’); INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, (Select max(id) FROM wp_users), ‘wp_user_level’, ’10’); Share this article

Share this article

Read More Create WordPress User with Admin Privileges in MySQL
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

Similar Posts