If you check the wp-config.php
you can identify which database is being used:
// ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define('DB_NAME', 'this_here');
Then, use phpMyAdmin or Adminer to export the data into an .sql and move it over to the new database for import.
Related Posts:
- Why does importing copies of the database dump and the document root make WordPress data inconsistent?
- WordPress url transformation script
- Multiple developers / editors working on a site in progress
- How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
- What’s the simplest way to backup my WordPress database?
- Fastest way (least amount of steps) to locally import a remote database using WP-CLI
- Solution for database version control and deployment?
- How to migrate a HTTPS WordPress installation to localhost?
- Does wpdb add considerable overhead on queries with large result sets?
- How can I migrate from another platform to WordPress (using the same domain) and launch when ready?
- Migrating data between local and development server
- Best way to import users, post and categories from an external database
- Syncing local content with development / staging sites
- Organizing WP Pages based on old website database
- Presentation vs Content in WP DB-Tables
- Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
- Migrate a Non WordPress database to wordpress [closed]
- Faulty restore of the database, encoding issue
- How does WordPress create its database during installation?
- WordPress and automated MySQL backups to a different host
- Weird issue with database migration and SSL links
- How to fix unchanged URLs in Database after running serialized search and replace script?
- Backup another database with BackUpWordPress plugin [closed]
- Migrating database / content of non-CMS site to WordPress
- How do I reset a self-hosted WordPress URL?
- Why are no posts showing despite my apparently correct DB restoration?
- I don’t see site_url and home_url fields in wp_options table (phpMyAdmin)?
- Export all content from wordpress
- For WordPress is there content in the database which I can safely ignore?
- What happens if I overwrite the current wp_options table with a backup from a week ago?
- Migrating WordPress from DreamHost to Azure WordPress Resource via UpdraftPlus “wp_options table does not exist…” error
- Moving minor updates between local and live sites – just database?
- How to move the WordPress site Layout from test site to Production site?
- Merging two databases without borking it
- Able to use all admin pages but in the frontend there is a “Error establishing a database connection”-Error
- Trouble Migrating all data blog from WordPress.com to WordPress.org
- Store partial database to an archive database time to time
- Copying database tables to new database
- Migrating from PDO using SQLite to clean new install using MySQL
- how to migrate wpmu from one host to the other?
- Migration: Copying database content to a different server
- Change WordPress URL in sql file via Terminal
- Where is phpMyAdmin inside WordPress?
- How To Run A Temporary Instance Of a WordPress Backup Without a Database?
- How to backup my site and restore my wordpress site
- Strange characters added to the database
- Cannot restore wordpress database from sql dump [closed]
- wordpress database restore – broken link
- restore a db after bad backup
- After database migration, theme mods don’t show [closed]
- Problem migrating to localhost
- Can I customised default WP table
- How to transfer from localHost to live but use the already existing database on the server?
- Backing up WordPress database and files
- Image link issues after importing a database backup to my local web server
- Database migration issues – Error #1046 No database selected
- echo site_url() returns a different value than what is in the database siteurl field
- Migrate Users From laravel to wordpress
- /wp-admin not accessible after migrating to local host (no plugin issue)
- How to fix Uploaded to this post option to see group of images uploaded to a post?
- How can i restore a WordPress site with the DB and WordPress Files
- SQL database import #1046 error
- WordPress site migration – locked out of admin area
- is it possible to install new WordPress in an old WordPress folder?
- Malware in old website – how to migrate?
- Is it possible to separate databases in WordPress site – one for orders and the other for all non-orders related
- WP website showing blank page after moving from subdomain to main domain
- WordPress Migration – Issue with admin panel changes
- Do I need to be selective about where I search and replace when pointing a domain to a subfolder used for development?
- WPCLI search and replace in a particlar site dir effect another site-dir
- How to edit posts/pages without making the change live?
- Migrate not successful, DB is broken. How to fix, or at least output static HTML without plugins?
- After Migration From dev, Only my Links to the Homepage Still Redirect to dev
- How do I find out from my database what version of WordPress I need?
- Backup Restore turns carriage returns to literal strings
- I have a WordPress 4.6 database dump – how do I use it in a new install?
- I cannot change anything in my wordpress database from within wordpress?
- Copy WordPress to new directory
- Find/ascertain latest wordpress db from multiple database copies
- Media library images “missing” after migrating them using SQL
- version control for wordpress? (wordpress folder and database at same time)
- Restoring .sql backup results in “Error establishing a database connection”
- import (migration) user database to wp-users
- Database question while Migrating from one domain to another on same WebHost [Bluehost]
- Moving database from WP 2.6 to 3.5 problem
- Importing Concrete5 content to WordPress
- Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]
- What’s the cleanest way to transfer WordPress to a new server
- Improve or optimize a very slow query
- MySQL Syntax Error upon restoring database from backup [closed]
- How to check if a core update, like 4.9.8 → 5.0, involves a database update (migration)?
- what is the best way to store user created data?
- WordPress Settings Lost After Site Migration
- WordPress and user security
- How to delete database without using any plugin?
- WordPress database products structure
- Migrating my site to a new domain does not keep any changes made in customizer
- Restore of database doesn’t show content
- Why theme settings lost when I installed https
- mysqli_query(): MySQL server has gone away for Curl Request