CGI/Perl Guide | Learning Center | Forums | Advertise | Login Site Search: in Perl Guide PerlGuru Forums Learning Ctr

	MAIN INDEX	SEARCH POSTS	WHO'S ONLINE	LOG IN

Home: Perl Programming Help: DBI: Easy backup, and import backup?

skirrow stranger Feb 23, 2003, 8:59 AM Post #1 of 5 (5540 views) Easy backup, and import backup? Can't Post Hi, Are their any modules or any easy ways of backing up an entire mySQL database? Also, if possible also an easy way to then import the backup? Is the only way to read all the records from the db out to data files and then import from the data files back to the mySQL db? Thanks, - Neil -- http://www.locked-area.com/ http://www.opencrypt.com/

Paul Enthusiast Feb 24, 2003, 6:04 AM Post #2 of 5 (5536 views) Re: [skirrow] Easy backup, and import backup? [In reply to] Can't Post bash$ mysqldump -u USERNAME -p DATABASE > /path/to/file.txt

skirrow stranger Feb 24, 2003, 6:12 AM Post #3 of 5 (5533 views) Re: [Paul] Easy backup, and import backup? [In reply to] Can't Post Thank you! What about importing the data back to the mySQL db? Or does that dump the structure info as well so I can just run it to re-create dbs? - Neil -- http://www.locked-area.com/ http://www.opencrypt.com/

Paul Enthusiast Feb 24, 2003, 6:14 AM Post #4 of 5 (5532 views) Re: [skirrow] Easy backup, and import backup? [In reply to] Can't Post It dumps the structure. Reimport using: mysql -u USERNAME -p DATABASE < /path/to/file.txt

skirrow stranger Feb 24, 2003, 6:27 AM Post #5 of 5 (5529 views) Re: [Paul] Easy backup, and import backup? [In reply to] Can't Post Excellent! Thank you so much. - Neil -- http://www.locked-area.com/ http://www.opencrypt.com/

Announcements     PerlGuru Announcements Perl Programming Help     Frequently Asked Questions     Beginner     Intermediate     Advanced     Regular Expressions     mod_perl     DBI     Win32 Programming Help Fun With Perl     Perl Quizzes - Learn Perl the Fun Way     Perl Golf     Perl Poetry Need a Custom or Prewritten Perl Program?     I need a program that...     I Need a Programmer for Freelance Work     Throw Down The Gauntlet General Discussions     General Questions     Feedback     Tutorial/Article Suggestions for The Learning Cent     Internet Security Other Programming Languages     Javascript     PHP

Search this forum this category all forums for All words Any words Whole Phrase (options)

Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives