Hi, I am new to mysql and have a question regarding how to read/import
existing mysql databases (i.e. binaries, not sql dumps) copied from
somewhere.
What I now have is a whole mysql directory that contains all binary files
(version 5.0.27 for 32bit Linux) copied from somewhere, including database
files under the "data" directory. Suppose there is a database called "foo"
under the "data" directory (and I don't have its sql dump). How should I
set up mysql such that I can read this database?
I tried to execute the following sequence of commands under "root" account
and entered the mysql prompt environment.
shell> groupadd mysql
shell> useradd -g mysql mysql
shell> cd mysql
shell> scripts/mysql_install_db --user=mysql
shell> chown -R root .
shell> chown -R mysql data
shell> chgrp -R mysql .
shell> bin/mysqld_safe --user=mysql &
shell> bin/mysql -u mysql
mysql> show databases;
However, the "show databases;" command did not give me the "foo" database;
and the "use foo;" command was denied access. Does it have to do with the
grant table? And how should I set up mysql such that I can read the "foo"
database?
Many thanks!
~Pengkui
