How do I import database through command line?
Answer / Nandeshwar Dubey
To import a MySQL database from a .sql file, you can use the `mysql` command-line tool. Here's an example:
```
mysql -u username -p database_name < path/to/your/sqlfile.sql
```
Replace `username`, `database_name`, and `path/to/your/sqlfile.sql` with your actual credentials and the location of your .sql file.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are mysql functions?
What is datatype in mysql?
How do I start mysql in linux?
How do I change directories in mysql?
What are the difference between and myisam and innodb?
How can you increase the performance of mysql select query?
I have a table like this tblData (month int,Qty int) and i am inserting three rows in this table 1.tblData Values (1,100) 2.tblData Values (2,200) 3.tblData Values (3,300) The Result I want is the Running total of the field Qty that is 1 100 100 2 200 300 3 300 600 What is the Query for that ?
What is schema in mysql?
How MySQL Optimizes DISTINCT?
What is the maximum number of columns per table?
How can you find out the version of the installed mysql?
What is pdo :: fetch_assoc?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)