471,084 Members | 807 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,084 software developers and data experts.

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 1463
1,046 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 Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.