blocks|key|627526|text|我想问题出在你的表引擎上。我猜您正在为您的表使用InnoDB。所以你不能轻易地通过复制文件来进行复制。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|627527|看看这些链接：|627528|http://dev.mysql.com/doc/refman/5.0/en/innodb-backup.html|offset|length|627529|http://dev.mysql.com/doc/refman/5.0/en/innodb-migration.html|627530|此外，我建议您使用类似于phpMyAdmin的工具来创建备份文件，然后使用相同的集成开发环境在下一台计算机上恢复备份文件。|627531|entityMap|0|LINK|mutability|MUTABLE|url|1^0|0|0|0|1L|0|0|0|1O|1|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|U|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|V|8|@]|9|@$F|W|G|X|1|Y]]|A|$]]|$1|H|3|I|5|6|7|Z|8|@]|9|@$F|10|G|11|1|12]]|A|$]]|$1|J|3|K|5|6|7|13|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|E]]|S|$5|O|P|Q|A|$R|I]]]]

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: 
<a href="http://dev.mysql.com/doc/refman/5.0/en/innodb-backup.html">http://dev.mysql.com/doc/refman/5.0/en/innodb-backup.html</a> 
<a href="http://dev.mysql.com/doc/refman/5.0/en/innodb-migration.html">http://dev.mysql.com/doc/refman/5.0/en/innodb-migration.html</a> 

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.

blocks|key|627604|text|对于Mac，您的数据库文件位于：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|627605|/Applications/XAMPP/xamppfiles/var/mysql|code-block|syntax|javascript|627606|您可能需要管理员权限才能访问或删除文件。|627607|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

For Mac, your database files are located at: 

<pre><code>/Applications/XAMPP/xamppfiles/var/mysql
</code></pre>

You might need admin permissions to access or delete your files.

blocks|key|627544|text|您的数据库位于此目录中：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|627545|C:\xampp\mysql\data|offset|length|style|CODE|627546|entityMap^0|0|0|J|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@$D|L|E|M|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

Your database is in this directory: 
<code>C:\xampp\mysql\data</code>

blocks|key|627754|text|我知道已经很晚了，但是你可以使用SELECT+@@datadir来获取信息。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|627755|快乐的文件huntin‘SO社区:)|627756|这是在phpmyadmin中运行时的样子：|627757|📷|atomic|627758|​|627759|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/2b8c82db138c1895543239d599a8247c.png|imageAlt^0|G|G|0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|X|8|@$9|Y|A|Z|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|10|8|@]|D|@]|E|$]]|$1|H|3|I|5|6|7|11|8|@]|D|@]|E|$]]|$1|J|3|K|5|L|7|12|8|@]|D|@$9|13|A|14|1|15]]|E|$]]|$1|M|3|N|5|6|7|16|8|@]|D|@]|E|$]]|$1|O|3|-4|5|6|7|17|8|@]|D|@]|E|$]]]|P|$Q|$5|R|S|T|E|$U|V|W|-4]]]]

Rather late I know, but you can use <code>SELECT @@datadir</code> to get the information.
Happy file huntin' SO community :)
This is how it looks when ran in phpmyadmin:
<a href="https://i.stack.imgur.com/8veWM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8veWM.png" alt="enter image description here" /></a>

blocks|key|412627|text|复制并粘贴整个data文件夹，而不仅仅是内容。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|412628|我使用xampp，数据的路径是xampp/mysql/data。|offset|length|style|CODE|412629|entityMap^0|0|F|G|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@$D|L|E|M|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

Copy and paste the entire data folder, not just the content. 
I use xampp, and the path to the data is <code>xampp/mysql/data</code>.

blocks|key|412463|text|数据存储在此路径中。您可以搜索数据位置，只需在您的搜索位置(url地址)中输入以下地址：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|412464|C:\xampp\mysql\data|offset|length|style|CODE|412465|entityMap^0|0|0|J|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@$D|L|E|M|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

Data are store in this path. You can search data location, just put the below address in your search location (url address):

<code>C:\xampp\mysql\data</code>

blocks|key|412605|text|如果您像我一样，在没有使用Xampp或其他安装程序情况下手动安装are服务器，|type|unstyled|depth|inlineStyleRanges|entityRanges|data|412606|您的数据可能存储在C:\ProgramData\MySQL\MySQL+Server+5.6\data中|offset|length|style|CODE|412607|entityMap^0|0|9|16|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@$D|L|E|M|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

If you are like me, and manually installed your webserver without using Xampp or some other installer,

Your data is probably stored at <code>C:\ProgramData\MySQL\MySQL Server 5.6\data</code>

blocks|key|412643|text|以防您忘记或避免通过PHPMYADMIN导出功能进行复制。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|412644|过程:对于最新版本的XAMPP，可以手动复制:适用于MAC+OS的过程|412645|位置:在以下位置找到数据库文件夹/Users/XXXXUSER/XAMPP/xamppfiles/var/mysql。|412646|解决方案:将带有数据库名称的整个文件夹复制到类似文件夹中的新xampp中。|412647|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

Just in case you forgot or avoided to copy through PHPMYADMIN export feature..
Procedure: You can manually copy: Procedure For MAC OS, for latest versions of XAMPP
Location : Find the database folders here /Users/XXXXUSER/XAMPP/xamppfiles/var/mysql..
Solution: Copy the entire folder with database names into your new xampp in similar folder.

blocks|key|627848|text|在Ubuntu中，文件路径是./opt/lampp/var/mysql|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|627849|entityMap^0|E|L|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

In Ubuntu the file path is <code>./opt/lampp/var/mysql</code>

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:

<pre><code>xampp -&gt; mysql -&gt; data -&gt;
</code></pre>

Here I found a separate folder for each of my databases and within these folders I saw files stored with the <code>.frm format (FRM FILE)</code>.

When I copied my desired database with all tables in <code>.frm format</code> 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?

What is the exact location of MySQL database tables in XAMPP folder?

集成开发环境

数据存储

SQL数据库

SQL Server

数据库

服务器

Ubuntu

MySQL

我有一个MySQL数据库，我想知道这些数据在XAMPP文件夹中实际存储的确切位置，我转到这个文件位置来尝试获取信息：xampp -> mysql -> data ->在这里，我为我的每个数据库找到了一个单独的文件夹，在这些文件夹中，我看到了存储在.frm format (FRM FILE)中的文件。当我复制包含.frm format中所有表的所需数据库，并尝试在另一台PC上使用它们时，我得到了一个

问MySQL数据库表在XAMPP文件夹中的确切位置是什么？
EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MySQL数据库表在XAMPP文件夹中的确切位置是什么？EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MySQL数据库表在XAMPP文件夹中的确切位置是什么？
EN