Sync, Tunneling, Ssh

[Robert]

Hi all,

just bought the enterprise and have some problems:

1. Internetserver: Mysql 4.xx; about 220 tables in one db

2. Local Mysql 5.xx

First step: Sync between tow databases from web to home using http-tunnel;

stops after 15 tables.

then tried to use ssh; error: lost connection during query

Second step: Changed a value on net-db; tried to sync the two dbs;

error: NULL definition mismatch for 'ID' column in '`Links`' table

Dont know what this means. I have both tables with the same structure;

maybe it only syncs new datasets, but not changed datasets?

[Ritesh]

Quote:

First step: Sync between tow databases from web to home using http-tunnel;stops after 15 tables.

Can you explain this problem a little more? What do you mean by *stops after 15 tables*?

What happens if you sync that table individually?

Quote:

error: NULL definition mismatch for 'ID' column in '`Links`' table

Can you post the CREATE TABLE statement of the table for both source and target?

[peterlaursen]

MySQL 4.x and 5.x should not sync at all!

But it should display an error not attempt to!

http://www.webyog.com/faq/10_68_en.html

@ritesh: check your Eventum! There is such issue pending!

[Robert]

Ok. Read about the possible errors. So how can i change reconnect to 1?

[Robert]

Ok. While we change servers soon, i install mysql 4.xx now on the windows client; maybe this is the problem im looking for.

Just another question. Has someone an idea how i can program a tool under windows to manipulate my data in the mysql db easily?

I could do everything online with php, but i want to know if i can do it with the client, too. So im looking now for the stuff microsoft offers, but have no clue if i should take VB, C++ or C# to start? (I still use only php and perl, but im learning fast. 😉

[Ritesh]

You can always use SQLyog 😛

If you are looking for MS based programming language to manipulate data from your code then you will require the ODBC driver for MySQL i.e. MyODBC. Good links at:

http://www.vbmysql.com/ and

http://dev.mysql.com/downloads/connector/odbc/3.51.html

[Robert]

Ok. With mysql 4.xx on client i can sync now. 😉

BTW: How the sync does its job? Looking for every dataset? I have only about 5000 datasets, but it takes minutes to sync, maybe this can be imporved with a timestamp? Oh, maybe with a select … where timestamp > x;

Yes, ODBC is needed, i tried it once with MS Access. But i need some things like open a pic, choose a part of it, upload, change values in db and this kind of stuff, think with access i cant do this and hope this .net-stuff has the right libs for this.

[peterlaursen]

read this:

http://webyog.com/articles/Using_SQLyog_En…L_Databases.pdf

It gives you quite a lot of insight into how it does!

Read about:

1) Timestamp. The sync tool does not use it. Why is explained in the article. And actually we have a pending issue with PK's using a timestamp: http://www.webyog.com/forums/index.php?showtopic=1924

2) How to use the COLUMNS and SQL_WHERE options to effectivize the sync!

Also read this FAQ: http://www.webyog.com/faq/10_61_en.html

[peterlaursen]

and

Quote:

how i can program a tool under windows to manipulate my data in the mysql db easily?

What language would you prefer to use?

VB for instance uses ODBC to connect. With other languages JDBC may be preferable. For Delphi, C and C++ there a other type of connectors.

But to 'manipulate .. easily' .. hmm. From the little experience that I have (with Powerbuilder /AS-400 ten years ago and more recently PHP and MySQL I would say that coding database manipulations is never 'easy'. The methods for fetching data available with programming languages seem pretty primitive compared to GUI tools like SQLyog. Most often you will need to fetch a row at a time, fill an array with that row and the do ordinary coding with data in that array. And all that in some kind of iterative statement with forms/GUI element control too.

Much depends on how experienced you are as a programmer!

[Robert]

Im not afraid of getting, manipulating and saving data at all; but i have “respect” for learning this windows-stuff i never used before. Just at this moment i download vb and give it a try. I read some things about c++ and c# but nothing that could give me a final decission what is better for my goals. I will see …

The data-stuff would be possible with MS Access, too. It is the theme about using, cropping, editing and upload pics i see the hardest work. But maybe the libs are as good as i hope. (Just remeber the times with delphi ten years ago, when you have to do verything from new, every window, every input …

You remember you frist program?

10 Print “Hallo”

20 Goto 10

Smile

[Robert]

BTW: Fast answers, good job! Thank you.

[Ritesh]

Robert wrote on Feb 9 2006, 03:13 PM:

BTW: Fast answers, good job! Thank you.

[post=”8705″]<{POST_SNAPBACK}>[/post]

Thanks 😀

Quote:

stops after 15 tables.

This one still amazes me. Under no circumstances SJA should just hang. I will ask my engineers to test this on the same environment as yours.

[Author]

Posts