[peterlaursen]

yes – you use the WHERE clause(“SELECT .. FROM … WHERE …”)

examples:

… WHERE `thename` like 'gas%' …

… WHERE `thedate` = '2006-01-05' …

… WHERE `thetime` >= '2006-01-05 12:00:00' …

… WHERE `theuser` IS NOT NULL …

… WHERE `theuser` IS NOT NULL and `thename` like 'gas%' and `thetime` >= '2006-01-05 12:00:00' …

Also use the LIMIT clause to retun only a limited number of rows.

[peterlaursen]

You did not get this point then?

http://www.microsoft.com/downloads/details…;displaylang=en

just install and Excel2000/2002 should read the file.

[peterlaursen]

I think we found this issue now!

Problem is that there is a small time-slice between UPDATES and DELETES.  If there is activity in between and if for instance there is some counter in the table that counts how many times a topic has been opened, checksums will change in between.  Actually we have been able to reproduce with this Forum itself.

We will have to reuse the checksums, generate some snapshot of (parts of) the table or find some similar solution.

It may take some days to find and implement the optimal solution …

[peterlaursen]

happy new year to you too.

BTW: did you ever try/test the Excel export of SQLyog 5.22?

You were the one the 'pushed' for this mostly …

We may consider disabling support for German Excel-localisations if you did not … <_< I will 'revive' the clipboard discussion, and see if we can find something.

[peterlaursen]

the GRANT statement must be issued form inside the 'mysql' client.   the OS does not know abaout it.

Once connected with putty:

1) start the mysql client like “mysql -uroot -p” (you may need to navigate to the /etc folder first).  Also some ISP rename the 'root' user (to 'admin' for instance) for security reasons.

2) you get the mysql> prompt

3) send “use mysql” (most often not required actually!)

4) now “GRANT ….” remember to conclude with a “;” (semicolon)

5) “exit” the mysql client

6) close putty connection

7) now try to connect from a remote host

[peterlaursen]

Access denied for user 'root' at host XXX (using password: YES).

Can you create a user 'root'@'%' (or better 'root'@'XXX') and give him all privileges.

Most likely only 'root'@'localhost' exists.

You will of course need to log on as root from localhost to do this …

The SQL from cmd-line is (in case there is no SQLyog there)

Code:

GRANT ALL on *.* to 'root'@'%' WITH GRANT OPTION

this will create the user and give him same priv's as 'root'@'localhost'

[peterlaursen]

1) If credentials are different for every database (and you do not have the 'root' user's (or similar) credentials) you will need to create a connection for each of those that you want to access.  What do you think passwords are for? 😛

2) By default MySQL only gives access to users connecting from 'localhost' (the same machine as whre the MySQL server runs).  '%' is a “wildcard” 'any characters'? (so ''user'@'%' may connect 'from everywhere' and 'user'@'123.124.125.%' may connect from any host from the complete ip-range from 123.124.125.0 to 123.124.125.255

[peterlaursen]

The issue is solved.  For some reason (a small blunder I would say) we did not 'wrap' the connection in the function that we will normally use (and which reconnects automatically whenever a connection is lost).  We do that now.  Expect RC4 tonight with the fix.  If you are in urgent need just give us 1/2 hour more for testing and I can PM you a link …

However when working with your server from the IDE/debugging environment we can see that a SSH-tunnel connection to your server is frequently lost and even the most  simple operations often require several reconnects.  This is unusual and should 

ot be like that!

[peterlaursen]

I replied to your PM!

[peterlaursen]

It is an issue with the webhost (privilege issue to the Information_Schema).

However with 5.22 RC3 we send different queries, so (execept for Triggers) it should work .. even with that issue on the host.

[peterlaursen]

No this is not possible.

SQLyog connects with the compiled-in C API.  There is no function to query the database file sizes.

The client code accesses the MySQL server only – not the Operating System or File System.

Probably there is some way with PHP (provided that PHP is executed with appropriate user privileges) and that could explain what PMA does.

 

[peterlaursen]

I just tried 3 different remote hosts with SSH-tunnelling and cannot reproduce any such issue.

We will need some more info.  Or best of all temporary access.  Is that possible? (do no write your details here!)

[peterlaursen]

Did you read:  http://webyog.com/faq/28_73_en.html

With version 5.21 CSV-export is only possible from the RESULT tab (you can issue a “select * from …” however), but with 5.22 (RC3) you can export directly from the DATA tab.

[peterlaursen]

You are not supposed to amend this! 'Autoincrement' means 'give me a unique number and I do not care what it is'.

This is the server behaviour ….

However you can with SQLyog right-click a table .. ALTER TABLE .. advanced properties .. and enter the new autoincrement 'offset' before entering data.  Use version 5.22 RC3 for this (some bugs were fixed in the 5.22 tree with ALTER TABLE ..advanced properties).

[peterlaursen]

PPPL =  Peters Personal Programming Language 😆

[Author]

Posts