Running From Remote Linux Server

[Anonymous]

Hello,

I have a dedicated Red Hat Enterprise base server hosted with ServerMatrix. I have two separate hosting accounts (websites) on that server, but I need the two accounts to share MYSQL data.

The database isn't likely to be all that large, and I'm only going to need to share about 10 fields from 1 table that will probably never have more than 10,000 records.

I want the synchronization to occur as a scheduled operation about every 5-10 minutes or so, and I don't want this process to be dependent upon whether my home computer is running.

Can I install SQLyog on my server and set it up to do what I want to do (via Cron Tabs) remotely from my home computer?

[peterlaursen]

To run SQLyog on Linux you will need to install Wine first. I do not think that is normal to have Wine on RHEL, but it you can install it you can install SQLyog too. You can use the SJA for Linux however. It runs natively on Linux.

[Anonymous]

So, using SJA for Linux, I could install on a remote Redhat based server (ie. not MY computer, but my website server) and run scheduled mysql sync tasks via crontab?

[peterlaursen]

yes …

If you have the necesary privileges. With cheap shared hosting it is not always the case. But with your own 'dedicated server' you probably have. You will need SHELL-access of some kind. FTP-access won't do. And you (some OS user that is under your control) must have EXECUTE privilege to the sja – and write access somewhere in the folder tree where SJA can write its session- and log-file.

Actually you will not need to 'install' anything. We only distribute the .tar.gz – no RPM or DEB packages as SJA has no dependencises. Just unpack the achive (.tar.gz) and copy the sja executable to the server. Log on from some remote shell and execute it (“./sja “) or configure crontab to execute this command.

Please read these FAQ's: http://webyog.com/faq/category25.html

and this article: http://webyog.com/en/whitepapers/Using_SQL…L_Databases.pdf

[Author]

Posts