[TYPO3-english] transfer typo3 database

Christian Zenker christian.zenker at 599media.de
Tue Jun 14 12:00:44 CEST 2011


Yeah, that should have been another point on the list.

> Instead put your database in some subfolder like "_import" and name it  
> "database.sql"
>
> Then put this script as php file "import_database.php" in this folder  
> and run from your browser like  
> http://www.example.com/_import/import_database.php

You actually don't have to write that script. TYPO3 has this functionality  
in the install tool. You just have to upload the file to the typo3conf  
folder and give it whatever name you like as long as it ends with ".sql".  
If you enter the Install Tool now, you can click the file in the tab for  
all the database operations. This will import the file regardless of the  
filesize (as long as it does not exceed the maximum time for PHP scripts,  
but it usually should not). The only limitation, that might be annoying,  
is that you have to keep the table definitions in that file.

Christian.


More information about the TYPO3-english mailing list