Page 3 of 3
Re: Today's server problems
Posted: 24 Dec 2023 22:19
by exxos
elterwater wrote: 24 Dec 2023 21:40
As per the manual, you need to specify the DB name of the wiki you want to be dumping out otherwise you'll get everything including MySQL server users....
I did specify the wiki database. It dumped the lot anyway.
Re: Today's server problems
Posted: 25 Dec 2023 13:41
by mfro
exxos wrote: 24 Dec 2023 22:19
I did specify the wiki database. It dumped the lot anyway.
not with the command you showed above
Code: Select all
mysqldump -u root -p redacted > wiki7b.sql
(-u is to specify the user, -p is to specify the database password)
Re: Today's server problems
Posted: 26 Dec 2023 13:04
by troed
Install trafik/prometheus/grafana and keep some dashboards showing you your server stats/health. Most people overpay a lot for servers.
I run a home server with 4 cores, SSD and 32GB RAM. It's not even at half load and it's running _lots_ more than you are from what I can see :/