Christopher Juckins

SysAdmin Tips, Tricks and other Software Tools

User Tools

Site Tools


centos_8_migration_notes

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Next revisionBoth sides next revision
centos_8_migration_notes [2020/10/14 15:10] juckinscentos_8_migration_notes [2020/10/14 20:55] juckins
Line 16: Line 16:
     * mkdir ("$log_dir", 0755);     * mkdir ("$log_dir", 0755);
     * should crons write to /tmp and then have a daily script that checks cron logs for errors?     * should crons write to /tmp and then have a daily script that checks cron logs for errors?
 +
 +
 +----
 +
 +
   * Get inventory of users   * Get inventory of users
 +  * ///
 +  * Check that PHP is working correctly, localhost/index.php tries to open a file
 +    * check httpd.conf
 +  * ///
 +  * Clear all history from Firefox before testing phpmyadmin
 +    * Check httpd logs for any errors, such as mod security
 +    * uninstall [[https://phoenixnap.com/kb/setup-configure-modsecurity-on-apache|mod_security]] if necessary
 +  * [[https://www.digitalocean.com/community/tutorials/how-to-set-up-a-firewall-using-firewalld-on-centos-8|Add https and http to firewall rules]]
   * <color #ed1c24>MySQL / MariaDB Database and users</color>   * <color #ed1c24>MySQL / MariaDB Database and users</color>
     * [[https://www.digitalocean.com/community/tutorials/how-to-reset-your-mysql-or-mariadb-root-password|Reset mysql root password]]     * [[https://www.digitalocean.com/community/tutorials/how-to-reset-your-mysql-or-mariadb-root-password|Reset mysql root password]]
     * [[https://www.tecmint.com/install-lamp-on-centos-8/|Notes for installing LAMP]] on CentOS 8     * [[https://www.tecmint.com/install-lamp-on-centos-8/|Notes for installing LAMP]] on CentOS 8
-    * [[https://www.tecmint.com/transfer-mysql-databases-from-old-to-new-server/|Migrate with rsync]]+    * [[https://www.digitalocean.com/community/tutorials/how-to-install-the-apache-web-server-on-centos-8]] 
 +    * [[https://www.tecmint.com/transfer-mysql-databases-from-old-to-new-server/|Migrate all databases with mysqldump]] 
 +      * Note that the restore of mysql does not use "--all-databases" option and is an error in link above
     * [[https://www.linode.com/docs/databases/mysql/create-physical-backups-of-your-mariadb-or-mysql-databases/|Migrate with tar]]     * [[https://www.linode.com/docs/databases/mysql/create-physical-backups-of-your-mariadb-or-mysql-databases/|Migrate with tar]]
     * [[http://www.uptimemadeeasy.com/linux/mysql-migrate-users-server-server/|Migrate MySQL users to new machine]]     * [[http://www.uptimemadeeasy.com/linux/mysql-migrate-users-server-server/|Migrate MySQL users to new machine]]
-      * Don'forget to add semicolons with this:  # sed -i ‘/[^;] *$/s/$/;/’ ./grantfile+      * They can be exported from phpmyadmin (but don'include root)
   * export MySQL databases with mysqldump   * export MySQL databases with mysqldump
     * [[https://www.digitalocean.com/community/tutorials/how-to-migrate-a-mysql-database-between-two-servers|Migrate MySQL database to new server]]     * [[https://www.digitalocean.com/community/tutorials/how-to-migrate-a-mysql-database-between-two-servers|Migrate MySQL database to new server]]
centos_8_migration_notes.txt · Last modified: 2022/06/08 16:03 by juckins