If you have already created the database that you wish to import into and you have selected that database in PHPMyAdmin, but the import file is trying to create a new database, then you will see this error message.
All you need to do is open up the SQL file in a text editor and delete the line that begins with CREATE DATABASE (it will be very near the top of the file).
Now try the import again and it should import that data into your selected database rather than trying to create a new one.
Related Posts:
- Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
- phpMyAdmin error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
- How to auto login user again after change user_login
- How to Join two tables from separate databases within WordPress
- Import 10,000 Users into WordPress WITH a specific ID for each user
- WPDB: how to get the value of a field in a custom database table
- #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
- How to generate page content from database the right way?
- Transferring working local PHP site to wordpress – with database (MySQL)
- Is it possible to create a wordpress database with php code?
- Databases – Submitting data from inputs to database [closed]
- Is it best to avoid using $wpdb for security issues?
- Lost in trying to create user database system
- Filter results from a serialized string to use on statistics
- wordpress site – using custom database and PHP
- Error establishing a database connection (Set-up locally)
- add role on WordPress in PHP on a second database
- Unable to insert two value in two different columns (WordPress database)
- why not selecting multiple rows of same standard_id using SQL query from database?
- Can I disable auto increment of WordPress Posts Database to utilize previously deleted records?
- Front end/Database connection in WP
- direct query to post_meta table
- can’t delete a row from post_meta table
- Can not manually create a database ( db, user, pass ) for a plugin
- How to merge 2 WordPress sites?
- Querying multiple meta_keys in WordPress SQL query
- Retrieve data from external database and insert back in
- Using wpdb to connect to a different database is not working
- Using custom php to connect to database blocks wp from accessing galery pictures
- Running a PHP SQL script on a wordpress page
- Create “blank” admin page without having admin-bar/admin-menu for faster load
- WordPress PHP version
- Import Instagram post as WordPress post
- Collect all events in one year
- WordPress search query, how to modify the sql
- Editing the term_order field
- How do I get data from my database into my Custom Export Field
- Updating the database after parsing CSV document
- WordPress database error only while loading page for 1st time
- Multiple WordPress sites with different theme and plugin sharing the same content
- getting the values of hidden inputs to use them in a php mysql query
- How to grab data from input and store it into custom table in database?
- custom search query database in child theme
- wp-login.php?redirect_to=https problem
- Insert data from form to database
- How do I fetch a data from an external database into my wordpress homepage
- How do I fetch a data from an external database into my wordpress homepage
- Inserting other fields to existing registration form in a WordPress theme
- Full search and replace isn’t enough to make all pictures to be loaded with https
- How to display post_content from database in different on template page?
- Generate random access token to a post page
- How to query a staging database?
- Get meta_query value by user meta array
- Getting error in sql query
- user update profile for custom code
- Where to check in PHPmyAdmin / SQL database for subdomain
- 403 Forbidden Localhost Wamp Apache Php
- How to retrieve user data based on role using SQL?
- Changing WordPress author name in database
- Plugin Modification Change Functionality For Logged User Only
- I changed the password for the database user of my website, updated wp-config.php and wordpress asks to be reinstalled
- I want to use wordpress database in android app using json encode?
- Pull a div from one WordPress site into another WordPress site
- WordPress character set issue
- Issue in url update when using wordpress update query
- SQL Query Search page
- Child theme functions.php file change database entries
- Importing demo data in Multisite
- What to create new post using wp_insert_post, but it repeat the post infinitely
- Accessing external database: ERR_INCOMPLETE_CHUNKED_ENCODING
- Can form entries from a WordPress form go to a database
- AJAX Not Working With WordPress Database properly
- special characters not supporting in wordpress
- Conditional statement within WP SQL query
- How to set max users to 17.000
- Weird Behaviour: Not all WordPress Posts appearing
- Sum of Custom Meta written by Authour
- two wordpress sites, two themes, one database, same content
- Insert double entry in DB
- How to fetch results from database
- Manipulate database of WordPress site with my own scripts
- Unserializeing multiple column values that are stored in one database results variable
- Best way to define a database with product codes and back-end support?
- How to connect database table to each registered wordpress user.
- Problems with plugin that fetches data from database with ajax
- See output of a sql query while plugin installation in wordpress
- Check if values exists DB
- Let users register weight each day and save it in DB
- How to export database correctly for local to online
- How can I order metaboxes in my posts in WordPress?
- MySQL database migration to WordPress
- Host does not allow remote connection, so how do I transfer data to my WordPress site?
- Trying to post information from a remote database to wordpress page
- MySQL Engine vs. Charset
- Query specific posts per user selections from dropdown menus
- WXR XML import is stripping php tags that I need to keep
- Custom query_posts() parameter
- Create an unique ID number after submit form
- How to print array of specific item
- Fetching wpdb data from a php file seems to break?