HacksLinux SysAdmin Notes
Backing up your WebSite is a necessary step for all users.
This article describes how to recursively download your WebSite with all files, directories and sub-directories from FTP server, using Wget utility.
Do not use phpMyAdmin to restore your MySQL database if the MySQL database is large.
phpMyAdmin has limit on total upload size and, there is also maximum execution time which may cause browser to time out.
The solution of how to restore large MySQL database from the sql dump file is to use Linux/Unix command line.
The basic installation of MySQL Server provides a great command line utility to take backup of MySQL databases.
The 'mysqldump' command is used for creation "dumps" of databases managed by MySQL.
These dumps are just files with all the SQL commands needed to recreate the database.
Copyright © 2011-2015 Shell Hacks - Linux Howtos and Tutorials