Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forum Replies Created

Viewing 15 posts - 151 through 165 (of 642 total)
  • Author
    Posts
  • in reply to: Cannot connect to ISP mysql #16391
    Shadow
    Member

    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)

    in reply to: Cannot connect to ISP mysql #16389
    Shadow
    Member

    It 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.

    in reply to: The best backup stratergy #16388
    Shadow
    Member

    If 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.

    in reply to: Bug in HTTP Tunnel? #16381
    Shadow
    Member

    In 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?

    in reply to: Error 2003 #16387
    Shadow
    Member

    No, 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.

    in reply to: Problem with "Copy Table Structure / Data" #16372
    Shadow
    Member

    Theorectically MySql changes every CHAR column to VARCHAR that exceed 3 characters in length. Are you sure it's not just a display error?

    in reply to: INSERT Acting Oddly #16370
    Shadow
    Member

    Hope, you put those semicolons back before executing a mass INSERT…

    in reply to: alter table problems #16345
    Shadow
    Member

    To Ritesh: “Type” keyword is deprecated as of 4.1.4, “Engine” must be used instead.

    in reply to: Use script to export file #16351
    Shadow
    Member

    Yes, as long as you provide a correct SQL statement that invokes the stored procedure (CALL…).

    in reply to: Remember window maximized #16339
    Shadow
    Member

    Because SQLyog stores the position of the window in its ini file, but not the fact that it was maximized. The difference is hardly noticable…

    in reply to: cannot delete foreign keys #16334
    Shadow
    Member

    Are 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.

    in reply to: Foreign Keys not being created #16331
    Shadow
    Member

    Yes, it's a known bug.

    Now I see that Ritesh was faster…

    in reply to: Foreign Keys not being created #16328
    Shadow
    Member

    SQLyog should display a message box in case of failing to create the FK. Did you check those possible reasons?

    in reply to: ERROR 1031 #16316
    Shadow
    Member

    I 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?

    in reply to: SQLYog Max #16318
    Shadow
    Member

    MAX is still planed to be multiplatform, v4.0, however, will be available only on Windows.

Viewing 15 posts - 151 through 165 (of 642 total)