Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
+5 votes
349 views
in Q2A Core by

1 Answer

+1 vote
by

That depends on what DBMS you're using, and to some extent also on how you're managing it.

For MySQL/MariaDB you can backup a single table on the commandline like this:

mysqldump --opt -u DB_USER DB_NAME TABLE_NAME >table_dump.sql

and restore it like this:

mysql -u DB_USER DB_NAME <table_dump.sql

Replace DB_USER, DB_NAME and TABLE_NAME with the correct names for your system(s).

...