作者:___何鵬 | 来源:互联网 | 2023-09-02 17:50
Preamble -- I thought I sent this message already, and did not see it on the message list in the forum. Sorry if anyone has received this message twice.
Hello. I am a newbie at the whole database thing, and I have gotten over some hurdles at the start, and found after some poking around, that my web host uses the collation "latin1_swedish_ci", and for whatever reason, this seems to be okay with my English-only website under those settings on my blog. It is unknown if WordPress changes those settings, but I seem to have few problems.
I made a backup of this database, and decided to read it under PHPMyAdmin, which is running locally. After a false start or two, I declare a database, then I read in my bzip2 file (1.7 megs, expands to about 12 megs), which was generated by a mysqldump command. Something like:
mysqldump --add-drop-table -h dbs.webhost.com -u user -p user | bzip2 -c > user.bak.sql.bz2
I get the error:
SQL query:
SELECT
FROM
.
WHERE db_name = 'user'
AND table_name = ''
AND column_name = '(db_comment)'
MySQL said:
1100 - Table 'pma_column_info' was not locked with LOCK TABLES
This error persists regardless of the charset I choose, even binary. All that is read are two tables out of 50 or more. Any suggestions as to how to get this beast read by PHPMyAdmin?
Thanks for everyone's help so far. I am using PHPMyAdmin version 3.3.8.1.
Phrank
- Original URL: https://sourceforge.net/p/phpmyadmin/support-requests/1161/
- Original author: psinatra
该提问来源于开源项目:phpmyadmin/phpmyadmin
- Original author: psinatra