tags: apache   archive   business   charity   climbing   cluster   comic   database   email   exchange   family   fm2008   hack   humour   linux   liverpool   microsoft   money   mysql   network   oes   opensource   outlook   php   pictures   poem   process   project   real_life   review   rss   science   security   software   sql   thought   tsm   updates   webdev   website   windows  

MySQL Dump Load

Fri, 18 Jul 2008 10:29:22

If you want to take a backup of your MySQL database or move it to another server, here's the easiest way. Run the following from a cmd, terminal or bash session, do not use the mysql command line tool.

DUMP
mysqldump -h hostname -u user --password=password databasename > filename

LOAD
mysql -h hostname -u user --password=password databasename < filename

Cheers
Ryan Partington

mysql/