How to Create a MySQL Backup of a big Database:
===================================
It’s not possible to create a backup from a MySQL database with phpMyAdmin which is bigger than 2 MB. If you are running MySQL on a Linux based system, try this:
Login to your web server with Putty (Windows) or any other SSH client
Type in your console:
#mysqldump -uYOURUSERNAME -pYOURPASSWORD DATABASE-NAME > dump.sql
(Note: there is no space between “-u”/”-p” and the MySQL username/password.)
You can create simply all database at once by using –all-databases insted of database_name
Copy the newly created backup (dump.sql) to a safe place via SCP or FTP
No comments:
Post a Comment