How can you import tables from a sql file into a database by using the mysql client?
Answer / Puneet Awasthi
You can use the `mysql` command followed by the `< sql_file_name.sql >` to import data from an SQL file. For example, `mysql db_name < sql_file_name.sql;`
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the function of mysqldump?
Why does mysql have so many connections?
What is the difference between mysql_fetch_array and mysql_fetch_object?
How to check if a record exists in a mysql database php?
What are the mysql database files stored in system ?
What is identity in mysql?
How to enter binary numbers in sql statements?
Is microsoft sql same as mysql?
Is mysql a distributed database?
How does mysql clustering work?
please give me the answer for this: query which generates the second highest integer in the table?
Explain % and _ inside like statement?
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)