phpMyAdmin displays error when importing database

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:

  1. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  2. phpMyAdmin error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
  3. How to auto login user again after change user_login
  4. How to Join two tables from separate databases within WordPress
  5. Import 10,000 Users into WordPress WITH a specific ID for each user
  6. WPDB: how to get the value of a field in a custom database table
  7. #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
  8. How to generate page content from database the right way?
  9. Transferring working local PHP site to wordpress – with database (MySQL)
  10. Is it possible to create a wordpress database with php code?
  11. Databases – Submitting data from inputs to database [closed]
  12. Is it best to avoid using $wpdb for security issues?
  13. Lost in trying to create user database system
  14. Filter results from a serialized string to use on statistics
  15. wordpress site – using custom database and PHP
  16. Error establishing a database connection (Set-up locally)
  17. add role on WordPress in PHP on a second database
  18. Unable to insert two value in two different columns (WordPress database)
  19. why not selecting multiple rows of same standard_id using SQL query from database?
  20. Can I disable auto increment of WordPress Posts Database to utilize previously deleted records?
  21. Front end/Database connection in WP
  22. direct query to post_meta table
  23. can’t delete a row from post_meta table
  24. Can not manually create a database ( db, user, pass ) for a plugin
  25. How to merge 2 WordPress sites?
  26. Querying multiple meta_keys in WordPress SQL query
  27. Retrieve data from external database and insert back in
  28. Transaction when using WP functions rather than vanilla SQL?
  29. what is the use of /wp-includes/SimplePie?
  30. Display data from a non wordpress database on a page template
  31. Inserting choice in database table
  32. How To Make Connection To WordPress Data Base In A Plugin?
  33. Has anyone tried putting PHP ActiveRecord on WordPress?
  34. count number of user comments with a specific comment meta value
  35. Duplicate domain database to local – How?
  36. How can I call a row of user specific data from a custom table added to the WP Database
  37. How to merge local and live databases?
  38. How to track a users progress through pages by inserting data into WordPress Database?
  39. my function doesn’t return my post from today
  40. How to migrate the posts from an old custom legacy blog to a new WordPress website?
  41. How to create and work with custom data / tables (i.e., for arbitrary data)?
  42. Get Current User Id Inside a Loop Returns 0 For a Shortcode
  43. Any possible way to make $wpdb->get_results() return anything else than array?
  44. how to delete 30 day old data using PHP [closed]
  45. Storing Array from returned database query and using the array in a new query
  46. WordPress not reflecting changed of the database
  47. Detect session/cookie variable in wordpress to prevent access to documents
  48. How can I get the total number of installed importers?
  49. Querying wpdb using PHP
  50. How can I save unique user data on my site? [closed]
  51. Archive post by meta value + 24hours
  52. Using custom tables for old posts
  53. db converts decimal number wrong
  54. How can I import an excel column into wordpress database?
  55. Execute a function every hour in the background
  56. Create page with custom php script and fetched data
  57. Creating Database Table vs. Adding MetaData to Post & User
  58. WordPress and MySQL: trying to print data using PHP from user_meta custom field data
  59. Most commented posts by time period (last 12h, last 24h and etc)
  60. Cant connect to database with php 7.3
  61. Include style.css in the Child Theme with PHP
  62. PHP -> SQL Query with Summing
  63. Set default Database Storage Engine when creating tables with plugins?
  64. Plugin can’t write to database even though permissions appear correct?
  65. Remove password protection from all posts
  66. SQL error with custom query
  67. Unserialize Custom Field & Save as Multiple Rows in WordPress Database
  68. WordPress: Export/Import Yoast meta title & description to custom taxonomy
  69. WordPress SQL Prepare
  70. Create a new account on site B with data from the purchase of site A
  71. How to search order using database frontend short code WordPress
  72. Run a sql (update) after 12 hours after the user login. Woocommerce users
  73. PHP Warning: mysqli_query(): after updating my websites php from 5.6 to 7.2
  74. wp_update_post gives 500 internal error
  75. Import Instagram post as WordPress post
  76. Collect all events in one year
  77. getting the values of hidden inputs to use them in a php mysql query
  78. wp-login.php?redirect_to=https problem
  79. Getting error in sql query
  80. user update profile for custom code
  81. 403 Forbidden Localhost Wamp Apache Php
  82. WordPress character set issue
  83. SQL Query Search page
  84. Importing demo data in Multisite
  85. Accessing external database: ERR_INCOMPLETE_CHUNKED_ENCODING
  86. AJAX Not Working With WordPress Database properly
  87. Manipulate database of WordPress site with my own scripts
  88. Problems with plugin that fetches data from database with ajax
  89. Let users register weight each day and save it in DB
  90. How to export database correctly for local to online
  91. Query specific posts per user selections from dropdown menus
  92. WXR XML import is stripping php tags that I need to keep
  93. Fetching wpdb data from a php file seems to break?
  94. How to pass username into form that sends data to database
  95. Insert into db with foreach problem
  96. save array of objects with update_option
  97. Execute multiple PHP Snippets causes error?
  98. How to sort search result by post_title, then by post_content
  99. How to use phpspreadsheet reader with $wpdb
  100. Can’t insert into a database wordpress