468,540 Members | 1,714 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,540 developers. It's quick & easy.

Can't start the mysql server


I have a huge problem and I need help.
I have the data folder from the server I had on one computer (containing the schema folders and the ibdata1 file). Now I need the install the mysql server on another computer, and transfer the data - but every time I try, when I move the data folder, it can't start the server. I must have the data, and can't get it any other way.
Am I doing something wrong? Do I need to do something else then copy the data foldet to "C:\ProgramData\MySQL\MySQL Server 5.6"?

Please help me
Apr 20 '13 #1
2 1404
1,043 Expert 1GB
[quoot]I have a huge problem and I need help[/quoot]

[quoot]....but every time I try, when I move the data folder, it can't start the server.[/quoot]
1) Which data dit you move exactly?
2) Are both servers the same version?
3)Was the first database server shutdown properly, before copying this data?

[quoot]Am I doing something wrong?[/quoot]

Maybe you should give some error messages that the server displays when trying to start.

Also, can you explain why you do not have a proper backup of your old server (or cannot make one?)

i.e. mysqldump is a nice tool to make backups with...
Apr 21 '13 #2
13,262 8TB
Try changing the datadir option in your mysql configuration file to point to the location of the old datafiles. Make sure mysql is stopped when you do this.
Apr 22 '13 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Mark Adams | last post: by
reply views Thread by Massimiliano Marcon | last post: by
2 posts views Thread by Lazy Hill Wineries | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.