That will work – as long as you’re the only user. If other users have access to the site you’d also have to port over their work to the other database. If that’s the case, you may want to copy your entire website to a staging site, make the changes there, and once changes are complete push everything (database and files, assuming files are also necessary) to the live site.
Related Posts:
- Please explain how WordPress works with MySQL character set and collation at a low level
- Connect to database using wordpress wp-config file
- Accessing two databases
- Delete all post meta except featured image
- Custom DB_COLLATE (collation) value not working on fresh install?
- Set Display Name to first and last name (phpmyadmin SQL Query)
- Why can’t I swap a DB in a WP install? [closed]
- Emojis getting converted to “?”
- How to replace values in WordPress DB using phpMyAdmin
- Delete all post meta except featured image Using SQL
- Can I have multiple database users within WordPress?
- Accidentally deleted active_plugins portion of the wp_options DB table
- Error establishing a database connection on Installation
- Moving WP from local server to live, error establishing a db connection
- WordPress database import: Row size too large
- Connect to a remote database for wordpress in my own hosting server
- WordPress Database Huge wp_usermeta Table
- Switching Databases in LocalHost
- Will changing the folder name two directories above a fresh wordpress installation break the site?
- Localhost to Staging to Development Dynamic WP-CONFIG
- How to share plugin created database tables between two WordPress sites
- Connection refused on locahost after importing database?
- Changing root password in PHPMyAdmin for WordPress Database when going live
- Can’t update WordFence Options, clear data manually
- Post Views / Hit Counter Problem?
- How to migrate a database from a server to another
- Problem migrating to localhost
- Is my way to change WordPress server is correct?
- how to encyrpt DB_PASSWORD in wp-config
- SELECT SQL_CALC_FOUND_ROWS with wordpress search
- Files on Localhost, Database on Server
- Backing up WordPress database and files
- wp_option table error while importing
- Installing local to live WP into subdirectory
- Getting WordPress to work inside a rails 3 application
- Can two domains use the same database?
- Delete user with only subscriber role
- WordPress keeps redirecting to localhost
- Can’t log into wordpress site – I have made a new user and still cant access
- Is there any way to monitor a MySQL db and check what has changed?
- 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’
- How to re-connect WP files in lampp/htdocs to new SQL database to recover site under development
- I need to find posts that contain YouTube links without http:// or https:// prefix and add http:// to all of them
- Is there any defects for using same database prefix in WordPress for multiple sites?
- Migrating meta_key and meta_value from old theme to new one
- What is recommended data type and encryption type for password in a database
- syntax error for changing user role from database
- WP website showing blank page after moving from subdomain to main domain
- Confused over wp-config.php and ‘database user + database password + name’
- Cloned site not connecting to database – MAMP
- How to retrieve user data based on role using SQL?
- WordPress character set issue
- execute custom function on database connection error
- Does WordPress Support Using Named Pipes on the Windows Operating System?
- Missing latest posts and options after DB migration via phpMyAdmin
- I have include wp-config, should I add global $wpdb also?
- Can’t Install WordPress (local) Failed to open file wp-includes/wp-db.php
- Issue “Error establishing a database connection” problem.
- Check if a database is well installed
- Changed meta_key value in structures, now dashboard shows zero users
- Options table – where does my values go?
- /var/run/mysqld/mysqld.sock
- Database question while Migrating from one domain to another on same WebHost [Bluehost]
- DB access blocked when initializing WP externally
- How to use remote db tables in current config? [duplicate]
- Multiple Address In WP-Option Value
- ERROR: “Table Prefix” must not be empty
- Can I connect WordPress website with an external database?
- wp-config was suddenly updated
- Deleting WordPress posts and media files based on author via MYSQL database
- Database table prefix different between wp-config.php and in database
- Rename a table in MySQL
- How should I tackle –secure-file-priv in MySQL?
- Keeping WP database synced across multiple developers using git
- Connect forms in WP to external database
- Hook into $wpdb
- Is it wise to delete post revisions and autosaves from database?
- Using two different DB users on one WP install
- Usage of Direct Database Call Without Caching Error
- Can I transfer a mysql database to another site?
- Backup another database with BackUpWordPress plugin [closed]
- Easiest Way to Authenticate WP Users Using an External DB?
- How do I find out the full path of a page’s template?
- “The link you followed has expired” & “Error while saving” messages when adding new post
- Sending data with multi step form to wp database
- WordPress query is not returning proper results
- What does wp_term_taxonomy.parent reference?
- pull data from a remote wordpress database
- Users table missing from Database [closed]
- How to connect and insert data in database of wordpress?
- wp_insert_user not creating account correctly when ID is manually set
- How do I change several broken URLs in a several wordpress databases in the fastest way?
- Best way to store 1 billion+ posts?
- update to a new template without loosing any data
- Locally installing wordpress. Database problem
- I have my full special database from xampp how can i use this on wordpress?
- Changing database links has no effect
- Restrict users viewing post using age on database [closed]