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

Question

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?

score 45 · Answer 1 · answered Feb 06 '15 at 00:39

45

For Mac, your database files are located at:

/Applications/XAMPP/xamppfiles/var/mysql

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

answered Feb 06 '15 at 00:39

Alfonse

732
1
6
7

Still true in 2018 for XAMPP for OS X 7.2.12 (same location) – auspicious99 Dec 02 '18 at 02:39
I didn't find the data in that place... – Archit Gargi Mar 04 '22 at 11:07

score 38 · Answer 2 · edited Mar 15 '19 at 09:50

38

Your database is in this directory:
C:\xampp\mysql\data

edited Mar 15 '19 at 09:50

SherylHohman

16,580
17
88
94

answered Apr 19 '14 at 13:14

Shaktisinh Jadeja

1,427
1
17
22

Can O' Spam · Answer 3 · 2021-11-18T14:50:03.150

18

Rather late I know, but you can use SELECT @@datadir to get the information.

Happy file huntin' SO community :)

This is how it looks when ran in phpmyadmin:

edited Nov 18 '21 at 14:50

answered Aug 27 '15 at 14:53

Can O' Spam

2,718
4
19
45

2

Neat and clean answer – Kalpesh Popat Nov 18 '17 at 18:45
Where do I type this? – SherylHohman Mar 15 '19 at 09:49
1

@SherylHohman, you can run it via the command line or through phpmyadmin > sql tab. – Vincent Edward Gedaria Binua Feb 17 '21 at 23:53

Mohammad Saberi · Accepted Answer · 2012-03-11T06:50:58.163

13

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.

edited Mar 11 '12 at 06:50

answered Mar 11 '12 at 06:45

Mohammad Saberi

12,864
27
75
127

@muhammad thanks alot for answering, ya m using innodb but i try myisam also. I know phpMyAdmin & i import & export data easily but now i need to know the location for my tables – Arif Mar 11 '12 at 07:16
@Arif all tables stores in the path you said in your question (mysql\data). But when your InnoDB tables and databases have other related files that do not store in this directory. You need .idb files too that I could not find them in this path – Mohammad Saberi Mar 11 '12 at 07:25
@Muhammad i have all tables saved in "**.frm**" type and in same folder there is 1 additional file "**db.opt**" – Arif Mar 11 '12 at 07:32
Look at the first link: http://dev.mysql.com/doc/refman/5.0/en/innodb-backup.html – Mohammad Saberi Mar 11 '12 at 07:49

score 8 · Answer 5 · edited Aug 12 '21 at 00:55

8

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

edited Aug 12 '21 at 00:55

Dharman

30,962
25
85
135

answered Jun 11 '16 at 07:48

Silva

81
1
2

could you please make your answer more constructive? – Enamul Hassan Jun 11 '16 at 08:07
@Silva There is no directory or file call data in my xampp at centos 6 – Chaminda Bandara May 25 '17 at 08:28

score 6 · Answer 6 · edited Mar 15 '19 at 09:44

6

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

C:\xampp\mysql\data

edited Mar 15 '19 at 09:44

SherylHohman

16,580
17
88
94

answered Jun 30 '15 at 05:30

Vivek Kumar

81
1
5

score 6 · Answer 7 · answered Mar 11 '12 at 06:36

6

The exact location is stored in "my.ini" which exists under main mysql installation directory. In my.ini file, look for 'datadir'. This parameter points the data folder.

answered Mar 11 '12 at 06:36

Sudhir Bastakoti

99,167
15
158
162

ya i saw folder path from "**my.ini**" but in that folder i found my tables in "**.frm**" type – Arif Mar 11 '12 at 07:20
`my.ini` is in 'C:\xampp\mysql\bin\my.ini' dir – Filomat Sep 22 '19 at 18:29

score 4 · Answer 8 · edited Aug 12 '21 at 00:56

4

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.

edited Aug 12 '21 at 00:56

Dharman

30,962
25
85
135

answered Jul 15 '18 at 07:51

NadZ

1,024
9
10

score 2 · Answer 9 · edited Mar 15 '19 at 09:53

2

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

Your data is probably stored at C:\ProgramData\MySQL\MySQL Server 5.6\data

edited Mar 15 '19 at 09:53

SherylHohman

16,580
17
88
94

answered Oct 15 '15 at 13:31

Pequenaweb

21
2

score 2 · Answer 10 · answered Nov 07 '20 at 13:41

2

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

answered Nov 07 '20 at 13:41

Shardul Birje

341
5
14

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

10 Answers10

Linked