Moving To New Server

From rbachwiki
Revision as of 17:30, 11 November 2026 by Bacchas (talk | contribs)
Jump to navigation Jump to search

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.

Import from the command line

mysql -u root DBNAME < joomla.sql