Current Page: 1 of 1
Results 1 - 7 of 7
14 years ago
ct_privy
ok, I understand that I should put the tablename folders back to the original version of MySQL (ver 5.0) that they came from, but that means that I will not have tablename folders (with the .frm files and db.opt) in the data folder of the MySQL (ver 5.1.30) that I work from. you say I "have to export the db and reimport them". will exporting and reimporting the db recover the miss
Forum: WampServer English
14 years ago
ct_privy
yes, I am the right user for that db. I did install another version of MySQL5.0 previously, and what I did do was take the tablename folders from the 5.0 version and copy them into the 5.1.30 version that I was using. I did this after I noticed that the 5.1.30 folder did not have the tablename folders with the .frm and db.opt files. The version that I work from is 5.1.30 (that was instal
Forum: WampServer English
14 years ago
ct_privy
it looks like .myd and .myi files are the ones I am missing. they are not in my recycle bin. is there a way to work around this? (the db.opt is 1KB and the .frm files are 9KB and all located in the database-named folder). Thanks.
Forum: WampServer English
14 years ago
ct_privy
I inadvertently deleted some files I needed to access four tables I created with the innoDB storage engine. I can open the database in myphpadmin, but I cannot access the tables in myphpadmin even though there is a (4) next to the database name on the lelft side indicating the four tables. In the folder I have the .frm files, an ibdata file, and INDEX file, and two logfiles, I just need to know
Forum: WampServer English
14 years ago
ct_privy
I found the .frm files of the table (actually of the tables) I created. I found this in another version of MYSQL (5.0) which is outside the WAMP Suite that I run (using MySQL 5.1.30). The question of why the tables would be found in this older version is of interest but of less importance right now than the fact that I did find the .frm files. After putting said .frm files into the C:\wamp\
Forum: WampServer English
14 years ago
ct_privy
Thanks for your response. What are the names of the 3 files needed in order for each table to work/be seen? It's most likely one of these three that I inadvertently deleted. Also, could you point me to a webpage that steps through the process of switching from innodb engine to MyISAM?
Forum: WampServer English
14 years ago
ct_privy
The phpMyAdmin application I use often no longer sees the 'plants' database that I created. I believe this is due to having inadvertently deleted part of the MySQL folder (5.1.30) yesterday. However I think the data and possibly the tables are still in tact within the file 'ibdata1'. Therefore I feel like I didn't delete the data, just the program's ability to see the data. I am very mu
Forum: WampServer English
Current Page: 1 of 1