Mica noastra lume

… sau fiecare cu lumea lui

Manual backup of database

Posted by unepetitemonde pe Aprilie 29, 2008

Manual backup of database
If you want to make a copy of a database you need to use the mysqldump command:
mysqldump -u USER -p –opt database > backup.sql
or, if the user is password protected, use that command:
mysqldump -u USER -pPassword –opt database > backup.sql
The original article was posted here

Un răspuns to “Manual backup of database”

  1. Martin said

    I can suggest you to have a look at more professional sql backup methods and tools. For example, we use LiteSpeed that can really speed up backup and restore process and give some extra abilities like high compression, different ways of encryption, cretaing self extracting database backups, individual objects and empty schemas restoring, support of managing native backups and many more.
    The tool supports all popular sql server editions like SQL Server 2000, SQL Server 2005, SQL Server 7, MSDE / SQL Express, SQL Server 2008 CTP 4

Lasă un răspuns

Completează mai jos detaliile despre tine sau dă clic pe un icon pentru autentificare:

Logo WordPress.com

Comentezi folosind contul tău WordPress.com. Dezautentificare / Schimbă )

Poză Twitter

Comentezi folosind contul tău Twitter. Dezautentificare / Schimbă )

Fotografie Facebook

Comentezi folosind contul tău Facebook. Dezautentificare / Schimbă )

Fotografie Google+

Comentezi folosind contul tău Google+. Dezautentificare / Schimbă )

Conectare la %s

 
%d blogeri au apreciat asta: