Forum Replies Created
-
AuthorPosts
-
peterlaursen
ParticipantJust use the local ip as “MySQL Host Address” 🙂
If the servers are configured to run at different ports and you have a router you can also use the global ip (from inside or outside) or a dyndns-domain and provide the respective port. Depending on the router however it could result in some (!) internet traffic.
If your servers are set up to allow access through “named pipes” I know you can use that name too, but I'm not sure if YOG supports it. And besides I know nothing about it. Search the MySQL documentation … or wait for someone else who know more about it 🙂
ParticipantWell, I don't require it … but having all essential utilities for MySQL at one place easy accessible just would be practical!
And from your (marketing) point of view I think it would let you to demonstrate to users that YOG is an ESSENTIAL for Mysql 🙂
But of course it's not something to spend a lot of time with …
ParticipantTo import to MySQL with sqlyog from a text file you don't use ODBC all all.
From Table .. export/import .. import table data .. import from CSV.
A .csv is basically a semicolon-delimitted text-file.
This is a sample generated with MS Excel (four cells with string content (first row) “d”,”d” (second row)”a” and “s”
(start)
d;d
a;s
(end)
ParticipantYou must explain more in detail what you are trying to do !! We can't read thoughts 🙂
Do you want to import TO MYsql FROM MS-SQL-Server ?? If yes, then you of course need to configure an MS-SQL-ODBC instance for the MS-SQL DB using Windows' “administrative tools” and give it a name. From the “ODBC import wizard” in sqlyog choose that name to import from.
I don't have access to a MS-SQL server, so if there is any specific problem in that I can't help, but those are the basic principles. Sqlyog does not use an ODBC driver to access (neither read or write) a MySQL database (it uses the “native” C -interface/API built into MySQL Server executables).
Participantnot here … attached pic: dbnavne, username and password are all identical. only the names of the host are different.
And it works here …
Mysql-versions: My remote srver is 4.0.16 and localhost is 4.1.8 .
ParticipantPlease look at attached picture !! That's how it looks like here aftr pressing “compare now”
Each connected database has it's own window – they shall not show up at left at the same window. Did you get that piont ?
Also notice that the structure syncronization tool (only) produces sql to run against the target host.
ParticipantTo connect to a MYSQL database you must use one of the connection tools provided by MYSQL !! Primarly the Mysql ODBC-driver or Mysql JDBC-driver! A driver for MS-SQL-Server won't work with MYSQL!
You can however also connect from programming languages like php, perl, c etc.
Participantyou won't have to reboot but you'll have to stop and restart mysql.
you can use “Winmysqladmin” or “Mysql Administrator” or Command Line (“net stop mysql” and “net start mysql”)
Participantit's the same … just a matter of words!!
mysql is a server program! If you say you have installed mysql for windows – that's the same as saying that you are running a mysql server!!
” I have been sync'ing quite happily using a laptop that doesn't have mysql installed on at all!”
pardon ??? syncing means making to mysql databases identical!
But of course if you are networked you can sync two remote servers.
“I can find a my.ini file.”
then the mysql server must be installed on that computer!
” I've added the max_allowed_packet in there and seeing if it makes a difference.!
did it ?
ParticipantWhen you are sync'ing you must have a Mysql-server installed locally.
I guess you should check the my.ini/my.cnf -filer for that server and the settings for
max_allowed_packet
I beliveve most (all ?) sql servers install with a default value of “max_allowed_packet = 1M”
Try rasing that significantly.
I'm using max_allowed_packet = 100M (and have tried higher) and no problems in that.
Participantwell, it does .. if I understand you right !
See attched picture.
I'm talking about “MySQL Administrator” and not “winmysqladmin”
You can get “MySQL Administrator” from http://www.mysql.com (look in “developer tools”)
“winmysqladmin” that's still distributed with mysql is not useful here (and outdated too!)
I really do hope I understand you right !
ParticipantWhat happens if you use MySQLAdministrator ( http://www.mysql.com) to define user privileges ??
Probably Ritesh can tell exactly what's happening here, but the tke user's schema has changed internally in the MySQL grant tables from 4.0 to 4.1 (and again from 4.1 to 5.0). I'm not quite sure that YOG is fully compatible with 4.1 (though it can be used for most tasks!).
Have you upgraded your current 4.1 MySQl from 4.0? If the answer is YES you must follow the upgrade procedure as described in the MySQL documentation. It won't do just to run the installer or replace the binaries.
I quote from the MySQL-documentation
“On Windows systems, there isn't an easy way to update the grant tables until MySQL 4.0.15. From version 4.0.15 on, MySQL distributions include a `mysql_fix_privilege_tables.sql' SQL script that you can run using the mysql client. If your MySQL installation is located at `C:mysql', the commands look like this:
C:> C:mysqlbinmysql -u root -p mysql
mysql> SOURCE C:mysqlscriptsmysql_fix_privilege_tables.sql”
(end of quote)
ParticipantWhy don't you try ver. 4.0? You can use the free version for that operation. It won't install over the one you have!
I remember someone had similar problems some time ago, but don't remember details.
the error message “Can't DROP 'PRIMARY'” might indicate that you have another field defined as PK, or just that sqlyog believes you have!
BTW:: which version of MySQL are you using … ?
ParticipantIt was discussed her too:
Participantyou should update sqlyog !!!
the user authentification in MySQL changed from 4.0 4.1 versions.
As far as I remeber you need sqlyog 3.71 or higher with MySQL 4.1
-
AuthorPosts
