[peterlaursen]

two comments ..

1) a MySQL server 5.0 can be everything from 5.0.1 and onwards.

Get the exact version by issuing “select version();'

latest COMMUNITY (free) release is 5.0.27.  If it not at least 5.0.24a I would start upgrading (very simple on windows)

2) “Yes it is around line 26 every time. ”  I would like to see that line 26 .. or rather the first 50-100 lines!

>> Do you have an editor that can handle such big files?

3) BTW: is it a 'mysqldump-dump' or a 'SQLyog-dump' (or a 'phpmyadmin-dump' or something else) ?

4) What happens with the mySQL command line client?  It is in start-menu .. all programs .. mysql .. mysql server version

a: Start it!  It prompts for the root@localhost password.

b: you must issue the staaament “use your_database” if there is no “use …. ” statement in the file.  Also create a database for the import if there is no 'create database' statement

c: now import your file with “source the_path_to_the_file;” (avoid spaces in the path)

>> Does it import or does server go on vacation again …

[peterlaursen]

Please tell:

The MySQL server version (Is it recent?)? How did you install and configure it? Using the installers for Windows from mysql.com?

Operating system?  No 'virtual environment' involved?

How do you connect (on your local I would expect 'direct conenction' but please confirm that there is no HTTP involved!)

80 MB is not a horrible big database.  And size should not matter.

With some server versions there can be issues with the data themselves.  

For instance most servers will crash when configured to use UCS2 as default and client that has not tries to connect ….

There is no timeout in SQLyog and MySQL will not start counting down for timeout as long as there is activity on the connection.  

I think we should start clarifying:

1: Has the server CRASHED when you get that 'Gone Away' error message?

2: When does this error message occur? At exactly the same point every time? (You can see how much data imported before connection was lost!)?

[peterlaursen]

It is now fixed in the development tree.

We plan to release 5.23 beta1 by beginning/mid next week with the fix for this.

Actually we did delete the old clipboard content from memory, but doing this and allocating the buffer for the new content was done in the wrong order.

[peterlaursen]

status: we have now actually been able to 'copy to clipboard' successfully and then doing the same thing once more raises an issue with available memory.

I still am not sure that we can do anything about it. But let us research a little more!

[peterlaursen]

Fixed now!

We have replaced the installer for the 5.22 COMMUNITY version on the same download location.

Also file name is the same, but it identifies itself as “5.22a” and not “5.22” from the installation screen and from “about”.

Just download from http://webyog.com/en/downloads.php

This looks like a compiler issue! We still do not fully understand what creates this issue with the “5.22 COMMUNITY” code compared to “ENTERPRISE” ..

[peterlaursen]

OK .. we can reproduce now with 5.21 and 5.22.  

Only COMMUNITY version is affected, ENTERPRISE is not.

we will fix with high priority.

[peterlaursen]

BTW: The menu items have changed between 5.21 and 5.22.  But we will look at the code anyway.

Just to be perfectly sure: is it our binary you are using or did you compile yourself?

[peterlaursen]

Thanks for the report.  We will study this.  And your hints too, of course.

First test here does not let us reproduce this.

Is this happening EXACTLY the same way EVERY time you click the table menu or only sometimes?

Does the same thing or similar things happen when using the table context menu?

Did you try a 'fresh install' (just install to an empty folder)?

Could you list the files in the current installation folder?

[peterlaursen]

Right now we are preparing for the release of 5.22 Final with the fix.

After 1/2 hours more of testing we will start uploading, announcing etc …

[peterlaursen]

Do you have problems with the Interface of this Forum .. ??

quoting two previous post does not add any new content to the discussion, I think!

[peterlaursen]

I really do not know what VFP is.  Could you explain, please?

“I would like to create a csv file with the field_name, field_type, field_length and then have sqlyog create the schema.”  The problem, please??  I do not see any!

“If there are other, similar, methods of accomplishing … ” Well then I think you must explain WHY you need this CSV file.  Maybe ODBC import/migration, DATA SYNC are better options.  But I cannot tell as long as I do not understand the 'project' …

[peterlaursen]

Verified as describe with 5.21 and 5.22 RC4 (integer columns only).

I do not know aboaut the old discussion, but this will be fixed in 5.22 FINAL of course.

[peterlaursen]

You are mismatching what the MySQL Server does and what SQLyog does, I think!  SQLyog does not interfere in where MySQL stores itis data.

To change the location of MySQL data storage you will need to specify the datadir in the MySQL configuration file (my.ini) and restart the server.

in the [mysqld] section of my.ini just insert:

datadir: X:/the/place/i/want/my/data/to/be

(or use the fre program 'MySQL Administrator' to from http://dev.mysql.com to change the configuration.  MA is part of the 'MySQL GUI Tools' package.

BTW: Installing SQLyog into the MySQL program folder is not a pretty good idea.  i am not sure what will happen wonce you u[grade mysql.  Like any program SQLyog would normally be installed in /program files/it's own folder

[peterlaursen]

like

Code:

WHERE `thedate` >= '2006-01-05' and `thedate` < '2006-01-10'

??

[peterlaursen]

Please answer: how many ROWS are there in the table?

(“SELECT count(*) from …”)

[Author]

Posts