Nov 21, 2009

Recover Tables From A MySQL .frm File

 		free web hosting
Open Discussion & Free Web Hosting > Computers & Tech > Databases

Recover Tables From A MySQL .frm File

warriors
May 9 2005, 10:13 AM
I have a couple of .frm files with no corresponding data or index files. Is it possible to recover the table structure (field names, types, sizes, rows,col, etc) from these files? The table type is innodb

Comment/Reply (w/o sign-up)

miCRoSCoPiC^eaRthLinG
May 9 2005, 02:17 PM
Here's a page from the MySQL manual that might help you solve your problem: http://dev.mysql.com/doc/mysql/en/backing-up.html

I'm not too sure whether you can do it just on the basis of .frm files - do you have the .ibd files or ibdata file with them too ? If you have those the process becomes far easier... Read that page and see if it helps - and if it does, please come back here and make a post on what you did to solve your problem. That'll certainly be very helpful for all of us..

Thanks & Regards,
m^e

Comment/Reply (w/o sign-up)

warriors
May 9 2005, 02:26 PM
i don't have the .ibd files or ibdata file. i only have the .frm files.

Comment/Reply (w/o sign-up)

oncombeureum
May 10 2005, 02:27 AM
.frm is a table created by mysql.
you can fine in there a series of field but no guarantee the data itself.

in order to rebuild the database using only .frm.

i think you should do it manualy then.

