1. Summary
  2. Files
  3. Support
  4. Report Spam
  5. Create account
  6. Log in

Changes between Version 6 and Version 7 of Using mysqldump for backups

Show
Ignore:
Timestamp:
01/06/10 21:52:42 (4 years ago)
Author:
ctsai (IP: 172.29.29.55)
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • Using mysqldump for backups

    v6 v7  
    1212  * Next, run the `mysqldump` command.  The below example also compresses the dump file and adds the date to the filename.  Please replace `DATABASE` with the name of your database and `DATABASE_USER` with the name of your database user: 
    1313{{{ 
    14 mysqldump -h mysql-LETTER.sourceforge.net --user=DATABASE_USER --opt -p DATABASE | gzip > DATABASE.`date +%Y-%m-%d`.sql.gz 
     14mysqldump -h mysql-LETTER.sourceforge.net --user=DATABASE_USER -P 4040 --opt -p DATABASE | gzip > DATABASE.`date +%Y-%m-%d`.sql.gz 
    1515}}} 
    1616  * When complete, remove any temporary files you may have created.