mysqldump and mysqlrestore

It is vital that you back up your data ... and if you hold your data in a MySQL database, then the mysqldump utility will do the job admirably for you.

It is equally vital that you can restore the data from backup if (heaven forbid) you need to do so ... and yet there is not a mysqlrestore utility.

Why so? How do I restore dumped data?

Mysqldump saves data in the form of SQL commands which can be typed in to the mysqlclient program .... and tha program supports a source command which allows the user to bring in the data from a named file.

Want to see an example? Let's use MySQLDump and MySQL to dump a database (called imageapp) from one server (called liveserver) and restore it, inder a new name (imgappcopy), on another server (devserver):

mysqldump -hliveserver -uroot -p imageapp > images.sql

mysql -hdevserver -uroot -p

create database imgappcopy;

use imgappcopy;

source images.sql

(written 2007-03-30 14:55:56)

Associated topics are indexed under

S153 - Sourcing, Running and Configuring MySQL

Back to
Hotel - online feedback forms compared

Previous and next
or
Horse's mouth home

Forward to

Some other Articles

A day at the races
MacFormat - Me and My Mac
Train service - petititon reply
mysqldump and mysqlrestore
Hotel - online feedback forms compared
Sharing the load with Apache httpd and perhaps Tomcat
1200 miles in 3 days
The Last Word on the road
Origin of Jack and Jill and little Jack Horner
Newport Male Voice Choir