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

1 Answer

+1 vote

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).