0

How to take single table backup from database in linux

Am using Phpmyadmin to manage Mysql databases. Is it possible to export a single table from the database through command-line instead of exporting graphically.

MySQL Add a comment
cameron
asked Mar 27 2017

Answer

0

Definitely its possible.

Assume your DB name as testDB and it contains a table called testtable.

#  mysqldump test_DB test_table > test_table.sql

So the above command will take the testtable from the testDB and save it as a .sql file.

Add a comment
jagannatharumugam
asked Mar 27 2017
edited Oct 05 2018
Post your Answer