Jump to content

stiphu

New Members
  • Posts

    3
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

stiphu's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. There is a folder on my computer as well, with the name of the scheme, calles "measurement1" for example. In this folder, there is the data of the tables, for each table one file with the same name and the ending ".frm". This files are about 9 KB. There is another file, called db.opt, which is 1 KB. I have no idea what this file is about. But the stored data is not in this folder, because I stored about 2 GB data. The file "ibdata1" in the folder "data" is about 2 GB, so I guess the data is there. But thats not what I want, because the data of every scheme is stored in this file. But I wan't seperate folder with the data for every session. So maybe I should try to install an older version of MySQL?!
  2. Hi guys I've got a few questions about mySQL: 1. I made a java interface to store and get data to a mySQL database over matlab. The interface works very well and very fast, if I don't have a lot of data in the tables. But if I have about 500'000 rows in a table, it takes a lot of time to load the data (about 2-3 sec). Is this normal? 2. I don't really get where the data is stored. I use MySQL Server 5.0 version 5.0.24a. I just see that there is a new folder (if i create a new database) with the name of the scheme and the information of the created tables. But where is the data i store? I just got that the file "ibdata1" is much bigger than before, so the data must be there. But I want to create a new scheme anbur this onto a dvd. I need portable data. Is this possible? 3. How can I erase data? I know how to erase a table or a scheme, but the data isn't really erased, because the file "ibdata1" is still the same size. I think this is maybe the same problem like in Nr.2! Looking forward to your answers, thanx for your help, regards Stephan
  3. Hi guys I've got a few questions about mySQL: 1. I made a java interface to store and get data to a mySQL database over matlab. The interface works very well and very fast, if I don't have a lot of data in the tables. But if I have about 500'000 rows in a table, it takes a lot of time to load the data (about 2-3 sec). Is this normal? 2. I don't really get where the data is stored. I use MySQL Server 5.0 version 5.0.24a. I just see that there is a new folder (if i create a new database) with the name of the scheme and the information of the created tables. But where is the data i store? I just got that the file "ibdata1" is much bigger than before, so the data must be there. But I want to create a new scheme anbur this onto a dvd. I need portable data. Is this possible? 3. How can I erase data? I know how to erase a table or a scheme, but the data isn't really erased, because the file "ibdata1" is still the same size. I think this is maybe the same problem like in Nr.2! Looking forward to your answers, thanx for your help, regards Stephan
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.