QUOTE
MySQL will always create a `.frm' file to hold the table and column definitions. The table's index and data will be stored in one or more other files, depending on the table type.


QUOTE
MySQL stores its data dictionary information of tables in `.frm' files in database directories. But every InnoDB type table also has its own entry in InnoDB internal data dictionaries inside the tablespace. When MySQL drops a table or a database, it has to delete both a `.frm' file or files, and the corresponding entries inside the InnoDB data dictionary. This is the reason why you cannot move InnoDB tables between databases simply by moving the `.frm' files, and why DROP DATABASE did not work for InnoDB type tables in MySQL versions <= 3.23.43.


further you should read at:

mysql

Oncom Beureum
The Best Place in the City

 

 

 


Comment/Reply (w/o sign-up)

warriors
May 10 2005, 05:24 AM
well seems like theres no way. tks anyway

Comment/Reply (w/o sign-up)

Luiz Pestana
Jun 6 2008, 08:08 PM
QUOTE(warriors @ May 10 2005, 02:24 AM) *
well seems like theres no way. tks anyway


Hi, i found way to restore innodb with only .frm files. rolleyes.gif

First create a database to restore and create the tables with same name of XXX.frm files (with one field, only to create the .frm files);
After, stop mysql service and replace the created .frm files with saved .frm files;
Finally, start mysql service and see, the tables are replaced with old columns, but sure, without data.

I hope it help.
Luiz Pestana

Comment/Reply (w/o sign-up)

FeedBacker
Jun 6 2008, 07:52 PM
Restoring with only .frm
Recover Tables From A MySQL .frm File

Replying to warriors

Hi, I found way to restore innodb with only .Frm files.

First create a database to restore and create the tables with same name of XXX.Frm files (with one field, only to create the .Frm files);
After, stop mysql service and replace the created .Frm files with saved .Frm files;
Finally, start mysql service and see, the tables are replaced with old columns, but sure, without data.

I hope it help.
Luiz Pestana

-reply by Luiz Pestana

Comment/Reply (w/o sign-up)

iGuest-can
Jul 20 2008, 09:28 AM
Recover Tables From A MySQL .frm File
Recover Tables From A MySQL .frm File

Feedback for Luiz Pestana's reply:

Tried it and doesn't work. Mysqld-nt crashes when you try to access the db and the tables,

Sorry

Comment/Reply (w/o sign-up)

iGuest-Manoj Kumar
Aug 6 2008, 09:00 AM
Replying to Luiz Pestana
Recover Tables From A MySQL .frm File

Hi,

The Procedure provided by you to retrive the data from .Frm as worked very well and the Table Structure as been restored not the Data

But No Issues

And many Thank's for the Solution

-reply by Manoj Kumar

Comment/Reply (w/o sign-up)

(G)Hilda
May 6 2009, 07:46 AM
importing data
Recover Tables From A MySQL .frm File

I am trying to import sql file on the mysql server nothing is happening. Instead I just copy the data from Mysql Folder from another to the server and when Itry to open the database I am getting this error SQL show index from `mbw_components` failed : Incorrect information in file: './db-rtsa-1/mbw_components.Frm' Please help. -question by Hilda

 


Comment/Reply (w/o sign-up)

Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.
Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

This textarea will convert to Rich-Text automatically (IE, Firefox, Chrome)

Similar Topics

Keywords : recover, tables, mysql, frm, file

  1. Login System
    I want to make a login system using Mysql. I am amateur in these thing (12)
  2. Mysql Overhead
    (3)
    Sometimes in a table especially if i do alot of things in it i start seeing overhead then a size
    near it? what is overhead? and is it essential to optimize the table to fix it? I know its just a
    press of a button but i'd like to know what happens when i optimize a table. Also when you make
    a new table you can limit the size of VARCHAR to a number, that number would be the number
    characters allowed in that column per entry. I'd like to know how the limit works for texts, is
    it in KB? or number of characters? Cuz i made a messaging system. And i remember reading s....
  3. Mysql Multiple Tables
    (3)
    It is good practice to use multiple tables to sort out big amounts of data. But once you do that it
    becomes increasingly hard to cross reference the tables. Mysql has a little beautiful command
    structure that they have added. You can select multiple tables within one sql query. Example of a
    basic sql query CODE $sql = "SELECT * FROM table WHERE row=1"; If you noticed that I selected
    all of the rows in the table. Normally you will try to not select the entire table from the database
    unless you absolutely want all of the table. I would recommend against it; just gra....
  4. Any Website Provide Free Host Mysql Host?
    (4)
    any website provide free host mysql host? i need it because i am using 000webhost.com now but it
    only provide 2 mysql database... can i know where or how can i get more databases regards....
  5. Mysql On Computer
    XD (9)
    I posted PHP on computer? , but for some reason it doesn't show :/. Anyways I am wondering if
    there is MYSQL on my computer, meaning can i make a data base on my computer? that way i make what i
    want and upload it when i get hosted =)....
  6. Mysql Database Entry By Excel Sheets
    (2)
    Hello .. I would like to ask if i can use use Microsoft excel files in order to make entries to
    mysql database. Thanks....
  7. Mysql Database Management
    (1)
    Hi i am new, I have a problem in understanding the query decomposition in D-DB. Can anyone help me
    to understand the first question of the exercise 25.21 of Elmasri-Navath 4th edition? Consider the
    following relations: BOOKS (Book#, Primary_author, Topic, Total_stock, $price) BOOKSTORE (Store#,
    City, State, Zip, Inventory_value) STOCK (Store#, Book#, Qty) Consider a distributed database for a
    bookstore chain called National Books with 3 sites called EAST, MIDDLE, and WEST. Consider that
    BOOKS are fragmented by $price amounts into: B1:BOOK1:up to $20. B2:BOOK2:from ....
  8. Mysql And User File_priv
    (0)
    HI, I've hit the grain while trying to import file to mysql database - I need to enable file
    permissions of the database user but this seems not possible with most of the hosting providers.
    The problem is to set file_priv of the database user to "Y" . This is done in the "user" table of
    the maintanance database named "mysql". cPanel doesn't allow this. Via the cPanel you can only
    allow privileges on table querries but you cannot grant host file privileges to the database user -
    which makes querries like: "LOAD DATA INFILE 'filename' INTO TABLE tablen....
  9. I Have An Error With My Mysql Connection
    mysql connection error (7)
    ok so here's my web page... http://lacrossems.t35.org/ it only lags cause its trying to
    connect to the my sql server...i followed this guide
    http://forum.ragezone.com/showthread.php?t=387249 and when i edit my config.php to my host and
    login info i always get the error cannot connect to the database here is my config.php if you can
    help me CODE $host = 'CENSORED';                // my host $host =
    'righto';       // my database username $host = 'CENSORED';   // my database
    password $host = 'odinms';       // my datab....
  10. Mysql Backup With Another Address?
    (4)
    I just got my site hacked!! (don't worry because it is not on astahost) Actually it is a
    wordpress blog. So I backed up my MySQL Databases with cpanel. Now when I get my hosting approved
    here at astahost, can I restore those backups? Is the change of the site address going to interfere
    with this? Is there anyway I can edit those databases to work with my new address? Please help me
    out here!....
  11. Mysql - So Hard
    Come in here if you think MySQL is soo hard! (14)
    Doesn't anybody think MySQL is so hard to code? I mean think about it, you need loads of
    databases just for one little script and you have to type things in like ;Host-Username:
    (blahblah) ;Host-Password: (blahblah) ;Host-DatabaseName: (blahblah) Ok, that MySQL code was
    random, and it is alot harder than that. If you have expierenced it being hard, you are free to
    post right in here, mate.....
  12. Login System Using A Mysql Db
    How do i do this? (5)
    Hi guys, ive got a registration system that looks something like the one below: Firstname:
    Lastname: Then i have inset.php, which looks like the following: $con =
    mysql_connect("localhost","autobot","abc123"); if (!$con) { die('Could not connect: ' .
    mysql_error()); }mysql_select_db("my_db", $con);$sql="INSERT INTO person (username, password) VALUES
    ('$_POST ','$_POST ')";if (!mysql_query($sql,$con)) { die('Error: ' .
    mysql_error()); } echo "1 record added";mysql_close($con) ?> Now my question is, how do i creat....
  13. Mysql And Php
    When trying to install Joomla (16)
    I don't know if this is the correct forum, but here is my question: I'm trying to test
    Joomla and some forums in my computer, I have already installed MySQL with the GUI tools, Apache,
    and PHP with the MySQL and MySQLi extensions, but when I'm trying to install Joomla I get this
    error: Required Settings Check: ------------------------------------- PHP version >= 4.1.0
    Yes - zlib compression support Available - XML support Available - MySQL support
    Unavailable configuration.php Writeable Session save path Unwriteable Not ....
  14. Can't Import Backup Sql File To Localhost
    (11)
    Hi, I downloaded a backup of my forum database and wanted to import it on my computer locally for
    testing purposes. This has always worked for me in the past, but I'm having some problems with
    it lately. I'm backing up my database via phpMyAdmin->Database->Export->Select All and
    downloaded as a .gz file. I'm using Windows XP Home with WAMP installed, so it has MySQL built
    in. It's version 5.0.27. I ran all the services and at the prompt typed in: mysql -u root -p
    backup.sql > testDB My root account in WAMP has no password, so when it prompts for a ....
  15. Navcat For MySQL
    is Navcat any good? (9)
    Hello all, i ve recently come across NavCat (GUI tool) for MySQL. I have not bought a copy yet, just
    played around with the demo. Has any one used it beore, if so please let me know if its worth
    buying. I already have PhpMyadmin, Just wanna know if NavCat is better than PhpMyAdmin in usibility
    and functionality. Regards....
  16. Is It A Good Practice To Store Image Or Other Binary Files Directly In A Mysql Database
    (6)
    Hello to all of you beautifull people out there, I am new to MySQL, i just wanted to know if its a
    good practice to directly store images and other binary files in a MySQL database. Any one with
    help? Thanks....
  17. Read/Write Issues After Copying An Access .mdb File
    (4)
    Alright, I'm currently creating an interface program for a MS Access database. I've only
    used Access once in the past but used other DB's a handful of times so I didn't have any
    trouble getting the general program created. My issue arose when I tried to make it so that the
    users needing to use the program can just copy the .exe and the .mdb files and use it. The program
    doesn't require users to share the database but to store their OWN programs information in their
    OWN database, so basically each needs to have their own database with the exact same d....
  18. MySQL, Multiple Tables
    (27)
    Ok, I'm coding a project which is a leap than what I'd normally do. Before, I've always
    learned ONE table... put EVERYTHING in one database table. I'm making a profile system so there
    needs to be at least two tables: 1 for users, 1 for content. My problem is, how do I link the two
    together? I could probably figure this out faster if someone explained and posted sample SQL code
    that shows how the two are linked together. Thanks!! F....
  19. Updating A Database's Tables
    (11)
    Is there an "easy" way to update a database's tables? Like for instance, I have my own
    custom-coded member login system. Whenever I add a new feature that needs a database, I manually
    have to download, update and upload the database. Is there an easy way I can do this? THANKS!!! F....
  20. How To Restore A Sql.gz File
    (5)
    How do i restore a sql.gz file? Im confused /mellow.gif" style="vertical-align:middle"
    emoid=":mellow:" border="0" alt="mellow.gif" />....
  21. MySQL Output Database Question
    (19)
    I am new to MySql and have just created a database after using a script. My problem is not the
    script, but what it says about putting it into the output file. I cant figure out the right terms
    to put it in, I keep getting errors. I try using; SELECT*FROM 'database name' WHERE
    'location' but it isnt working. I'm lost with this stuff, I really am. Can someone
    please help me out?....
  22. MS-database To MySQL
    I'd like to batch them (6)
    Hi, maybe one of you already came across this, so I ask. I'll continue searching on. I've
    got two vocable trainers, one is Windows-native, the other one is on the web. While I can't
    control the output of the Windows-thing (so I can't export them to a *csv or something), I can
    write an import script. But since I'm not that great with Regular Expressions and don't know
    anything about *.mdb (that is MS SQL, isn't it?) files, I would need some finished thing to make
    out the field information and put it in arrays or something more readable. It wou....
  23. What Are The Alternatives To MySQL
    (7)
    Hi. i'm interested in alternatives to MySql combined with php. what database else can i use to
    create a webbased managment system with a lot of entries. maybe more than mysql can handle fast
    enough. it should be more powerful than mysql and should have nearly the same features. i hope
    there is a webbased administration program like phpmysqladmin thanks for your help ! greetings c.....
  24. Mirror My MySQL Database To Another Mysql Server
    (7)
    Hi..I want to ask if its possible to automatically mirror my mysql databases into another mysql
    server?or create a small php script to do this? The reason is because, we all know that database is
    very improtant if we have dynamic website. I have my forum hosted and i want to automatically
    mirror this or backup into another mysql server(free). Like in freesql.org. So that im not afraid
    that i forgot to backup my database..also i have one central backup database. Thanks for the
    help..Im looking forward for this posibility.....
  25. MySQL Database Problems
    (8)
    My friends have a little forum running here . The problem is that quite often we get the following
    message when we try to open the page: QUOTE Warning: mysql_connect(): Can't connect to
    local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in
    /home/vhosts/rohit.bizhat.com/forums/db/mysql4.php on line 48 Warning: mysql_error(): supplied
    argument is not a valid MySQL-Link resource in /home/vhosts/rohit.bizhat.com/forums/db/mysql4.php on
    line 330 Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in
    /home/vhosts/roh....
  26. Error In Installing MySQL Server
    MySQL server cannot be started (9)
    I try to upgrade my MySQL server from 4.018 to 4.1.10a. Firstly, I downloaded mysql-4.1.10a (not the
    essential one) for win XP Then I install the new version after the old version was uninstalled.
    After the installation process, Instance Configurator comes up to help for the configuration. But an
    error occured when it try to start the MySQL service. Error messageis "cannot create windows
    service for MySQL. Error:0" So my MySQL server cannot be started. It is running win XP on my
    computer. Does anybody can tell me what is wrong?. Thanks (sorry for my bad english)....
  27. How Can I Import Csv Files To My MySQL Database?
    I was able to export but where's import? (3)
    I am having hard times finding that import csv in the mysql phpmyadmin. I once worked on some csv
    files and someone imported it on the mysql server. I was not able to ask him. Does someone know how
    can I import csv files in mysql server?....
  28. MySQL Datetime --> VB.NET Datetime Conversion Prob
    Any solutions ?? (4)
    Hi, Can anyone provide me with a quick example of fetching a MySQL Datetime Field and converting it
    into native VB.NET DateTime format ?? Say for example my db contains a couple of fields: Field1,
    Field2, DateField... one of which is the default MySQL DateTime. Say I'm using the following
    code to connect... CODE ConnectionString = "....." QueryString = "SELECT * FROM SomeTable" Dim
    myConnection As New MySql.Data.MySqlClient.MySqlConnection(ConnectionString) Dim myCommand As New
    MySql.Data.MySqlClient.MySqlCommand(QueryString, myConnection) Dim myReader As MySq....
  29. MySQL Realtime Replication
    how to replicate mysql in realtime (4)
    i dont know if this might be useful to ppl here, but this is a very good knowledge for serious
    siteadmins. while i was digging for mysql backup techniques, i've found that mysql is able to
    do realtime replication. the idea is that there are master server and slave server. both are having
    the same version of mysql installed. the data flows; Master >copy> Slave ( in realtime!)
    you'll never have to manually copy the database file of wasting your time to manually use the
    mysqldump command. here are the links; http://dev.mysql.com/doc/mysql/en/Replication_HOWTO.h....
  30. MySQL - Trouble With Bulk Insert Statements
    (3)
    I'm trying to insert about 500 rows into mysql, but I keep getting errors. If I copy and paste
    too many (about 50) insert statements at a time I get errors sometimes. I sometimes even get errors
    but then the row is skipped so I don't know there was an error (I'm using linux and SSH).
    What's the best way to get my insert statements to put the data in MySQL? Is there anyway that I
    can have it tell me if there where any errors all the statements are executed? Thanks for your
    help.....


      31. Looking for recover, tables, mysql, frm, file

See Also,

*SIMILAR VIDEOS*
Searching Video's for recover, tables, mysql, frm, file
advertisement



Recover Tables From A MySQL .frm File

Affordable Web Hosting, Low cost Web Hosting - ComputingHost.com