'm working in my spare time I often at the Web site of a sports club ( www.tsv-oberensingen.de ) around, in which I also have an honorary position (head of the table tennis section). This Web site is based on the open, MySQL based CMS TYPO3.
For larger experiments with the system (that could go wrong times ...) I copied the files from the web space and MySQL database from the hosted provider environment in a local WAMP environment and afterwards (if I know that does everything) back.
The file-based portion of the data transfer is not a problem with Total Commander or Filezilla can be copied, larger directory trees via FTP.
situation is completely different from the backup and restore of the database. Since I have no SSH access to the hosted server, I can not make a mysqldump from the command line and had to settle for far more with the provider made phpMyAdmin.
Unfortunately neither phpMyAdmin for generating large dumps nor wiedereinzulesen this really be, because it runs at the dump production in the usual PHP scripts 30-second timeout, and also when reading from a SQL Files 16-MB limit sets. As a workaround, you can then divide everything into small pieces (such as table), but this is really a great effort and impractical.
brought the solution to the problem, the free Backup-/Restore-Tool MySQLDumper that you can download from www.mysqldumper.de . The script handles the time-out problem in that only a small part of the data is dumped and then it calls itself, and the point continues, where it was. For the user of the whole process is completely transparent, he added at the end of a zip file with a complete dump of the database.
Installing MySQLDumper is really very simple and comfortable, you put on the Web Space mysqldumper a subdirectory and extract all files to the latest ZIP distribution there, then you call the browser http://www.meinserver.de/mysqldumper , the initial setup dialog is done out.
Other great features:
- The installer puts all the needed subdirectories in itself, if it fails the first try, even alternatively using the FTP protocol
- MySQLDumper Dump files can also restore the other programs were created
- establishment of the list directly in the protection MySQLDumper, no handling. htaccess etc. necessary
- very active support forum at www.mysqldumper.de
