Unix Technical Forum

backup MySql (newbie)

This is a discussion on backup MySql (newbie) within the MySQL forums, part of the Database Server Software category; --> Hello, What's the best way for me to back-up my mysql development that I do on my laptop? Regards, ...


Go Back   Unix Technical Forum > Database Server Software > MySQL

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-28-2008, 09:33 AM
Mike
 
Posts: n/a
Default backup MySql (newbie)

Hello,
What's the best way for me to back-up my mysql development that I do on
my laptop?

Regards, Mike


config:
mysql Ver 14.12 Distrib 5.0.22, for Win32 (ia32)

phpMyAdmin-2.8.1

PHP 5.1.4 (cli) (built: May 4 2006 10:35:22)
Copyright (c) 1997-2006 The PHP Group
Zend Engine v2.1.0, Copyright (c) 1998-2006 Zend Technologies

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-28-2008, 09:33 AM
Nicholas Sherlock
 
Posts: n/a
Default Re: backup MySql (newbie)

Mike wrote:
> What's the best way for me to back-up my mysql development that I do on
> my laptop?
>
> config:
> mysql Ver 14.12 Distrib 5.0.22, for Win32 (ia32)
>
> phpMyAdmin-2.8.1
>
> PHP 5.1.4 (cli) (built: May 4 2006 10:35:22)
> Copyright (c) 1997-2006 The PHP Group
> Zend Engine v2.1.0, Copyright (c) 1998-2006 Zend Technologies


I don't know about the best way, but phpMyAdmin has a convenient
"Export" feature for your whole database which gives you a text file
with all the statements needed to completely reconstruct your database.
Then you just back up this single file, easy as .

Cheers,
Nicholas Sherlock

--
http://www.sherlocksoftware.org
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

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
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 01:23 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com