lent

Managing Talent

Great managers know and value the unique abilities and even the eccentricities of their employees.




lent

Important that US continues to get access to talent critical to recovery phase: Nasscom

US President Donald Trump has signed an executive order pausing immigration for 60 days to protect the jobs of Americans laid off due to the COVID-19 pandemic. ​​Nasscom noted that the US Department of Homeland Security (DHS) has provided an excellent roadmap for any subsequent potential recommendation for non-immigrant and other visa categories.




lent

Being the world’s best in what you do is the path to wealth. Here's how talent stacking can help

Skill stacking is the most efficient way to multiply your earning ability. Not everyone has the time, ability and resources to single-mindedly pursue one skill to perfection. However, there is a faster way.




lent

Looking for silver lining in the dark clouds? India has plenty

We manufactured a crisis much before the pandemic hit the financial world.




lent

Leader of Armed Home Invasion Robbery Crew Convicted of RICO Conspiracy and Other Violent Crimes

A federal jury in Detroit, Michigan, found a Colombian man guilty of all charges in a nine-count indictment charging him with Racketeer Influenced and Corrupt Organizations Act (RICO) conspiracy and other violent crimes, announced Assistant Attorney General Brian A. Benczkowski of the Justice Department’s Criminal Division and Special Agent in Charge Steven M. D’Antuono of the FBI’s Detroit Field Office.




lent

Brooklyn Tax Preparer Sentenced to Prison for Preparing Fraudulent Returns

A Brooklyn, New York, tax return preparer was sentenced to 15 months in prison today for preparing false returns for his clients and himself, announced Principal Deputy Assistant Attorney General Richard E. Zuckerman of the Justice Department’s Tax Division and U.S. Attorney Richard P. Donoghue for the Eastern District of New York.




lent

In Milestone for Sentencing Reform, Attorney General Holder Announces Record Reduction in Mandatory Minimums Against Nonviolent Drug Offenders




lent

Court Orders Halt to Sale of Silver Product Fraudulently Touted as COVID-19 Cure




lent

Harrison Urges Witnesses To Reach Out After Violent Week In Baltimore

Baltimore City's non-fatal shootings have gone down from 232 this time last year to 195 now, but homicides have gone up from 102 in 2019 to 103 so far this year.




lent

Weekend Lineup: No Derby, But Plenty Of Action At Oaklawn

Throughout the year, the NTRA will provide a guide to the best stakes races in North America and beyond. Races are listed in chronological order (all times Eastern). Full previews when available can be found through the link for each race. There may be no Kentucky Oaks or Kentucky Derby this weekend, but there is […]

The post Weekend Lineup: No Derby, But Plenty Of Action At Oaklawn appeared first on Horse Racing News | Paulick Report.




lent

Comment on Clocker Suspended Five Years For Posting Fraudulent Workouts; Trainers Sanctioned by perks

omg thats about right Hamish. I never trust work times on claimers especially.




lent

Comment on Clocker Suspended Five Years For Posting Fraudulent Workouts; Trainers Sanctioned by perks

oh here we go... seriously get a life tired of the racial BS.




lent

Comment on Clocker Suspended Five Years For Posting Fraudulent Workouts; Trainers Sanctioned by perks

Theres a new female trainer at Remington park, has pretty much zero stats/starts. So far her horses have qualified/won several stakes. . Pretty talented for zero trainer whos history shows zero starts. Qualified one last night again to futurity. And then Judd Kearls shill trainer padgett who won everything in NM has not hardly lit the board. Tres Abagados Stupidos do you anything about this girl?




lent

Harrison Urges Witnesses To Reach Out After Violent Week In Baltimore

Baltimore City's non-fatal shootings have gone down from 232 this time last year to 195 now, but homicides have gone up from 102 in 2019 to 103 so far this year.




lent

Harrison Urges Witnesses To Reach Out After Violent Week In Baltimore

Baltimore City's non-fatal shootings have gone down from 232 this time last year to 195 now, but homicides have gone up from 102 in 2019 to 103 so far this year.




lent

Expect Long Lines, Full Parking Lots and Plenty of Fun at Grand Canyon this Spring

Visitors to Grand Canyon National Park this spring break can expect long lines and full parking lots. https://www.nps.gov/grca/learn/news/spring-break-crowds.htm




lent

The heartbreaking past of Britain's Got Talent 'magic' dog Miracle

Simon Cowell was moved to tears by rescue dog Miracle on Britain's Got Talent who has a very traumatic past




lent

Check out the NI dad aiming to break the world record on Britain's Got Talent

He appeared on BGT in 2017 and broke the record for balloon sculpting




lent

Glentoran footballers lend support to Covid-19 care project

First-team players from the Oval club volunteered at Connswater Community Centre earlier this week.




lent

CLI Equivalents for Common MAMP PRO and Sequel Pro Tasks

Working on website front ends I sometimes use MAMP PRO to manage local hosts and Sequel Pro to manage databases. Living primarily in my text editor, a terminal, and a browser window, moving to these click-heavy dedicated apps can feel clunky. Happily, the tasks I have most frequently turned to those apps for —starting and stopping servers, creating new hosts, and importing, exporting, deleting, and creating databases— can be done from the command line.

