Re: [cobalt-users] FW: Mysql Not Connecting

["Steven Werby" <steven-lists@xxxxxxxxxxxx>]

JA <jjma@xxxxxxxxxxxxxx> wrote:
> Another important question is that I have databases set up with existing
> information in them, I don't want to lose this very important information,
> so can someone suggest how I can grab the information and dump it straight
> into the databases created that will the existing tables or data unaffected.

Use the mysqldump program.  It takes data from a table and saves it as a MySQL create
table statement and a series of MySQL insert statements in another file.  To recreate
the tables you need to run this command: mysql -uroot -ppassword <
thenameofyourdumpfile.  Use the mysqldump program instead of doing a simple file copy
b/c you *may* end up with corrupted tables if you do a simple file copy.  If you
don't know where your data files are, do "locate *frm" to find some of the files in
the data directory, then run mysqldump against all of the tables you want to keep.

I see you got a response from Sinisa of MySQL so you obviously know where the mailing
list is.  To lear more about mysqldump visit the MySQL site (www.mysql.com), search
the MySQL list archives or get a good MySQL book.  I like MySQL by Paul DuBois.  Best
price on the net (when I bought it) was $20 or $25 at www.bookpool.com and I'm very
satisfied with their service and price.  And no, I'm not affiliated with them.  I
should direct you to my amazon.com affiliate page, but they charge more.

Steven Werby {steven-lists@xxxxxxxxxxxx}