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

Forum Replies Created

Viewing 15 posts - 2,476 through 2,490 (of 2,527 total)
1 2 3 … 165 166 167 168 169
  • Author
    Posts
  • February 14, 2003 at 3:07 pm in reply to: Export/Import #13738
    Ritesh
    Member
    Quote:
    So SQLyog don't support the “Export to another Database” and “Export to another Host/DB” option.

    SQLyog does have the option. Select the database and choose Copy Database… option from the Popup menu. It allows you to copy the database into another host/db.

    Quote:
    Then I notice that the SQLEditor doesn't have the save/load to file functions. It's only

    You can do that. Choose File->Open… and File->Save… option.

    Quote:
    After a big data import test with executing a batch script file I notice that it

    Can you tell us your config and the file size? Under all our test condition, SQLyog has been found to execute query in Batch File faster then other Front ends.

    Hope it helps.

    February 14, 2003 at 1:53 pm in reply to: InnoDB #13725
    Ritesh
    Member

    Make sure that the correct MySQL Server is running. To enable InnoDB with MySQL, you need to run mysqld-max-nt and not mysqld.

    Also, you need to tweak a little the my.ini file. More information can be found in the MySQL Docs.

    February 12, 2003 at 6:02 pm in reply to: version 3.02 problem #13719
    Ritesh
    Member

    I have already replied to a similar post by you at Comments Forum

    February 12, 2003 at 5:58 pm in reply to: Sorting Data #13711
    Ritesh
    Member

    SQLyog has been designed for remote administration. There if we keep on executing queries, we lose out in the efficiency part.

    Also, the result can be send by a complex query where inserting ORDER BY clause at the end may cause an error and is also nt feasible.

    February 12, 2003 at 5:34 am in reply to: ODBC for dummies #13707
    Ritesh
    Member

    Are you sure you have created a correct DSN? Which version of Access you are using.

    Will it be possible to send us your .mdb file so that we can work on our side? If so then mail it to [email protected]

    February 12, 2003 at 4:52 am in reply to: ODBC for dummies #13705
    Ritesh
    Member
    Quote:
    I just installed SQLyog, clicked the icon SQLyog. I believe this to be the control panel but i fail to find the administrative tools. Is it hidden?

    What type of administrative tool you are talking about?

    February 12, 2003 at 4:44 am in reply to: Please add forms #13718
    Ritesh
    Member

    This is in our TO-DO list for one of major future releases.

    February 11, 2003 at 9:21 pm in reply to: Great software, only one thing about the ODBC #13689
    Ritesh
    Member
    Quote:
    My question is: why there is so big different?

    ODBC Import is done in three steps.

    • Retrieving the data from the source

    • Creating insert statement

    • Inserting the data in target datasource

    Quote:
    on the other hand, when i import mysql database into Access 2000 in the Access 2000, it just takes me severl mintus (same size).

    It might be that when we are retrieving data from Access, Access is taking more time then MySQL to parse the query and return the data whereas MySQL is doing it ( obviously !!! ) more quickly. Therefore the time difference in importing same amount of data.

    Hope it helps.

    February 11, 2003 at 9:11 pm in reply to: BUG INFO PLEASE #13672
    Ritesh
    Member
    Quote:
    More info on the Bug Fixes would be nice, I had some data loss after I hit done on the update table area. Is this the bug that was fixed in 302?

    Sorry, for the late reply. The bug was fixed in SQLyog 3.02

    February 11, 2003 at 8:58 pm in reply to: Simple ? How do i connect remotely? #13714
    Ritesh
    Member

    SQLyog has been specially designed to work on remote connections.

    In the connection dialog box just give your Remote MySQL server details instead of Localhost details.

    February 11, 2003 at 5:52 pm in reply to: Sorting Data #13709
    Ritesh
    Member
    Quote:
    I verified that using “order by” it's really fast so , sometimes is better make a new select than click in a column to get it sorted.

    Is that right or am I doing something wrong?

    😀 There is nothing wrong. When you use ORDER BY syntax the data is sorted by MySQL in the server side which uses a different mechanism. While when you click on a column header, the sorting is done on client side with a different mechanism.

    February 11, 2003 at 5:43 pm in reply to: Insert/Update Data #13698
    Ritesh
    Member

    😮 Its difficult to tell anything from the query. Do you find any error in the query?

    If so, then please send the table with its structure and data to [email protected] so that we can work on the problem.

    Step by step operation to reproduce the error will be appreciated.

    February 11, 2003 at 5:41 pm in reply to: importing datetime from M$ SQL Server 2K #13713
    Ritesh
    Member

    We are working on how SQL Server keeps datatime data.

    I will post back withing 24 hrs.

    February 11, 2003 at 5:40 pm in reply to: ODBC for dummies #13703
    Ritesh
    Member
    Quote:
    Hi to all that have a heart for an absolute ODBC-newby !

    SQLyog was made so that new-bies can take advantage of MySQL.

    Go to control panel and search for administrative tools. There will be an option Data Source ( ODBC ). Double click on it.

    Go to the System DSN tab. Create a new DSN by clicking on Add… button. In the list you will find all the datasources installed on your system. Select ACCESS.

    From ODBC Microsoft Access Setup….select proper options and your DSN will be created.

    Hope it helps.

    February 11, 2003 at 1:27 pm in reply to: Insert/Update Data #13696
    Ritesh
    Member

    What is the the structure of the table you are updating the table. Please check the SQL which SQLyog generates in the history tab. Is it what you expect?

    Many a times MySQL does internal conversion of data to make it correct.

  • Author
    Posts
Viewing 15 posts - 2,476 through 2,490 (of 2,527 total)
1 2 3 … 165 166 167 168 169