Need Sqldump Options Same As Sqlypog Uses

[peterlaursen]

I will move your post. This is not MONyog-related.

[peterlaursen]

Quote:

I guess sqlyog is calling a mysqldump on the server

No it doesn't!  Even if we wanted to we cannot do this.  A 'pure' MySQL client  cannot access file system and execute commands on remote servers. That would require a SSH-shell or similar inside the program and there is no such. SQLyog is compiled with the MySQL client C-API (you may know it as 'libmysql') and that one is all what is used for connection. We can only execute SQL (and similar API-calls).  The backup file is aggregated on the client machine from the returns of SELECT statements and the settings specified by user.

[duff]

Hi

Many thanks for your reply , that explains why were are getting differences in the backups

I will go back to investigating all the options for mysqldump

If i cannot get it to work i shall write my own backup script using select statements

may be useful as i can build in stats to validate against restorations tests

Really like Sqlyog its a joy to use

Cheers

[Author]

Posts