Forum Replies Created
-
AuthorPosts
-
Shadow
MemberSQLyog is not available on Linux as of now. SQLyog MAX is planned to be released on other platforms than Windows in the upcoming months.
MemberAnd what do you mean by 'updating data' ? Do you mean that after the initial syncronization each attempt fails if you updated any record in DB located on the PDA?
MemberAre you behind a firewall or is your MySql db located on a server hosted by an ISP? If yes, you may encounter problems connecting to your db.
If you use firewall, then you have to tunnel SQLyog, it's been discussed extensively in this forum.
If you have an ISP hosted MySql server, then you'll have to ask your ISP to allow remote access to your db (PHPMyAdmin runs locally!!!!).
MemberThis parameter restricts the size of data affected by a single insert or update statement. If you try to upload a 1MB jpg picture to your db, but your max_allowed_packet is set to 512KB then the attempt will fail. Set this parameter to the largest possible insert/update size (or to the largest WANTED insert/update size).
MemberPerhaps you could check out the “Can't connect to [local] MySQL server Error” part of the manual. Hope, it helps!
MemberIn this case, unfortunately, I cannot be of any help, as I don't have access to any Linux based computers running MySql…
MemberJalrond: Did you try to replace 20040610115204 with 2004-06-10 11:52:04?
MemberWell, you could create a little script that modifies the XML file generated by sja by adding the desired date to
node. You may use XML APIs (DOM, SAX), or just simply open it as a text file and insert the content. If you want to use the date/time when the sync job is executed, then use CURDATE(), CURTIME(), or NOW() functions of MySql in the WHERE clause.
MemberAs I said before, sja is currently unable to sync tables without a PK. I know no hack or workaround. It is up to Ritesh to incorporate a new feature. He argues that you cannot tell which record gets updated in a table without PK as there may be multiple rows holding the same values.
You should consider using MySql's built-in replication feature, that won't mind about PKs.
MemberI would say that the definition of the synced tables are not exactly the same in the source and the target servers.
MemberSja has nothing to do with the first problem, it's XML specific. < and > (and others) characters have special meaning in XML, therefore they must be escaped. < must be written as < and > as >.
You should describe the second problem in a greater detail! Does sja return any error messages? Any modification done to the dbs?
MemberLet's make a point clear: MySql is a database server and not a language. SQL is the accepted standard language for manipulating relational databases, including, but not limited to MySql. MySql implements a subset of SQL and extends the language with special functions.
There are several tutorials and book available online that deal with SQL and data modelling in general. SQLyog may help you if you decide to use MySql to learn SQL as it provides an GUI for editing SQL statements (and a lot more, but you won't need most of its features in the near future).
MemberPerhaps you could describe your problem in a greater detail. At first sight I would say that 207.176.202.85 does not have any MySql servers running.
MemberThe correct MySql host name is either the IP address or the FULL NAME of the computer running MySql server. If MySql is provided by an ISP, then ask them for details. If you run it yourself, then check out your OS' manual how to find the full name or IP address of that machine.
MemberSupport for MySql stored procedures are planned for SQLyog MAX. v3.7 however is capable of connecting to MySql 5.0, but it does not offer any GUI tool for accessing stored procs, you have to deal with them using the SQL window.
-
AuthorPosts
