BACKUP via SJA fails

[royvarley]

Trying to use SJA to backup my remote database (http tunnel). I use the query BACKUP TABLE {list of tables} TO {directory}; The query was parsed ok.

The job starts – and then stops. Window disappears No error message. No log information (other than the fact that the job was started). Let's face it folks, error messages and logging information from SJA is awful – essentially non-existent! You really need to fix this side of things – it spoils a good product.

Is a BACKUP query supported in SJA? If it is, any suggestions as to where to look for problems? All table names are spelled out correctly. The destination directory exists, doesn't contain any spaces in the name, is short, is empty. I've tried both flavours of slashes, / and just in case.

[ Hmmm… it could be my website settings…. the .frm files won't copy…]]

[peterlaursen]

You are using SJA – is that the Linux version or the version “built in” sqlyog (for windows) ??

SJA is a SYNCRONIZATION TOOL, that means you syncronize data from one running Mysql server to another. That means that you must have the two running mysql servers accessible (local or remote). Thats what SJA is for, and NOTHING ELSE !!!

You can run the backup command from the sql-pane in sqlyog or from any command-line tool.

Or from the GUI in sqlyog. Provided that you run windows.

However the BACKUP command is in my opinion not very usual as EXPORTING to a sql-file.

(how would you actually use the .frm and .MYD -files ? )

Quote:

[ Hmmm… it could be my website settings…. the .frm files won't copy…]]

No, its probaly locked by the system because its in use!! Mysql is not Access and you can't just copy files like that …

[royvarley]

Quote:

Thats what SJA is for, and NOTHING ELSE !!!

Well… not quite. Under windows, SJA.exe runs for all job types including synchronization. So you can run just about any sort of query as well as data and structure synchronisation. The xml defines the type of job.

That said, I'm thinking of using the export functionality – but now I hit a limitation of sja – as far as I can tell, it doesn't handle running mysqldump to create the .sql files. Unless, of course, it does… Ritesh?

[Ritesh]

Quote:

SJA.exe runs for all job types including synchronization. So you can run just about any sort of query as well as data and structure synchronisation. The xml defines the type of job.

Currently, SJA only supports Data Synchronization and Notification Services. Notification services allows you to execute any query(s) and send the result over mail.

Quote:

as far as I can tell, it doesn't handle running mysqldump to create the .sql files.

Nope it dose not.

In v4.1, SJA will support dumping of data in .sql files like mysqldump.

Quote:

I use the query BACKUP TABLE {list of tables} TO {directory}; The query was parsed ok.

SJA logs all the errors in sja.log found in the installation directory of SJA. What does sja.log say?

[royvarley]

Quote:

QUOTE  

SJA.exe runs for all job types including synchronization. So you can run just about any sort of query as well as data and structure synchronisation. The xml defines the type of job.

Currently, SJA only supports Data Synchronization and Notification Services. Notification services allows you to execute any query(s) and send the result over mail.

Yep – glad I got that right. But just to clarify for everyone – Notification services type jobs can run a query without having to send any form of notification. I'm currently using this for some nightly maintenance tasks.

Quote:

QUOTE  

as far as I can tell, it doesn't handle running mysqldump to create the .sql files.

Nope it dose not.

In v4.1, SJA will support dumping of data in .sql files like mysqldump.

Great! Any ideas when 4.1 SJA for windows will be available?

Quote:

QUOTE  

I use the query BACKUP TABLE {list of tables} TO {directory}; The query was parsed ok.

SJA logs all the errors in sja.log found in the installation directory of SJA. What does sja.log say?

It just says: “Job started at Sun Feb 06 15:31:59 2005”. No error messages at all. Hence my remarks about the level of both error reporting and simple logging of job details.

Thanks for that Ritesh. Guess I'll just hang on till SJA 4.1

[royvarley]

oops – I just realised that I'd said SJA does structure synch – and you said it doesn't – got it! Not till 4.2. OK – I'm with it now. 😀

[Author]

Posts