Welcome to the Power Users community on Codidact!
Power Users is a Q&A site for questions about the usage of computer software and hardware. We are still a small site and would like to grow, so please consider joining our community. We are looking forward to your questions and answers; they are the building blocks of a repository of knowledge we are building together.
Post History
You may try looking for the command mariadb-dump. As I can see from the documentation, this is a standalone command that generates the necessary SQL DDL statements to recreate and populate existin...
Answer
#1: Initial revision
by
aura-lsprog-86
·
2025-02-15T08:10:37Z (6 days ago)
You may try looking for the command `mariadb-dump`.
As I can see from [the documentation](https://mariadb.com/kb/en/mariadb-dump/), this is a standalone command that generates the necessary SQL DDL statements to recreate and populate existing tables.
With additional options given, you can include stored procedures, events, and views in the dump, because all these are not included by default. On the other hand, triggers, procedures and functions are included without additional arguments.
As a start, you may try the following command:
CMD> mariadb-dump -R -E --databases your_DB_name
where:
* `-R` includes stored procedures.
* `-E` includes events.