I still pull up MAMP PRO if I need to change a host's PHP version or work with its other more specialized settings, or Sequel Pro to quickly inspect a database, but for the most part I can stay on the keyboard and in my terminal. Here's how:

Command Line MAMP PRO

You can start and stop MAMP PRO's servers from the command line. You can even do this when the MAMP PRO desktop app isn't open.

Note: MAMP PRO's menu icon will not change color to reflect the running/stopped status when the status is changed via the command line.

  • Start the MAMP PRO servers:
/Applications/MAMP PRO.app/Contents/MacOS/MAMP PRO cmd startServers
  • Stop the MAMP PRO servers:
/Applications/MAMP PRO.app/Contents/MacOS/MAMP PRO cmd stopServers
  • Create a host (replace host_name and root_path):
/Applications/MAMP PRO.app/Contents/MacOS/MAMP PRO cmd createHost host_name root_path

MAMP PRO-friendly Command Line Sequel Pro

Note: if you don't use MAMP PRO, just replace the /Applications/MAMP/Library/bin/mysql with mysql.

In all of the following commands, replace username with your user name (locally this is likely root) and database_name with your database name. The -p (password) flag with no argument will trigger an interactive password prompt. This is more secure than including your password in the command itself (like -pYourPasswordHere). Of course, if you're using the default password root is not particular secure to begin with so you might just do -pYourPasswordHere.

Setting the -h (host) flag to localhost or 127.0.0.1 tells mysql to look at what's on localhost. With the MAMP PRO servers running, that will be the MAMP PRO databases.

# with the MAMP PRO servers running, these are equivalent:
# /Applications/MAMP/Library/bin/mysql -h 127.0.0.1 other_options
# and
# /Applications/MAMP/Library/bin/mysql -h localhost other_options

/Applications/MAMP/Library/bin/mysql mysql_options # enter. opens an interactive mysql session
mysql> some command; # don't forget the semicolon
mysql> exit;
  • Create a local database
# with the MAMP PRO servers running
# replace `username` with your username, which is `root` by default
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p -e "create database database_name"

or

# with the MAMP PRO servers running
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p # and then enter
mysql> create database database_name; # don't forget the semicolon
mysql> exit

    MAMP PRO's databases are stored in /Library/Application Support/appsolute/MAMP PRO/db so to confirm that it worked you can

ls /Library/Application Support/appsolute/MAMP PRO/db
# will output the available mysql versions. For example I have
mysql56_2018-11-05_16-25-13     mysql57

# If it isn't clear which one you're after, open the main MAMP PRO and click
# on the MySQL "servers and services" item. In my case it shows "Version: 5.7.26"

# Now look in the relevant MySQL directory
ls /Library/Application Support/appsolute/MAMP PRO/db/mysql57
# the newly created database should be in the list
  • Delete a local database
# with the MAMP PRO servers running
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p -e "drop database database_name"
  • Export a dump of a local database. Note that this uses mysqldump not mysql.
# to export an uncompressed file
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysqldump -h localhost -u username -p database_name > the/output/path.sql

# to export a compressed file
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysqldump -h localhost -u username -p database_name | gzip -c > the/output/path.gz

  • Export a local dump from an external database over SSH. Note that this uses mysqldump not mysql.

# replace `ssh-user`, `ssh_host`, `mysql_user`, `database_name`, and the output path

# to end up with an uncompressed file
ssh ssh_user@ssh_host "mysqldump -u mysql_user -p database_name | gzip -c" | gunzip > the/output/path.sql

# to end up with a compressed file
ssh ssh_user@ssh_host "mysqldump -u mysql_user -p database_name | gzip -c" > the/output/path.gz
  • Import a local database dump into a local database
# with the MAMP PRO servers running
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p database_name < the/dump/path.sql
  • Import a local database dump into a remote database over SSH. Use care with this one. But if you are doing it with Sequel Pro —maybe you are copying a Craft site's database from a production server to a QA server— you might as well be able to do it on the command line.
ssh ssh_user@ssh_host "mysql -u username -p remote_database_name" < the/local/dump/path.sql


For me, using the command line instead of the MAMP PRO and Sequel Pro GUI means less switching between keyboard and mouse, less opening up GUI features that aren't typically visible on my screen, and generally better DX. Give it a try! And while MAMP Pro's CLI is limited to the essentials, command line mysql of course knows no limits. If there's something else you use Sequel Pro for, you may be able to come up with a mysql CLI equivalent you like even better.



  • Code
  • Front-end Engineering
  • Back-end Engineering

lent

Australia is recruiting – New Global Talent Visa

Australia has introduced a streamlined, priority visa pathway for highly skilled and talented individuals to work and live permanently in Australia. The Government and industry has recognised there is growing competition for talent around the globe and to compete we must have a pathway that leads to certainty for people wishing to come to Australia. […]

The post Australia is recruiting – New Global Talent Visa appeared first on Visa Australia - Immigration Lawyers & Registered Migration Agents.




lent

Australia’s global talent visa for individuals and businesses

In late 2019 the Australian Government launched the Global Talent – Independent program which offers a streamlined, priority visa pathway for highly skilled and talented individuals to work and live permanently in Australia. There are two streams. The first is the Global Talent Independent Program (GTI) and the second is the Global Talent Employer Sponsored (GTES). […]

