LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 04-16-2006, 09:21 AM   #1
mchitrakar
Member
 
Registered: Mar 2004
Posts: 93
Blog Entries: 1

Rep: Reputation: 15
mysql copying database


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?
 
Old 04-16-2006, 10:13 AM   #2
Ramark
LQ Newbie
 
Registered: Mar 2006
Location: Serbia
Distribution: Slackware 10.2
Posts: 8

Rep: Reputation: 0
try this

cd /var/lib/mysql
chown -R mysql:mysql mydata
chmod 755 mydata
cd mydata
chmod 660 *
 
Old 04-19-2006, 09:36 AM   #3
mchitrakar
Member
 
Registered: Mar 2004
Posts: 93
Blog Entries: 1

Original Poster
Rep: Reputation: 15
still errors

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)
 
Old 04-20-2006, 07:58 AM   #4
Ramark
LQ Newbie
 
Registered: Mar 2006
Location: Serbia
Distribution: Slackware 10.2
Posts: 8

Rep: Reputation: 0
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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying database grob115 Programming 1 01-28-2006 06:35 AM
Mysql - Copying database files. jackster Linux - Software 2 02-03-2005 02:03 AM
Writing an app that uses a mysql database without installing mysql server? QtCoder Programming 4 08-09-2004 02:43 PM
copying MySQL database linuxprogrammer Linux - Newbie 1 07-23-2004 09:53 PM
Copying mysql database to another comp parsek Linux - Software 1 11-15-2003 07:34 PM


All times are GMT -5. The time now is 11:49 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration