[peterlaursen]

it's very funny but I do with some tables, not others.

and it's very confusing – I can't reproduce things …

[peterlaursen]

With the new version of mysql 5.00a (dated 2004.01.11) and webyog 3.64 RC4 I don't experience the problem anymore!

An sqloyg error message appears telling “couldn't read data for the table” but after clicking “OK” it actually does read and alterations to the table structure can be done!

[peterlaursen]

I can confirm kengaun's observatin … 🙁

Mysql 5 – WinXP Home (danish version)

[peterlaursen]

Just an information for those who read here ….

It seems that SqlYog 3.64 RC1 works fine with the new Mysql ver. 5 alpha too.

[peterlaursen]

As you might have noticed, I upgraded from 4.0.13 to 4.1.1 with no problems.

So it might be a problem with the 4.1.0 -version, that causes your problem?

After all – it is an alpha!

[peterlaursen]

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

– as you se I have no problems !

HOW did you upgrade to MySQL 4.1.1 and from which version ?

When I DL'ed 4.1.1 it came without installer, so I Just stopped the service and WinmySQLAdmin, replaced the folder (of course not the folder “data”) then restarted WinMYSqlAdmin and the service. WinMySqlAdmin tells me that I run server version 4.1.1 so I believe that !

I interpret your error message “Could not read the data for the table” as if the information in the “mysql”DB (or folder if you like) contains wrong or no information about your own user-DB.

If you have a backup try to replace your “data” folder with the one from the backup. (close service and MySQLAdmin while doing this)

[peterlaursen]

Thanks – works fine!

[peterlaursen]

and also important ..

What is the filed delimitter in that .csv-file and eol-character ? You can choose corresponding values during import.

What program wrote the .csv file ?

Several programs (Excel for instance) can only write DOS-text, so if there are non-english national characters (ö, æ ñ) that could cause all sorts of problems …

[peterlaursen]

Or – a little bit more simple –

if you use the templates for my.cnf/my.ini (my-small, my-medium aso) that ship with mysql there's a basic configuration for InnoDB that works, but the lines are commented out …

[peterlaursen]

No problems here ..

SSL works fine …

[peterlaursen]

try —

export from Access (to MysQL) instead of import to MySQL (from Access).

U understand ??

Perform the Operation from the Acces user-interface …

Besides I've been looking at OpenOffice 1.1 brightly. It seems very promising using JDBC (gives more opportunities it seems than ODBC). It's all a little bit different than M$-products – and there is no installation program for the JDBC but it's really quite simple …

You should be able to open the .xls-file in OpenOffice Spreadsheet and run an update-query (You'll have to type it – there's only GUI for generating Select-queries). I'll try that out one day myself…

[peterlaursen]

I didn't try that myself, but OpenOffice ver 1.1 (now in beta) should have some database interface supporting MySQL. It might be a better solution than Access ..

[peterlaursen]

Succes!

Uninstalling and reinstalling the server solved everything in 2 minutes!

I think system has been messed up by the “MySQL Control Center. alpha” – there's something real bad about user management in that program, I think.

Only Issue now is that WinMySQLAdmin still sees only the “test” database.

??????

But that's not important!

Thanks for support!

[peterlaursen]

try the other way around

Export from Access – I never had problems with that. Thereafter u just check indexes and field characteristics (NULL/NOT NULL, BINARY etc.)

[peterlaursen]

I'll try that …

But if that does not work I think I'd better uninstall and install NMYSQL Again. It's not a Big Deal – backup and recover is easy with MyIsam tables …

[Author]

Posts