The post Australia’s global talent visa for individuals and businesses appeared first on Visa Australia - Immigration Lawyers & Registered Migration Agents.




lent

CLI Equivalents for Common MAMP PRO and Sequel Pro Tasks

Working on website front ends I sometimes use MAMP PRO to manage local hosts and Sequel Pro to manage databases. Living primarily in my text editor, a terminal, and a browser window, moving to these click-heavy dedicated apps can feel clunky. Happily, the tasks I have most frequently turned to those apps for —starting and stopping servers, creating new hosts, and importing, exporting, deleting, and creating databases— can be done from the command line.

I still pull up MAMP PRO if I need to change a host's PHP version or work with its other more specialized settings, or Sequel Pro to quickly inspect a database, but for the most part I can stay on the keyboard and in my terminal. Here's how:

Command Line MAMP PRO

You can start and stop MAMP PRO's servers from the command line. You can even do this when the MAMP PRO desktop app isn't open.

Note: MAMP PRO's menu icon will not change color to reflect the running/stopped status when the status is changed via the command line.

  • Start the MAMP PRO servers:
/Applications/MAMP PRO.app/Contents/MacOS/MAMP PRO cmd startServers
  • Stop the MAMP PRO servers:
/Applications/MAMP PRO.app/Contents/MacOS/MAMP PRO cmd stopServers
  • Create a host (replace host_name and root_path):
/Applications/MAMP PRO.app/Contents/MacOS/MAMP PRO cmd createHost host_name root_path

MAMP PRO-friendly Command Line Sequel Pro

Note: if you don't use MAMP PRO, just replace the /Applications/MAMP/Library/bin/mysql with mysql.

In all of the following commands, replace username with your user name (locally this is likely root) and database_name with your database name. The -p (password) flag with no argument will trigger an interactive password prompt. This is more secure than including your password in the command itself (like -pYourPasswordHere). Of course, if you're using the default password root is not particular secure to begin with so you might just do -pYourPasswordHere.

Setting the -h (host) flag to localhost or 127.0.0.1 tells mysql to look at what's on localhost. With the MAMP PRO servers running, that will be the MAMP PRO databases.

# with the MAMP PRO servers running, these are equivalent:
# /Applications/MAMP/Library/bin/mysql -h 127.0.0.1 other_options
# and
# /Applications/MAMP/Library/bin/mysql -h localhost other_options

/Applications/MAMP/Library/bin/mysql mysql_options # enter. opens an interactive mysql session
mysql> some command; # don't forget the semicolon
mysql> exit;
  • Create a local database
# with the MAMP PRO servers running
# replace `username` with your username, which is `root` by default
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p -e "create database database_name"

or

# with the MAMP PRO servers running
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p # and then enter
mysql> create database database_name; # don't forget the semicolon
mysql> exit

    MAMP PRO's databases are stored in /Library/Application Support/appsolute/MAMP PRO/db so to confirm that it worked you can

ls /Library/Application Support/appsolute/MAMP PRO/db
# will output the available mysql versions. For example I have
mysql56_2018-11-05_16-25-13     mysql57

# If it isn't clear which one you're after, open the main MAMP PRO and click
# on the MySQL "servers and services" item. In my case it shows "Version: 5.7.26"

# Now look in the relevant MySQL directory
ls /Library/Application Support/appsolute/MAMP PRO/db/mysql57
# the newly created database should be in the list
  • Delete a local database
# with the MAMP PRO servers running
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p -e "drop database database_name"
  • Export a dump of a local database. Note that this uses mysqldump not mysql.
# to export an uncompressed file
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysqldump -h localhost -u username -p database_name > the/output/path.sql

# to export a compressed file
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysqldump -h localhost -u username -p database_name | gzip -c > the/output/path.gz

  • Export a local dump from an external database over SSH. Note that this uses mysqldump not mysql.

# replace `ssh-user`, `ssh_host`, `mysql_user`, `database_name`, and the output path

# to end up with an uncompressed file
ssh ssh_user@ssh_host "mysqldump -u mysql_user -p database_name | gzip -c" | gunzip > the/output/path.sql

# to end up with a compressed file
ssh ssh_user@ssh_host "mysqldump -u mysql_user -p database_name | gzip -c" > the/output/path.gz
  • Import a local database dump into a local database
# with the MAMP PRO servers running
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p database_name < the/dump/path.sql
  • Import a local database dump into a remote database over SSH. Use care with this one. But if you are doing it with Sequel Pro —maybe you are copying a Craft site's database from a production server to a QA server— you might as well be able to do it on the command line.
ssh ssh_user@ssh_host "mysql -u username -p remote_database_name" < the/local/dump/path.sql


For me, using the command line instead of the MAMP PRO and Sequel Pro GUI means less switching between keyboard and mouse, less opening up GUI features that aren't typically visible on my screen, and generally better DX. Give it a try! And while MAMP Pro's CLI is limited to the essentials, command line mysql of course knows no limits. If there's something else you use Sequel Pro for, you may be able to come up with a mysql CLI equivalent you like even better.



  • Code
  • Front-end Engineering
  • Back-end Engineering

