C
C
c5c52015-12-19 16:40:06
MySQL
c5c5, 2015-12-19 16:40:06

How to import table into mysql db?

Request to import the entire database from filename into the dbname database

$ mysql -u username -p -h localhost dbname < filename.sql

There is a database, I want to import a table into it, but so that all existing tables are not overwritten (table names are different, there are no matches). The above query will allow this? Will it overwrite the entire dbname database ?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
R
Robot, 2015-12-19
@c5c5

Add with the same command, the old tables will not overwrite

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question