[peterlaursen]

They are not available wit h SJA itself. However you can use a windows bat file.

that bat file will then have one line for each database like

SJA job1

SJA job2

etc.

finally you will need to use a zip program that can be called from command line and delete the originally file once it is added to the zip archive

Filzip (www.filzip.com) for instance can do this.

So

SJA job 1

filzip

del … (delete file now that is is added to zip)

SJA job 2

filzip

del … (delete file now that is is added to zip)

etc.

And then the bat file itself can be scheduled.

more examples of the use with SJA and .bat -files: http://webyog.com/faq/27_35_en.html

[peterlaursen]

Not required, I think!

Even when inserting first row of data I get this!

When clicking the mem_date_created column the corresponding NULL value pops up 30-40 characters to the right. SQLyog 5.14 beta2.

[peterlaursen]

1) To 'script out' a few objects you can copy from the OBJECTS tab.

2)

“Another feature that would be very helpful is the ability to script out individual users and their associated permissions in each database.”

What will you use that for? Hopefully not in order copy the information to another database?

This FAQ: http://webyog.com/faq/23_76_en.html has some related information on how you should NOT create user privileges!

However just for reading it would be OK – but what is wrong with

Code:

SHOW GRANTS for 'user'@'host';

?

3)

I still think you have a point 😀 It is not priority at this moment to change anything here. But at a later point of time it may come up again!

[peterlaursen]

Now look here!

I have a similar thing here with this Forums database itself!

I click the 'created_data' column and data pops up somewhere else!

@Ritesh – it is the 'phpbt_auth_user' table!

@marcm: can we have your database schema?

[peterlaursen]

“I don't see that table in the drop down (actually no tables)”

did you check the checkbox for the/each table you want to import?

See attached!

I have two .csv-files in a …/My Documents/test/…folder. The ODBC driver points to that folder.

I am importing into a database with four tables named 'capuser','capuser_copy', 'master_projects' and 'table' and the dropdown shows all of them.

Next issue could be the mapping of columns if you do not have a header line in the CSV-file. The driver is not working very 'smart' then. That is why I wrote that you might then want to save and edit a job-file!

… do you have a header line?

BTW: What I meant was that I do not think that the text-ODBC-driver lets you write to the source files (but I never tried actually …)

[peterlaursen]

Now this is strange –

WinXP SP 2, Apache 2.0.x, a recent MySQL 5.0.x, PHP 5.1.1 … the same as works here!

Now: I attach the php.ini that I use with PHP 5.x (zipped). It is quite 'minimal' (does not use a lot of extensions – only MySQL related, graphics (gd2) and curl -extensions). The extensions dir in my configuration is ” ./ext/ ” (what is default)

Is it possible that you can try compare with yours and maybe even temporarily replace?

You can also download PHP 5.1.4 from here http://www.php.net/get/php-5.1.4-Win32.zip/from/a/mirror .. copy my php.ini in there and (temporarily) replace that folder with your PHP folder. Then we have exactly the same PHP! If that does the trick we will have to compare the two files. If it still does not work we can do the same exercise with Apache …. (you can have my Apache config file as well). Don't forget to restart Apache after any change in Apache or PHP configuration.

Or you may zip your complete PHP folder and the Apache config file (httpd.conf) and send it to me (there is nothing confidential or personal in there – except for the e-mail adress of the Apache server administrator).

There are two type of PHP-binaries for Windows available. One with an installer (this is a 'shrinked' PHP – and does not install/configure correctly with Apache anyway (it is intended for use with IIS – but can of course be manually configured for Apache as well)), and one without an installer. Do you remember which one you used? The one I linked to is the one without installer.

[peterlaursen]

“I have SQLyog installed on the same machine as the MySQL server” …

That probably means that this machine is a Windows machine!?

Is the webserver/PHP system running on the same?

If yes: what is it? IIS or Apache or something more obscure ?

Also for completeness: Windows version?

(I tested on WinXP with Apache2.0.58/PHP5.1.1)

[peterlaursen]

I do not think the Editor component of SQLyog has the 'logic' or 'parsing ability' to do something like that.

Basically it does only KEYWORD highlighting and tokenizes for DELIMITERS (the standard ” ; ” and any user defined created with the DELIMITER keyword) – no parsing is done (this is done by the parser component of the MySQL server itself – as it usually is the case with Database Client software).

To do this I think we will need to add a complete new component – a 'pre-parser' of some kind.

What editor do you use that has this feature?

[peterlaursen]

regarding the speed of inserts from DATA TAB:

Try 5.14 beta2. It is much faster here than was any 5.12 or 5.13 (( don't remember the ones before)

[peterlaursen]

hmmm..

mreaves53 claims that it occurs when connecting!

@mreaves53: can you verify that?

[peterlaursen]

Does not look as if it is a problem with the PHP version here. I have no problem with connecting to Apache_2.0.58/PHP_5.1.1/MySQL_5.0.22 from SQLyog 5.1.13. (though update to PHP 5.1.4 is recommended for security reasons – at least if it is a public server)

“Error message No. 73 >required.”

Looks like a XML-related issue – doesn't it Ritesh?

[peterlaursen]

Was that the complete error message?

What is the PHP version that you are using? There is a problem with PHP versions older than 4.3.

[peterlaursen]

This is from a BETA repository after all.

It may depend on WHEN you downloaded it.

Please try from here:

http://www.webyog.com/sqlyog/download_sqlyogent.html

[peterlaursen]

@Ritesh …

the problem is that there are more versions named 5.13 … so how should marcm be able to tell?

We have been discussing this before, but I will repeat that there should NEVER two not-identical pieces of code having the same ID. Even when inserting a single linebreak or a SPACE-character it is a new version. You can call them 5.13a, 5.13b etc. then. Because this is a mess!

And btw. it is still much faster from RESULT tab than from DATA tab.

[peterlaursen]

1) I agree that the DATA tab still is too slow. I think it must be rewritten from scratch. There are more reasons. BTW: What is the exact SQLyog version that you are using?

2) To reproduce the different issues could you provide a sample table? It will be easier to discuss this if we have the same data.

3) I still ask if you to try a very simple mouse! How much of this will you still get then? No chance to borrow one?

[Author]

Posts