[peterlaursen]

I think I understand that the mySQL server is running on your local machine?

1) When installing (using the MSI installer) you entered a root password. With that root password you should be able to connect! If you forgot it will only take 5-10 minutes to uninstall the server and reinstall!

DO NOT EVER FORGET THE ROOT PASSWORD!!

2) Firewall

–> first try to disable the WinXP firewall to see if that is the problem. If it is then configure like this. Open 'Windows firewall' from Control Panel, to to the 'Exceptions' TAB, click 'Add port' and add the MySQL port (normally 3306) here.

3) You are talking about executables int the bin folder under the installation folder. You cannot execute any of the .exe's by double-clicking for instance. There are two types of binaries here:

—>The Server binaries, they are normally run as Services in Windows. To start the Mysql service from command line type 'net start mysql'. But if you chose to let the Server start with Windows when installing it should be running. Do you see any proces like 'mysql*****.exe' in Task Manager

—>Clients and Utility progams. They are command line programs only and you will need to give the correct parameters with them.

[peterlaursen]

Quote:

What is most relavent is how fast my queries will be executing on the server itself.

This is simply not possible and never was. The server does not send this information. Also the 'mysql' command line client gets this information from the client machine.

I also am not aware of any intentional change here, but let us discuss.

[peterlaursen]

Quote:

Error Code : 1052

Column: 'customers_id' in field list is ambiguous

Yes .. there is a `customers_id` in both tables!

Now read the error message: ” … is ambiguous”. It tells everything!

In this situation you must use `table`.`column` like

`address_book`.`customers_id`

or

`customers`.`customers_id`

.. for that column!

[peterlaursen]

'Quick filter' is a planned feature (with a priority of 2 on a scale from 1-5)

[peterlaursen]

And now fixed in the development tree. 5.22 beta2 will have the fix. A few days only. Maybe even today.

[peterlaursen]

Quote:

The source ODBC table often has rows removed, which must be removed from the destintation MYSQL table.

yes! we are aware of this. We also have discussed if we can do something about this. But priorities are so that we will only look into this after the MySQL Users Conference (end of April 2007).

[peterlaursen]

Only the tables and columns (and not the database) are listed in the example statement that I wrote. Do one of:

1) include the database like database.table.column in every reference

2) or select the database in the Object Browser (the left pane of SQLyog) or in the dropdown on the icon bar

[peterlaursen]

It should now (version 5.21) also work on LINUX without the tag.

Can you confirm?

[peterlaursen]

We have discussed some stuff like that. Also a high contrasty visual 'theme/skin' for visually impaired people, an option to provide icons in different sizes etc.

But priorities are that it will earliest be next summer we start such things.

[peterlaursen]

It works here. Also on W98. It could be data-specific.

Could you provide a compete (and small and simple!) test case consisting of:

*table structures

*data

*querie

.. to reproduce with?

Yes it is a problem with Finnish! I only know the name of the Finnish Miniters of Health ('Hygiejnen') and Energy ('Kakkelovnen') – – – sorry about my bad Danish jokes!

[peterlaursen]

Please read this FAQ:

http://webyog.com/faq/8_147_en.html

[peterlaursen]

something like:

Code:

Select adress_book.entry_firstname, adress_book.entry_lastname, customers.customer_email_address from adress_book, customers where adress_book.customer_id = customers.customer.id;

We will soon provide a Graphical Query Builder that can build such queries.

[peterlaursen]

What is the SQLyog program version that you are using?

[peterlaursen]

Hello.

You are welcome to say 'hello' but I deleted your ridicolous add link of course!

[peterlaursen]

pooohhhh …. That was a long sentence without a aingle punctuation 😀

Please provide a small test case: a dump of a single table with a few rows of data only. We need getting oor hands on some data. TRey are better than words!

And pleasse confirm: both sorce and target servers are 4.1.x ??

[Author]

Posts