Server Administartion Server Instances

I’m new to My SQL. Im trying to change the Data directory location to that of the server Instead of the default "C:\Program Data\MySQL\MySQL Server 5.5\data". I changed the my.ini file so that the database directory was pointing to the server "Y:\dev224\MySQL\data" and then stopped the database server and tried to restart the database. It would not re-start.. I copied the old my.ini file back and the database restarted. I thought, well maybe it can not find the same dabases in the new directory that I had in old directory , so I copied the entired database structure and tried the new my.ini database file again and it still would not restart after I stopped it. I copied the original data directory using the windows explorer. I do see a directory when I sign up to the original configuration that I don't see in the actual directory  information_schema . But I copied the directory and stopped the Server and tried to restart, but it would not restart.
any suggestions?

Thanks,
Mike
miker454Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

johanntagleCommented:
Check the file ownership and permissions of the copied data - they should be the same as the original.  Also, see if you encounter the same (weird) error regarding the size of ib_logfile* described at http://benjisimon.blogspot.com/2009/01/gotcha-of-day-moving-mysqls-data.html

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
miker454Author Commented:
Thanks johanntagle, I read your article and it was going along with my thinking. I have spent hours granting permission. I really don't know what other permission to give the directory. The ib_logfile0 and ib_logfile1 are the same file in both directories. I tried moving the data around to several hard drives and I was able to move it, but when it came to moving it to public shared network drive (Z:\) it would not work. I have windows 7 and the 5.2.22 community version of My SQL. I hope there are no restrictions on the community version of my SQL. I'm still trying to figure out what is going wrong . Like you said easier said than done. Thanks for your suggestion.

Thanks,
Mike
johanntagleCommented:
Ah.  Didn't realize you were moving it to a shared network drive.  Weird things happen with them.  Even if it was possible to put the data directory there I would not recommend it as it could hamper performance.
miker454Author Commented:
I appreciate your help. I realize you are right. It is my fualt for trying to put it on a shared network, My problem is I have installed My SQL on the network server and I have tried and tried to be able to use on the client computers and I can not even see the database on the client machines. My SQL is running on the Server (using windows 2008) I can connect to it via ODBC on the server, but I can not connect to via ODBC on the client machines. I turned off the firewall on both the client and the server. I have no clue what is going on, but Im going to keep trying. (Stupidly, installed My SQL on the client and thought I could run My SQL on each client and use the file server to hold the data. Obviously this won't work).<br />Thanks,<br />Mike
johanntagleCommented:
Hi Mike,

Suggest you open a command prompt on a client machine and do a "telnet address-of-server 3306" and see if you get a response.  If you do, then the server and network is set up to receive mysql client connections.  Start from there then maybe post another question for troubleshooting your client odbc connections.

(UPDATE: I see you already got a new question going :) )

Johann
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.