[peterlaursen]

1)

“and if I select one, it does not map to my table in the database”

I do not understand! You need to explain a little more in detail.

Does the MySQL table exist in advance? Are you sure the structure and the data fit?

2)

“it told me the object or database was read-only”

I think that is because this ODBC-driver does not allow for write.

I do not understand why this is a problem? You cannot use 'triggers' and that is it.

Could you provide a table definition and a sample file with a few data?

[peterlaursen]

Actually I made a FAQ out of it!

http://webyog.com/faq/17_111_en.html

[peterlaursen]

Now ..

neither MySQL or SQLyog read these regional settings at all. So it must be the ODBC-driver that does – and generates the data stream accordingly. Actually that is probably a nice feature when importing to a localized MS-Excel for instance. But not pretty nice when importing to MySQL – as it does not handle it!

There is no setting available with the driver itself?

[peterlaursen]

Well .. actually that became a FAQ:

http://www.webyog.com/faq/28_110_en.html

[peterlaursen]

There is with the ENTERPRISE version!

You can then use the MIGRATION tool with the Microsoft text-ODBC-driver. Simply copy all the files to the same folder, configure the ODBC driver to point to the folder and each file will be identified as a 'table' by the driver.

In case the .csv-files are identical in structure and should be imported to the same MySQL table you just set DML/DLL options accordingly (not to empty table before import). You can test with the ENTERPRISE TRIAL .. but only test, as it is a restriction with this TRIAL that it only lets you import one file per job.

[peterlaursen]

@Michael

Try this:

Code:

SHOW CREATE TABLE `master_projects`;

If you do not have a valid CREATE STATEMENT returned, there is something wrong with your MySQL installation.

[peterlaursen]

It is difficult to remember .. about the past in particular .. 🙂

But there was an issue with SJA and some early 5.0.x releases (I do no remember exactly which ones) that it did not 'normalize' the sql_mode. That could be the issue if server default sql_mode is a special one (like 'NO_BACKSLASH_ESCAPES'. About SQLyog and sql_modes: http://webyog.com/faq/28_72_en.html

I think that upgrading to 5.13 will solve that.

get it from here: http://www.webyog.com/sqlyog/upgrade.html

.. and try making a new backup with it.

It this one imports OK, then there is no reason to 'drill holes' in the past I think!

Please explain:

“The backup will not work because of the table type”

????

Should InnoDB be a problem ???

You just have to “set FOREIGN_KEYS_CHECK = 0” in the backup wizard as you most often will when working with InnoDB!

The problem is the escaped ' ( like ' ) in deaults. MySQL does not seem to like that.

I really do not understand either how it gets there!

I'll research a little!

I cannot make it generate

default 'blabla' no matter what I try! Also not changing the sql_mode!

Now .. escaping applies WITHIN strings but the string enclose character should not be escaped itself!

Any idea where that comes from ??

Anyway, please try 5.13!

Also this:

Quote:

