WordPress - Revision history

Bacchas at 16:39, 10 May 2022

2022-05-10T16:39:18Z

← Older revision		Revision as of 16:39, 10 May 2022
Line 10:		Line 10:
	* Log into phpmyadmin		* Log into phpmyadmin
	* click sql		* click sql
			* make sure you change the table to the proper name

	UPDATE bd_options SET option_value = replace(option_value, 'http://www.oldurl.com', 'http://www.newurl.com') WHERE option_name = 'home' OR option_name = 'siteurl';		UPDATE bd_options SET option_value = replace(option_value, 'http://www.oldurl.com', 'http://www.newurl.com') WHERE option_name = 'home' OR option_name = 'siteurl';
Line 23:		Line 23:

	UPDATE bd_comments SET comment_content = replace(comment_content , 'http://www.oldurl.com','http://www.newurl.com');		UPDATE bd_comments SET comment_content = replace(comment_content , 'http://www.oldurl.com','http://www.newurl.com');

			===If you have images linked in your posts then you need to run the following additional queries.===
			''''For images inside posts'''
			UPDATE wp_posts SET post_content = replace(post_content, 'Existing URL', 'New URL');

			'''For images linked in old link manager'''
			UPDATE wp_links SET link_image = replace(link_image, 'Existing URL','New URL');

			'''For images linked as attachments'''
			UPDATE wp_posts SET guid = replace(guid, 'Existing URL','New URL');



	==[[Open Source Software]]==		==[[Open Source Software]]==

Bacchas at 16:36, 10 May 2022

2022-05-10T16:36:32Z

← Older revision		Revision as of 16:36, 10 May 2022
Line 7:		Line 7:
	* Check the wp-config.php file make sure everything is ok		* Check the wp-config.php file make sure everything is ok

			== If you change the URL then you have to update the database also==
			* Log into phpmyadmin
			* click sql


			UPDATE bd_options SET option_value = replace(option_value, 'http://www.oldurl.com', 'http://www.newurl.com') WHERE option_name = 'home' OR option_name = 'siteurl';

			UPDATE bd_posts SET post_content = replace(post_content, 'http://www.oldurl.com', 'http://www.newurl.com');

			UPDATE bd_postmeta SET meta_value = replace(meta_value,'http://www.oldurl.com','http://www.newurl.com');

			UPDATE bd_usermeta SET meta_value = replace(meta_value, 'http://www.oldurl.com', 'http://www.newurl.com');

			UPDATE bd_links SET link_url = replace(link_url, 'http://www.oldurl.com','http://www.newurl.com');

			UPDATE bd_comments SET comment_content = replace(comment_content , 'http://www.oldurl.com','http://www.newurl.com');

	==[[Open Source Software]]==		==[[Open Source Software]]==

Bacchas: /* [Open Source Software] */

2022-05-10T15:47:36Z

[Open Source Software]

← Older revision		Revision as of 15:47, 10 May 2022
Line 8:		Line 8:


	==[Open Source Software]==		==[[Open Source Software]]==

Bacchas at 15:47, 10 May 2022

2022-05-10T15:47:23Z

← Older revision		Revision as of 15:47, 10 May 2022
Line 6:		Line 6:
	* Copy the entire folder over from the old installation to the new server		* Copy the entire folder over from the old installation to the new server
	* Check the wp-config.php file make sure everything is ok		* Check the wp-config.php file make sure everything is ok


			==[Open Source Software]==

Bacchas: /* Move Wordpress to a new server */

2022-05-10T15:45:30Z

Move Wordpress to a new server

← Older revision		Revision as of 15:45, 10 May 2022
Line 3:		Line 3:
	* Export the database.		* Export the database.
	* Create a blank database in phpmyadmin with the same name		* Create a blank database in phpmyadmin with the same name
			* Import the database into the database you just created
	* Copy the entire folder over from the old installation to the new server		* Copy the entire folder over from the old installation to the new server
	* Check the wp-config.php file make sure everything is ok		* Check the wp-config.php file make sure everything is ok

Bacchas: Created page with "==Move Wordpress to a new server== * Export the database. * Create a blank database in phpmyadmin with the same name * Copy the entire folder over from the old installation to the new server * Check the wp-config.php file make sure everything is ok"

2022-05-10T15:44:25Z

Created page with "==Move Wordpress to a new server== * Export the database. * Create a blank database in phpmyadmin with the same name * Copy the entire folder over from the old installation to the new server * Check the wp-config.php file make sure everything is ok"

New page

==Move Wordpress to a new server==

* Export the database.
* Create a blank database in phpmyadmin with the same name
* Copy the entire folder over from the old installation to the new server
* Check the wp-config.php file make sure everything is ok