Difference between revisions of "Moving To New Server"
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...") |
|||
| (4 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
=Moving Joomla to a new Server= | |||
==On the old server, dump the database:== | ==On the old server, dump the database:== | ||
mysqldump -u root | mysqldump -u root --single-transaction --routines DBNAME > joomla.sql | ||
Copy the files while preserving permissions and timestamps: | Copy the files while preserving permissions and timestamps: | ||
| Line 9: | Line 11: | ||
===Create the database in phpmyadmin=== | ===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 | |||
Latest revision as of 17:31, 11 November 2026
Moving Joomla to a new Server
On the old server, dump the database:
mysqldump -u root --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