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

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 /