stuff24 blog

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:

1. Login to your web server with Putty (Windows) or any other SSH client
2. 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

3. Copy the newly created backup (dump.sql) to a safe place via SCP or FTP

That’s it!

More information:

• mysqldump reference manual

Incoming search terms:

• backup big mysql
• mysql backup big database
• backup big database
• how to create backup from big database
• how to create backup from huge database