[Keith Davis]

Still have this problem.

[Keith Davis]

Weird, but yea, now both the loading of the SMTP details and the Encryption drop-down are both working.

[Keith Davis]

Also, that version does not load my SMTP details from previous version XML files. I downgraded to 12.2.1 for now.

[Keith Davis]

Yikes, that sucks. If I had known that when I started building these systems, I would have turned it on for all of them. 

[Keith Davis]

So, that was the problem. Still don’t understand my test results though (which is why I didn’t check grants further), but oh well. 🙂

[Keith Davis]

 

 

Are you ‘root’@’localhost’ when backing up? 

 

No. 

 

mysqlbackup@[email protected]

 

 

And does he/you have privileges to underlying tables?

 

I thought so, but now that I look at these again, I believe that the problem is that this user needs execute, right? The problem is, why doesn’t this fail if run by that same user for only that view?

SHOW GRANTS;



GRANT SELECT, LOCK TABLES, SHOW VIEW ON *.* TO 'mysqlbackup'@'app02.pridedallas.com' IDENTIFIED BY PASSWORD 

[Keith Davis]

MySQL 5.6.26

InnoDB

 

I’m not using Backup Databases as SQL Dump, I’m using Scheduled Backups.

 

[attachment=2057:Capture.JPG]

 

 

 

 

[Keith Davis]

Ah, the problem is with IE. I use IE 11 primarily for work. Chrome works fine.

[Keith Davis]

No ideas?

[Keith Davis]

11.4 and it’s a direct connection. Could it be because my host is not restricting access to some of those objects? If so, it would help if the error log indicated such.

[Keith Davis]

Ok, it seems like if I export any of these (even though I have none of these objects in these databases), they cause the error message:

 

 

However, that was never an issue before.

[Keith Davis]

MONyog

FYI, I did not get a notification email and also, return i.e., new line does not work in this editor for IE 10.

[Keith Davis]

'Mahesh' wrote on '02:

Also,

Make sure that you have used proper encryption method in drop-down (No Encryption/TLS/SSL)?

Tried others just in case I was wrong, but No Encryption is selected and that is correct.

[Keith Davis]

'navyashree.r' wrote on '01:

Hi Davis,

We are getting these 3 errors when our SMTP details are incorrect. So, could you please furnish the details below:

1. What SQLyog program version you are using?

2. Also, please confirm whether your password contains any special characters?

Let us know the status.

Regards,

Navya

version 8.2

No special characters [a-z0-9] only

[Keith Davis]

peterlaursen wrote on Aug 12 2009, 02:48 AM:

I understand you want to be able to run Schema Sync unattended/scheduled. Is this correct?

That is correct.

[Author]

Posts