如何带回我的数据库wamp sever？ [英] How to bring back my database to wamp sever?

问题描述

我的服务器今天早上崩溃了，所以在重新安装它之前，我只是复制了我的localhost运行的文件夹，使我的数据库不丢失，相信我，我安全地保存它。现在它的重新安装，现在我的本地主机是工作，但我想要的是雇员数据库回到它的位置。我如何获得它？

我复制了文件夹employee，并保存回它的位置，但它没有用。仍然卡住。

提醒您，我在重新安装前未导出。因此，有人可以告诉我如何面对这种情况？

解决方案

Ok所以假设你做了一个完整的备份wampserver文件夹

 
 $ c> wampmanager  - >停止所有服务
  

现在在新安装的WAMPServer上备份此文件夹，一个香草，只要安装状态，如果这不工作。

 移动\wamp\bin\mysql\mysql5。 6.17 \data \wamp\bin\mysql\mysql5.6.17\data_vanilla 
  

现在将您备份的MySQL文件夹从以前的安装文件复制到新安装

  copy \old_wamp\bin \mysql \mysql5.6.17\data \wamp\bin\mysql\mysql5.6.17\data 
  

现在清除mysql日志文件，这样你就不会在日志中的新旧消息之间混淆。

 移动\wamp\logs\mysql.log \wamp\logs\old.mysql.log 
  

您现在应该可以重新启动MYSQL服务，看看它是否干净地启动。

  wampmanager  - > MySQL  - >服务 - >开始/恢复服务
  

现在如果wampmanager图标变成橙色，MySQL应该已经启动。检查mysql错误日志，看看是否一切正常。

  wampmanager  - > MySQL  - > MySQL日志
  

如果一切顺利，您现在可以启动Apache。

  wampmanager  - > Apache  - >服务 - >开始/恢复服务
  

wampmanager图标应为绿色。

My server got crashed today morning, so before re-installing it I just copied the folder where my localhost was running so that my databases are not lost and trust me I preserved it safely. Now its re-installed and now my localhost is working but all I want is 'employee' database back to its place. How do I get it?

I copied the folder employee and saved back to where it was but its of no use. Am still stuck.

Reminding you, I didn't export it before re-installing. So can someone tell me how to face this situation?

解决方案

Ok so assuming you did do a complete backup of the old wampserver folders you can try this.

First make sure you stop all service via wampmanager

wampmanager -> Stop all Services

Now make a backup of this folder on the newly installed WAMPServer, so you can return to a vanilla, just installed state if this does not work.

move \wamp\bin\mysql\mysql5.6.17\data \wamp\bin\mysql\mysql5.6.17\data_vanilla

Now copy your backed up MySQL folder from the Previous installations files to the new install

copy \old_wamp\bin\mysql\mysql5.6.17\data \wamp\bin\mysql\mysql5.6.17\data

Now lets clear the mysql log file, so you dont get confused between old and new message in the log.

move \wamp\logs\mysql.log \wamp\logs\old.mysql.log

You should now be able to restart the MYSQL service and see if it starts up cleanly.

wampmanager -> MySQL -> Service -> Start/Resume Service

Now if the wampmanager icon goes Orange, MySQL should have started. Check the mysql error log, to see if all is well.

wampmanager -> MySQL -> MySQL log

If all is well, you can now start Apache as well.

wampmanager -> Apache -> Service -> Start/Resume Service

The wampmanager icon should go green.

这篇关于如何带回我的数据库wamp sever？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！