Downloadable database dumps [SOLVED]


#1

Is it possible to install some utillity like AutoMySQLBackup for taking regular database dumps?
Or would be possible to use LOCAL BACKUPS feature from Server management section just for database backups?


#2

Hello,

There is a local backup feature which you can use to get dump of MySQL database.

Or, another way is using “MySQL manager” and export as SQL file after selecting all tables.

Thanks & Regards,
Gulshan


#3

Hello Gulshan,

thanks for reply.

Is there any way how to connect to DB remotely so we would be able to automatize our dumps? We would like to avoid human input and keep our DB backups on separate backup server.

Regards
Ladislav


#4

Team Cloudways has written a simple tutorial on that remote subject. May be this help in your case.

https://support.cloudways.com/setting-up-remote-mysql-database-connections/


#5

As @gulshankumar has already guided. You may use the feature of remote MySQL DB and keep your database on a different server.

If you face any issues in configuring it, please let me know.

Regards,
Ibad Rehman