mysql copying database

mchitrakar · 04-16-2006, 09:21 AM

I have to copy mysql database file from one Linux computer (test bed) to another machine (final system).Testbed computer is using RedHat enterprise 4 WS. And the final operating computer is RHlinux 9.I tried to copy from /var/lib/mysql/mydata/(all contents) and simply copied to final system's same location.But soon I was greeted with thousands of errors and sysadmin's wrath.So,How to copy databases from one location to another? and also, is it possible to copy mysql database from windows to linux and vice-versa?

Ramark · 04-16-2006, 10:13 AM

try this

cd /var/lib/mysql
chown -R mysql:mysql mydata
chmod 755 mydata
cd mydata
chmod 660 *

mchitrakar · 04-19-2006, 09:36 AM

I did as you advised. But errors remain.The error message while:
mysql>use mydata;
(following error messages..)
didnt find any fields in table abc_1
didnt find any fields in table abc_2
didnt find any fields in table abc_3
didnt find any fields in table abc_4
....................................
didnt find any fields in table abc_n
Database changed.
mysql> show t
(all tables are displayed)

Ramark · 04-20-2006, 07:58 AM

I think the problem is RHEL 4 has mysql 4 and RH9 has mysql 3. It is posible you used new table type that old version of mysql do not support. Try to upgrade mysql to newest 4 version or something. See http://distrowatch.com/table.php?distribution=redhat