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.
How to dump a MariaDB while mariadb.service is stopped, to move the database to a different server?
A MariaDB server is installed on a Linux server. The MariaDB service is currently stopped, so no client can connect to it. How to create a SQL-dump of all databases without starting the service?
The plan was to disable the MariaDB service so that no new writes to the database can be made (that have a risk of not being included in the dump).
Why: The database should be moved to a different server and isn't needed on the original server anymore after moving is done.
1 answer
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 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:
-
-Rincludes stored procedures. -
-Eincludes events.
0 comment threads
0 comment threads