Backing up a database?

Dev Shed Forums Sponsor:

May 2nd, 2000, 06:14 AM

gunja

Junior Member

Join Date: Apr 2000

Posts: 22

Time spent in forums: < 1 sec
Reputation Power: 0

Please could someone let me know how I can backup a complete MySQL database, and restore it afterwards. We are running on Linux. Thanks...

------------------
Check out Nottingham's Only Alternative at http://urn.nott.ac.uk

May 2nd, 2000, 07:07 AM

Shiju Rajan

.Net Developer

Join Date: Feb 2000

Location: London

Posts: 987

Time spent in forums: 3 h 26 m 22 sec
Reputation Power: 14

i think you should use the mysqldump program for a full backup of your database:

shell> mysqldump --tab=/path/to/some/dir --opt --full

see the mysql-manual for the database back up details.

------------------
SR -
shiju.dreamcenter.net

Viewing: Dev Shed Forums > Databases > MySQL Help > Backing up a database?

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump