[Bobnz]

I have uninstalled sqlyog from the WIN2k machine and installed it on a laptop and connected that to the server and imported an original copy of the DB (with all the odd field names) with the same results. I thought I had had success but the first import was the amended DB not the original. When I tried the original DB the import process fell over with the error I first posted. How likely is it that two successive PC's have corrupt ODBC?

Bob

[Bobnz]

I'm using Access 2000 (9.0.3821 SR-1)

Bob

[Bobnz]

I have had to remove all spaces in field names eg. “I P Address” becomes “IPAddress” and other field names such as “Memory(M:cool:” (sqlyog error said it was undefined function) becomes MemoryMB one field name had a “?” that had to go. and various others….

Bob

[Bobnz]

Ok I have imported all tables in the database. However I had to go into the access version and rename tables and fields, remove spaces in names and other characters that sqlyog didn't like. None of which I have had to do before when importing to mysql.

I have two linux boxes both running mysql. Once a DB has been imported successfully I import a copy on to the testing server and run the scripts which will be run by users and admin. The way this import has gone I wont be able to test any scripts against it because of the different table and field names. Is there a setting I haven't configured on the testing server that causes this difference in the import process?

Bob

[Bobnz]

Seems to be tblAccessories, tblMonitor and tblPrinter. I have imported and deleted this DB several times without any problems.

Bob

[Bobnz]

Edited insert and couldn't reinsert into post.

Bob

[Bobnz]

This is a mock up as screen shot only takes top window. I get the error message halfway through the import

I close the error window and the import window looks as it does in the attachment.

I am using the import wizard the way I have for quite a few Dbs and had no problem except where table names need to be cleaned up.

Bob

[Bobnz]

No just using the ODBC import wizard.

Bob

[Bobnz]

Ok thanks for all the help.

great program.

Bob

[Bobnz]

Hi, I think the problem has been one of patience or lack of. I expected import process to be very quick where in fact it can take some time. What I noticed was that the task manager had mysqlyog as not responding yet the network traffic icon was lit and up sure enough the network monitor showed data being transferred, I went and had a coffee and on my return db had been imported.

One thing when I import a db I have to close sqlyog then add that db to the user at the connect window is there a easier way of doing that?

When sqlyog opens only some of the db's in the left window (under the user@host ) display tables when I click on the + . With some the + just disappears yet I can run queries on them on the server so I know they are there and that they have tables and data.

Thanks for your help I appreciate it; I will work on my patience 😛

[Bobnz]

I have the ok to upload the DB

I'm using mysqld 3.23.54 that comes with RH9

PC is 2.2mhz 512mb ram

windows PC is a windows NT workstation

Bob

[Bobnz]

Thanks Shadow, I'm using MySql on RH 9.0

Bob

[Bobnz]

Sorry about that , using access97.

Bob

[Bobnz]

I have included the table minus some data. Hav also had a problem with another DB where some of the tables names hav a ” / ” ie. table/table is there a list of reserved characters or just a specific naming convention for mysqlyog. I have over 600 DB's to migrate to mysql so would like as much info on the import process as possible.

thanks again

Bob

[Author]

Posts