Manual install of MySQL DB?

Having trouble installing serendipity?
Post Reply
PerfectCr
Regular
Posts: 90
Joined: Mon Nov 21, 2005 2:21 am
Contact:

Manual install of MySQL DB?

Post by PerfectCr »

I use Godayy.com and they provide a MySQL database (10 of them actually) They have a 100MB size limitation. Now my database is only 800K, so I am not going to hit that anytime soon. But let's say I wanted to have my "own" installation of MySQL. How would I do this exactly? Is the install similar to installing Serendipity? I looked at the below link, I don't even know where to start (if I wanted to). Can anyone help or point me in the right direction? Thanks!

http://dev.mysql.com/downloads/mysql/5.0.html
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Manual install of MySQL DB?

Post by garvinhicking »

Yes, you can always migrate your SQL dumps/backups from one machine to another, and then just adjust the s9y settings to connect to the new DB. The FAQ actually mentions this quite in depth.:)

Instaling MySQL is not hard, but definitely harder than installing Serendipity. It's a completely different type of application, actually...

You'll maybe want to consult a MySQL forum to learn more about MySQL.

Bestregards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
PerfectCr
Regular
Posts: 90
Joined: Mon Nov 21, 2005 2:21 am
Contact:

Post by PerfectCr »

Ok, will do, any suggestions on a good place to start? Sorry, I know nothing about databases :(
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking »

Basically, the mysql.com homepage is a good starting point :)

Best regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
PerfectCr
Regular
Posts: 90
Joined: Mon Nov 21, 2005 2:21 am
Contact:

Post by PerfectCr »

Oh man, I got lost there already :( Ok, I will give it a shot. :shock: :shock:
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking »

What I just realize: You can only install your own MYSQL system if you have root privielges on your webserver!

I doubt you have that kind of access on godaddy.com hosted sites.

Bestregards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
PerfectCr
Regular
Posts: 90
Joined: Mon Nov 21, 2005 2:21 am
Contact:

Post by PerfectCr »

garvinhicking wrote:What I just realize: You can only install your own MYSQL system if you have root privielges on your webserver!

I doubt you have that kind of access on godaddy.com hosted sites.

Bestregards,
Garvin
You're right, I do not have kind of access. :( Well, My database is nowhere near 100MB and probably will not be for a long time, so I will worry about it then! Thanks!
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking »

Yes, I guess that's better. If you should reach that limit (which I haven't reached on myblog for 3 years of operating), you can surely talk to the nice people of godaddy.com to see on how to proceed. :)

Bestregards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
PerfectCr
Regular
Posts: 90
Joined: Mon Nov 21, 2005 2:21 am
Contact:

Post by PerfectCr »

garvinhicking wrote:Yes, I guess that's better. If you should reach that limit (which I haven't reached on myblog for 3 years of operating), you can surely talk to the nice people of godaddy.com to see on how to proceed. :)

Bestregards,
Garvin
Godaddy can sometimes be a pain. I just asked them a very simple question, and they refused to answer it.
PerfectCr wrote:Question:
How do I restore a database backup using the provided PHPMyAdmin
interface?
GoDaddy.com wrote:Thank you for contacting Customer Support. Unfortunately we are not able to advise you on this issue as we are not licensed to support third-party software. You should be able to find a walkthrough for the process by lookup an online support forum or FAQ. Please let us know if we can help you in any other way.
WTF? They provide a HUGE FAQ with tons of questions and answers about "3rd party software". Why is this question any different?
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking »

:-)

Well, I guess a company's support is only as good as the weakest co-worker. You might just have written on a bad day of the supporter-guy, or he had no motivation to write up a lengthy explanation.;-)

Bestregards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Post Reply