location of mysql database files?

[Harold Hallikainen]

THANKS! I'm trying to keep an updated hot standby running, so I'll first
try moving them with rsync. If that doesn't work, I'll try export/import.

THANKS!

Harold


> Harold Hallikainen wrote:
>
>>I'm SLOWLY bringing up a new server and moving stuff from the old to the
>>new. My next issue is moving over mysql database files. If someone knows
>>off the top of their head what they're called and where they are, it'd
>>save me a bunch of research. They are currently buried deep in an RH8
>>machine, and I'll be moving them to an FC4 machine.
>>
>>THANKS!
>>
>>Harold
>>
>>
>>
>>
> The files are stored in /var/lib/mysql. You will find one directory of
> fields for each database you have created.
>
> You would probably be better off if you used mysqldump to create an
> ascii dump of the database, moved that to the new server and then use
> mysqlimport to import the data to the new database.
>
>
>
> Carl.
>
>
>
> _______________________________________________
> Redhat-install-list mailing list
> Redhat-install-list at redhat.com
> https://www.redhat.com/mailman/listinfo/redhat-install-list
> To Unsubscribe Go To ABOVE URL or send a message to:
> redhat-install-list-request at redhat.com
> Subject: unsubscribe
>


-- 
FCC Rules Updated Daily at http://www.hallikainen.com