Views not working ?

Compares and synchronizes MySQL database schemas.

Moderators: Chris Auckland, eddie davis, Michael Christofides

Views not working ?

Postby michabb » Tue Aug 24, 2010 4:24 pm

hi, i tried the software and its great, but it seems like views are not created in the compare-script:

CREATE VIEW `us_shop`.`vw_currency` AS ;

that´s all what i see, no details.. is that normal ??

thank you,
micha
michabb
 
Posts: 3
Joined: Tue Aug 24, 2010 4:16 pm

Postby michabb » Wed Aug 25, 2010 12:44 am

might it be possible that this depends on wrong user rights ? maybe the user is not able to read the content of the view.. ..
michabb
 
Posts: 3
Joined: Tue Aug 24, 2010 4:16 pm

Postby coastguard » Wed Mar 28, 2012 3:31 pm

Had the same problem. In my case, it was caused by insufficient user rights. A different user account than the one I used in mysql compare was hardcoded in the view.
coastguard
 
Posts: 2
Joined: Tue Jan 31, 2012 8:49 am


Return to MySQL Compare

Who is online

Users browsing this forum: No registered users and 0 guests