#cli #mysql
Command to import DB through the command line in MySQL
upload your SQL file to the serve through FTP. Ones the file is on server you can user the following command.
Assumptions
- you have created a DB
- you have already create a DB user with privileges as per required.
- you have ssh access to the server
- you know how to log in through ssh into your server.
Command
mysql -u db_user_name -p db_name < /complete/file/path.sql
If you are using amazon RDS, you need to alter the command by adding the host to the command
mysql -h host -u db_user_name -p db_name < /complete/file/path.sql
Queries and comments are welcome.
Most Viewed Posts
Must Read
How to Add AppImage Application to Menu in Ubuntu (Linux)
AppImages are the most easiest to run compared.The challenging task is to make the AppImage accessible globally through he system like an installed application (in the menu)
#code-quality #vscode #laravel-pint #laravel
How to Add Laravel Pint to VS Code Formatter
I have been using the unsatisfactory formatters from a long time. All of them have one thing but lack other. Laravel Pint is one who has it all, combining it with vscode is like proving you laravel project a super power.
#express js #node #node js #sequelize #mysql
How to create model association in Sequelize - express JS / Node JS
In the very initial days of my work in Node JS if faced this issue. Though Sequelize provide a great ORM for MySQL but the association within the models is a bit tricky.
#database #javascript #sequelize #npx
Sequelize CLI Commands
list of Sequelize CLI commands which comes handy, while working on a project.
#functionality #pwa #javascript #laravel
How to create a progressive web app (PWA) in laravel 5.* and above
The progressive web app is the new trend as well as the need for the present time. I hope before getting in the “HOW” part you know what is exactly a PWA
#express js #node #node js #sequelize #mysql
How to create model association in Sequelize - express JS / Node JS
In the very initial days of my work in Node JS if faced this issue. Though Sequelize provide a great ORM for MySQL but the association within the models is a bit tricky.
PHP artisan make:auth in laravel 6.0
As you may have known by now that laravel 6.0 has been out. Though it's expected to have a lot of changes in the major release but in 6.0 there are not that many changes.
Store Git credentials in Terminal
ones this command is run, any git operation required credentials you do, credentials will be stored. Next time you don't need to put the credentials again.
How to take MySQL DB back up from the command line
As you know regular backups of DB for a running site are very important. Most of the hosting providers do this for you, but sometimes its also expected from you to do the same.
Hi, I am Samgan, I know the adds are bit annoying but i hope you understand. Talking about me, I excel at solving complex problems involving logic and step by step breakdown of the problem. Besides, to develop complex algorithms, I specialize in problem framing, systems design, and product development strategy. Sometimes I also enjoy public speaking.
