在EasyPHP中使用phpmyadmin导入sql文件 [英] Importing sql file using phpmyadmin in EasyPHP

问题描述

我有一个网站写的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 

我不知道接下来要做什么，任何帮助将非常感激。
谢谢。 Bridget

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.

在web上查看我需要更改我的 config.inc.php 文件在phpadmin目录中，因为我运行EasyPHP 13.1密码略微diff在博客中提到的 http://amir-shenodua.blogspot.co.uk/2012/03/error-while-importing-db-in-mysql.html 。我添加了两行：

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'] = '';

所有排序！ Yippee！

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文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！