First change database name, username and password in the config.php file
/** The name of the database for WordPress */
define('DB_NAME', 'DB_NAME');
/** MySQL database username */
define('DB_USER', 'DB_USERNAME');
/** MySQL database password */
define('DB_PASSWORD', 'DB_PASSWORD');
then upload the database and run the following queries, this will change all the local links to your live url
UPDATE wp_options SET option_value = replace(option_value, 'http://www.oldurl', 'http://www.newurl');
UPDATE wp_posts SET guid = replace(guid, 'http://www.oldurl','http://www.newurl');
UPDATE wp_posts SET post_content = replace(post_content, 'http://www.oldurl', 'http://www.newurl');
UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://www.oldurl','http://www.newurl');
After this wp-admin should work, then login and go to settings>permalink and hit save which will reset the redirects.
Related Posts:
- Error Logs to Diagnose Error 500 in LAMP
- How to get a Custom 500 Error Page to show?
- How to show the error causing the ‘There has been a critical error on your website’?
- Nginx 404, 500 errors and WordPress
- How to Fix “Are You Sure You Want to Do This”, while uploading my theme?
- 500 error after update
- A SINGLE Post Giving an “Under Maintenance” Message
- Weird Cron Error
- Internal 500 error: Activating rootio theme and deploying with capistrano
- Unable to log in: “Cannot serve directory www/wordpress/wp-includes/ No matching DirectoryIndex”
- My websit dosent worke http errors 500
- Showing errors with $wpdb update
- Unable to locate WordPress Content directory (wp-content)
- How to fix “There has been a critical error on your website. Please check your site admin email inbox for instructions”?
- Notice: Use of undefined constant SCRIPT_DEBUG
- WordPress Redirecting to wp-admin/install.php
- When does remove_filter not work?
- This webpage is not available ERR_NAME_NOT_RESOLVED
- Error 310 too many redirects after switching domains
- How do I set up Debugging?
- Does wordpress have an error log?
- WP_DISABLE_FATAL_ERROR_HANDLER vs WP_DEBUG ? What to use and when to use to see errors?
- Call to undefined function get_header() in index.php
- Dashboard Whitescreen of Death?
- Unexpected Output: register_activation_hook with namespace
- WP Site Only Shows Javascript for Main Page
- PHP notice coming from the WordPress core?
- Get notified by email when Fatal error occurs on wordpress site?
- Is there a way to avoid 404 pages in WordPress?
- Get PHP Fatal error on globalized $wpdb: Call to a member function insert() on a non-object- I have no clue. What to do?
- media_buttons_context is deprecated
- PHP Fatal error: Call to a member function get() on null in /wp-includes/cache.php on line 123
- Unable To Login With Correct Credentials?
- Any way to check the integrity of a WordPress site?
- is_wp_error() and handling errors
- I am getting an error some times when uploading themes
- After upgrading Debian Buster to Bullseye, WordPress sites no longer updating
- My wordpress site loads perfectly, but I cannot access the menus in the admin panel
- Call to undefined function wp_embed_register_handler()
- Site works fine, but editing page causes error “Call to undefined function _wp_array_get()” in Gutenberg
- Odd error on top of my dashboard. How do I fix it?
- Handle new created WP_Error
- Deprecated issue in WordPress [closed]
- Why getting “The input type is invalid” when accessing edit.php?
- Warning: An unexpected error occurred. Something may be wrong with WordPress.org
- Visual editor not working after update
- Two Domain pointing to the same WordPress installation
- Front end empty (i.e. nothing displays); Back end looks fine; What are possible causes?
- Website Warning: call_user_func_array() expects parameter 1 to be a valid callback, class ‘Wppr_Public’ does not have a method ‘amp_support’
- Debugging: How to determine which plugin is throwing error in plugin.php
- “load-scripts.php” hangs and times out when plupload is requested
- Object of class stdClass could not be converted to string in
- why would ABSPATH not get defined
- 404 Not found error after update to WordPress 5.0
- Keep getting this code reparted again and again?
- How to trace an Error when it says nothing about any plugin?
- WordPress fonts need to upload with Google fonts?
- require_once() error after moving WordPressto another server
- Method Not Implemented GET to wp-admin/post.php not supported
- Removed plugin generating error message
- Parse error:syntax error [closed]
- When sorting WP_List_Table, table sorts, but I also get SQL errors
- Why do these errors appear on my wordpress site? [closed]
- WordPress + Buddpyress – troubleshooting server overloading
- Error when activating child theme: `failed to open stream: No such file or directory`
- Error when trying to logout
- WordPress cracked? Posts not found in dashboard
- Multiple use wp_logout_url() on page cause ‘header already sent’ error after submit form
- A critical error has occurred on the site
- Fatal error for category archives
- 403. You don’t have permission to access this resource error
- Critical error but refresh fixes it
- How to identify the origin of an issue or an unexpected behavior?
- Fatal Error: Uncaught Error: call to undefined function get_plugin_data after uploading 2 blog posts(wp-shopify)
- WordPress error when update to new version
- Forbidden permission and editor error after update to WordPress 5.1.1
- Crawl Errors in Search console
- How to fix this CORS error?
- One page is showing the “Index of /” error
- Parse error: syntax error, unexpected ”tax_query” in wordpress
- What is the source of “HTTP error,” and
- WordPress Dashboard visible but site is not after migration
- 403 error with no reason
- WordPress displays 500 error on PHP errors
- All of my wordpress sites showing †Ù¥
- Possible to hide the search engine indexing disabled prompt/error message?
- WordPress Error Missing Argument [duplicate]
- WordPress installation self deleted in server restart. SQL Tables gone too!
- Error updating WordPress, does not ask for FTP password, just error
- Post show up as post and pages
- Parse error: syntax error, unexpected T_FUNCTION
- Error thrown Cannot use object of type WP_Error as array
- The ( error_log ) file size is very large
- index page is not loading [closed]
- Solve theme installation problem?
- Fatal error trace not shown in development setup
- Console errors after WordPress Update 6.1
- Getting 403 Forbidden Error while trying to edit or delete new posts or existing posts
- Creating a function inside a custom WordPress Plugin [closed]
- Critical error after updating my wordpress