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

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

DB Resource Usage
Byalexrusin December 19, 2018

You can use the following query to see who is using your database resources SELECT max(user) as user, count(*) as connections_count, db from information_schema.processlist GROUP BY db order by connections_count desc; Share this article

Share this article

Read More DB Resource Usage
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
PHP MySQL Development | System Administration

Using PhpMyAdmin With Homestead
Byalexrusin June 18, 2017June 18, 2017

Laravel Homestead includes a lot of software, but unfortunately does not have PhpMyAdmin. You can always install it on nginx, but if you have it already on your host system (for example, as a part of xampp package), you can always configure it as a Nginx site. First of all, you need to edit your config.inc.php file. At…

Share this article

Read More Using PhpMyAdmin With Homestead
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

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

Similar Posts