Data Synchronization with mysql

[sjors]

Hello all,

Can someone help me with Data Synchronization with mysql ?
The thing is, I live real remote and have e extreme slowwwwwwwwww connection at home.
For the website directadmin and specially xoops the connection is to slow to maintain the website.

For that we have to drive 40 min to town with the laptop.

So I setup my webserver on the laptop.

The idea is maintain the website at home on the laptop (local) go to town, make a connection and use (for example) navicat for Data Synchronization ( and the picture folder).
The problem is if I make a connection I get no access as I don’t login as user@localhost but as [email protected]
If someone can help me, please do, the alternative would be backup and restore but that’s not easy with phpadmin.

Thanks for helping me out

Greetings Sjors

 

[SeLLeRoNe]

for enable remote connection on the database you can go in mysql management section into da panel, and, on the db u need to, enable or the host "xxx.xxx.xxx.xxx" or "%" that is ANY HOST.

Open the 3306 port on the firewall and you will be able to connect [email protected] to that database.

A nice program for make dumps should be MySQL Maestro but ofc you have to open the mysql access for your host to that db before do a dump from a remote machine.

regards

 

[sjors]

Hello SeLLeRoNe,

THANKS, simple but works 100 % thanks you where a GREAT help

Greetings Sjors

 

[sde]

if you have ssh setup to the box, you can configure your navicat connection to tunnel through ssh. this way you don't have to mess with your mysql permissions.