[Gllug] Backing-up / Moving a MySQL database

[Xander D Harkness]

Daniel Andersson wrote:

>man mysqldump
>
>is your friend
>:)
>
>simply dump the data, then restore it with
>mysql -uUSER -pPASSWORD database < file.sql
>
>/ d
>  
>
Wow, thanks.

I have had a look through google and a couple of sites had mentioned it 
- but not in any depth and there mostly for remote backups.

I am a database newbie and hope to correct that very soon....

Thanks again.

Xander

>
>----- Original Message ----- 
>From: "Xander D Harkness" <xander at harkness.co.uk>
>To: <gllug at linux.co.uk>
>Sent: Monday, September 23, 2002 9:01 PM
>Subject: [Gllug] Backing-up / Moving a MySQL database
>
>
>  
>
>>I have just installed the horde groupware suite which backends to a 
>>MySQL database.
>>
>>The packages come with some lovely scripts so that you can install the 
>>database without knowing anything about MySQL :-)
>>
>>I have just discovered that a new server is being built in the next few 
>>days to take this software.
>>
>>As many of the users have entered their data, I was wondering how easy 
>>it is to move the database.  Is it a matter of copying a couple of files?
>>
>>I guess the same questions go for backups too :-)
>>
>>Kind regards
>>Xander
>>
>>
>>-- 
>>Gllug mailing list  -  Gllug at linux.co.uk
>>http://list.ftech.net/mailman/listinfo/gllug
>>
>>    
>>
>
>  
>


-- 
Gllug mailing list  -  Gllug at linux.co.uk
http://list.ftech.net/mailman/listinfo/gllug