Israel Hanukoglu, Ph.D.
Laboratory of Cell Biology
Ariel University
Ariel 40700, Israel

Software : SQLite issues in Linux

To execute SQLite commands, SQLite should be installed in the system.

Copy a table from one database to another

Go the directory where the database files are located.

Right click on the directory name and select "Open in Terminal" option.

In the terminal window enter the following commmand

sqlite3 Database1.db3 ".dump Table_name" | sqlite3 Database2.db3

NOTE: The code above assumes that the file extension name is "db3". If yours is different, change accordingly.

I use DB-browser for the maintenance of the databases.