Posts

Showing posts from October, 2019

Delete any files and folder forcefully

Use the command Prompt for this command -------------------------------------------------------------- For Deleting the file. DEL /F /Q /A name_of_the_file DEL /F /Q /A C:\Users\HP1\Documents\file.txt For Deleting the folder RD /S /Q name_of_the_folder RD /S /Q C:\Users\HP1\Documents\folder1

How to Import Large SQL file in mysql in Xampp Server

Open Command Prompt Type:  cd c:\xampp\mysql\bin Now I am showing you main command for import SQL file with the explanation . mysql -u {DB-USER-NAME} -p {DB-NAME} < {db.file.sql path} or if it's on a remote server use the -h flag to specify the host. mysql -u {DB-USER-NAME} -h {MySQL-SERVER-HOST-NAME} -p {DB-NAME} < {db.file.sql path} In my case i used this command to import sql.  mysql -u root -p opencart < client_db_file.sql here i directly put sql file in this folder c:/xampp/mysql/bin since while I was putting path it was not working for me. so I moved the SQL file in the same folder and it worked perfectly for me. Enjoy 😅😆