lent

CLI Equivalents for Common MAMP PRO and Sequel Pro Tasks

Working on website front ends I sometimes use MAMP PRO to manage local hosts and Sequel Pro to manage databases. Living primarily in my text editor, a terminal, and a browser window, moving to these click-heavy dedicated apps can feel clunky. Happily, the tasks I have most frequently turned to those apps for —starting and stopping servers, creating new hosts, and importing, exporting, deleting, and creating databases— can be done from the command line.

I still pull up MAMP PRO if I need to change a host's PHP version or work with its other more specialized settings, or Sequel Pro to quickly inspect a database, but for the most part I can stay on the keyboard and in my terminal. Here's how:

Command Line MAMP PRO

You can start and stop MAMP PRO's servers from the command line. You can even do this when the MAMP PRO desktop app isn't open.

Note: MAMP PRO's menu icon will not change color to reflect the running/stopped status when the status is changed via the command line.

  • Start the MAMP PRO servers:
/Applications/MAMP PRO.app/Contents/MacOS/MAMP PRO cmd startServers
  • Stop the MAMP PRO servers:
/Applications/MAMP PRO.app/Contents/MacOS/MAMP PRO cmd stopServers
  • Create a host (replace host_name and root_path):
/Applications/MAMP PRO.app/Contents/MacOS/MAMP PRO cmd createHost host_name root_path

MAMP PRO-friendly Command Line Sequel Pro

Note: if you don't use MAMP PRO, just replace the /Applications/MAMP/Library/bin/mysql with mysql.

In all of the following commands, replace username with your user name (locally this is likely root) and database_name with your database name. The -p (password) flag with no argument will trigger an interactive password prompt. This is more secure than including your password in the command itself (like -pYourPasswordHere). Of course, if you're using the default password root is not particular secure to begin with so you might just do -pYourPasswordHere.

Setting the -h (host) flag to localhost or 127.0.0.1 tells mysql to look at what's on localhost. With the MAMP PRO servers running, that will be the MAMP PRO databases.

# with the MAMP PRO servers running, these are equivalent:
# /Applications/MAMP/Library/bin/mysql -h 127.0.0.1 other_options
# and
# /Applications/MAMP/Library/bin/mysql -h localhost other_options

/Applications/MAMP/Library/bin/mysql mysql_options # enter. opens an interactive mysql session
mysql> some command; # don't forget the semicolon
mysql> exit;
  • Create a local database
# with the MAMP PRO servers running
# replace `username` with your username, which is `root` by default
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p -e "create database database_name"

or

# with the MAMP PRO servers running
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p # and then enter
mysql> create database database_name; # don't forget the semicolon
mysql> exit

    MAMP PRO's databases are stored in /Library/Application Support/appsolute/MAMP PRO/db so to confirm that it worked you can

ls /Library/Application Support/appsolute/MAMP PRO/db
# will output the available mysql versions. For example I have
mysql56_2018-11-05_16-25-13     mysql57

# If it isn't clear which one you're after, open the main MAMP PRO and click
# on the MySQL "servers and services" item. In my case it shows "Version: 5.7.26"

# Now look in the relevant MySQL directory
ls /Library/Application Support/appsolute/MAMP PRO/db/mysql57
# the newly created database should be in the list
  • Delete a local database
# with the MAMP PRO servers running
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p -e "drop database database_name"
  • Export a dump of a local database. Note that this uses mysqldump not mysql.
# to export an uncompressed file
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysqldump -h localhost -u username -p database_name > the/output/path.sql

# to export a compressed file
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysqldump -h localhost -u username -p database_name | gzip -c > the/output/path.gz

  • Export a local dump from an external database over SSH. Note that this uses mysqldump not mysql.

# replace `ssh-user`, `ssh_host`, `mysql_user`, `database_name`, and the output path

# to end up with an uncompressed file
ssh ssh_user@ssh_host "mysqldump -u mysql_user -p database_name | gzip -c" | gunzip > the/output/path.sql

# to end up with a compressed file
ssh ssh_user@ssh_host "mysqldump -u mysql_user -p database_name | gzip -c" > the/output/path.gz
  • Import a local database dump into a local database
# with the MAMP PRO servers running
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p database_name < the/dump/path.sql
  • Import a local database dump into a remote database over SSH. Use care with this one. But if you are doing it with Sequel Pro —maybe you are copying a Craft site's database from a production server to a QA server— you might as well be able to do it on the command line.
ssh ssh_user@ssh_host "mysql -u username -p remote_database_name" < the/local/dump/path.sql


For me, using the command line instead of the MAMP PRO and Sequel Pro GUI means less switching between keyboard and mouse, less opening up GUI features that aren't typically visible on my screen, and generally better DX. Give it a try! And while MAMP Pro's CLI is limited to the essentials, command line mysql of course knows no limits. If there's something else you use Sequel Pro for, you may be able to come up with a mysql CLI equivalent you like even better.



  • Code
  • Front-end Engineering
  • Back-end Engineering

lent

CLI Equivalents for Common MAMP PRO and Sequel Pro Tasks

