I reviewed WordPress’ advice on phpMyAdmin and it seems I was adding one extra step which was causing the problem – ticking Add CREATE DATABASE / USE statement.
Exporting without checking this box and results in SQL that imports without any problems.
Related Posts:
- Delete all post meta except featured image
- Set Display Name to first and last name (phpmyadmin SQL Query)
- Emojis getting converted to “?”
- Delete all post meta except featured image Using SQL
- WordPress database import: Row size too large
- Changing root password in PHPMyAdmin for WordPress Database when going live
- Can’t update WordFence Options, clear data manually
- Files on Localhost, Database on Server
- Installing local to live WP into subdirectory
- DB prefix not updating
- I wanted to Know that how can I give ingore to 0000-00-00 in my config file
- I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
- Check if a database is well installed
- Deleting WordPress posts and media files based on author via MYSQL database
- Rename a table in MySQL
- How should I tackle –secure-file-priv in MySQL?
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- phpMyAdmin – Error > Incorrect format parameter?
- Why is my database import losing text widget data?
- Checking if Database Table exists
- Please explain how WordPress works with MySQL character set and collation at a low level
- How to fetch Data in WordPress using MySQLi or $wpdb
- Connect to database using wordpress wp-config file
- Reset Post IDs to less than 64bit integer
- How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
- How to define composite keys with dbDelta()
- Is it possible to define two databases for one installation?
- Does WordPress use the InnoDB engine for MySQL by default?
- Huge wp_options table
- “MySQL server has gone away” since update to 3.8
- what to do when your WordPress database is too large?
- Can I transfer a mysql database to another site?
- WordPress and automated MySQL backups to a different host
- MySQL Syntax Error upon restoring database from backup [closed]
- Help running a MySQL query to update all wp_#_options tables in a Multisite install
- How Do I Merge Categories With phpMyAdmin
- Size article thumbnails and retrieve them directly from database
- Is it safe to convert tables from MyISAM to InnoDB?
- How do I properly update the WordPress database password?
- wpdb_prepare with multiple or condition
- Accidentally deleted active_plugins portion of the wp_options DB table
- WordPress Install and Database on separate hosting?
- WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
- Advanced SELECT query with condtional statements
- Error establishing database connection – high traffic?
- Using GROUP CONCAT in my-sql query with wp_usermeta table
- Create table from array with prepare
- How to prevent/delay MySQL connections when an object cache is used?
- Migrating from PDO using SQLite to clean new install using MySQL
- Call to undefined function get_user_meta() – trying to access data in MySQL from custom fields
- Better ads plugin has 500.000 entries in wp_postmeta
- Connection refused on locahost after importing database?
- Duplicated site isn’t recognized as a site
- Have working sql query… trying to adjust it to use $wpdb
- How to properly check if a table exists in WordPress Database using Show Tables Query
- creating new field on mysql
- How and where is wordpress adding mySQL content to database?
- SQL query to set posts in bulk based on the post content
- How can I detect right db type?
- How to create more than one new wpdb object?
- Remote database -> massive response time increase?
- Second ezSQL initialization for MSSQL
- Fetch a single row from a custom table for to a given ID
- Database create or redirect
- Getting “Error Establishing a Database Connection” on localhost in new Mac OSX Lion environment
- Delete user with only subscriber role
- Is there any way to monitor a MySQL db and check what has changed?
- How to escape percentage sign(%) in sql query with $wpdb->prepare?
- Recovery – Restore Database after moving folder location locally
- Replacing javascript link in WordPress database without getting mysql syntax errors
- How to edit custom table data in frontend
- local wordpress broke after changing URL
- how to access 2nd Mysqli Database from different server for wordpress
- Deleted products from woocommerce are still in the database
- Error establishing a database connection – WordPress setup, everything else is working
- Store GravityForm data in phpmyadmin (mysql)
- What is recommended data type and encryption type for password in a database
- How to map data on CSV to web pages?
- WP website showing blank page after moving from subdomain to main domain
- How to create index (sql) to a meta_key?
- Search and Replace in Windows XAMPP site
- WPCLI search and replace in a particlar site dir effect another site-dir
- How can i syn wordpress user table with a stand-alone php script?
- insert data from a form:: Warning Empty query mysqli::query()
- How can I get $wpdb to show MySQL warnings?
- WordPress Database Posts Table query
- Hang Up Followed By Can’t select database
- How to extract some part of WordPress full source code
- Mysql Queries per Visit – Crazy High
- Changed meta_key value in structures, now dashboard shows zero users
- Why is converting my database to UTF-8 truncating entries?
- using same mysql user with many databases
- Why are my WordPress post queries so slow?
- Database question while Migrating from one domain to another on same WebHost [Bluehost]
- Migrated to Namecheap, now Trouble with Database & wp-config [closed]
- export individual posts to text files or a single csv file
- Custom wordpress SQL statement for a website
- SQL errors when querying for something with apostrophes
- Naming conventions for database tables