Before you carry out extensive work such as a TYPO3 update or the installation of an extension, you should create a copy of your TYPO3 project. This allows you to carry out updates or similar work on the copy first without affecting the functionality of the original site.
This video shows you how to create a copy in just a few minutes.
Copy database
The following command copies a database to a new one "in one go".
mysqldump --opt -h mariadb106 -u db123456_78 -p'XXXXXX' db123456_78 | mysql -h mariadb106 -u db123456_89 -p'XXXXXX' db123456_89
Replace db123456_78 with your source database and db123456_89 with the target database.
Instead of XXXXXX, enter the respective passwords of the database users.
The output of the mysqldump (export) command is forwarded directly to the mysql command via the pipe symbol | and imported into the new database.
Updated: 17.07.2024