Questions tagged [frm]

FRM is a file extension for formatting used with MySQL. Contains the formatting information or structure data for a MySQL database; specifies the tables stored in the database and defines the fields and structure of each table.

About FRM

FRM is a file extension for formatting used with MySQL. Contains the formatting information or structure data for a database; specifies the tables stored in the database and defines the fields and structure of each table.

FRM files are saved along with an .MYD file, which contains the actual data stored in the database. Both files are necessary for MySQL to recognize the database. If the MySQL database uses MyISAM tables, an .MYI file is also used and required.

FRM extension for files are used for more applications. These files contain forms that have been created by a variety of software applications. The forms are used to define the fields within a table and to store data within a database. MySQL, Microsoft Visual Basic, Corel WordPerfect, iBlaze and MYOB are some of the applications that use the .frm file extension for form file purposes.

The FRM file extension is also used by the PhotoFrame software application. This program uses the .frm file suffix for picture image files.

Files that contain the .frm file suffix are also used by the Corel Painter software application. This program uses the FRM files for frame stack files.

25 questions
23
votes
3 answers

How do you deal with Visual Basic 6.0 frm and frx files in source control?

This is always a pain, no matter what source control system I have used (Visual SourceSafe, CVS, ClearCase, etc.). The binary .frx files always cause a problem when merging Visual Basic forms. I know...I know...why are you using Visual…
Andy Slater
  • 231
  • 1
  • 2
  • 4
3
votes
6 answers

VB6 silently deleting huge chunks of control data from forms

My project has maybe 130 controls (total of all labels, textboxes, etc.) in an SSTab (4 tabs). The project loads fine, it runs fine, I don't see a single error or warning at any point, but when I save the form with the SStab on it, the SStab data…
Fred Hamilton
  • 697
  • 3
  • 9
  • 22
3
votes
0 answers

Starting the spawned server on port XXXX ... ERROR: Spawn server operation failed

I am using MySQL Utilities to recover a table schema from .frm file. Every time I run mysqlfrm command in default mode, I get this message: Starting the spawned server on port XXXX ... ERROR: Spawn server operation failed. To diagnose, run the…
2
votes
2 answers

Why would a VB6 .frm file ever be full of binary?

I am sorting out some .frm files in a VB6 project. I have found some of them are full of binary data. Clearly these wouldn't compile and I discovered that they are not being referenced by the project but are just sitting in the project folder…
CJ7
  • 22,579
  • 65
  • 193
  • 321
1
vote
1 answer

Frm file location

Very new to mySQL and databases in general. I don't understand what files I will need to transfer to my website after creating a schema in mySQL Workbench. I read that tables are stored as frm files but after creating my first schema and a table…
1
vote
2 answers

cant find a frm file when trying to import data into mySql

I am trying to import English wikipedia dump into MySQL so I can use the JWPL library to work with it. I installed MySSQ, created a database named wikidump, ran a sql script that created the needed tables, and tried to run the following import…
Roi Ronn
  • 55
  • 1
  • 8
1
vote
0 answers

Fast copy of mysql database gets error

I need to copy over a large mysql database with myisam tables. The fastest way for me to do it is by copying over the mysql/data directory. The .MYI and .MYD files copy over smoothly. However, copying the .frm file is causing mysql to show an error…
Shlomo
  • 43
  • 1
  • 6
1
vote
1 answer

How can I connect to DashDB with Slick?

I have a Scala Play application running on Bluemix. We decided to try DashDB (we were on DB2 before). The application uses the freeslick plugin for connection to DB2 which worked fine. It also seems to partly work (SELECT queries work, UPDATE not)…
John
  • 4,786
  • 8
  • 35
  • 44
1
vote
2 answers

How can I recover MySQL tables from data files?

I've got a database (all MyISAM tables) and the machine where MySQL was running is no longer bootable. However, we have all the MySQL data files from the data directory. How can I restore the data from the MYD and FRM files, or whatever other files…
Josh
  • 7,232
  • 8
  • 48
  • 75
1
vote
1 answer

slick 3 mapping custom fields

I have case class with a lot of fields case class H( id: Int, min: Option[String] = None, max: Option[String] = None, step:…
initmax
  • 395
  • 2
  • 10
1
vote
1 answer

MySQL - able to access database after deleting .frm and .ibd files

I have a MySQL server which is running with out any error. Accidentally i removed all .ibd and .frm files. But server is not throwing any error. It continue data insert and all operations even using command line. I found that its using ibdata files…
KJP
  • 11
  • 2
1
vote
3 answers

Take a word from a file and then the next word. C#

I need some advice here. I am making an application to get a particular SQL statement within a VB Form but do not know which would be the best option to do so. For example i have this sentence on to explain: FROM sys.master_files WITH…
1
vote
1 answer

Type mismatch in slick query

I'm new to Scala. I'm getting type errors when I try do following. WHy my findByUUID method is wrong? case class User (token: String, email: String) { } class Users(tag: Tag) extends Table[User](tag, "USERS") { def email =…
Fishman
  • 1,737
  • 1
  • 25
  • 42
1
vote
1 answer

Restore tables and DBs from frm file and

Im trying to restore my Databases by frm files and ibdata1 that I did backup; I simply copy all of the files in mysql/data (which include different databases as folders which have .frm files for each single table and some other files in the "…
Shima Mdz
  • 185
  • 1
  • 5
  • 18
0
votes
1 answer

Restore table from .frm and .ibd file?

I've some ibd and frm files. Now I want to import those into mysql database. But its not working. I tried with mysqlfrm but it showing C:\xampp\mysql\data\example>mysqlfrm --diagnostic -vvv users.frm # WARNING: Cannot generate character set or…
1
2