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



`mysqlshow' from the command line, or `show databases' from a mysql
command prompt.

Matt

On 4/13/07, Don Levey <lug at the-leveys.us> wrote:
> 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.
>
> _______________________________________________
> Discuss mailing list
> Discuss at blu.org
> http://lists.blu.org/mailman/listinfo/discuss
>

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