Discover duplicate database phpmyadmin, include the articles, news, trends, analysis and practical advice about duplicate database phpmyadmin on alibabacloud.com
I. preparations: 1. Installation
I. preparations:
1. install
2. prepare the required software. The details are as follows:
Php V5.2.1 For Windows
Http://www.skycn.com/soft/516.html
MySQL For Windows V5.2 Alpha
Http://www.skycn.com/soft/126
phpMyAdmin is the client software used to connect the MySQL database remotely, the user can refer to the following steps
To configure phpMyAdmin software:
Please download the Phpmyadmin.rar file to your local;
Use WinRAR to extract the file and
phpMyAdmin is used to remotely connect to the MySQL database client software, users can refer to the following steps
To configure phpMyAdmin software at a glance:
Please download the Phpmyadmin.rar file to your local;
Use WinRAR to extract the
1. Access the MySQL database web page management tool through the phpMyAdmin website you have created.
2. Enter your user account and password to log on.
3. enter the name of the database to be created in the database creation box, for example,
PHPMyAdmin version 2.9.1.1Back up data with phpMyAdminDatabaseAfter export, use it locallyPHPWhen restoring MyAdmin or sqlyog, the following error occurs:Error occured at: 10:09:43Line No.: 11154Error code: 1062-duplicate entry '?????? 'For key 2
Before the server data loss decided to move out with phpmyadmin export, because the database file is relatively large, so directly using the MySQL command direct import
MySQL Export Import commandBut the results are always there.
ERROR 1062 (23000)
Mysqldump Lead Library error Duplicate entry "for key 1This database backup is backed up with a backup program back in the background, more than 400 m, larger, so no phpmyadmin import, enter cmd, mysql-h localhost-u root-p database name This is what
VPs has been around for a long time. I just encountered importing a database during the WordPress migration process. Met
#1062-duplicate entry '1' for key 'primary'
At that time, I was so anxious that I had deleted all the original data and
There are 2 of tables
The first table is f_city (field: city_id and field City_name)
The second table is F_chengjiao (field: ID, city_id, area, Taoshu, Fang_time)
The associated field is city_id
The statement I wrote was
SELECT CONCAT
Duplicate entry... for key... cause of error: this error occurs because the unique value of the primary key is repeated. This error is reported once the unique value of the primary key is repeated during database modification and insertion, if
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.