[navyashree.r]

Sammy Taylor wrote on Nov 19 2008, 12:45 AM:

Run sqlyogEnterprise

(Create new site)

MySQL host address now is what?? http://www.mysite.com??

(so that's what I used)

Then username and password are easy (same as with phpMyAdmin).

Thanks,

Hi,

Please remove “www” and try with 'mysite.com' in the MySQL host and other details. Please let us know the status.

Regards,

Navya

[navyashree.r]

krypta wrote on Nov 11 2008, 12:28 PM:

4) try to look for the new stored procedure in the query editor

I can't find it in my intellisense even if I refresh the object browser.

Hi,

Both from query editor and advance editor tab this testcase is working fine for me.

Regards,

Navya

[navyashree.r]

Hi,

We have to refresh Object Browser explicitly if we create store procedure from query editor and not from advance editor tab. So, no need to disconnect and reconnect the server to get the result in the object browser.

Please let us know if this works.

Thank You.

Regards,

Navya

[navyashree.r]

Hi,

The error 1045 is MySQL Server error and not SQLyog error.

The most likely problem why you cannot connect directly is described in our SQLyog FAQ:

http://webyog.com/faq/content/23/18/en/err…ion-denied.html

“User is not allowed to connect from the actual host. Note that MySQL by default only allows connection from 'localhost'. To specify from where a user may connect SQL wildcards (% and _) can be used. Simply 'someuser@%' means that user 'someuser' may connect from everywhere”.

To comment on the problem/error message with SSH tunneling I will need more information about the setup. But first check MySQL configuration if there is a skip_networking setting or a bind_address setting.

99% the problem is lack of user privileges (and possibly a skip_networking setting in configuration).

Please start reading this forum post for more info:

http://www.webyog.com/forums//index.php?showtopic=2838

Regards,

Navya

[navyashree.r]

HI,

We have fixed this issue in this special not released build.

To download,

http://www.webyog.com/downloads/betas/not_…SQLyog713n1.exe

Please verify and let us know the details.

Thanks,

Navya

[navyashree.r]

Mostafa Aedera wrote on Nov 6 2008, 08:24 AM:

this is the first time that I log into this forum .

I'm univercity's student ,I have had project to make : MySQL Databases synchronization tool .

this tool must will be work on a network , so please ,I need to Know , where is I can start from .

and I need to know where MySQL Log Files exist.

Hi,

To perform database synchronization in SQLyog. Follow the below steps,

1. Select the connections where the 2 databases are present i.e. whether localhost or remote system.

2. Select source and target databases which should be synced.

3. Then next select whether one way or two way synchronization should be performed for the selected db's.

4. After select ALL tables or specific tables data to be synced.

5. Then run the job.

For more information read SQLyog help document regarding Database Synchronization and also few Data sync FAQ's.

http://webyog.com/faq/category/10/database…ronization.html

And for MySQL log files you need to specify explicitly. That depends on where you have specified the path.

Regards,

Navya

[navyashree.r]

Hmmn… Ok. Then can you please confirm whether is this error message pops for all db's or few.

And as you mentioned can you please give access to that problematic db.

Create a ticket in our support system so that you can attach the dump by using our SQLyog — From DB menu select 'Backup DB as SQL dump' and please zip the sql file.

Sorry we are not able to reproduce at our end.

–Navya

[navyashree.r]

fosterm wrote on Nov 5 2008, 10:43 PM:

Ok no proble, if you want, I can email you details to a problmatic database to see if you can get the tables to open up

Hi,

Please attach a sample dump which is posing problem. So that we can analyse the issue at our end. If you have any confidential db's and requires any privacy then you can use our support ticket system http://webyog.com/support/ttx.cgi to attach dump and further assistance.

Regards,

Navya

[navyashree.r]

fosterm wrote on Nov 5 2008, 10:28 AM:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TABLE' at line

Hi,

Thank you for using SQLyog.

At our end the issue is not reproducible. So, can you please brief out the exact testcase and also the sql dumps which is posing the problem? And also which SQL yog community version using?

Regards,

Navya

[navyashree.r]

Hi,

To synchronize 2 databases which are in two different machines. You can do it in by 2 ways.

1. If data to be synced then Database Synchronization is used where the 2 db's which are located in different machines details should be specified in the connection manager. Then specify source and target databases and sync.

2. If structure should be synced then use Schema Synchronization selecting source and target db's. Then click compare. For these you should connect to 2 machines using connection manager.

For more information read Help document.

In community edition these 2 features are not available which are enterprise features.

Regards,

Navya

[navyashree.r]

We have fixed this in 7.12 just released. Thank You.

Regards,

Navya

[navyashree.r]

Hi,

Thank You for your suggestion. Added in our list.

http://code.google.com/p/sqlyog/issues/detail?id=903

Regards,

Navya

[navyashree.r]

Hi,

Issue has been added in our tracker. Thank you for interest.

http://code.google.com/p/sqlyog/issues/detail?id=888

Regards,

Navya

[navyashree.r]

Hi,

Issue confirmed. Added in our list. Thank you.

http://code.google.com/p/sqlyog/issues/detail?id=884

Regards,

Navya

[navyashree.r]

Hi,

Thank you for your testcase. We reproduced at our end. It was an issue with 'FROM' clause; alias was not displaying when we type 'from in full caps'. Added in our issue tracker.

We will include this fix into our next release. If you require we will provide you a special build. To avail this special build please create ticket and let us know the status.

Regards,

Navya

[Author]

Posts