LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Enterprise Linux Forums > Linux - Enterprise
User Name
Password
Linux - Enterprise This forum is for all items relating to using Linux in the Enterprise.

Notices

Reply
 
Search this Thread
Old 05-02-2005, 04:19 PM   #1
dt4stat
LQ Newbie
 
Registered: Mar 2005
Posts: 19

Rep: Reputation: 0
Access old data with newly installed MySQL


Hi all:
I am stuck on this for days , please help me if you can. All suggestions are wellcomed.

I have a RHEL 3.0 server running. Mysql 3.X was installed, and i removed that and its related packages (to get rid of the installation conflict).

Before i install 4.x rpm , runing "rpm -q -a | grep -i mysql " returned nothing. After runing these two commands below, i didnt do anything, and when i logged in again, i can get a promt by typing mysql at the shell.

rpm -i MySQL-client-4.1.11-0.i386.rpm
rpm -i MySQL-server-4.1.11-0.i386.rpm

My old data is in /var/lib/mysql/old_data, and the data created by the newly installed mysql 4.x is in the same directory: /var/lib/mysql/test
I tried create table in database test, it works, and i can see those file in the /var/lib/mysql/test/ folder.

At the mysql promt

mysql> use olddata;
ERROR 1044 (42000): Access denied for user ''@'localhost' to 'database olddata'

mysql> use test;
====> OK for creating table


I tried the above command as user 'mysql', and 'normal user'
As a root, i couldnt get the mysql promt.


So I want to access those old data again, any sugguestions ?

Many Thanks


--DT
 
Old 05-05-2005, 11:53 PM   #2
NetSnake
LQ Newbie
 
Registered: Sep 2004
Location: China
Distribution: Debian 3.0r2 unstable
Posts: 28

Rep: Reputation: 15
I suggest you can check the folder's permission first.
It's must owned by mysql user, the mysqld daemon owner.
 
Old 05-06-2005, 07:02 PM   #3
dt4stat
LQ Newbie
 
Registered: Mar 2005
Posts: 19

Original Poster
Rep: Reputation: 0
Hi NetSnake:

No luck. I checked the right for old_data, and test, and they have the same right.
Any other suggestions?

Thank you very much.

--DT
 
Old 05-06-2005, 07:11 PM   #4
dt4stat
LQ Newbie
 
Registered: Mar 2005
Posts: 19

Original Poster
Rep: Reputation: 0
It's Wired that when i types in rpm -q -a |grep mysql
==>
MySQL-server-4.1.11.0
MySQL-client-4.1.11.0

However, when i tried "rpm -e MySQL-server-4.1.11.0" , it said packet is not installed. I can get the access to mysql> promt.

Any one know what is gonning on?

Thanks.

-DT
 
  


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
Access old data with newly installed MySQL dt4stat Linux - Newbie 5 12-05-2005 02:51 AM
Newly Installed Apps arpanetguru Linux - Newbie 2 11-25-2005 10:41 PM
How to configure newly installed Macintosh access to Linux shared drives mrmandms Linux - Networking 4 09-08-2005 06:04 PM
MySQL Access problem from Aqua Data Studio stedo Linux - Software 0 10-03-2003 03:57 AM
newly installed programs... tang Linux - Software 2 09-10-2003 09:41 AM


All times are GMT -5. The time now is 08:28 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