.MYD and .MYI is missing

Problems with the Windows version of XAMPP, questions, comments, and anything related.

.MYD and .MYI is missing

Postby gian363 » 26. August 2011 09:34

Everytime I create a database, there's no .MYD and .MYI files included in the folder, so everytime I copy it and paste through another computer, the tables are not visible and it started when I installed the latest version .4, what should I do?
gian363
 
Posts: 4
Joined: 26. August 2011 09:31

Re: .MYD and .MYI is missing

Postby Altrea » 26. August 2011 09:47

Are your sure the databases used MyISAM as Table-Engine and not something else?
It depends on the Engine which and how the files are created.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8294
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: .MYD and .MYI is missing

Postby JonB » 26. August 2011 12:01

so everytime I copy it and paste through another computer


Not exactly a 'best practice' for MySQL = :shock:

Good Luck
:lol:



YSF
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: .MYD and .MYI is missing

Postby gian363 » 27. August 2011 06:04

Altrea wrote:Are your sure the databases used MyISAM as Table-Engine and not something else?
It depends on the Engine which and how the files are created.


I looked at the engines, MyISAM is there
gian363
 
Posts: 4
Joined: 26. August 2011 09:31

Re: .MYD and .MYI is missing

Postby gian363 » 27. August 2011 06:05

JonB wrote:
so everytime I copy it and paste through another computer


Not exactly a 'best practice' for MySQL = :shock:

Good Luck
:lol:



YSF



What's the other way of copying databases? I just use this for my visual basic project, and I'm just a newbie here
gian363
 
Posts: 4
Joined: 26. August 2011 09:31

Re: .MYD and .MYI is missing

Postby JonB » 29. August 2011 14:22

Are you still 'missing the MYISAM data files' for one of your databases? or is that remedied?

About backup for MySQL -

MySQL databases should be exported/imported. That's actaully how 'backing them up' works.

There are many tools; phpMyAdmin, MySQL Workbench (a free, cross-platform and very powerful tool for MySQL) the MySQL CLI (mysql.exe) or mysqldump.exe. Plus lots of free-to-expensive tools to automate all this.

http://dev.mysql.com/doc/refman/5.1/en/ ... thods.html

Most of these tools produce .sql files as a default. These are text files with all the MySQL directives and data required to rebuild, recreate, or reinstantiate MySQL databases. The wonderful thing about this approach is you know you got a good backup, AND you can remediate after the fact.

Copying the datafiles is not particulalry risky if the two machines have absolutely identical setups and the MySQL servers are down when you do it. Any other scenario is asing for a disaster.

Good Luck
8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: .MYD and .MYI is missing

Postby gian363 » 02. September 2011 20:40

RESOLVED
gian363
 
Posts: 4
Joined: 26. August 2011 09:31

Re: .MYD and .MYI is missing

Postby Altrea » 02. September 2011 21:01

gian363 wrote:RESOLVED

Your answer is very helpful for other users who came to this thread with the same problem.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8294
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 77 guests