[smine]

sorry, i think there is no dump. the only dump file i see is “SQLyog_Dump_000.dmp 0KB 4/15/2010 6:52 AM” which i believe is when i restarted SQLyog on Friday morning (it was a regular restart, not caused by the crash i reported).

i might be able to recreate the problem, i will try.

[smine]

'peterlaursen' wrote on '07:

Unfortunately universe is still a mystery. … I think I will have to conclude that this is a problem with your hosting and their configuration (they may have patched the server).

perhaps i can bribe our administrator to help understand this problem. the universe is a big place, there must be an answer out there somewhere!

thanks you for all your help. i will report back when i have new information.

[smine]

'peterlaursen' wrote on '01:

If upgrading the server is out of question then at least try change tx_level to READ-COMMITTED (ie

Code:

SET @@global.tx_isolation = 'READ-COMMITTED'

i receive:

Query : SET @@global.tx_isolation = 'READ-COMMITTED'

Error Code : 1227

Access denied; you need the SUPER privilege for this operation

i guess the universe does not want me to run the sync tool

[smine]

'peterlaursen' wrote on '01:

Are you using HTTP-tunnel?

we are not using HTTP tunneling.

[smine]

'peterlaursen' wrote on '02:

One more question: Do you have a Primary Key defined on the table?

yes, both source and target have the same Primary Key, which consists of 3 columns.

[smine]

'peterlaursen' wrote on '01:

…So what is your transaction isolation levels? Check

SHOW VARIABLES LIKE 'tx_isolation'

tx_isolation='REPEATABLE-READ'

i will try READ-COMMITTED

[smine]

'nithin' wrote on '30:

Also please tell are those Innodb tables?

Also execute these queries at source db and target db and tell if any error:

SELECT * FROM FOR UPDATE;

SELECT * FROM LOCK IN SHARE MODE;

Regards

Nithin

all databases are MyISAM.

for the first query i get the following for both source and target

Query : SELECT * FROM mytable FOR UPDATE

Error Code : 1036

Table 'mytable' is read only

for the second query, both source and target complete successfully with no errors or warnings.

[smine]

'nithin' wrote on '30:

1) We do not understand “target: not in the list of tables of SHOW GRANTS results”. Please detail this.

2) Could you try to add global SUPER privilege to user? Just to check if server 5.0.45 is affected by same bug as the one we linked to above.

1) the only SHOW GRANTS command i can get to work is just “SHOW GRANTS” (without the “FOR [email=””]'user'@'host'[/email]). when i execute that command, the database i am calling the target is not in the list of results

2) it will not be possible to change any permissions on these databases, not even for testing. i do not have access to them and system administrator will not allow any changes

[smine]

1) Win XP Pro v2002 SP3

2) source and target are same machine: MySQL v5.0.45; OS: redhat-linux-gnu (Sleepycat Software: Berkeley DB 4.1.24: (July 4, 2007))

3) source: GRANT SELECT, EXECUTE; target: not in the list of tables of SHOW GRANTS results

4) read_only='OFF'

[smine]

okay, i am using Database Synchronization Wizard. i ask it to only generate a script and not modify any data (One-way sync with “Don't delete extra rows…” checked). i receive the error message in sja.log

Code:

Data Sync script generation started at Fri Mar 26 09:21:06 2010
`ric_lookup` 124011 124011 Error No. 1036 Table 'ric_lookup' is read only
`security_lookup` 276216 276216 Error No. 1036 Table 'security_lookup' is read only

if i am only generating a script, why does it care about read-only? because of the error, i do not see the number of Inserts, Updates, Deletes in the Database Sync window.

[smine]

yes, sorry, i am stupid. i was using Schema Sync. i am using Database Sync now. thanks!

[smine]

'navyashree.r' wrote on '24:

Sure Smine,

You can use “Schema Synchronization tool” from Powertools menu or simply click Ctrl+Q.

hi. thanks! i tried Schema Synchronization Tool, but it was not quite what i need. i need to compare the tables including data. Schema Synch appears to compare only the structure of the tables.

can SQLyog perform data comparison, too? if not, do you know of some other tool to do that?

[smine]

'Khushboo' wrote on '23:

The error occurs because there is difference between the fields of table created by 1st .CSV file and the fields which are present 2nd .CSV file.

i am baffled. when i try to import the CSV files then i get the error described in item 3 above (and the table name i specified to import into is ignored and a table name based on the input filename is generated). but if i simply rename the files then the import succeeds! here are the actual filenames

FAIL

Discrepancy_Counts_By_Status_20091109.csv

Discrepancy_Counts_By_Status_20091110.csv

SUCCEED

Discrepancy_Counts_By_Status_20091109.csv

xDiscrepancy_Counts_By_Status_20091110.csv

SUCCEED

xDiscrepancy_Counts_By_Status_20091109.csv

Discrepancy_Counts_By_Status_20091110.csv

SUCCEED

Discrepancy_Counts_By_Status_20091109.csv

Discrepancy_Counts_By_Status_20091110x.csv

SUCCEED

Discrepancy_Counts_By_Status_20091109x.csv

Discrepancy_Counts_By_Status_20091110.csv

i do not modify the file in any way, i simply rename it. how is this possible?!?

[smine]

i don't know if this is a different problem, but before i call it a bug i will check with you. when i Import External Data and go to ODBC Text Setup > Options > Define Format, when i click Ok i get a popup Error. maybe i don't know how to use this dialog box?

[smine]

thanks. i am using 8.22 and 8.3 beta 1. i found the settings you describe (in Select tables > Advanced > DDL/DML Options). but i still have problems.

• i cannot find “don't overwrite” option[*]when i click “Select All” to select all tables, the Destination is automatically filled with a table name based on the CSV filename. i change it for one table then click “Apply changes to all tables” but the Destination does not change. do i have to manually change every Destination table name?[*]if i do set the Destination of each file, the import appears to work for the first table, but other tables fail with these errors (slightly edited)

DBMS Information: TEXT
Importing table schema: Discrepancies… Successful…

Importing table schema: Discrepancies… Successful…

Importing table foreign keys: Discrepancies… Successful…

Importing table foreign keys: Discrepancies… Successful…

Importing table data: Discrepancies…

993 rows transferred!

Successful…

Importing table data: Discrepancies…

ERROR: 1054, Unknown column 'F1' in 'field list'

Table:Discrepancy_Counts_By_Status_20091110.csv

Sql:REPLACE INTO `qa_test`.`Discrepancies` (`F1` ,`F2` ,`F3` ,`F4` ,`F5` ,`F6` ,`F7` ,`F8` ,`F9`) VALUES ('date', 'RStatus', 'Product', 'Project', 'DevAssign', 'QAAssign', 'Subject', 'Modified', 'Sent'),…

(note that i am not Mapping any fields and i am not using WHERE for any of the tables). i must be missing something. i read the Help file but i guess it didn't help me enough

[Author]

Posts