[peterlaursen]

in the menu .. tools .. restore from SQL dump.

If there is no USE statement in the SQL you just select a database from the dropdown before importing, and it will be imported to this one.

[peterlaursen]

I am sorry, but I really do not understand!

You can enter any valaue for 'host' and it is inserted to the `mysql`.`user`.`host` column.

Please explain more in detail if I missed something?

[peterlaursen]

Please tell the SQLyog version and the MySQL version!

Entering 'p_e_t_e_r' as a username from 'Add user' generates

Code:

insert into mysql.user (
host, user, password, select_priv, insert_priv, update_priv, delete_priv, create_priv, drop_priv, reload_priv, shutdown_priv, process_priv, file_priv, grant_priv, references_priv, index_priv, alter_priv, show_db_priv, super_priv, create_tmp_table_priv, lock_tables_priv, execute_priv, repl_slave_priv, repl_client_priv, create_view_priv, show_view_priv, create_routine_priv, alter_routine_priv )
values
( '%', 'p_e_t_e_r', PASSWORD(''), 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N' );

Now

Code:

“select host, user from mysql.user where user like 'p%';”

returns

Code:

host user
——— ————-
% p_e_t_e_r

And you can log on as 'p_e_t_e_r'.

I understand you expected the user to be created as p_e_t_e_r. Right?

Now this

Code:

insert into mytab(id,name) values ('1','t_e_s_t');

select name from mytab where id = '1';

/*returns
name
———-
t_e_s_t
*/

but

Code:

insert into mytab(id,name) values ('1','t\e\s\t');

select name from mytab where id = '1';

/*returns
name
———-
test
*/

and

Code:

insert into mytab(id,name) values ('1','tnensnt');

select name from mytab where id = '1';

/*returns
name
———-
t
e
s
t
*/

This is MySQL behaviour (mySQL 5.0.33). I also think that this is not fully in accordance with the MySQL docs on how to use escaping with the “_” wildcard character. But this is inside a quoted string in an INSERT statement. So I am not perfectly sure. Also

Code:

insert into mytab(id,name) values ('1','t%e%s%t');

select name from mytab where id = '1';

/*returns
name
———-
t%e%s%t
*/

.. so it behaves identically with the two 'wildcards'. I guess I will have to study MySQL docs (and it may take a few days)! But it is no issue with SQLyog User Management. This is how INSERTing a quoted string with escaped wildcards works with (this) MySQL (version).

And further:

From the SQLyog GUI you are never supposed to do escaping yourself. SQLyog GUI handles this – that is one basic idea with a GUI tool. But not the case of course if you type into the SQL editor!

To create the user 'p_e_t_e_r', just enter 'p_e_t_e_r'.

[peterlaursen]

I understand you want to copy 'DATA ONLY' and not 'STRUCTURE and DATA'

You can export/dump data and import to the other.  In the export dialogue do not choose any DROP option and do not include the USE statement.  

[peterlaursen]

1)

Quote:

then leaving the cursor outside of the semicolon at the end of it

The SQLyog Query Tab is designed for holding multiple queries.  If you only want to execute a single query, you will have to tell the program which one! You do by positioning the cursor inside the 'current query'.

If the is one query only you can omit the concluding ” ; ” and 'current query' will then be the complete tab

2)

Quote:

Crazy program!

How could it be elsehow, when I am involved …  🙄

Please detail …

3

With SQLyog ENTERPRISE you can use 'Notifications Services'

With MySQL 5.1 or higher you can create an EVENT.

* On Notifications Services and SP's: http://webyog.com/faq/26_81_en.html

(note that with SQLyog 5.23 it is actually possible to have resultset(s) returne

 

-also with HTTP connections provided that the php_mysqli() extension is enabled

* Events: read the MySQL 5.1 documentation and some of the 'developer articles' they published on the subject

[peterlaursen]

We released RC1 without any (intentional) change here.

We have not been able to establish a situation that was fit for debugging it.

However, sometimes 5.23 shows a 'little less constant CPU' picture in task manager compared to 5.22.

We will give this priority in the next hours and days.

[peterlaursen]

What you are doing is not running the procedure – you are only creating it with that SQL.

The SQL contains two statements only:

1) a DROP PROCEDURE statement

