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

|

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

Retrying and Logging Requests with Guzzle

Byalexrusin

When consuming 3d party API, you may want to do two things: In this article we will look at how to implement the above features using Guzzle, a popular PHP library for making API calls. Let us scaffold our app composer init composer require guzzlehttp/guzzle:~6.0 composer require monolog/monolog composer require –dev phpunit/phpunit:^8 We will be…

Share this article
|

Composer: Path Repositories

Byalexrusin

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