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)

 S153 - Sourcing, Running and Configuring MySQL

Back to Hotel - online feedback forms compared

Previous and next or Horse's mouth home

Forward to

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
Link to page ... 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33 at 50 posts per page


This is a page archived from The Horse's Mouth at http://www.wellho.net/horse/ - the diary and writings of Graham Ellis. Every attempt was made to provide current information at the time the page was written, but things do move forward in our business - new software releases, price changes, new techniques. Please check back via our main site for current courses, prices, versions, etc - any mention of a price in "The Horse's Mouth" cannot be taken as an offer to supply at that price.

Link to Ezine home page (for reading).
Link to Blogging home page (to add comments).