WordPress Manual Upgrade for Experts: Difference between revisions

(4 intermediate revisions by the same user not shown)

Line 26:

===Database===

For the database, use the mySQL (MariaDB, etc.) command line or phpMyAdmin. phpMyAdmin makes it much easier. Select the database in the left pane, Export Tab, "Simple" Radio Button, Go Button, save it to a file, done.

For the command line;

* Export: mysqldump -u WhatEverUserName -p WhatEverDataBaseName > WhatEverFileName.sql

* Create

** CREATE DATABASE WhatEverDatabaseName;

** GRANT ALL ON WhatEverDatabaseName.* TO 'WhatEverUserName'@'localhost' IDENTIFIED BY 'WhatEverPassword';

** FLUSH PRIVILEGES;

* Import: mysql -u WhatEverUserName-p WhatEverDatabaseName< WhatEverFileName.sql

===Other Thoughts===

Line 63:

Line 74:

*Make sure the original wp-config.php file is in the upgrade directory (The "original / working" version of the file should be copied with the above CP command as it does not typically exist in a newly extracted version of WordPress (it's generated))

*Also remember a LOT of extensions make use of an .htaccess file (with Apache and other web servers) to modify the behavior of a WordPress site, so make sure ~~that~~ file from the original version of that file is copied into the upgrade directory (it is a hidden file, so ~~make sure~~).

*Also remember a LOT of extensions make use of an .htaccess file (with Apache and other web servers) to modify the behavior of a WordPress site, so '''make sure the .htaccess file from the original version of that file is copied into the upgrade directory''' (it is a hidden file, so double check that). And after it was promptly forgotten by the author of this article, looked it up and found this reference too: https://tompai.pro/wordpress/solved-404-on-posts-and-pages-after-wordpress-update-to-4-9-8/ (it applies to other versions than the one noted in that article).

===Plugins===

Line 69:

Line 80:

cp -ax WhatEverExtension WhatEverExtension.BackUp

</syntaxhighlight>

===Database===

The website database may also need to be updated. Navigate to: https://www.riseofthesaltonsea.com/wp-admin/upgrade.php and it will prompt to update the database if necessary.

==Final Thoughts==

@@ Line 26: / Line 26: @@
 ===Database===
 For the database, use the mySQL (MariaDB, etc.) command line or phpMyAdmin.  phpMyAdmin makes it much easier.  Select the database in the left pane, Export Tab, "Simple" Radio Button, Go Button, save it to a file, done.
+For the command line;
+* Export: mysqldump -u WhatEverUserName -p <mark>WhatEverDataBaseName</mark> > WhatEverFileName<mark>.sql</mark>
+* Create
+** CREATE DATABASE WhatEverDatabaseName;
+** GRANT ALL ON WhatEverDatabaseName.* TO 'WhatEverUserName'@'localhost' IDENTIFIED BY 'WhatEverPassword';
+** FLUSH PRIVILEGES;
+* Import: mysql -u WhatEverUserName-p WhatEverDatabaseName< <mark>WhatEverFileName.sql</mark>
+<br />
 ===Other Thoughts===
@@ Line 63: / Line 74: @@
 *Make sure the original wp-config.php file is in the upgrade directory (The "original / working" version of the file should be copied with the above CP command as it does not typically exist in a newly extracted version of WordPress (it's generated))
-*Also remember a LOT of extensions make use of an .htaccess file (with Apache and other web servers) to modify the behavior of a WordPress site, so make sure that file from the original version of that file is copied into the upgrade directory (it is a hidden file, so make sure).
+*Also remember a LOT of extensions make use of an .htaccess file (with Apache and other web servers) to modify the behavior of a WordPress site, so '''make sure the .htaccess file from the original version of that file is copied into the upgrade directory''' (it is a hidden file, so double check that).  And after it was promptly forgotten by the author of this article, looked it up and found this reference too: https://tompai.pro/wordpress/solved-404-on-posts-and-pages-after-wordpress-update-to-4-9-8/ (it applies to other versions than the one noted in that article).
 ===Plugins===
@@ Line 69: / Line 80: @@
 cp -ax WhatEverExtension WhatEverExtension.BackUp
 </syntaxhighlight>
+===Database===
+The website database may also need to be updated.  Navigate to: https://www.riseofthesaltonsea.com/wp-admin/upgrade.php and it will prompt to update the database if necessary.
 ==Final Thoughts==