Working on website front ends I sometimes use MAMP PRO to manage local hosts and Sequel Pro to manage databases. Living primarily in my text editor, a terminal, and a browser window, moving to these click-heavy dedicated apps can feel clunky. Happily, the tasks I have most frequently turned to those apps for —starting and stopping servers, creating new hosts, and importing, exporting, deleting, and creating databases— can be done from the command line.

I still pull up MAMP PRO if I need to change a host's PHP version or work with its other more specialized settings, or Sequel Pro to quickly inspect a database, but for the most part I can stay on the keyboard and in my terminal. Here's how:

Command Line MAMP PRO

You can start and stop MAMP PRO's servers from the command line. You can even do this when the MAMP PRO desktop app isn't open.

Note: MAMP PRO's menu icon will not change color to reflect the running/stopped status when the status is changed via the command line.

  • Start the MAMP PRO servers:
/Applications/MAMP PRO.app/Contents/MacOS/MAMP PRO cmd startServers
  • Stop the MAMP PRO servers:
/Applications/MAMP PRO.app/Contents/MacOS/MAMP PRO cmd stopServers
  • Create a host (replace host_name and root_path):
/Applications/MAMP PRO.app/Contents/MacOS/MAMP PRO cmd createHost host_name root_path

MAMP PRO-friendly Command Line Sequel Pro

Note: if you don't use MAMP PRO, just replace the /Applications/MAMP/Library/bin/mysql with mysql.

In all of the following commands, replace username with your user name (locally this is likely root) and database_name with your database name. The -p (password) flag with no argument will trigger an interactive password prompt. This is more secure than including your password in the command itself (like -pYourPasswordHere). Of course, if you're using the default password root is not particular secure to begin with so you might just do -pYourPasswordHere.

Setting the -h (host) flag to localhost or 127.0.0.1 tells mysql to look at what's on localhost. With the MAMP PRO servers running, that will be the MAMP PRO databases.

# with the MAMP PRO servers running, these are equivalent:
# /Applications/MAMP/Library/bin/mysql -h 127.0.0.1 other_options
# and
# /Applications/MAMP/Library/bin/mysql -h localhost other_options

/Applications/MAMP/Library/bin/mysql mysql_options # enter. opens an interactive mysql session
mysql> some command; # don't forget the semicolon
mysql> exit;
  • Create a local database
# with the MAMP PRO servers running
# replace `username` with your username, which is `root` by default
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p -e "create database database_name"

or

# with the MAMP PRO servers running
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p # and then enter
mysql> create database database_name; # don't forget the semicolon
mysql> exit

    MAMP PRO's databases are stored in /Library/Application Support/appsolute/MAMP PRO/db so to confirm that it worked you can

ls /Library/Application Support/appsolute/MAMP PRO/db
# will output the available mysql versions. For example I have
mysql56_2018-11-05_16-25-13     mysql57

# If it isn't clear which one you're after, open the main MAMP PRO and click
# on the MySQL "servers and services" item. In my case it shows "Version: 5.7.26"

# Now look in the relevant MySQL directory
ls /Library/Application Support/appsolute/MAMP PRO/db/mysql57
# the newly created database should be in the list
  • Delete a local database
# with the MAMP PRO servers running
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p -e "drop database database_name"
  • Export a dump of a local database. Note that this uses mysqldump not mysql.
# to export an uncompressed file
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysqldump -h localhost -u username -p database_name > the/output/path.sql

# to export a compressed file
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysqldump -h localhost -u username -p database_name | gzip -c > the/output/path.gz

  • Export a local dump from an external database over SSH. Note that this uses mysqldump not mysql.

# replace `ssh-user`, `ssh_host`, `mysql_user`, `database_name`, and the output path

# to end up with an uncompressed file
ssh ssh_user@ssh_host "mysqldump -u mysql_user -p database_name | gzip -c" | gunzip > the/output/path.sql

# to end up with a compressed file
ssh ssh_user@ssh_host "mysqldump -u mysql_user -p database_name | gzip -c" > the/output/path.gz
  • Import a local database dump into a local database
# with the MAMP PRO servers running
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p database_name < the/dump/path.sql
  • Import a local database dump into a remote database over SSH. Use care with this one. But if you are doing it with Sequel Pro —maybe you are copying a Craft site's database from a production server to a QA server— you might as well be able to do it on the command line.
ssh ssh_user@ssh_host "mysql -u username -p remote_database_name" < the/local/dump/path.sql


For me, using the command line instead of the MAMP PRO and Sequel Pro GUI means less switching between keyboard and mouse, less opening up GUI features that aren't typically visible on my screen, and generally better DX. Give it a try! And while MAMP Pro's CLI is limited to the essentials, command line mysql of course knows no limits. If there's something else you use Sequel Pro for, you may be able to come up with a mysql CLI equivalent you like even better.



  • Code
  • Front-end Engineering
  • Back-end Engineering

lent

Godox’s new SL150/SL200 Mark II LED lights offer fanless “silent mode” operation

The Godox SL series LED lights have proven to be extremely popular due to their low cost. Two of the models in that range, the SL150 and SL200 have seen a Mark II update today, according to an email that Godox has been sending out today. One of the features of the new SL150II and […]

The post Godox’s new SL150/SL200 Mark II LED lights offer fanless “silent mode” operation appeared first on DIY Photography.




lent

