Exporting/Importing MySQL database from/to Remote Server

Byalexrusin

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

Similar Posts

API Client Design

API Client Design

Byalexrusin

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
Debugging Webhooks
|

Debugging Webhooks

Byalexrusin

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
|

Running Artisan Command as a Separate PHP Process in Laravel

Byalexrusin

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
|

Adding Email Headers in Laravel Application

Byalexrusin

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