Mysql database & Prestashop Relationship Questions

[ajaque]

Hi all,

 

I recently found Prestashop and it is what I need for the project I am working on, BUT, while trying to install it for the first time I have encountered myself with a bunch of problems and questions.

 

This is what I have and doing so far:

 

1) I am using Yahoo Small Business as a webhosting.

2) The site which will contain the e-commerce I am trying to make is a subfolder from my domain root and the prestashop (ver 1.4.9.0) files were uploaded to a subfolder under it:

www . domain . com / projectsite / prestashop /

 

3) Using my Yahoo webhosting website I have activated Mysql (Mysql Ver. 5.1.55 & PHP Ver. 5.3.6) and I installed the files in this subfolder:

www . domain . com / mysqldb /

 

I created a new database 'mydb' and it has no tables in it so it says (0) next to its name when I log into it with phpmyadmin.

 

4) I changed the folder's permissions for the prestashop folders and files I installed following the tutorial and using filezilla.

 

5) When I run the prestashop installer (step 2) it gives me all OK except these two:

 

Optional set-up

• Allowed to open external URLs [X]
  
• PHP magic quotes option is off (recommended) [X]
  

I am not sure if these two options could be causing any problem.

 

6) Moving to the next step during installation (step 3), I have tried so many different combinations of all the options it asks but nothing seems to work. The installer just does not even says if something is bad or missing or what is actually wrong.

 

7) I have deleted and re-installed everything twice and using different folders and subfolders and nothing seems to work. You probably can see my level of frustration right now.

 

 

Here are some of my questions that are not answered in tutorials (or I have not found yet)

 

a) Mysql database and Prestashop files should be in the same folder?

 

Can Mysql and Prestashop files be under subfolders or not?

 

c) Is it possible to use the general Mysql user/password when running the Prestashop installer or I need a specific user/password for the individual database I have created for it?

 

d) Is the server 'localhost' or 'mysql'? If I upload the database files to a subfolder, how do I set this option for the installer?

 

I have these questions so far. I would really appreciate if any of the gurus or experienced webmasters here could give me a hand or any tip with this. I am helping a friend with this project and it is really important for us.

 

Thanks in advance!

[El Patron]

Here are some of my questions that are not answered in tutorials (or I have not found yet)

 

a) Mysql database and Prestashop files should be in the same folder?

Your MySql files do not reside in a folder, they are loaded to the MySql database you create for the site.

Can Mysql and Prestashop files be under subfolders or not?

see a)

c) Is it possible to use the general Mysql user/password when running the Prestashop installer or I need a specific user/password for the individual database I have created for it?

the user/password should be the same as the MySql database you created prior to intalling

 

d) Is the server 'localhost' or 'mysql'? If I upload the database files to a subfolder, how do I set this option for the installer?

the server is the name you see in phymyadmin after creating and viewing your MySql database

I have these questions so far. I would really appreciate if any of the gurus or experienced webmasters here could give me a hand or any tip with this. I am helping a friend with this project and it is really important for us.