List:General Discussion« Previous MessageNext Message »
From:Pengkui Luo Date:February 27 2012 8:05am
Subject:how to read existing databases copied from somewhere else
View as plain text  
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

Thread
how to read existing databases copied from somewhere elsePengkui Luo27 Feb
  • Re: how to read existing databases copied from somewhere elseReindl Harald27 Feb