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

basic questions

forums › forums › SQLyog › Using SQLyog › basic questions

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • February 19, 2004 at 5:41 am #8335
      octi
      Member

      Hi! Someone recommended this software on another forum, so I came over here to learn more about it, but still have some basic questions.

      1)How is this software different from something like phpMyAdmin? From what I can tell, it seems similar but it gets installed and ran on a persons home computer, not on the server.

      2)Can I load data from a tab delimited text file (or something similar) into a MySQL database with this? If so, how does it do this? My host has the commands 'LOAD DATA INFILE' (and I think 'LOAD DATA INFILE LOCAL', or something like that also) disabled. Because of this I have not been able to use phpMyAdmin to get files loaded into a database, since phpMyAdmin uses this same command to do it. Does SQLyog load data into a db differently or the same way?

      Sorry if these questions have been asked previously, I looked around and didn't see anything like it.

      Thanks!

    • February 19, 2004 at 12:51 pm #15492
      Shadow
      Member

      1). You mentioned an important difference between the two products, SQLyog runs on your machine, not on a remote server. Besides having the basic administrative functions (user, db, table management…), SQLyog has several additional features.

      It lets you synchronize the structure or the data of two dbs, import data from ODBC sources, drop foreign keys, create a schema for a db in HTML. Moreover, you can even schedule the sync operations.

      2). SQLyog uses the LOAD DATA INFILE command to import text files as well (which won't work in your case), but you may create an ODBC data source from that CSV file and use the ODBC import instead of text file import.

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.