[CalEvans]

mysqldump won't do the trick?

=C=

[CalEvans]

IMHO (and I cannot stress this enough)

I am not affiliated with SQLYog

SQLYog != Access

Access == crap

If you like the features of Access then use the MySQL ODBC drivers to attach Access to a MySQL Database.

SQLYog is a tool for serious database development and does not equate in any way to Access. If you absolutely must compare it to any M$ tool then it is much more closely aligned to iSQL. A good tool that M$ has now abandoned as it tries to make M$-SQL feel like Access.

Again, IMHO!

=C=

[CalEvans]

The editor is one of the weak points of SQLYog. I'm desperately hoping that the next major version has a new one.

To work around your problem, go to the last line you can get your cursor on and then hit return. This should cause the editor to work again. (at least it does for me when I run into this problem.)

HTH,

=C=

[CalEvans]

use SQLYog to export the tow tables (structure only) to a batch script. Then copy that and paste it in here. Don't try to attach it.

=C=

[CalEvans]

Can you post the SQL that you are trying to execute to create the tables and relationships?

=C=

[CalEvans]

Don't take this the wrong way.

The absolute best way to get around this problem is to create primary keys on all of your tables.

SQLYog provides a nice front end for you to edit but on the back end it's simply issuing UPDATE statements. To issue an update, SQLYog HAS to have a way of identifying the exact record you want to update. Without a primary or a candidate (UNIQUE) key, there is no way to do this.

phpMyAdmin is a toy for those who don't know how to use better tools. (IMHO) Yes, it allows you to do this…and yes, if you have 2 records exactly the same, it will update them both when you edit one. Nature of the beast.

HTH,

=C=

[CalEvans]

Can you log on to your server from the server itself using the mysql command?

An empty my.cnf could be a serious problem. I'm not familiar with how debian organizes it's conf files. MySQL needs something to tell it how to work.

Quote:

bind-address=127.0.0.1, 10.0.0.%

no, try

Code:

bind-address=127.0.0.1, 10.0.0.*

or

Code:

bind-address=127.0.0.1, 10.0.0.0

not sure which one is right. I don't use it in this matter.. Might want to scan the docs. There is a section on the config file that will explain all.

HTH,

=C=

[CalEvans]

From:

http://dev.mysql.com/doc/mysql/en/Error-returns.html

Quote:

ERROR code 2000 to 2999 can be found in the MySQL source code file: `include/errmsg.h'

Example: 2003 – Can't connect to MySQL server on 'xxx.example.com' (10060)

#define CR_CONN_HOST_ERROR 2003

( “include/mysqld_error.h” contains ERROR code 1000 – 1??? )

Is your server listening on ip addresses other than localhost? (127.0.0.1)

You shouldn't have to do port forwarding, however, if the server is on the Internet then I recommend limiting mysql to localhost and use an ssh tunnel to get to it. It's a little more secure.

HTH,

=C=

[CalEvans]

Hi,

A)

There is no NOOP command in SQL.

I guess they could determine what database you are connected to and select * where 1=2 but that's really troublesome.

I've already put in a request for an auto-reconnect and re-select the database I was last in. I've been told that they are considering it. This would do the trick. (I have 1 server I work with that has a 2 minute disconnect! It really gets annoying after a while)

In the mean time, I've worked around this problem by adding databasename. to each of my table names in my from clause. I'm never exited about having to change my habits to work around flaws in a tool but SQLyog is a very important tool for me and it's still the best out there for mysql. So I begrudgingly work around it.

HTH,

=C=

[CalEvans]

Either:

get a shell account fomr them and use ssh to tunnel mysql. (not bloody likely if they won't give you access to a mysql database) or

Get a new ISP.

Sorry, wish I had better news.

=C=

[CalEvans]

Sounds like [email protected] does not have an account on the server. My guess is that rmlebuser@localhost does.

Add [email protected] or if you are brave, add rmlebuser@% as a user and give them permissions to the databases they need access to.

HTH,

=C=

[CalEvans]

1: Make sure you are allowing connections from IP addresses other than localhost:

Look for bind-address in my.cnf If it's there and it's bound to 127.0.0.1, comment out the line, reboot mysql and see if that allows it to connect.

2: Make sure the user you are trying to connect with has permission to connect from a non-localhost box.

HTH,

=C=

[CalEvans]

works fine with sqlyog 3.7 against MySQL 4.0.16

=C=

[CalEvans]

If you run this server then you should have the root account and password info. Check the mysql docs for more info.

If this server is run by your ISP then you most likely won't be able to get to teh root account but you can ask them to perform the tasks.

[CalEvans]

Quote:

Please note the weird qualifying string after the user name.

That's your machine name.

From your root account, either add a user for that user with that as the 'New Host' or add a user with '%' in the 'New Host' field. (Or change your existing record to '%' in 'New Host.')

I'm not sure if it's true anymore but I used to (MySQL v3.x) have to add each user in twice. Once with localhost and once with %.

HTH,

=C=

[Author]

Posts