Difference between revisions of "Moving To New Server"
Jump to navigation
Jump to search
| Line 12: | Line 12: | ||
* Click Databases in the top tab bar. | * 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. | * 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 -p DBNAME < joomla.sql | |||
Revision as of 17:30, 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.
Import from the command line
mysql -u root -p DBNAME < joomla.sql