Import a mysql database on the command line
Command:
mysql -u username -p database_name < file.sqlIf you do not want to use the password on the command line then you can do the following:
For linux, add ~/.my.cnf and put the following in it
[client]
password="password"For MacOS with homebrew, add ~/.mysql.cnf and put the same contents in the file as above.
Now, you can do the following command without using a password:
mysql -u username database_name < file.sql
This is a password protected section available to those who know me in some fashion. If you know me and you do not already have a login, you can request a login here.
I am nuts about books. I read on all kinds of topics. I attempt to review each book I read for the sake of my own enrichment as well as conversation starters with others.
God has called me to be a pastor, and occasionally I have some pastoral thoughts I like to share.
You never know what you will find in an attic! Usually there is a hodgepodge of things buried under dust.
Most of what is included here are notes to myself. The majority of folks will not find interest in these posts.