XAMPP文件夹中Mysql数据库表的确切位置是什么? [英] What is the exact location of Mysql database tables in XAMPP folder?
问题描述
我有一个MySQL数据库,我想知道这个数据实际存储在xampp文件夹的确切位置,我去这个文件位置尝试获取信息:
xampp - > mysql - >数据 - >
在这里,我为每个数据库找到一个单独的文件夹,在这些文件夹中, .frm格式(FRM FILE)
。
c> .frm格式,并尝试在另一台PC上使用它们,我被赋予了一个相同名称的空数据库。
我认为问题是你的表引擎。我想你正在使用InnoDB的表。因此,您无法轻松复制文件以进行复制。
查看以下链接:
http://dev.mysql.com/doc/refman/5.0/en/innodb-backup.html
http://dev.mysql.com/doc/refman/5.0/en/innodb-migration.html
此外,我建议您使用类似phpMyAdmin的方法来创建备份文件,然后使用相同的IDE在下一台计算机上还原备份文件。 p>
I have a MySQL database and I want to know the exact location where this data actually stored in the xampp folder, I went to this file location to try to get the information:
xampp -> mysql -> data ->
Here I found a separate folder for each of my databases and within these folders I saw files stored with the .frm format (FRM FILE)
.
When I copied my desired database with all tables in .frm format
and try to use them on another PC, I was given an empty database of the same name.
Where are the data files for the database kept on the local server?
I think the matter is your tables engine. I guess you are using InnoDB for your table. So you can not copy files easily to make a copy.
Take a look at these links:
http://dev.mysql.com/doc/refman/5.0/en/innodb-backup.html
http://dev.mysql.com/doc/refman/5.0/en/innodb-migration.html
Also I recommend you to use something like phpMyAdmin for creating your backup file and then restore the backup file on the next machine using the same IDE.
这篇关于XAMPP文件夹中Mysql数据库表的确切位置是什么?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!