By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,745 Members | 1,873 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,745 IT Pros & Developers. It's quick & easy.

Can't start the mysql server

P: 1
Hi,

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
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 1,035
[quoot]I have a huge problem and I need help[/quoot]
ok

[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?
4)....

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

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

10K+
P: 13,264
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.