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
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- Get error messages when $wpdb->insert() returns false?
- Does dbDelta delete columns as well?
- Special characters in WordPress UTF-8 [closed]
- Query from a different database than the default
- Need of separate security plugins for both root and subfolder sites WordPress?
- Escaping / encoding data before insert into a database?
- Error: SELECT SQL_CALC_FOUND_ROWS
- Switching database on the fly
- Populate dropdown from database
- Finding the original login information in the database
- wordpress ‘database update required’ loop after update
- How to Access wp_usermeta Data Immediately After a New User is Created
- How to paginate information obtained from a query to a custom table?
- Trying to create a custom meta table for working with a custom table
- Connecting to a different database
- Regenerate user_nicename column
- Create Pages for database content
- Should I use an additional column in the DB?
- How to save EXIF metadata in WordPress database?
- Recurring 502 Bad Gateway issue
- why not selecting multiple rows of same standard_id using SQL query from database?
- WordPress Migration – Issue with admin panel changes
- How To connect to the same WordPress database with different database user
- Localize strings from db
- Redirect Issue: WordPress database
- Category not displaying in add post, edit post, and categories page.
- How to store a plain password in WordPress database in another field
- How to stop WordPress from using utf8mb4_unicode_ci collation