Locally equivalent Floer complexes and unoriented link cobordisms. (arXiv:1911.03659v4 [math.GT] UPDATED)

We show that the local equivalence class of the collapsed link Floer complex $cCFL^infty(L)$, together with many $Upsilon$-type invariants extracted from this group, is a concordance invariant of links. In particular, we define a version of the invariants $Upsilon_L(t)$ and $ u^+(L)$ when $L$ is a link and we prove that they give a lower bound for the slice genus $g_4(L)$. Furthermore, in the last section of the paper we study the homology group $HFL'(L)$ and its behaviour under unoriented cobordisms. We obtain that a normalized version of the $upsilon$-set, introduced by Ozsv'ath, Stipsicz and Szab'o, produces a lower bound for the 4-dimensional smooth crosscap number $gamma_4(L)$.




lent

Kathy Valentine talks about her deeply personal memoir and life in the Go-Go's

Virtually every musician starts out trying to copy their heroes.…



  • Arts & Culture

lent

Adjacent to a ski resort, this mountainside hamlet offers plenty of small-town pleasures

If you've ever been compelled to visit Chewelah, it has likely been related to a trip to 49 Degrees North.…




lent

Sugar, spice and everything nice, plus where to find it locally this Valentine's Day

Don't be caught empty-handed (or empty-hearted) this Valentine's Day, coming up Friday, Feb. 14.…



  • Food/Food News

lent

Lipid composition having excellent shape retention property and product

It is to provide a technique for preventing aggregation or caking of menthol at the time of its keeping. In addition, it is to provide a lipid composition, which can show excellent thermal stability even in the case of high temperature at the time of keeping menthol and at the time of blending in a product, does not cause mutual aggregation of powders, particles, flakes, pellets, sticks and the like of menthol, and can maintain its shape retention property. From 10 to 50% by mass of sterols are added to and mixed with from 50 to 90% by mass of menthol, and the resultant is melted with heating. Paraffins may be further added and mixed in an amount of 20% by mass or less, based on the lipid composition.




lent

Mixed-valent transition metal-phosphoranimide catalysts

Phosphoranimide-metal catalysts are disclosed. The catalysts comprise first row transition metals such as nickel, cobalt or iron. The hydrocarbon-soluble catalysts have a metal to anionic phosphoranimide ratio of 1:1, and have no inactive bulk phase and no dative ancillary ligands. The electronic state of the clusters can be adjusted to optimize catalytic activity for a range of commercially important reductive transformations, including hydrodesulfurization. A method of synthesis of these catalysts by anionic metathesis of a halide substituted precursor followed by oxidation is also disclosed.




lent

Method of manufacturing water repellent film and thereby manufactured water repellent film

A method of manufacturing a water repellent film includes, before a formation step of forming an organic film on a substrate using a silane coupling agent by a vapor phase deposition method under film formation conditions, a step of specifying the film formation conditions using a test substrate of a same material as the substrate used in the formation step. The film formation condition specifying step includes: specifying film formation temperature to be not lower than a temperature at which the silane coupling agent evaporates and to be lower than a temperature at which the silane coupling agent bumps; and forming an organic film of the silane coupling agent on the test substrate at the specified film formation temperature, measuring by optical microscopic observation a time at which a bead of surplus water repellent material is formed, and specifying the film formation duration to be shorter than the measured time.




lent

Construction of a multivalent scFv through alkyne-azide 1,3-dipolar cycloaddition

The present invention provides for a practical, universal and efficient method to ligate two large macromolecules (e.g., proteins) using the alkyne-azide 1,3-dipolar cycloaddition reaction to produce a conjugated macromolecule, such as a multivalent scFv. The present invention also provides for conjugate macromolecules comprising a plurality of macromolecule components cross-linked through at least one linking group comprising at least one 1,2,3-triazole moiety, wherein at least 50 percent of the macromolecule components in the conjugate macromolecule has only one site available for cross-linking.




lent

Covalently bound monolayer for a protective carbon overcoat

A magnetic data storage medium may include a substrate, a magnetic recording layer, a protective carbon overcoat, and a monolayer covalently bound to carbon atoms adjacent a surface of the protective carbon overcoat. According to this aspect of the disclosure, the monolayer comprises at least one of hydrogen, fluorine, nitrogen, oxygen, and a fluoro-organic molecule. In some embodiments, a surface of a read and recording head may also include a monolayer covalently bound to carbon atoms of a protective carbon overcoat.




lent

Silent chain

In a silent chain, rocker joint pins are composed of first and second rocker pins having mutually engaging front rolling surfaces. Each first rocker pin is fixed to pin fixing link plates of a first link, and extends through holes in other link plates of the first link. Each first pin has a back surface engaged with portions of the pin holes in the other link plates of the first link on the inner side of a pitch line, but is spaced by a gap from portions of the same pin holes on the outer side of the pitch line. The second rocker pin moves with link plates of a second link which forms a link pair with the first link, and elastically deforms the first rocker pin when the second link is flexed relative to the first link, thereby resisting flexion of the link pair and reducing impact noise.




lent

Silent chain transmission system

