Question about isolated database

Community Support Database
1

Hello everyone

I have a system with PHP + Apache + MariaDB all on one server.

I want to migrate MariaDB to another server, in this case separate PHP + Apache from the current server (and deactivate MariaDB) and leave MariaDB running on another server.

What would be the best way to do this?

Simply install Hestiacp on the other server with only MariaDB?

Or could I just install MariaDB without Hestiacp? In that case, should I use this command CLI Reference | Hestia Control Panel?

Or should I use this one?

What is the difference between add-database-host vs remote database server?

I have doubts about this part.

Important: I use the v-add-database and v-delete-database commands to create and delete databases.Preformatted text

2

the other server does only require MariaDB or Mysql 8 and open port 3306

3

Thanks for the answer - and also for the project

Can you confirm some questions for me please?
1 - On the new server, do I install only ubuntu + mariadb and do I not need to install hestiacp?
2 - With that done, on the main server, do I use the command v-add-database-host mysql new-server.com root password?

3 - Will the v-add-database commands executed on the main hestiacp server (apache + php) continue to work on the new server (with only mariadb)?

4
  1. Yes but open port 3306 (Default Mysql port for at least your server ip)
  2. Yes better would be v-add-database-host mysql new-server.com user password. Where the user has permissions to create new users / database and do all related commands
  3. Yes …
2 Likes
5

Thanks so much @eris

Last awsers…

What path would you recommend for the current server that has MariaDB installed but will be migrated to another server?

Some alternatives that I see are:
1 - Completely uninstall MariaDB from the server. However, I think that could cause problems. Have you tried something similar or do you know more information?
2 - Run a command to stop MariaDB from running when starting the server. However, MariaDB will still be there.
3 - Reinstall the entire HestiAcp without MariaDB (the problem is that I have many customizations in HestiAcp).

6

Webmail (Roundcube or Snappy mail) depends on it make sure to migrate it before deleting…

Everything else it doesn’t matter all 3 will work

7

@eris

Thanks brother…

Just to confirm and avoid problems…
On the current server where I have PHP + Apache + MariaDB, can I uninstall MariaDB without any problems (since I don’t use the email service)?

  • I believe I will need to disable MariaDB backups, and also send backups via FTP. Apart from that, do you remember any other procedure to be done before disabling MariaDB (or any other point that you consider important)?

Thank you very much

8

If you add “remote.database.host” to Hestia via v-add-database-host it will still make the backups without issues

9

thanks for support

Do you have any idea when creating the other server with only mariabd installed, how can I import all databases from the current server to the other?

10
  • Create new database in Hestia on remote server
  • Dump database
  • copy over database to new server
  • mysql database_name < database.sql
1 Like
11

Thanks

More 200 databases… is possible in mariadb remote server run a restore or something like that?
If I have to do it manually I’m broke… there are a lot of databases