Difference between revisions of "Moving To New Server"
Jump to navigation
Jump to search
| Line 14: | Line 14: | ||
==Import from the command line== | ==Import from the command line== | ||
mysql -u root | mysql -u root 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 DBNAME < joomla.sql