In a silent chain transmission, noise performance is improved by preventing guide plates of a silent chain from contacting sprocket teeth before the link plates of the chain contact the sprocket teeth. The silent chain transmission comprises a silent chain in engagement with a sprocket. The silent chain comprises guide rows, each having a pair of guide plates and a plurality of middle link plates, and non-guide rows, each having a plurality of inner link plates. An engagement starting point of the middle link plate with a sprocket tooth and an engagement starting point of the inner link plate with the sprocket tooth are set at positions such that the guide plate is prevented from contacting the sprocket tooth before the respective link plates start to engage the sprocket tooth when runout of the chain in the direction of its width occurs.




lent

Lubricant composition using ionic liquid as a base oil and having excellent rust prevention properties

The invention provides a lubricant composition containing (A) an ionic liquid having an anion represented by formula 1: (Rf1-SO2) (Rf2-SO2) N− or formula 2: (Rf3) (Rf3) (Rf3) PF3− wherein Rf1 and Rf2 in formula 1 may be the same or different and are each F, CF3, C2F5, C3F7 or C4F9, and Rf3 in formula 2 may be the same or different and is CF3, C2F5, C3F7 or C4F9; and (B) a fatty acid amine salt in an amount of 0.1 to 5.0 mass %. The lubricant composition of the invention can favorably be used under a high vacuum or an ultra high vacuum, or under high temperatures, and exhibits excellent rust prevention properties.




lent

Hot-dip galvanized steel sheet and alloyed hot-dip galvanized steel sheet, each having excellent workability, high yield ratio and high strength

Disclosed is a hot-dip galvanized steel sheet or an alloyed hot-dip galvanized steel sheet, which has a tensile strength of 980 MPa or more, excellent workability, high yield ratio and high strength. The hot-dip galvanized steel sheet or the alloyed hot-dip galvanized steel sheet is characterized by containing 0.12-0.3% by mass of C, 0.1% by mass or less (excluding 0% by mass) of Si, 2.0-3.5% by mass of Mn, 0.05% by mass or less (excluding 0% by mass) of P, 0.05% by mass or less (excluding 0% by mass) of S, 0.005-0.1% by mass of Al and 0.015% by mass or less (excluding 0% by mass) of N, with the balance made up of iron and unavoidable impurities. The hot-dip galvanized steel sheet or the alloyed hot-dip galvanized steel sheet is also characterized in that the metallic structure thereof contains bainite as a matrix structure, and the area ratio of ferrite is 3-20% and the area ratio of martensite is 10-35% relative to the entire structure.




lent

Water/oil repellent composition, method for its production and article

To provide a water/oil repellent composition which can impart sufficient post-air-drying water/oil repellency to the surface of an article, and which presents a low environmental impact, and an article having its surface treated with the water/oil repellent composition. A water/oil repellent composition comprising a copolymer (A) having structural units based on a monomer (a), structural units based on a monomer (b), structural units based on a monomer (c) and/or structural units based on a monomer (d); and an aqueous medium (B) containing water, and a film-forming assistant (x) and/or a film-forming assistant (y). Monomer (a): a monomer having a C1-6 polyfluoroalkyl group, monomer (b): vinylidene chloride, monomer (c): a monomer, the homopolymer of which has a glass transition temperature of at least 20° C., monomer (d): a monomer having a crosslinkable functional group, film-forming assistant (x): a specific amide solvent, and film-forming assistant (y): a specific glycol solvent.




lent

Method of determining a turbulent condition in an aircraft

A method of determining a turbulent condition in an aircraft with a handheld device where the handheld device has at least one of a gyroscope, seismometer, and an accelerometer where the method includes receiving an output from the at least one of the gyroscope, seismometer, and accelerometer while the handheld device is located within the aircraft and providing an indication of a turbulent condition.




lent

Welding metal having excellent low-temperature toughness and drop-weight characteristics

Provided is a welding metal in which the chemical component composition thereof is appropriately controlled; an A value that is specified by a predetermined relational expression satisfies the requirement of being 3.8% to 9.0%; an X value that is specified by a predetermined relational expression satisfies the requirement of being 0.5% or greater; the area percentage of carbide particles having a circle-equivalent diameter of 0.20 μm or greater in the welding metal is 4.0% or less; and the number of carbide particles having a circle-equivalent diameter of 1.0 μm or greater is 1000 particles/mm2 or less. This welding metal, which can exhibit not only high strength but also good low-temperature toughness and good drop-weight characteristics, is useful as a material for a pressure vessel in a nuclear power plant.




lent

Bake hardening steel with excellent surface properties and resistance to secondary work embrittlement, and preparation method thereof

Provided are a bake hardening steel having a crystalline grain size of ASTM No. 9 or more and a method for preparing the bake hardening steel by controlling the winding, rolling and cooling conditions. The bake hardening steel includes: C:0.0016˜0.0025%, Si:0.02% or less, P:0.01˜0.05%, S:0.01% or less, sol.Al:0.08˜0.12%, N:0.0025% or less, Ti:0.003% or less, Nb:0.003˜0.011%, Mo:0.01˜0.1%, B:0.0005˜0.0015% or less, balance Fe and other inevitable impurities, wherein % is weight %, and Mn and P satisfy the relation of −30(° C.)≧803P−24.4Mn−58.




lent

