Apache Friends Support Forum

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

/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!

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

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