2) a CREATE PROCEDURE statement

To run it once it is created do this

Code:

CALL `applications`.`test`();

 

[peterlaursen]

1) To export the connections details just copy the 'sqlyog.ini' file

2) The request for a Connections Manager like this is not new.  We will need to change the storage from a text fi

e to a database then.  We have given priority to other issues but have not forgo

ten. I think that we will be able to return to this later this year.

[peterlaursen]

This feature is planned for SQLyog 5.3.

We name it a 'FORMS' feature.  Because that is what term is used by Dbase, Access etc.  Basically it is DATA or RESULT display of a single row at a time in a GRID that is 'flipped' 90 degrees.

Such 'FORMS' are widely popular to use for data entry from the keyboard.  Most mainframe-based database have a similar option (a 1-record text-based display and entry FORM).

Actually this feature is allready working 99% in our development tree.  We will proably need 2-3 weeks for merging the different code trunks and for tsting before we can release beta1.  However, maybe this feature is only shipped with beta2.  It is a resource and planning issue.  We want to release beta1 with full Unicode swupport ASAP so the FORMs may have to wait.

FORMs will be an ENTERPRISE feature only.

[peterlaursen]

If the table is a MyISAM table then there is a chance that traditional file system recovery tools can recover.  For each database there is a .frm, .MYD and .MYI file.  You will need them all.

I do not think there is any chance with InnoDB.  Here all databases share the same tables

ace unles you have enabled the 'innodb file per table' -option in configuration.

And the more you use this computer the bigger chance there is that the Hard Disk area form where you need to recover the files will be overwritten.  Also do not defragment the hard disk untill you have recovered!  

[peterlaursen]

Now fixed in the development tree.

RC1 with the fix is expected in 1-2 days.

[peterlaursen]

Yes it is compatible with PHP 5.

 

It should work and usually does with all versions 4.4 – 5.2.  I have practically only been using it myself with 5.1.2 and 5.2 for some m

nths now.  

PHP older than 4.3 is not supported.  And there also is a problem with (the non-released) PHP 6.  Maybe this a small problem only, but we did not have the time to get into it.

As you are 99% sure that it worked 1 week ago some server configuration must have changed?

Please try asking the System Administrator adbout Webserver and PHP configuration.

However I would also recommend that you upgrade SQLyog (and the tunneller with it) to 5.22 or 5.23 beta (RC in 1-2 days).  The tunneller shipped with 5.23 is practicallay totally rewritten (and supports php-mysqli() )

[peterlaursen]

1. We export in the XML based format supported natively by Excel 2003 and 2007.  On Excel 2000 and 2002 you will need to install the Compability Pack provided by Microsoft.  We do not use the .xls-format.  We program for the future not the past 😆

2  When I export a small table with some Timestamps I giet a file reading like:

Code:

2006-11-20 12:00:03
2006-11-20 12:00:04
2006-11-20 12:00:04
2006-11-20 12:00:05
2007-01-19 10:43:27

Could you provide a test case to reproduce with?

[peterlaursen]

Bikas is debugging his way through the code right now.

With all operations on data the program can have more USE statements 'in the air' simutaneoulsy and use the correct one.

What exactly happens with this STOP issue I cannot tell now, but probably can tomorrow.

This issue (and two very small cosmetical issues) are all what we are missing before 5.23 RC1 can be released. So it is priority now actually!

[peterlaursen]

How should I be able to tell which users exist on that server?  It is not my server – it is yours :huh:

If there is a user 'Monte' (and he has the privileges needed for the job) you can use him!

Or maybe you can use a a privileged user like 'root' or 'admin' …

[Author]

Posts