[Gllug] Backing-up / Moving a MySQL database

[Daniel Andersson]

man mysqldump

is your friend
:)

simply dump the data, then restore it with
mysql -uUSER -pPASSWORD database < file.sql

/ d


----- 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