Learning some Mysql

I get to wear my MySQL hat – so some commands more for my own reference:

All databases:

mysqldump -u [username] -p [password] [databasename] > [backupfile.sql]

mysqldump -u sadmin -p pass21 Customers > custback.sql

Some databases:

mysqldump -u root -p pass21 –databases Customers Orders Comments > multibackup.sql

Compressing on the fly:

mysqldump –all-databases | gzip >databasebackup.sql.gz

Tags: it, work

02.Sep.08 Randomness

You can follow any responses to this entry through the RSS 2.0 feed.
Both comments and pings are currently closed.