SSH Key Set Up for Multiple GitHub Accounts

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

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

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

In php one can use filters with streams.  Sometimes it can become handy.  Let’s say you open a .csv file as a stream, but this file is tab separated.  Your program can can process coma separated csvs, but not tab separated.  This is a good use case for a stream filter, because it can make replacements…