Offline mySQL DB

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

Offline mySQL DB

Postby tricks22 » 03. July 2009 23:27

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
 
Posts: 4
Joined: 03. July 2009 23:23

Re: Offline mySQL DB

Postby tricks22 » 04. July 2009 07:26

Any Ideas?
tricks22
 
Posts: 4
Joined: 03. July 2009 23:23

Re: Offline mySQL DB

Postby Nobbie » 04. July 2009 09:52

Copy the data folder from MySQL from one installation to the other.
Nobbie
 
Posts: 8762
Joined: 09. March 2008 13:04

Re: Offline mySQL DB

Postby tricks22 » 05. July 2009 20:01

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.
tricks22
 
Posts: 4
Joined: 03. July 2009 23:23

Re: Offline mySQL DB

Postby Wiedmann » 05. July 2009 20:03

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.
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: Offline mySQL DB

Postby tricks22 » 06. July 2009 06:36

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)
tricks22
 
Posts: 4
Joined: 03. July 2009 23:23

Re: Offline mySQL DB

Postby glitzi85 » 06. July 2009 06:57

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
User avatar
glitzi85
 
Posts: 1920
Joined: 05. March 2004 23:26
Location: Dahoim


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 48 guests