Boston Linux & Unix (BLU) Home | Calendar | Mail Lists | List Archives | Desktop SIG | Hardware Hacking SIG
Wiki | Flickr | PicasaWeb | Video | Maps & Directions | Installfests | Keysignings
Linux Cafe | Meeting Notes | Blog | Linux Links | Bling | About BLU

BLU Discuss list archive


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Moving a MySQL installation?



Mark Richards wrote:

> 
> My preference would be your option 2 which can be done in a single 
> statement to export each database and a single statement to import each 
> database:
> 
> mysqldump -u USER -p  DATABASE > wholedb.sql
> 
>     You will be prompted to enter the password for USER
> 
> then to restore into a new mysql database
> 
> mysql -u USER -p DATABASE < wholedb.sql
> 
>     You'll be prompted to enter the password for USER.
> 
> Replace USER and DATABASE with appropriate names.
> 
> Before discarding the source MySQL installation I'd be certain that 
> everything is intact on the new one.
> 
> Also, make certain your fresh MySQL installation has at least been 
> initialized before you try to import.
> 
> /m

Ah, OK - that makes sense, and I *am* upgrading the version so this is 
probably safer.  One more idiot question: how to I generate a list of 
databases?  The current machine has been around for quite a while 
(started as Red Hat 6.1) so I'm not completely sure what I've got in 
there now...
  -Don

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.





BLU is a member of BostonUserGroups
BLU is a member of BostonUserGroups
We also thank MIT for the use of their facilities.

Valid HTML 4.01! Valid CSS!



Boston Linux & Unix / webmaster@blu.org