change mysql data location?

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

change mysql data location?

Postby fael097 » 10. July 2011 16:32

Hi, I'm currently storing my htdocs folder in my dropbox, so whatever changes in make in my home computer, I'll get on work, and the other way around too.

but I always have to export my DB and import back, so I was wondering, how to relocate my databases to a different folder?

I tried changing lines in the my.ini mysql config file, but it caused phpmyadmin not to start.

any help is appreciated, thanks!
fael097
 
Posts: 10
Joined: 12. February 2010 17:38

Re: change mysql data location?

Postby JonB » 10. July 2011 17:09

A. When you were attempting to change the MySQL data folder, were you able to use the MySQL monitor to access the database(s)???? (also known as CLI or mysql.exe)

you might want to look at this:
http://dev.mysql.com/doc/refman/5.0/en/ ... oting.html

good luck
:)



ysf
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: change mysql data location?

Postby fael097 » 10. July 2011 17:24

yes, I was, everything *appeared* to be working, my sites were accessing DB and stuff.

but i couldnt open phpmyadmin. many errors everywhere.

should I configure phpmyadmin somehow to access the new folder?
fael097
 
Posts: 10
Joined: 12. February 2010 17:38

Re: change mysql data location?

Postby JonB » 10. July 2011 17:53

Since MySQL seemed to be OK, my 'guess' would be, "it sure seems so".

it would be pretty useful to try to interpret those errors as a starting point.

I'd suggest looking at the very extensive docs on the phpMyAdmin site.

http://www.phpmyadmin.net/documentation/#config

Good Luck
:)

Last thought - you did restart everything after the changes???
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 34 guests