[turigeza]

I see! I'm sorry i'm not big on Mysql. So it's a mysql server what creates the mysql batch file not your application … 😀

I didn't know that ! 🙂 You have no control over it what is being writen in there. All you can do is take it out.

>> when the sql-file is created no one can tell where it will be used.

Unless it's an option user can choose and tell your application.

But I was specificaly talking about here the “Copy this database to a different host” functionality where the application can tell where it's copying from and where to.

This thing renders this function useless in my case:( But hey I understand now where you are coming from … 🙄

Thanks anyway …

Geza

[turigeza]

peterlaursen wrote on Nov 24 2005, 04:15 PM:

@geza …

when the sql-file is created no one can tell where it will be used.  And BTW the is no way to make the server not include this.  It should then be 'stripped away' when imported to 3.x or 4.0.  Well that is theoreticaly possible.  But as of now the SQLyog code does not parse – or even read – the .sql at all.  And I personally think that there are many more important things to do.

There are lots of editor programs available where you can define this 'search and replace' operation as a macro.  I just created one with Textpad http://www.texpad.com in less than a minute.  It is just recording it like a Word or Excel macro.  A Textpad is a pretty simple program compared to others.

The basic thing to understand is the SQLyog – being a MySQL client – actually does very little by itself.  It controls what the server should do!  And thus only things that the server can do can be done with SQLyog.

But yes … this 'macro' capability could be implemented in the SQLyog editor as well as in any editor.

[post=”7983″]<{POST_SNAPBACK}>[/post]

[turigeza]

I see it on a different way I'm sorry:(

I need to do this quite often and and it's pain:(

Sqlyog should be able to tell that if the mysql (it would take less time than for me) server version is less than 4.1 ( or what I don't know) creat valid sql statment for that server version.

But ok if you don't see it I find an other way around it …

Thank you for helping …

Geza

[turigeza]

Well I did but I'm afraid this did not fix anything 🙁

Still getting the same problem …

You meant sqlyog 5 not MySQL 5 !??

Any other way !!??

Thanks!

Geza

[turigeza]

Excellent :))

Thanks!

Ritesh wrote on Nov 24 2005, 02:01 PM:

Please upgrade to 5.0. This issue has already been fixed in 5.0.

[post=”7978″]<{POST_SNAPBACK}>[/post]

[turigeza]

Fair enough …. Just want thank you for your help!

R.

Geza Turi

[turigeza]

I don't know what encrypted “in the base” means. 🙂 Sorry!

As far as I know if you type the same passwords for two different user the encripted version is the same. I don't see why it wouldn't work.

In my case the two MySQL server is different version so I'm not going to mess about with it. But I just thought it would be great feature of the product if it was able to transfer users as well as databases 🙂

?? Do you not think so ?

Geza

[turigeza]

Maybe it would make a nice product feature !? To be able to transfer users and their previleges to a different server. You would of course need to have the right previleges to do this but least mysqlyog could keep track of the different versions of mySQL servers and transfer data accordingly!?

?

If you think it's any good I could post it on the relevant forum. I would find it very useful!

Kind Regards

Geza

[turigeza]

Of course:))

Thank you very much !!

Geza

[Author]

Posts