PRIMARY KEY (;

.. and then it stops! This of couse will not load! I cannot generate that either!

[peterlaursen]

I think I have something now!

search and replace ” ' ” with plain ” ' “.

What application wrote the backup? I do not think i was SQLyog that ever did ” ' ” (just tested both backup-tools of 5.02 and 5.13)

What sql_mode is the server running? (execute “SELECT @@global.sql_mode;” to find out)

[peterlaursen]

hmmm…

It exports and imports OK here with SQLyog 5.02 and 5.13 as well.

Now I have only the structure – no data! But I understand that the error occurs when creating the structure?

What is your EXACT MySQL version? (I tested with 5.0.22). You should at least use 5.0.10 … two many bugs and incompatible changes before that!

It looks like an issue with the DATE-type. Can you test that? (remove all DATAs from the file as a test, and change the 'crate database' and the 'use' statement.

Also please answer: do you export using the 'ordinary' export tool or the back-up 'powertool' ?

But no matter what: This statement exports and imports (you truncated the crate statement a little, I think, but should not make a big difference!)!

CREATE TABLE `master_projects` (

`no` varchar(15) NOT NULL,

`name` varchar(100) DEFAULT NULL,

`description` longtext,

`psd` date DEFAULT '1900-01-01',

`asd` date DEFAULT '1900-01-01',

`pfd` date DEFAULT '1900-01-01',

`afd` date DEFAULT '1900-01-01',

`manager` varchar(15) DEFAULT NULL,

`number_developers` int(2) DEFAULT '0',

`pcost` varchar(10) DEFAULT '0',

`tcost` varchar(10) DEFAULT NULL,

`printcost` varchar(10) DEFAULT NULL,

`lcost` varchar(10) DEFAULT NULL,

`ocost` varchar(10) DEFAULT NULL,

`phours` int(2) DEFAULT '0',

`ahours` varchar(5) DEFAULT '0',

`projstatus` char(1) DEFAULT 'O',

`requestor` varchar(50) DEFAULT NULL,

`tc` varchar(50) DEFAULT NULL,

`owner` char(1) DEFAULT NULL,

`development` char(1) DEFAULT 'n',

`coordinators` char(1) DEFAULT 'n',

`multimedia` char(1) DEFAULT 'n',

`admin` char(1) DEFAULT 'n',

`it` char(1) DEFAULT 'n',

`maintance` char(1) DEFAULT 'n',

`finance` char(1) DEFAULT 'n',

`night` char(1) DEFAULT 'n',

`prop_dt` date DEFAULT '1900-01-01',

`denied_dt` date DEFAULT '1900-01-01',

`hold_dt` date DEFAULT '1900-01-01',

`resume_dt` date DEFAULT '1900-01-01',

`changelog` timestamp NULL DEFAULT CURRENT_TIMESTAMP,

`acost` varchar(10) DEFAULT NULL,

PRIMARY KEY (`no`) ;

) ENGINE=MyISAM DEFAULT CHARSET=latin1

[peterlaursen]

To save a SP you execute the 'CREATE PROCEDURE … ' statement, and the SP gets saved in the database.

Of course you can save the CREATE statement as a textfile as well … and that is what you are prompted.

To execute a SP once created you call() it !

[peterlaursen]

I suggest that you save a jobfile!

I understand that you ask for an 'undo-stack' in the wizard? Is that correctly understood?

[peterlaursen]

@materix

“I changed my regional settings from danish to english.”

Could I ask you to elaborate a little bit!

Actually we would like to understand this issue …

WHERE and WHAT EXACTLY did you change?

[peterlaursen]

Hello Tom …

I am not sure that I understan you. But this is planned

1) A 'filtering' opton

2) A 'Select All' + ' Deselect All'

3) CTRL+CLICK and SHIFT+CLICK for easy selection of large no.s of rows

Is it something like this?

[peterlaursen]

I think the information that is Logitech + nvidia is important.

And of course I agree that if no other program does similar things we should at least be able to spot the origins of it. But we could not possibly without information.

Do you have a chance to plug in the most simple mouse (PS2 – wired) , and reboot and see if the problems persists. If not – then we have some 'thread' to follow in our attempt to reproduce (and fix if there is something to fix).

When I used the word 'crap' it was in some humoristic sense. The produts are fine in many respects (hardware quality, ergonomics) – but there are two many driver issues!

I have been a supporter at one of the biggest and most welknown IT-forums in my Country (Denmark) for some years before starting here. And I think that I have about 50 examples of 'weird' display issues with Logitech wireless products. In one situation the order of installation of mouse and keyboard made the difference. It worked if one was installed first – not if the other was installed first.

[peterlaursen]

Yes … not exactly as you describe it but something similar is happening here.

After modifying about 10 first columns of first row the GUI starts 'deciding for itself' how it will scroll vertically.

[Author]

Posts