first time installing mysql.

[steven420]

Hi, I am planning on installing mysql on my server for the first time. I have used mysql before but need mysql 5. I have very limited experience with linux. my os is red hat fedora core 2. I downloaded MySQL-server-community-5.0.37-0.rhel3.i386.rpm (I'm not sure if this is the right one). I have a couple of questions:

1. which rpm package should I use?

2. do I have to re-install php, phpmyadmin? or anything else?

Any advice would be great. I'm feeling a little lost.

Thanks,

Steven.

[Discovery]

Step 1:
find out where ur mysql store's the database generally default path will be:
:var/lib/mysql this is datadir=var/lib/mysql which is mention in mysql configuration file (/etc/my.cnf).

Now, Move Your whole Database to :/backup dir.
#mv var/lib/mysql /backup

if u have done any changes in configuration file, then take the backup.
more : [dev.mysql.com...]

Step 2: Then uninstall old mysql

Step 3. Install new mysql.
more [dev.mysql.com...]
No, you don't have to re-install php & phpmyadmin.

[edited by: Discovery at 8:51 am (utc) on April 12, 2007]

[edited by: volatilegx at 8:54 pm (utc) on April 23, 2007]
[edit reason] removed blog links. replaced with authoritative links [/edit]

[steven420]

Thank you so much discovery. I currently don't have much in my database so I don't need to back it up. Do you know what package I should choose? The one that I downloaded was called Red Hat Enterprise Linux 3 RPM (x86). I'm worried that it isn't the right one.

Thanks,
Steven.

[steven420]

How do I place the rpm in /var/lib/mysql? the directory doesn't seem to be anywhere in plesk. I have a godaddy server so they restrict alot of stuff. Can it be done using linux? If so how? I'm sorry if my questions are stupid this is my first time doing this and I have almost no experience with linux.

Thanks,
Steven.

[Discovery]

we don't know whether you have dedicated server or just a hosting your site with godaddy.

If we know that than we can assist you better.
thanks

[Discovery]

ok,

Case I.
if you are simply hosting a website with godaddy, so i don't think you have to care about these things. What you can do, you ask godaddy people they will assist you better.

Case II.

If you have dedicated server with godaddy then you can download using
go to location:
#cd /usr/src
Download using wget.
#wget http:// (downloadlocatation path)

now, you can install using rpm.

[steven420]

Again discovery thank you so much. I have a virtual dedicated server. I will give that a try.

Thanks,
Steven.

[Discovery]

ooh steven420 welcome,
Remember,

If we were born knowing everything, what would we do with all time on this earth?

So, help each other.

[edited by: Discovery at 4:49 am (utc) on April 14, 2007]