Forum Replies Created
-
AuthorPosts
-
Shadow
MemberWhad do you mean by “real IP”? You mean that you connect to Internet through LAN and your firewall uses NAT?
In MySql a user is created as username@hostname. Hosname may be an IP address or domain name. If your user is bound to a specific host (your computer is not granted access) and you connect from another one, then MySql refuses the connection! You may specify “%” as hostname meaning that user may connect from any host.
MemberFirst of all, SQLyog has nothing to do with storing MySql db tables. It's up to MySql's configuration.
Secondly, MySql is not a file based db manager like Access, but a server based one. This means that there is a daemon/process listening at a given port (or pipe, but that is very uncommon) which responds to incoming requests.
It would be nice if you copied the connection string here and disclosed some details about your MySql configuration!
MemberIssue a SHOW WARNINGS command from SQL window.
MemberActually, I disagree with you peterlaursen on this issue! I prefer to use one application, or at least one set of applications (set=apps created by same vendor) to perform all tasks regarding MySql! I don't want to launch MySqlAdministrator every time just because I want grant or revoke rights, ad or delete users.
MemberPerhaps you tried to export an empty table!
MemberHave you ever tried issuing a HELP “update”; command from SQL window? Hint: view results as text data! Although it is not as complete as the above mentioned help, but still it's quite useful!
MemberIf you are implementing a POS application, then I would use MySql's built-in replication capabilities as they offer continous sync and recovery options.
MemberThis arror may be well related to you using MySql v5.0.4. 5 series is marked beta therefore lot of changes should be expected!
MemberAt first I would be delighted if SQLyog supported “new” privileges introduced in MySql 4.1…
If you want to see a well designed UI, then download EMS MySql manager from Internet. Its GUI is far superior to SQLyog, but it is a bit buggy. I must admit, very buggy, at least on W2K…
MemberIn the old days I commited the mistake of creating an additional index on my pk fields and that adversly affected data sync… You only need to drop the extra, unneeded index in this case!
MemberFor simplicity MySql does not use the term 'CLOB'. MySql has enough field types already.
MemberTill this feature gets implemented use INSERT … SELECT statements to accomplish the same result. Just don't forget to flush privileges afterwards.
MemberPrompting is not really a solution if you sync dbs in which thousands of records get inserted/updated…
MemberCurrently SQLyog does not have a built-in tool for just adding records that are not present in the target database… Of course, you may query the target db to get the list of pks, then query the source db to get entries that are not present in the target db and manually issue the appropriate SQL commands to get them in sync. You can even write a small script to do the job for you.
MemberWell, synchronization means to bring two tables in separate databases (possibly located on separate hosts) with same structure to exactly the same state. The result is, if you change a record in the source db that has a corresponding record in the target db (same pk), then that record will be changed to resemble the source table…
-
AuthorPosts
