search

SeunMatt / mysql-backup4j

mysql-backup4j is a library for programmatically exporting mysql databases and sending the zipped dump to email, Amazon S3, Google Drive or any other cloud storage of choice
MIT License
124 stars 71 forks source link

Support of Remote Host #6

Closed mossaab0 closed 5 years ago

mossaab0 commented 5 years ago

It appears that this works only when the DB is in loclahost.

SeunMatt commented 5 years ago

Hello, @mossaab0 kindly provide more information regarding this. Provide code snippet as well. What did you do or try? Did you get any errors? If yes please state them here. Also, do you know you can set the connection string with a property?

properties.setProperty(MysqlExportService.JDBC_CONNECTION_STRING, "jdbc:mysql://localhost:3306/mnetsms_db?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC&useSSL=false");

If you're using a remote connection string, then ensure the remote host is allowing connections remotely. Mysql doesn't by default. So you might want to look into that area.

I'm going to close this now, but if you have further concerns with more info. Please, feel free to re-open

Cheers.