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
A MariaDB server is installed on a Linux server. How can a dump of the complete database be made, how it is at a single point in time, while preventing write access to the database during the dump...
#6: Post edited
by
H_H
·
2023-11-10T18:25:58Z (about 1 year ago)
- A MariaDB server is installed on a Linux server.
- How can a dump of the complete database be made, how it is at a single point in time, while preventing write access to the database during the dump?
There should be no writes to prevent inconsistencies.
- A MariaDB server is installed on a Linux server.
- How can a dump of the complete database be made, how it is at a single point in time, while preventing write access to the database during the dump?
- Writes to the database during dumping should be prevented to prevent inconsistencies.
#5: Post edited
by
H_H
·
2023-11-10T18:25:12Z (about 1 year ago)
How to create a dump of a complete MariaDB is at a single point in time?
- How to create a dump of a complete MariaDB how the data is at a single point in time?
#4: Post edited
by
H_H
·
2023-11-10T18:17:59Z (about 1 year ago)
How to dump a MariaDB while mariadb.service is stopped?
- How to create a dump of a complete MariaDB is at a single point in time?
- 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).
- A MariaDB server is installed on a Linux server.
- How can a dump of the complete database be made, how it is at a single point in time, while preventing write access to the database during the dump?
- There should be no writes to prevent inconsistencies.
#3: Post edited
by
samcarter
·
2023-11-09T19:34:35Z (about 1 year ago)
rolled back the edit as a follow-up question has been posted
- 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.
- 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).
#2: Post edited
by
H_H
·
2023-11-08T16:47:03Z (about 1 year ago)
- 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).
- 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: Initial revision
by
H_H
·
2023-11-08T11:29:39Z (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).