How to Create a MySQL Backup of a big Database

by on Feb.02, 2010, under Linux, Web Development

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:

Incoming search terms:

Share
:, , , , , ,

Leave a Reply

Looking for something?

Use the form below to search the site:

Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!