Database / Linux / W2K Question

[muhsinb]

Hi All,

 

me again :P

 

i've got XAMPP up and running on my Windows XP VMWare machine now as a test site. However, i just now thought to myself it wont be a true test, since my live site will be on a Linux box. And also on windows boxes, you can't change permissions like they do on Linux, so i can't have a play :(

 

Well anyway...could anyone recommend a Linux distro for an ABSOLUTE noob. I've NEVER touch Linux environments in the past, well if am honest i've always avoided them LOL, however, i have NO choice now and am determined to learn it now. Most people have recommended Ubuntu and Mandrake for starters...any other opinions?

 

2nd Question:

 

In a test environment, how do i create a local database? I've created the database on my live site through the CPanel of my host, however, if i want to create another database, they'll charge me £25 and i don't really want to do that, unless i have no option!

 

Any opinions, suggestions are greatly welcome.

 

Best Regards...

[Guest]

Hi All,

 

me again :P

 

i've got XAMPP up and running on my Windows XP VMWare machine now as a test site. However, i just now thought to myself it wont be a true test, since my live site will be on a Linux box. And also on windows boxes, you can't change permissions like they do on Linux, so i can't have a play :(

 

Well anyway...could anyone recommend a Linux distro for an ABSOLUTE noob. I've NEVER touch Linux environments in the past, well if am honest i've always avoided them LOL, however, i have NO choice now and am determined to learn it now. Most people have recommended Ubuntu and Mandrake for starters...any other opinions?

 

2nd Question:

 

In a test environment, how do i create a local database? I've created the database on my live site through the CPanel of my host, however, if i want to create another database, they'll charge me £25 and i don't really want to do that, unless i have no option!

 

Any opinions, suggestions are greatly welcome.

 

Best Regards...

 

 

I recommend using fedora :

http://www.stanton-finley.net/fedora_core_...tion_notes.html

http://www.fedorafaq.org/

http://www.informit.com/articles/article.a...169466&rl=1

 

25 pounds for a second database ?

give

me

a

break

 

that is brutal.

DEFINITLEY times to switch to a new host.

these guys rock - i have more than ten domains living here, never an issue :

http://www.lunarpages.com/basic-hosting/

 

you should learn some unix while you're at it!

http://www.ee.surrey.ac.uk/Teaching/Unix/

 

Corrie

[natewlew]

Fedora???? You have got to be joking!!!!

 

Just kidding :lol:

 

I would recommend Ubuntu for a desktop. I have never used it to setup a server. They also have a server cd but it doesn't have a graphical desktop on it. You could install the desktop one and then install the server programs you need later with apt-get (very easy to do).

 

I think a good distro to be used a server would be Centos (it has php4 and mysql4 installed by default). It is similar to Fedora. It is a more stable version.

 

Regardless of what distro you use follow the directions on this site. http://www.howtoforge.com/

 

They have server setup instructions for just about all of the major distribution's.

 

You can also go to http://www.distrowatch.com to see all of the Linux distro's.

[muhsinb]

25 pounds for a second database ?

give

me

a

break

 

that is brutal.

DEFINITLEY times to switch to a new host.

 

LOL...i know!!! Am fairly new to all this! However, there customer service is pretty good :blush:

 

So can anyone tel me how i can create a blank database locally?

[Guest]

LOL...i know!!! Am fairly new to all this! However, there customer service is pretty good :blush:

 

So can anyone tel me how i can create a blank database locally?

 

http://dev.mysql.com/doc/refman/5.0/en/linux-rpm.html

http://www.google.ca/search?hl=en&q=in...earch&meta=