[Mahesh]

HI,

6.16 Beta1 has been released with the fix,

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

[Mahesh]

HI,

6.16 Beta1 has been released with the fix,

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

[Mahesh]

HI,

We have fixed the issue,Please verify the fix with this 6.16(Not released) build .

To download,

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

[Mahesh]

HI,

We have fixed the issue,Please verify the fix with this 6.16(Not released) build .

To download,

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

[Mahesh]

HI,

We plan to add automatic detection of those encodings where it is possible – with this build 6.16(not released) you will have to select manually.

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

[Mahesh]

HI,

More information on Error 2003 can be found at:

http://www.webyog.com/faq/content/23/15/en…t-connect-.html

[Mahesh]

I think we will have to start finding out if this really is a difference between 6.07 and 6.15 or if something else happened on the server!

Could you please try 6.07 again?

Download link is given below:

http://www.webyog.com/downloads/oldies/sja607.tar.gz

[Mahesh]

HI,

We need a help from your side to reproduce the situation,

Please attach ,

1. Structure only dump that causes the crash also,

2. Sja dump.

@Exporting routines separately, this feature is implemented in our development tree and 6.2 Beta1 will have this feature.

Thanks

[Mahesh]

Nadav wrote on Jan 10 2008, 01:35 AM:

I used mysqldump with –all-databases option but it backedup only the first database because it had a view:

DROP VIEW IF EXISTS `demo`.`v_as_bl`;

CREATE OR REPLACE ALGORITHM=UNDEFINED DEFINER=`qa`@`%` SQL SECURITY DEFINER VIEW `v_as_bl` AS select `….

The problem is that there is no qa user in this server.

Why the backup is depended on the content of the view ?

I use the root user to backup the DB and I'm the admin of the server.

Any ideas ?

Thanks Nadav

HI,

@ Backup all databases option but it backup only first because it had a view

Ans: Currently we are allowing to backup the contents of only a single database .

@ View Statement problem,

Please execute the statement,

show create table `DB_name`.`view_name`;

what does this shows ?

Backup Dump contains the same SQL statements that are used to create a view etc…

BTW: Which program version you are using

[Mahesh]

HI,

We dont have any similar issue reported earlier ,

This is strange behaviour ! And we are not able to reproduce the situation either,

Can you please give the information listed below ,

1. Attach Exported Dump

2. What Error message it shows while import ? and

3. What type of connection you used (http or ssh) ?

Thanks

[Mahesh]

HI,

This may happen because the dump may have a single insert statement excceds the max_allowed_packet setting in server configuration!

Please do this,

1)

in SQLyog “tools .. preferences ('general' tab)” you can choose to use BULK inserts or not and you can define the BULK size. BULK INSERTS means that more than one row of data are included with every INSERT statement.

A FAQ here:

http://webyog.com/faq/content/24/101/en/ab…-and-bulks.html

2)

In the MySQL configuration file (my.cnf/my,ini) you enter a line in the [mysqld] section reading like

max_allowed_packet=100M

(or whatever size you want. Default is as low as 1M with recent MySQL versions. A BLOB can be up to 64M in size).

[Mahesh]

HI,

Your recquest has been added here,

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

[Mahesh]

HI,

This issue has been fixed in our development tree and 6.2 will have the fix , the first Beta(6.2) will be release in 10-12 days.

Thanks

[Mahesh]

Issue Confirmed !

Next version will have the fix.

Thanks for reporting.

[Mahesh]

HI,

We need a help from your side to reproduce the situation, please provide:

1. Structure only dump and

2. server version.

Thanks

[Author]

Posts