Hello,
check if the files have to be in a special directory.
check the datadir varible from >show variables
hope this helps
samier.
Myk Melez An: abw <[EMAIL PROTECTED]>
<[EMAIL PROTECTED]> Kopie: [EMAIL PROTECTED]
Thema: Re: transferring databases
22.05.02 22:18
abw wrote:
> Is it possible to zip up database directories on one server and move
> them to another server, then simply unzip them?
Yes.
> If so, once that is done, does something need to be done to mysql so
> it is aware of the databases? Is there some file that has a list of
> databases that must be updated or something?
No.
> Mysql is running, because I see it in the process list, and from what
> the customer told me, he does see the databases, but he cannot access
> them.
This is probably a file permissions problem. Make sure the user mysqld
runs as (probably "mysql") has access to the database directory and
files ("chown -R [name of mysql user] [directory name]" should do the
trick).
-myk
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
