How to import a single table in to mysql database using command line

Question

I had successfully imported a database using command line  but now my pain area is how to import a single table with its data to the existing database using command line

User · Answer

Command Line  Import   Export for single table   Exporting  table schema   - gt  mysqldump -u your user name -p your database name table name  gt  test sql   This will create a file named test sql  and  creates table sql command to create table table name   Importing data into table   - gt  mysql -u your user name -p database name table name  lt  test sql   Make sure your test sql file is in the same directory  if not navigate through the path and then run the command

User · Answer

First of all  login to your database and check whether the database table which you want to import is not available on your database   If it is available  delete the table using the command  Else it will throw an error while importing the table   DROP TABLE Table Name    Then  move to the folder in which you have the  sql file to import and run the following command from your terminal  mysql -u username -p  databasename   lt  yourtable sql   The terminal will ask you to enter the password  Enter it and check the database

User · Answer

Export   mysqldump --user root databasename  gt  whole database sql mysqldump --user root databasename onlySingleTableName  gt  single table sql   Import    Whole database   mysql --user root wholedatabase  lt  whole database sql   Single table   mysql --user root databasename  lt  single table sql

User · Answer

mysql -u root -p -D dbname  lt  tablename sql

User · Answer

you can  do it in mysql command instead of linux command  1 login your mysql  2 excute this in mysql command  use DATABASE NAME  SET autocommit 0   source ABSOLUTE PATH TABLE SQL FILE sql   COMMIT

User · Answer

If you re in the pwd of an SQL dump and you need a table from that  do this  sed -n   -- Table structure for table   TableNameTo GrabHere     -- Table     --    d p    dump file to extract from sql  gt  table name here sql  Then just import the table you extracted from the above into the needed database

User · Answer

To import a table into database  if table is already exist then add this line in your sql file DROP TABLE IF EXIST  table name  and run command mysql -u username -p database name  lt  import sql file sql  Please verify the sql file path before execute the command

User · Answer

Using a temporary database could be a solution depending on the size of the database   mysql -u  username  -p -e  create database tempdb  mysql -u  username  -p tempdb  lt  db sql mysqldump -u  username  -p tempdb  table to import   gt  table to import sql mysql -u  username  -p maindb  lt  table to import sql

User · Answer

From server to local Exporting   mysqldump -u username -p db name table name  gt  path filename sql  mysqldump -u root -p remotelab welcome ulink  gt    home local ladmin kakalwar base welcome ulink sql    From local to server Importing   mysql -u username -p -D databasename  lt  path x y z welcome queue sql mysql -u root -p -D remotelab  lt    home local ladmin kakalwar instant status db 04 12 welcome queue sql

User · Answer

Linux    In command line    mysql -u username -p  databasename   lt  path example sql   put your table in example sql  Import   Export for single table    Export table schema  mysqldump -u username -p databasename tableName  gt  path example sql   This will create a file named example sql at the path mentioned and write the create table sql command to create table tableName  Import data into table  mysql -u username -p databasename  lt  path example sql   This command needs an sql file containing data in form of insert statements for table tableName  All the insert statements will be executed and the data will be loaded

User · Answer

All of these options are fine  if you have the option to re-export the data  But if you need to use an existing SQL file  and use a specific table from it  then this perl script in the TimeSheet blog  with enable you to extract the table to a separate SQL file  and then import it  The original link is dead  so it is a good thing that someone has put it instead of the author  Jared Cheney  on GitHub  in this link

User · Answer

if you already have the desired table on your database  first delete it and then run the command below    mysql -u username -p  databasename   lt  yourtable sql

User · Answer

It works correctly     C   gt mysql gt bin gt mysql -u USERNAME DB NAME  lt  tableNameFile sql   please note  sql file specified your current database

User · Answer

We can import single table using CMD as below   D  wamp bin mysql mysql5 5 24 bin gt mysql -h hostname -u username -p passowrd databasename  lt  filepath

User · Answer

Also its working  In command form   cd C  wamp bin mysql mysql5 5 8 bin   hit enter mysql -u -p databasename   -u root -p blank

User · Answer

Importing the Single Table To import a single table into an existing database you would use the following command  mysql -u username -p -D database name  lt  tableName sql  Note It is better to use full path of the sql file tableName sql

User · Answer

It would be combination of EXPORT INTO OUTFILE and LOAD DATA INFILE You need to export that single table with EXPORT INTO OUTFILE  this will export table data to a file  You can import that particular table using LOAD DATA INFILE Refer doc1   doc2

User · Answer

- gt  mysql -h host -u user -p database name table name  lt  test table sql

[mysql] How to import a single table in to mysql database using command line

Examples related to mysql

Examples related to import