Communities

Writing
Writing
Codidact Meta
Codidact Meta
The Great Outdoors
The Great Outdoors
Photography & Video
Photography & Video
Scientific Speculation
Scientific Speculation
Cooking
Cooking
Electrical Engineering
Electrical Engineering
Judaism
Judaism
Languages & Linguistics
Languages & Linguistics
Software Development
Software Development
Mathematics
Mathematics
Christianity
Christianity
Code Golf
Code Golf
Music
Music
Physics
Physics
Linux Systems
Linux Systems
Power Users
Power Users
Tabletop RPGs
Tabletop RPGs
Community Proposals
Community Proposals
tag:snake search within a tag
answers:0 unanswered questions
user:xxxx search by author id
score:0.5 posts with 0.5+ score
"snake oil" exact phrase
votes:4 posts with 4+ votes
created:<1w created < 1 week ago
post_type:xxxx type of post
Search help
Notifications
Mark all as read See all your notifications »
Q&A

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

66%
+2 −0
Q&A 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? T...

0 answers  ·  posted 1y ago by H_H‭  ·  edited 1y ago by Canina‭

Question linux mysql
#2: Post edited by user avatar Canina‭ · 2023-11-09T20:24:30Z (about 1 year ago)
  • How to dump a MariaDB while mariadb.service is stopped?
  • How to dump a MariaDB while mariadb.service is stopped, to move the database to a different server?
#1: Initial revision by user avatar H_H‭ · 2023-11-09T17:51:21Z (about 1 year ago)
How to dump a MariaDB while mariadb.service is stopped?
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.