[Marcwolf]

This is the database.

Please look at Sales_Order_Srch

You will see that it is referenced both as a table and a vierw.. It is infact only a view!!!!

When importing I get the “Server has Gone Away” error.

I am using a standard http (or tcpip) connection. This occurs when the DB is either on localhost or remote.

Take Care

Dave

p.s. MySQL Version 5.0.45

Mahesh wrote on Jan 9 2008, 05:00 AM:

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

[Marcwolf]

Ok..

Lets take this a step at a time.

If I open up SQLYog and select a DB. Right click and then select Backup Database as SQL Dump

Select Structure and Data

Select Create DB, Foreign Key, Drop Table, and Bulk Insert optin

Because this is a MySQL5 DB and I want to make sure that I get the Views and SP structures as well I make sure that ALL

5.x Objects are set.

Select ALL Tables.

Export to a SQL file.

Now – I understand that I should beable to then take this SQL file to another machine, or the same machine and run it against an existing database with the Restore from SQL Dump.

The end result will (or should) be that the DB will be loaded with the new structure as well as the data.

This is not happening. I am getting an error becase the SQL Dump is treating a VIEW like a TABLE and exporting the VIEW ike a TABLE i.e. with INSERT statements.

Regardless of whether I should be using the Migration Tool, The Structure Syncronisation tool, or the Data Syncronisation tool… The act of DUMP and the RESTORING a Database should result in a CLEAN Import..

With this issue it now means that many of our MySQL5 backups are invalid and this causes us great concern for ourselves and our customers.

Dave

[Marcwolf]

I have the same issue.

I have now spent about 8 hours TRYING to backup a database from one locations and to import it into another location.

The speed that SQLYog can do the migrate takes too long.. Far faster to dump the DB, zip the SQL file, and then reimport at other end.

However I found that VIEWS are being exported as DATA!!!.. Not a Stored SQL Statement that gathers information and displays it.

Wonderful Bug.. I would have believed that even a first year DBA would have understood the nature of a view compared to a table.

If there a Fix for this Yet!!! (Using SQLYog Ent 6.14)

Most Annoyed!~!!

Dave (Developer who works on an hourly pay rate and cannot charge customer for this!!!!)

[Marcwolf]

peterlaursen wrote on May 30 2007, 09:07 AM:

This is an issue with MySQL and not SQLyog.

There are dozens or hundreds of complaints in MySQL Forums and bugs.mysql.com that the MySQL server 'garbles' the formatting of VIEWs.  We can only display what we retrieve from MySQL!

Ok.. I can understand that.

However – as SQLog can highlight key words etc – maybe a small feature called Formatter that can grab a very long SQL statement and do a simple formatting of it. Nothing fancy just say break at comma's and before keywords.

Anything would be better than a 600 character 1 liner.

Take Care

Dave

[Marcwolf]

Re the screen shots – I will try.. Its a little tricky as I am working on the desktop and that SQLyog is not really 'broken', its just has not rememebred to refresh its screen.

Re the multi threadedness – yes – that could be a big factor as it is often when I have something running on SQLYog that I will minimize it so I can do other development.

I'll try and keep you posted on this one.

Dave

[Marcwolf]

Thanks for that.

For example – last night I took a dump of our clients data so I could runs some tests on a new enhancement.

This is standard practice when checking developmetn issues and preparing to create an update script.

119000 (They there ARE that many 0's) queries later and about 3 hours of waiting.. the script completed its running

I have a pretty fast P4 development machine and a local copy of MySQL so its going as fast as it can.

The SQL script is generally in the 23 megs size too.

Take Care

Dave

[Marcwolf]

Ok.. This is useful information… However.

What happens when a query reaches this 8meg limit

Would it be possible for SQLYog to monitor a query size and ten put a break in it at a pre-determined size?

Many thanks for your reply thou.

Dave

[Marcwolf]

I have been using SQLYog for nearly a year now.

I must say this it is one of the most useful tools on my desktop for changing, manipulating, and maintaining our clients databases.

We use the Structure Syncronisation tool a lot when updating changes, and that it can create an SQL script for us to send out for our remote clients so they can update their local systems.

And we also ask our clients to purchase a copy so that they can use the SQL job system too.

The ability to extract and entire database and then load it locally is also very useful.

Having tries several other tools when I first started to use MySQL this is the only one that does most of what I need.

Great Product…

Dave

[Author]

Posts