[Shadow]

If only one of the fields is enclosed by a certain character, then checking the “Optionally” checkbox may help.

[Shadow]

Quote:

The Connect and Disconnect and Connections Manager buttons are missing in v3.61.

From where? I have connect and disconnect items in the File menu. Whenever I start a new connection, I get a dialog window with all the appropriate options.

[Shadow]

Foreign keys are excellent examples of such keys as multiple records may refer to the same field in the referenced table.

[Shadow]

This is odd, I have never experienced such behaviour. Which version of SQLyog and MySql do you use? Could you paste the contents of the history window to see what SQLyog had done (or had not done…)!

[Shadow]

MUL stands for MULTIPLE_KEY_FLAG which indicates a non-unique index field. The abbreviation is used by MySql and not by SQLyog.

[Shadow]

If you use InnoDB or BDB table handler, then sending a commit may help, otherwise not, because the other table handlers are not transactional. As far as I am concerned, you cannot include more than one DDL command in one transaction. In fact, issuing a DDL command will wait until all pending transactions are completed, then gets executed and commited immediatelly.

By the way, I can still see the test comments I made a week ago…

[Shadow]

Set lower_case_table_names variable to 1 in the MySql running on Linux. This forces MySql to create all tables (and since 4.0.4 all databases) lowercase.

[Shadow]

It is not SQLyog that rejects commands, but MySql itself! SQL commands are routed to MySql unaltered.

[Shadow]

ALTER TABLE tb1 MODIFY col1 INTEGER UNSIGNED NOT NULL COMMENT 'blabla'

The trick is that after the column's name you have to specify the type (what you already have) of the column. Otherwise it won't work!

[Shadow]

Quote:

How do I activate that? I suppose I have to visit innodb to find that out as well.

I suggest you to check MySql manual's corresponding part (7.5 InnoDB Tables) first of all!

[Shadow]

I don't know if MySql had such feature, but I don't think so. EXPLAIN command has similar results.

[Shadow]

Of course, you'll be able to do whatever you want (you can manipulate the data using SQL commands)! You may even add features to the script/app that SQLyog doesn't have. It's up to your imagination and programming abilities!

If you mean that you need to delete ALL rows from the destination table in MySql prior the import, then the TRUNCATE TABLE command is what you are looking for! Lot faster than DELETE FROM table_name command (drops and recreates the table), but has a few drawbacks. See MySql manual for details.

If you need to delete specific rows only, then you'll have to create parametrized DELETE commands, though.

[Shadow]

StefanWagner!

Take a look at this topic!

[Shadow]

tgifch!

I believe, your ISP runs phpMyAdmin on its site. If this is right, then your problem is that phpMyAdmin logs on locally, while SQLyog connects from your remote machine. MySql (NOT SQLyog) forms the login name as user_name@host_name, where host_name is the name of the computer you log in from. In you want to connect from home via SQLyog, then you should ask your ISP (or do it yourself, as you may have root privileges) to grant access to either your_user_name@% (from all hosts), or to your_user_name@that_dsl_name (that information about your DSL).

[Shadow]

Well, such script may not be that difficult to write…

First of all, make sure that you have an ODBC driver for MySql installed. If not, download the latest from MySql.com. Then get yourself aquainted with ADO. Finally, all you need to do is to write a script that connects to the MS SQL Server and to the MySql server, and loads the data from one to the other.

I suggest you to write the program in Visual Studio because of its debugging capabilities!

[Author]

Posts