[peterlaursen]

I forgot this:

From the “alter table” pane in sqlyog you can choose “advanced properties” you can set the “max. rows” and “average row length” parameter for the table – after creating it.

[peterlaursen]

You will have to study this yourself:

http://dev.mysql.com/doc/mysql/en/table-size.html

It could be either an OS/file system related topic or a Mysql related topic.

How big is table “attachments” ?

[peterlaursen]

simply “show variables” will show a lot af parametres for the server – among these max_allowed_packet setting .

More options for the “show” command:

http://dev.mysql.com/doc/mysql/en/show.html

[peterlaursen]

exactly …

the files you mention are “templates” for the my.cnf file.

But I have no experience with running Mysql under Linux, so I don't know have to make the server read it at satrt.

However “mySQL Administrator” is available for linux from mysql.com.

With this tool you can point to the my.cnf -file to be used. So I think that will do …

[peterlaursen]

try editing your my.cnf -file. Remember to stop and restart the MySQL-server for the change to take effect.

[peterlaursen]

Moving how ?? Do you use “copy DB to another host” or “syncronization” or just export/import sql ?? Does the connection involve some kind of tunnelling ?

What are the mysql server versions ?? Certain variable types (such as date/time , timestamp) are incompatible across older and more recent mysql versions. The error message could imply something like that.

Are the server configuration(s) under your control or not ?

Please explain about the data structure and possibly supply “create table” statements for the DB('s), and even some sample data. If you don't want to throw it here in public, you could wait for Ritesh to send him this information confidentially.

And you have no problems with small DB's ??

Do you know about a tool that works ?

[peterlaursen]

And don't forget the 48 bits ( 16 bits/ channel ) versions of .tif and .png.

[peterlaursen]

nad when that is fixed, then please add .png too!

[peterlaursen]

Are UserID and password correct ?

And dows that user have the privilege to access that database ?

Can you connect with php-based tools (i.e. phpmyadmin)

If all that seems to be OK, then answer please this:

Where is it at ? (ISP/webhotel or a server totally under your own control)

MySQL , php and sqlyog version ? (I suppose that php is up and running correctly on the host ?)

[peterlaursen]

compare the word “yoga” , that you probably know!

[peterlaursen]

Admittedly .. I'm too slow 🙁

[peterlaursen]

read this

http://www.webyog.com/forums/index.php?act…ct=ST&f=2&t=472

As of now the GUI is only available in english.

BTW Ritesh: how is progress with yogmax ?

[peterlaursen]

I won't answer the question – have no experience with MSSQL

but are you aware of the Migration toolkit from MySQL ?

http://dev.mysql.com/downloads/migration-t…oolkit/1.0.html

[peterlaursen]

Read those old threads

http://www.webyog.com/forums/index.php?act…ct=ST&f=6&t=664

http://www.webyog.com/forums/index.php?act…ct=ST&f=6&t=720

Why do you stick at sqlyog 3.64 ?

As far as I remember you will need sqlyog 3.71 or higher to use it with Mysql 4.1.x and 5.0.x

[peterlaursen]

Ritesh asked you a question !!

You will have to try different clients (Command line tool, MySQL Administrator, MySQL Query Browser … ).

We will have to know if it is ONLY a problem with sqlyog or if it's related to the combination of software versions.

I can't imagine that sqlyog would behave different than for instance MySQL Administrator.

It could very well be a problem related the combination og php-version and client library.

[Author]

Posts