Default File Location?

[newsqlyog]

I am just getting started using SQLyog and am able to create a database, table and data. However, where is the data being stored? How can I copy this data to an external drive (USB or floppy)?

[peterlaursen]

Please understand that SQLyog is a (MySQL) database client. It is the MySQL server that stores data – not SQLyog. SQLyog only sends instruction (SQL) to the server. Where MySQL stores its data depends but basically:

1) on Windows it is normally in the data folder under the MySQL (not SQLyog!) installation folder

2) on Linux common places are /var/lib/mysql and /temp/mysql

3) but you can specify a /datadir in MySQL configuration

4) with mySQL 5.1 and partitioned tables you can use the 'DATA DIRECTORY' clause to specify a storage position for each partition.

Now are you connecting to MySQL on your local machine or a remote server? Data are stored where the server is running!

How MySQL stores its data depends on the Storage Engine (table type). With the 'traditional' MyISAM tables there is a .MYD (data) a .MYI (indexes) and a .frm (definitions) file for each table. With InnoDB tables all the data of all databases and tables are normally stored in a single file (however in MySQL configuration you CAN specify that each table should be stored in its own file – also with InnoD:cool:. With MySQL 5.1.x we have a lot of new Storage Engine. They each use their type of storage.

A DATABASE SERVER like MySQL is not at all comparable with an Office-type database like Access, Dbase or Paradox. Do not think of data as 'files' but as 'server entities' instead!

And

Quote:

How can I copy this data to an external drive (USB or floppy)?

You EXPORT data (right-click a table from SQLyog). Normally to a SQL-file. DATA ar then imbedded into INSERT SQL-statements, like

Code:

INSERT INTO yourtable (column_1,column_2 … column_n) values (…………………………….);

there may also be CREATE statements and other statements in such files.

To import your data (to the same or another server) you EXECUTE the SQL-file. From SQLyog menu: tools …

You can also export to .CSV and .XML formats.

[Author]

Posts