Offline mySQL DB

[tricks22]

Hi,

I currently have a very large online database, what I need to do is take a copy of this database to my computer so I can use it offline in conjunction with phpMyAdmin and with my php files. I've taken the first step of installing xampp, but can't figure out where to go from there. Any help would be greatly appreciated. Thanks.

--
Patrick

[tricks22]

Any Ideas?

[Nobbie]

Copy the data folder from MySQL from one installation to the other.

[tricks22]

Sorry I should have been more clear. My current database is online, I can export it as a .sql (or other if required). Once I have it exported how do I use it to create an offline working copy. Thanks.

[Wiedmann]

Once I have it exported how do I use it to create an offline working copy.

Import the *.sql file with the MySQl command line client or phpMyAdmin to your local server.

[tricks22]

Where can I find the best documentation on all of this? Such as using phpMyAdmin with Xampp? (Sorry probably a stupid question but I am blissfully unaware)

[glitzi85]

phpMyAdmin is just a frontend for MySQL. It should not need too much documentation, as it is self explaining. More important is the MySQL Documentation. If you understand the MySQL Server, phpMyAdmin should be easy to use.

MySQL Documentation: http://dev.mysql.com/doc/refman/5.1/en/

When you open the XAMPP page http://localhost/xampp there is a point "Documentation" in the Menu on the left hand side. There you will find Links to the Documentations of all parts included in XAMPP.

glitzi