[peterlaursen]

It also simply could be the “Control Panel Applet” (.cpl-file) that is missing. In that case the service runs but is not accessible!

[peterlaursen]

is the file schedsvc.dll in system32 folder ?

the service is started with command “rundll32.exe schedsvc.dll” from a RUN registry key.

EDIT: corrected a pasting error! 🙁

[peterlaursen]

Quote:

Using Windows Task scheduler, you can set all of these options. Once SQLyog creates the task you can configure the options that you want

Actually I am becoming a little bit confused now!

This question: http://www.webyog.com/forums/index.php?sho…7197&#entry7197 made me research a little bit more.

This MS document http://support.microsoft.com/?kbid=223375 says

“This issue occurs because you cannot configure a task to use the System account using the Scheduled Tasks Wizard.”

Actually I can! See attached picture.

the Danish text “Kør kun … ” means “run only when a user is logged on”

If I uncheck this a request for PW pops up. However I can cancel this PW-request, and the job runs! (with “NT_AUTHORITYSYSTEM” privileges)

Anybody knows if this is changed from 2K to XP ?

[peterlaursen]

We have been discussing here too!

http://www.webyog.com/forums/index.php?sho…668&hl=schedule

[peterlaursen]

Well obviously SQLyog can't initialize the scheduler if the scheduler is not there <_< there is a FAQ item http://www.webyog.com/faq/index.php?action…d=33&artlang=en

The scheduler is a service in the OS. Sure it just does not has been stopped? Some people have a maniac for stopping services because they think they eat resources.

Actually the old command line NT scheduler is in 2k and XP too

http://support.microsoft.com/?kbid=223375

these should be good:

http://www.splinterware.com/products/wincron.htm

http://www.visualcron.com/

more resources

http://windows.about.com/od/customizations…l/aa001022a.htm

[peterlaursen]

There is no System Variable to use instead ?

default CURRENT_DATE or something like it ?

[peterlaursen]

No you don't need to open port 3306 to run SQLyog!

If you run a MySQL server on your local machine and want to allow direct connection from a remote client then you must open port 3306 – no matter what client is used for connection.

More on routers and firewalls here:

http://www.webyog.com/faq/index.php?action…d=40&artlang=en

[peterlaursen]

Undoubtedly it is Portuguese (as I wrote 😀 )

These accents tell

Quote:

função

[peterlaursen]

You have a Personal Message with a download link.

Peter

[peterlaursen]

No, this option is not available.

You can export to an XML-file but not import.

To my best knowledge there no STANDARD for how data from a database table should be serialized to an XML-file. The XML standard describes formal issues such as use of tags and only that. The exact implementation of a XML data-file would be an open issue. (such as identifiers/names, headings/no hedings etc.)

[peterlaursen]

Quote:

I want to be able to add this one column with a default value to the table that is being imported.

The solution is the have two jobs

1) An ODBC-importjob

2) A Notifications Service-Job executing the appropriate ALTER TABLE statement.

You can then build a job.bat file like

Quote:

SJA importjob.xml

SJA notifyjob.xml

and the job.bat can be executed or scheduled.

As of now there is no way to execute more job type from one jobfile and you can't either add additional data to the MySQL database with an ODBC-import-job.

[peterlaursen]

He had also posted a question in the FAQ.

This was the one that I answered!

[peterlaursen]

You can safely delete any user except for root@localhost.

Don't forget the password of root@localhost and don't attempt to change the privileges of root@localhost. Then you can always get back.

But maybe the version that came with that book has some prefigured settings to work with exercises.

You should always get your MySQL from MySQL, I think!

[peterlaursen]

You should upgrade.

Is this so bad: http://dev.mysql.com/downloads/mysql/5.0.html

The list of bugfixes from 5.0.0 to 5.0.12 is no less than 20 pages.

If you want to learn MySQL it would be a bad idea to learn with a version full of bugs.

I have no idea of that wildcard issue. Never used that client.

My advice is that you use SQLyog for manipulation your databases and MySQL Administrator for manipulationg the server environment.

[peterlaursen]

Then I learned something too!

I did not know that MySQL allowed the use of Windows Network network names.

But I just tested on my own network and it does!

Are you serious that you are using 5.0.0 ?

Not 5.0.11 or 5.0.12 or 5.0.14 for instance ?

[Author]

Posts