dbTalk Databases Forums  

move data folder from version 5.5

comp.databases.mysql comp.databases.mysql


Discuss move data folder from version 5.5 in the comp.databases.mysql forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
ferradini
 
Posts: n/a

Default move data folder from version 5.5 - 08-03-2011 , 04:19 AM






I have problems from version 5.5 to move the D: drive on the folder
containing the database. The procedure I use is to move / date d: /
server / mysql / data / files and change datadir in my.ini. save any
attempt to access MySQL resolves the error 1045 - Access denied for user
root @ localhost (using password: YES I repeat that until I used the
version 5.1 this did not happen. Thanks to all who are willing to give
me an explanation. Ferradini

Reply With Quote
  #2  
Old   
Gordon Burditt
 
Posts: n/a

Default Re: move data folder from version 5.5 - 08-03-2011 , 04:34 AM






Quote:
I have problems from version 5.5 to move the D: drive on the folder
containing the database.

The procedure I use is to move / date d: /
server / mysql / data / files and change datadir in my.ini.
This isn't a very clear description of what you did.


Quote:
save any
attempt to access MySQL resolves the error 1045 - Access denied for user
root @ localhost (using password: YES I repeat that until I used the
version 5.1 this did not happen. Thanks to all who are willing to give
me an explanation. Ferradini
One procedure to physically move the data is:

- Shut down the MySQL server daemon.
- Copy the data from the old location to the new location,
*carefully preserving ownership and permissions on all
the files and directories*
- Change the datadir parameter in my.ini
- Restart the MySQL server daemon.

If you didn't restart the server, it was probably looking for the
data (specifically the 'mysql' database which contains all the user
authorization) in the old place.


Also, if you're upgrading from 5.1 to 5.5 (which I did recently),
they recommend that you use mysqldump (under 5.1) to dump all the
data, then put up 5.5 and reload all of it. It's unclear whether
you did this previously or the procedure you're describing is also
an upgrade.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.