Location of MySQL Databases in Filesystem under XAMPP

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

Location of MySQL Databases in Filesystem under XAMPP

Postby Philip G. Duffy » 10. February 2005 18:24

I am migrating from Windows XP/IIS/PHP/MySQL to SuSE Linux 9.0/Apache 2/PHP/MySQL using the XAMPP installation. I have dumped my database in Windows but wish to know the standard location for loading it in the Linux filesystem.

If the response refers to documentation in German, I 'll try to read it.

Phil Duffy
Philip G. Duffy
 
Posts: 21
Joined: 10. February 2005 17:55
Location: West Chester, PA, USA

Postby Ceelight » 10. February 2005 18:32

/opt/lampp/var/mysql

There you can find for each db one directory. I think that you can just copy your windows db's into this directory.

Please correct me if I'm wrong! ;)
There's no place like 127.0.0.1
User avatar
Ceelight
 
Posts: 295
Joined: 31. January 2004 19:57
Location: Pfälzer im niedersächsischen Exil ;-)

Postby Oswald » 10. February 2005 18:36

Dear Philip!

The location of the MySQL database files of XAMPP for Linux is /opt/lampp/var/mysql/. But I think you don't need this information.

In your case you made a SQL dump of your databases. You only need to restore the dump the "usual" way on your Linux system: One way is to use phpMyAdmin and another way is to use the MySQL command line tool (/opt/lampp/bin/mysql).

For example: http://www.devshed.com/c/a/MySQL/Backin ... -Database/

Please prepend always /opt/lampp/bin/ to a MySQL command. For example if a tutorial says call mysql ... you've to type /opt/lampp/bin/mysql ...

Hope this helps. ;)

With many greetings from Germany
Oswald
User avatar
Oswald
Apache Friends
 
Posts: 2718
Joined: 26. December 2002 19:51
Location: Berlin, Germany
XAMPP Version: 5.5.19
Operating System: Linux

Location of MySQL Databases in Linux Filesystem

Postby Philip G. Duffy » 26. February 2005 20:12

Sorry for the delay in confirming. I had some configuration problems that had to be resolved first.

The databases are located as described.

Thank you.

Phil
Philip G. Duffy
Philip G. Duffy
 
Posts: 21
Joined: 10. February 2005 17:55
Location: West Chester, PA, USA


Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 4 guests