Difference between revisions of "Moving To New Server"

From rbachwiki
Jump to navigation Jump to search
(Created page with "==On the old server, dump the database:== mysqldump -u root -p --single-transaction --routines DBNAME > joomla.sql Copy the files while preserving permissions and timestamps: rsync -avz --progress /var/www/joomla/ user@newserver:/var/www/joomla/ == On the new server, create the database and user, then import: == ===Create the database in phpmyadmin=== 1. Log in to phpMyAdmin (as root or another admin user). 2. Click Databases in the top tab bar. 3. Under “Create...")
 
Line 9: Line 9:


===Create the database in phpmyadmin===
===Create the database in phpmyadmin===
1. Log in to phpMyAdmin (as root or another admin user).
* Log in to phpMyAdmin (as root or another admin user).
2. Click Databases in the top tab bar.
* Click Databases in the top tab bar.
3. Under “Create database,” enter the name and pick the collation utf8mb4_unicode_ci (or utf8mb4_general_ci). Click Create.
* Under “Create database,” enter the name and pick the collation utf8mb4_unicode_ci (or utf8mb4_general_ci). Click Create.

Revision as of 17:29, 11 November 2026

On the old server, dump the database:

mysqldump -u root -p --single-transaction --routines DBNAME > joomla.sql

Copy the files while preserving permissions and timestamps:

rsync -avz --progress /var/www/joomla/ user@newserver:/var/www/joomla/

On the new server, create the database and user, then import:

Create the database in phpmyadmin

  • Log in to phpMyAdmin (as root or another admin user).
  • Click Databases in the top tab bar.
  • Under “Create database,” enter the name and pick the collation utf8mb4_unicode_ci (or utf8mb4_general_ci). Click Create.