我已经从 wamp/bin/mysql/data 复制了数据库文件夹 [英] I have copied database folder from wamp/bin/mysql/data

问题描述

我已经从 wamp/bin/mysql/data 复制了数据库文件夹

I have copied database folder from wamp/bin/mysql/data

当我打开 phpMyAdmin 时，我看到了数据库名称，但是当我点击它们时它是空的，就好像没有在其中创建表一样.

As I open the phpMyAdmin, I see the database name, but when I click on them it is empty, as if no table has been created in them.

我的桌子现在在哪里?谢谢

Where are my tables now? thanks

推荐答案

复制 MySQL 数据目录不是备份或移动数据库的可靠方法.支持的方式是在新服务器上导出然后导入.有很多事情可能会出错，特别是如果您有 InnoDB 类型的表.

Copying the MySQL data directory is not a reliable means of backing up or moving your databases. The supported means is to export then import on the new server. There are a number of things that can go wrong, especially if you have InnoDB type tables.

您可以检查的基本内容是新数据目录的文件权限、MySQL 级别的用户权限(假设您尚未以管理用户身份登录，请尝试这样做，看看情况是否有所改善)，并查看如果有明显的提示，请查看 MySQL 错误日志以获取任何提示，但很可能某些内容没有很好地传输.

The basic things you can check are file permissions on the new data directory, MySQL-level user permissions (assuming you're not already logged in as an administrative user, try doing so and see if things improve), and looking in the MySQL error log for any hints if there's something obvious, but it's very likely that something didn't transfer well.

我建议您返回原始安装，验证您的数据，完全导出(或转储")为 SQL 格式，然后将该文件导入您的新服务器.

I recommend that you go back to the original installation, verify your data, do a complete export (or "dump") to SQL format, then import that file to your new server.

这篇关于我已经从 wamp/bin/mysql/data 复制了数据库文件夹的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！