[peterlaursen]

Better think it over now .. i'm getting tired!!

I'm not quite sure about copying .. it might work if you have the privileges.

But one thing's for sure. if you are working with two remote servers NONE is localhost!

Connect to both using their URL …

[peterlaursen]

correction: “webserver” should be “datadir belonging to a MySQLserver” of course. But we are just so used to thinking of MySQL as something powering a webserver. But it could be a corporate database or anything …

[peterlaursen]

And one point more.

You can copy a DB anywhere you want and to any webserver. But that DB won't work with MySQL on that server (it will just be a set of files! and there a not even beautiful to lo at like pictures 🙂 )

You must either (if you want to use sqlyog)

1) use the database syncronisation wizard and connect to an existing DB recognized by a running MySQL server

2) or export the DB as an SQL-script and run that script locally on the server using PHPAdmin or equally functioning program

If that was a trivial fact for you, I apologize!

It's goodnight here now!

have a nice weekend

Peter

[peterlaursen]

yes I thought so too .. just wanted to be quite sure that I'd got it right!

attached pict. is what I get for m the pull-down-box

Actually in this case the DB accessed from localhosted andd over the web fron URL deepeter.dyndns.dk is the very same database … Still I can copy a DB from localhost to deepeter.dyndns.dk successfully! Maybe it travels round the globe 🙂

Are you are logged on to both servers ?

You write “When using ssh tunnel with root@localhost” . Why tunnel on localhost? You have direct access to localhost.

And how do you do that, actually ? the ssh tunnnneling function is not in the “copy DB” functionality.

“Tunnelling” means accessing the phpadmin program on a Mysql server, so you won't have to have direct connection to the mySQL server itself.

[peterlaursen]

and this one

[peterlaursen]

I'm sorry but I'm very confused about your writing.

Please answer to questions:

Q1:

1) do you want to copy from one remote server to another

or 2) from localhost to a remote server ?

“true connection” as far as I'm concerned is “localhost” on “localhost” …

Q2

1) do you use the DB … copu Database to different host/DB

or 2) Tools .. database syncronization wizard ?

… if 1) where do you get the ssh tunnelling function from

… if 2) don't you get dialogues like these pics

[peterlaursen]

And now I even managed to

* move the installation of MySQL to the new standardlocation using MySQLAdministrator and

* replacing the old my.ini-file with a new one that MySQLAdministrator and the configuration wizard can recognize and modify correctly! and

* remove obsolete entries in the registry from old versions

So now the new installer and maintenace- and configuration-programs should work seamlessly in the future 😉

[peterlaursen]

> Shadow … was that a Q for me ??

I'm not so much an SQL-expert to decide how that should be implemented. I think convenience and data securety pull in different directions. In all circumstances an option to save old data should be implemented.

But with big corporate databases and when performing operations over the internet an “alter structure” solution probably would be preferrable. But when it comes to changed relationsships (and maybe changed relationships involving newly created tables) it's not so simple! And foreign keys and stored procedures complicate further …

[peterlaursen]

a “DB structure comparison tool” generating a script containing the SQL necessary to make one DB identical to another …

yeah!

[peterlaursen]

Just for information …

The latest “gamma” version 4.1.6 installed perfectly over ver 4.1.5 in the “old-style” location c:mysql.

I noted that the win installer had its version no. changed form 1.0 to 1.0.1 so probably they have fixed something …

😀

[peterlaursen]

I'm sorry – I missed more then half of the shortcuts

thes are hat you need

Ctrl+F5 Execute Selected Query(s)

Shift+F5 Execute All Query(s)

[peterlaursen]

F5 means “execute current query”. Queries in Sqlyog terminologi are divided by “;”. Therefore, You'll need to “execute all queries”. The easiest way is to click on the 'double green arrow' on the icon bar (no. 2 from the left). I don't think there is a standard keyboard shortcut for that. Accoding to the help menu, these are the shortcuts below. But it could be an idea to assign for instance F4 for “execute all queries” in future versions …. However I never use keyboard shortcut's so I don't mind 🙂

F5 Execute Current Query

F8 Execute For Update

F1 Help

F3 Keyboard Shortcuts Window

F6 Alter Table Structure

F7 Manage Index Window

F9 Refresh Object Browser

F10 Manage Foreign Relationships

F11 Insert Update Dialog

Ctrl+1 Show/Hide Object Browser

Ctrl+2 Show/Hide Result Pane

Ctrl+3 Show/Hide Query Window

Ctrl+B Set Focus On Object Browser

Ctrl+D Create Database

Ctrl+E Set Focus On SQL Window

Ctrl+F Find

Ctrl+L Toggle Result In Text/Grid Mode

[peterlaursen]

Thanks for your interest in my problems!

I knew this link of yours very well, but there is no hints for troubleshooting there!

I think that if it only my problem I'll have to find the solution myself and if some of the registered PRO users at Mysql experience the same problems there will probably be a solution supplied with the next version – maybe an improved installer or maybe something else … I'll wait and see

But I have been corresponding slightly with a very experienced MySQL from the forum at http://www.cerious.com who had a lot of trouble too – actually he spent 4-5 hours to get the server up and running. So I think the version could have bugs ….

Of course I could stick to well-probed versions and keep away from betas and “gammas” … what's a gamma ? … will the next be a “delta” ?! 🙄

Actually I only use MySQL personally for my photo-archive, music-library, cooking recipes and the like, so it's not so important which version …

Has anybody at webyog-company tried this version with the new installer ?

[peterlaursen]

well .. I did it “the old way” and it's up and running.

We'll see whats happening with the next version!

Peter

[peterlaursen]

of course it asked this question in the MySQL forum too …

[Author]

Posts