Questions
nicolez4nicolez4asked 4 months ago
I have a “sql” file and I want to import it using the command line in xampp. How do I do that?
1

1 Answers

Accepted
codegenlabcodegenlabanswered 4 months ago
follow these step,
  1. open CMD
  2. navigate to xampp/mysql/bin/ directory.(cd/xampp/mysql/bin)
  3. then type following command and press enter,(change username,db name, sqlfile name)
syntax,
mysql -u username -p database_name < file_name.sql
ex,
mysql -u root -p dbuser < user.sql
1