[peterlaursen]

Maybe:

http://www.codeproject.com/macro/easyif.asp

There are similar code pieces to be found on the internet!

[peterlaursen]

First: consider an upgrade of the SQLyog program! Latest version is 5.02. 5.1 beta will be out in less than a week. Registered users can upgrade for free.

Next: your question.

Because that is the way the server works with an INSERT statement! Even this SQL

Code:

insert into `test`.`t1` ( `id`, `t` ) values (  '0',  'rr' )

executed against an empty table inserts '1' and not '0' into first row of the table

However with an UPDATE staement like

Code:

update `test`.`t1` set  `id`='0',  `t`='rr' where `id`='1'

current value is updated with a '0'. As long as the is only this row having his value. dublicates are not allowed with an autoincrement

'autoincrement' means simply 'give me a unique number and I don't care which one'

http://dev.mysql.com/doc/refman/5.0/en/exa…-increment.html . It is a MySQL issue – not a SQLyog issue. And like that in practically every database.

I think that maybe you should consider redesigning your SCHEMA. It seems like you are using this column for more than one purpose.

[peterlaursen]

read this: http://www.webyog.com/faq/23_43_en.html

when you connect from a PHP-script (phpadmin or your own script) you connect from 'localhost' if the webserver/PHP subsystem is running on the same host as MySQL.

Most likely you will need to allow connection from 'remote hosts' in MySQL configuration.

[peterlaursen]

OK .. let's get back to the beginning! You wrote this

Quote:

when i try to connect or test i get the following error.

Error 1045:

Access denied for user admin username @ domain name (using password yes)

now shouldn't it use localhost after the @ instead of the domain name?

Now note that the error message is a MySQL Server error. There is no issue with tunnelling here! The communications' chain SQLyog <> SSH client <> SSH Server <> MySQL is functioning and this chain can process communication all the way through in both directions. It is a privilege issue! If SSH could not connect to MySQL error message would be the MySQL client error 2013 'Lost connection to MySQL server during query'

I also think that your observation is correct, that MySQL does not allow for connection from remote hosts and it 'thinks' that this is what happening – and rejects the request for connection. Provided (of course) that the user credentials are all correct. A problem that is related to the routing system used at the remote network, I think.

What 'domain name' is displayed in the error mesage ?

The remote 'domain name' I guess?

Would it be possible to allow connections from remote machines (only in MySQL user management – not elsewhere) for this user – just for a test?

But this:

Quote:

On the main server tab i am using

localhost

an admin username

an admin password

port 3306

Db is blank

admin user/password are MYSQL user, OK? Not OS/SSH user ?!

[peterlaursen]

Thank you for categorizing me as a 'light user' 😎

Quote:

There isnt a feature tht would be more valuable than an option “Show Table Data In Text”

Well, I think I could mention a few …

[peterlaursen]

I feel like to repeat myself <_< I do not understand why this is so important! It is so easy to issue a 'select *' and have results shown in text from RESULT-pane. With the most recent SQLyog's it is event more simple then before: you can right-click a table and paste a select statement. I also ABSOLUTELY don't understand that anyone has the need to have a COMPLETE TABLE shown in text. But they can from RESULT -pane if they want. To me it would be fine if Ritesh declared that this will not be implemented for the near future. There a hundreds of requests pending that are more important to spend time with in my opinion. Should I request something it would be that a similar popup-menu item was available for VIEWs.

[peterlaursen]

BTW: let me remind you of one detail more. If you have a mycolumn contaning a string 'c:folderfile'

and you would find all entries starting with the substring 'c:folder' you must write SQL like

Code:

SELECT …. FROM mytable WHERE mycolumn LIKE 'c:\\folder\\%'

When parsed with LIKE '\\' is stripped down to '\' – next '\ is considered an escaped '' , that is a literal ''.

to put it another way:

Code:

SELECT 'backs\ash' LIKE '%\\%'

returns TRUE. And it is the ONLY correct way to do it!

See another example with the data from above in attached.

[peterlaursen]

AHA … 😀

Tell me: do you use the GUI or do you write statements yourself ?

no. 2 – right ??

Did you ever study the use of escaping within strings:

http://dev.mysql.com/doc/refman/5.0/en/string-syntax.html

Also see attached!

and BTW: I don't think that even the very first SQLyog (ver 0.9) had such a bug with the GUI! Though I never tried it!

If it is not an 'Error 40' then it possibly could be a PHP mal-configuration!

(an 'Error 40' is when the error is 40 centimeters from the monitor 😆 )

[peterlaursen]

I can easily do that (of course). See attached!

Which version of SQLyog do you use? a very old SQLyog version maybe? Well it has to be VERYVERYVERY old then …

Also have a look at HISTORY pane. When inserting 'c:backslash' the SQL would be like

Code:

insert into `test2`.`TableName1` ( `id`, `t` ) values (  '',  'c:\backslash' )

This is the correct escaping!

Suggestions? Well … answer all what we ask for here:

http://www.webyog.com/faq/6_26_en.html

.. especially I would like to know if you use HTTP-tunnelling.

[peterlaursen]

You are right – this question has been asked and answered at least a dozen of times.

But I look forward to the day where you can adjust column widths in DATA-pane and close the program – and it will remember next time you open that table!

[peterlaursen]

You are always welcome to give me an opportunity to launch a bad joke! 😉

[peterlaursen]

Probably somewhere in the Antarctic Territory, I guess! I have been looking all over Denmark but did not find it here! 😀

I don't understand you question! Could you explain somewhat more in detail, or maybe provide a screenshot that illustrates this?

It is not the 'Truncate Column Headers …' option in 'tools .. preferences' that you are looking for?

Personally I would would like too more user configurations/settings for the data display (it makes a BIG difference if you are working on a 800*600 or a 2000*1600 screen!). With the embedded database that will be introduced with SQLyog 5.1 that also should be possible! But not high-priority right now!

[peterlaursen]

FAQ write-up accordingly!

http://www.webyog.com/faq/5_20_en.html

[peterlaursen]

Please read:

http://www.webyog.com/faq/23_36_en.html

and more general ones.

http://www.webyog.com/faq/16_66_en.html

and

http://www.webyog.com/faq/16_67_en.html

But this error 1130 can be very tricky when connecting to *nix based systems and I personally do not understand everything. I doubt if anybody does!

Also: try simply change from

MsqlHost address:

to

MsqlHost address: localhost

on the Server TAB. The point is that PHP connects from localhost, so there is no need for a DNS lookup!

Anything you could use? Could you provide more info about the server setup?

[peterlaursen]

1) SQLyog does not import XML yet, that is right

2) CSV: try to read: http://www.webyog.com/faq/28_73_en.html. Could be a problem with escaping! Or that the table that you import to does not have the right structure (sttructure must be defined in advance, at a CSV has no such inforamtion in it). It is not possible to anyone to help more here without a small set of data that generates this. + create statement for the table + a screendump of the settings.

3) Another way is to create a new table with a subset of data using this SQL

Code:

Create table my_table select my_column1,my_column2 ect  from… where .. limit etc.

It creates a new table named my_table (in the same database) with the (subset of) data that the select finds. That new my_table can then be exported/imported (to CSV or SQL), 'copied to other host', or sync'ed.

4) Copy complete table and thereafter drop irrelevant columns

I might have forgot something!

[Author]

Posts