Apparatus for turbulent combustion of fly ash

An apparatus for processing fly ash comprising a heated refractory-lined vessel having a series of spaced angled rows of swirl-inducing nozzles which cause cyclonic and/or turbulent air flow of the fly ash when introduced in the vessel, thus increasing the residence time of airborne particles. Also disclosed is a method of fly ash beneficiation using the apparatus.




lent

Method and an apparatus for processing a lenticular printing substrate

A method for preparing a lenticular guide roll for use in a lenticular printing run. The method comprises providing a printing roll of a printing press and a first piece of lenticular media. The first piece of lenticular printing substrate has a pitch which is substantially identical to a second lenticular printing substrate to be used in the lenticular printing run. The, method further comprises attaching the first piece of lenticular printing substrate to the printing roll to allow the maneuvering of the second lenticular printing substrate by the printing roll in the printing press.




lent

Thin gauge steel sheet excellent in surface conditions, formability, and workability and method for producing the same

The present invention provides ultralow carbon thin gauge steel sheet and a method for producing the same where coalescence and growth of inclusions in the molten steel are prevented and the inclusions are finely dispersed in the steel sheet, whereby surface defects and cracks at the time of press forming are prevented, growth of recrystallized grains at the time of continuous annealing is promoted, and a high r value (r value≧2.0) and elongation (total elongation≧50%) are exhibited, that is, ultralow carbon thin gauge steel sheet excellent in surface conditions, formability, and workability comprised of, by mass %, 0.00030.003%≦C≦0.003%, Si≦0.01%, Mn≦0.1%, P≦0.02%, S≦0.01%, 0.0005%≦N≦0.0025%, 0.01%≦acid soluble Ti≦0.07%, acid soluble Al≦0.003%, and 0.002%≦La+Ce+Nd≦0.02% and a balance of iron and unavoidable impurities, said steel sheet characterized by containing at least cerium oxysulfite, lanthanum oxysulfite, and neodymium oxysulfite.




lent

Method for producing seamless steel pipe for oil wells excellent in sulfide stress cracking resistance

A high-strength seamless steel pipe for oil wells excellent in sulfide stress cracking resistance which comprises, on the percent by mass basis, C: 0.1 to 0.20%, Si: 0.05 to 1.0%, Mn: 0.05 to 1.0%, Cr: 0.05 to 1.5%, Mo: 0.05 to 1.0%, Al: 0.10% or less, Ti: 0.002 to 0.05% and B: 0.0003 to 0.005%, with a value of equation “C+(Mn/6)+(Cr/5)+(Mo/3)” of 0.43 or more, with the balance being Fe and impurities, and in the impurities P: 0.025% or less, S: 0.010% or less and N: 0.007% or less. The seamless steel pipe may contain a specified amount of one or more element(s) of V and Nb, and/or a specified amount of one or more element(s) of Ca, Mg and REM. The seamless steel pipe can be produced at a low cost by adapting an in-line tube making and heat treatment process having a high production efficiency since a reheating treatment for refinement of grains is not required.




lent

High Al-content steel sheet excellent in workability and method of production of same

The present invention provides a high Al-content steel sheet having an excellent workability and a method of production of the same at a low cost by mass production, a high Al-content metal foil and a method of production of the same, and a metal substrate using a high Al-content metal foil, that is, a high Al-content steel sheet having an Al content of 6.5 mass % to 10 mass %, the high Al-content steel sheet characterized by having one or both of a {222} plane integration of an α-Fe crystal with respect to the surface of the steel sheet of 60% to 95% or a {200} plane integration of 0.01% to 15% and a method of production of the same, a high Al-content metal foil and a method of production of the same, and a metal substrate using a high Al-content metal foil.




lent

Method for manufacturing high strength galvanized steel sheet with excellent formability

A method of manufacturing a high-strength galvanized steel sheet includes hot-rolling a slab to form a steel sheet; during continuous annealing, heating the steel sheet to a temperature of 750° C. to 900° C. at an average heating rate of at least 10° C./s at a temperature of 500° C. to an A1 transformation point; holding that temperature for at least 10 seconds; cooling the steel sheet from 750° C. to a temperature of (Ms point—100° C.) to (Ms point—200° C.) at an average cooling rate of at least 10° C./s; reheating the steel sheet to a temperature of 350° C. to 600° C.; holding that temperature for 10 to 600 seconds; and galvanizing the steel sheet.




lent

Steel sheet for cans with excellent surface properties after drawing and ironing and method for producing the same

A component composition contains, by % by mass, 0.0016 to 0.01% of C, 0.05 to 0.60% of Mn, and 0.020 to 0.080% of Nb so that the C and Nb contents satisfy the expression, 0.4≦(Nb/C)×(12/93)≦2.5. In addition, the amount of Nb-based precipitates is 20 to 500 ppm by mass, the average grain diameter of the Nb-based precipitates is 10 to 100 nm, and the average crystal grain diameter of ferrite is 6 to 10 μm. Nb is added to ultra-low-carbon steel used as a base, and the amount and grain diameter of the Nb-based precipitates are controlled to optimize the pinning effect. Grain refinement of ferrite is achieved by specifying the Mn amount, thereby achieving softening and excellent resistance to surface roughness of steel.