问题描述
我有一个用 php 和 mysql(由其他人编写)编写的网站，我需要对其进行更改 - 只是为了您的兴趣，它是 bridgetjonesart.co.uk.所以我想我会把它下载到我的台式电脑上，并在本地使用简单的 php 和 mysql 进行更改，然后再次上传.
I have a website written in php and mysql (written by someone else) and I need to alter it- just for your interest it is bridgetjonesart.co.uk. So I thought I would download it to my desktop pc and use easy php and mysql locally to make changes then upload it again.
我将 sql 数据库作为根目录中的文件runningc_bjart.sql".我首先使用 php admin 创建一个与原始数据库同名的数据库，然后使用 import ......似乎创建了一个表，但随后出现错误......错误
I have the sql database as a file 'runningc_bjart.sql' in the root directory. I first use php admin to create a database of the same name as the orginal and then use import ... one table appears to be created but then getting an error... Error
SQL query: DocumentationEdit Edit
SELECT `comment`
FROM `phpmyadmin`.`pma_column_info`
WHERE db_name = 'runningc_bjart'
AND table_name = ''
AND column_name = '(db_comment)'
MySQL said: Documentation
#1100 - Table 'pma_column_info' was not locked with LOCK TABLES
---------
Error
SQL query: DocumentationEdit Edit
SELECT `comment`
FROM `phpmyadmin`.`pma_column_info`
WHERE db_name = 'runningc_bjart'
AND table_name = ''
AND column_name = '(db_comment)'
MySQL said: Documentation
#1100 - Table 'pma_column_info' was not locked with LOCK TABLES
我不确定接下来要尝试什么，任何帮助将不胜感激.谢谢你.布里奇特
I am not sure what to try next, any help would be really appreciated. Thank you. Bridget
推荐答案
浪费了很多时间，我有一个解决方案，所以在这里.
Having wasted many hours, I have a solution so here it is.
查看网络后，我发现我需要更改 phpadmin 目录中的 config.inc.php 文件，因为我运行的是 EasyPHP 13.1 密码，这与 config.inc.php 博客中提到的密码略有不同a href="http://amir-shenodua.blogspot.co.uk/2012/03/error-while-importing-db-in-mysql.html" rel="noreferrer">http://amir-shenodua.blogspot.co.uk/2012/03/error-while-importing-db-in-mysql.html.我添加了 2 行:
Having a look on the web I found I needed to change my config.inc.php file in the phpadmin directory as I was running EasyPHP 13.1 password slightly diff to that mentioned in the blog at http://amir-shenodua.blogspot.co.uk/2012/03/error-while-importing-db-in-mysql.html. I added 2 lines:
$cfg['Servers'][$i]['controluser'] = 'root';
$cfg['Servers'][$i]['controlpass'] = '';
所以都排序了！！伊皮！！
So all sorted !! Yippee!!
因此，如果您遇到问题，请阅读:
http://amir-shenodua.blogspot.co.uk/2012/03/error-while-importing-db-in-mysql.html
So if you have trouble please read:
http://amir-shenodua.blogspot.co.uk/2012/03/error-while-importing-db-in-mysql.html
这篇关于在 EasyPHP 中使用 phpmyadmin 导入 sql 文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！