Errcode: 2

[scastellar]

First of all, excuse my poor english

I have the following problem. I have syncronized two databases between two Windows XP without any problem. I have tried to do the same thing between a Windows XP (source) and a Windows 2003 server (target). The first time I Sync (database did exist in windows 2003 but it had no tables) it works correctly, creates the tables and fill them. After that any sync atemp is unsuccesful. I get this output for each table

Can't create/write to file 'C:AppServMySQLdatatemp_dir#sql_774_0.MYI' (Errcode: 2) – Could not get FIELD information for '`table_name`' in the TARGET database

There is no difference if I run SQLyog on Windows XP (source) or in Windows 2003 server (target). I'm using 'root' user on both computers

Windows XP is inside a Domain while Windows 2003 is not, is that a problem?

[peterlaursen]

Please tell the SQLyog version you are using and the versions of all MySQL servers involved. Also tell the file path to the MySQL /datadir on the 2003 server.

Domain or not should be no problem.  I recall that error message “Could not get FIELD information for '`table_name'” from another report  .. but we will have to search for it

[scastellar]

'peterlaursen' wrote on '30:

Please tell the SQLyog version you are using and the versions of all MySQL servers involved. Also tell the file path to the MySQL /datadir on the 2003 server.

Domain or not should be no problem.  I recall that error message “Could not get FIELD information for '`table_name'” from another report  .. but we will have to search for it

Thanks, but I have solved the problem by myself 😛

It wasn't a SQLyog problem, it was just the w2003. I've used another w2003 computer and it works now. Anyway, I'm giving you the info because maybe it will be useful for you in the future.

I'm using SQLyog 8.05, mysql community server 5.0.45 on both computers. The path to MySQL /datadir on the 2003 server was “C:/appserv/MySQL/data”

We were just trying SQLyog, but the trial version has solved a big problem we had, so we are definetly buying it (maybe today maybe tomorrow). Great aplication indeed

If you make something similar working on postgree, yo will become our Heros 😛

Thanks for your quick answer

[Author]

Posts