Forum Replies Created
-
AuthorPosts
-
Shadow
MemberSorry, 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)
Shadow
MemberIt 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.
Shadow
MemberIf 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.
Shadow
MemberIn 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?
Shadow
MemberNo, 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.
Shadow
MemberTheorectically MySql changes every CHAR column to VARCHAR that exceed 3 characters in length. Are you sure it's not just a display error?
Shadow
MemberHope, you put those semicolons back before executing a mass INSERT…
Shadow
MemberTo Ritesh: “Type” keyword is deprecated as of 4.1.4, “Engine” must be used instead.
Shadow
MemberYes, as long as you provide a correct SQL statement that invokes the stored procedure (CALL…).
Shadow
MemberBecause SQLyog stores the position of the window in its ini file, but not the fact that it was maximized. The difference is hardly noticable…
Shadow
MemberAre 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.
Shadow
MemberYes, it's a known bug.
Now I see that Ritesh was faster…
Shadow
MemberSQLyog should display a message box in case of failing to create the FK. Did you check those possible reasons?
Shadow
MemberI 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?
Shadow
MemberMAX is still planed to be multiplatform, v4.0, however, will be available only on Windows.
-
AuthorPosts