Forum Replies Created
-
AuthorPosts
-
ShadowMember
Sorry, must have overlooked something in your first post. Never mind about your PHP scripts, as they run locally on the ISP's servers.
Ask your provider if they allow direct connections to be made to their MySql server and if yes, then what parameters must be used. Many ISPs do not allow remote connections… As far as I'm concerned, HTTP tunneling cannot be used with SJA yet. (Ritesh may correct me on this issue if I don't figure it out myself)
ShadowMemberIt is up to your ISP to answer this question! Do you have any “traditional” PHP scripts running that use MySql backend? If yes, then check out the connection parameters and enter the same in the config file.
ShadowMemberIf we stick to SQLyog, then the “Database Syncronizaion Wizard” is the righttool for you. SQLyog uses a separete executable (sja.exe) to perform these tasks. You can determine from which db to which db do you want to perform the sync, you may add criteria to restric unneeded data flow, and sync sessions can be scheduled via Win's built-in scheduler.
Its greates advantage is, that you have a “live” copy of the data. A cach is that the target database must conform to the source one (at least the synced tables must match).
SQLyog does not offer any more backup techniques that could be scheduled. Of course, you may use Win's scheduler to launch for example mysqldump in a predetermined time.
If you use CSV as a backup format, then you'll have to store the SQL statements responsible for creting the tables elsewhere, thus reducing the required storage place, but complicating the db maintenance (just imagine that you change the structure of your db, but forget to commit these changes to the SQL scripts in the backup). SQL format, however, uses complete SQL statements that create the tables and insert data. MySqlAdministrator offers an interface to schedule such backups.
ShadowMemberIn case of HTTP tunneling a warning pops up if you enter a host name different from 'localhos' as this is the correct setting most of the time (in your case it is not so). If no error message is displayed, then the connection can be made. Have you tried to click on 'test connection' button?
ShadowMemberNo, as HTTP tunneling feature is introduced in 4.0. If you want to take advantage of HTTP or SSH tunneling, then 4.0 betas must be used.
ShadowMemberTheorectically MySql changes every CHAR column to VARCHAR that exceed 3 characters in length. Are you sure it's not just a display error?
ShadowMemberHope, you put those semicolons back before executing a mass INSERT…
ShadowMemberTo Ritesh: “Type” keyword is deprecated as of 4.1.4, “Engine” must be used instead.
ShadowMemberYes, as long as you provide a correct SQL statement that invokes the stored procedure (CALL…).
ShadowMemberBecause SQLyog stores the position of the window in its ini file, but not the fact that it was maximized. The difference is hardly noticable…
ShadowMemberAre you trying to delete “duplicate information” via your own SQL statements or via SQLyog's GUI? The first error you described happens if you want to create fulltext index on any column in an InnoDB table.
ShadowMemberYes, it's a known bug.
Now I see that Ritesh was faster…
ShadowMemberSQLyog should display a message box in case of failing to create the FK. Did you check those possible reasons?
ShadowMemberI don't think this error message is related to the separators, but to the contents of the CSV file. See this, for example. It would be helpful if you could paste at least some records from that csv file. Have you tried to execute a SHOW WARNINGS command after the failed import?
ShadowMemberMAX is still planed to be multiplatform, v4.0, however, will be available only on Windows.
-
AuthorPosts