How to creat new database for sub-domain?

[mynamesStephanie]

i know it work. but i dont know if prestashop can creat new database for sub-domain? if it is possible how?

 

please share..

Edited July 25, 2012 by mynamesStephanie (see edit history)

[AKJV]

Prestashop can't create a database for you. I don't know of any CMS platform that can do this for you.

 

So you'll have to create a new database yourself in your hosting management system or phpMyAdmin.

Some hosting providers also offer a fully automated installation of CMS platforms (via Installatron or similar options) that will create a database on-the-fly as well.

[mynamesStephanie]

you main i need cpnel to create newdatabase? and can you elaborate a bit for some information if what should i do and needs for this situation..

 

 

please help(thank advance)

[AKJV]

Assuming you mean cPanel, then look for the Databases section. There should be a MySQL Database Wizard option that will guide you in creating a new database.

 

Write down database name and access details (user name & password) because you will need that at some point during Prestashop installation. Look here for more info:

http://doc.prestashop.com/display/PS14/Getting+Started#GettingStarted-Creatingadatabaseforyourshop

You can skip the first step (creating a database in phpMyAdmin) when you use cPanel for this.

For the Database server name you can usually fill in localhost but it may also be something else, like sql.domainname.com.

This depends on your hosting provider, so if you are not sure then please contact them for help.

 

It depends on your hosting package how many databases you are allowed to use. If it's just a single database, then you're out of luck and you will not be able to create another database...

 

 

Hope this helps.

[mynamesStephanie]

Thank a lot for information and for the link AKJV it a big help for me.

 

 

and another question regarding for the database. if i create a new database in my cpanel it means i dont need any database server from my local computer. i mean is i dont need to install wampserver or else xampserver in where i create newdatabse? and another question it can be done by none live site since i want to try to create a sub-domain in my local computer a none live site. something like this: http://localhost/subdomain.maindomain/?

 

and it is sure that to increase the load time of a site and save database memory when i success this?

 

Thanks('--')

[AKJV]

Hi Stephanie,

 

I'm not sure if I understand you correctly.

 

I assumed that you want to setup a new database from within your cPanel access of your hosting provider.

Just to be clear: localhost for database server name has nothing to do with local installation (WAMP or XAMP). It's just the usual internal database server name that is used for webhosting solutions and this server name may in fact be different for your webhosting.

 

Setting up subdomains on a WAMP or XAMP server on your computer can be done as well but is a bit tricky. Here's a tutorial I've found:

http://www.axertion.com/tutorials/2012/03/how-to-setup-local-subdomains-using-wampserver/

 

But why would you want to setup a subdomain on a local server? There is no limit on how many sites you can run on a WAMP or XAMP server. Just copy the prestashop installation files into a subfolder in your www folder of your WAMP or XAMP server. After that, you can access the local site via http://localhost/subfolder. This way, you can install and run multiple webshops on your local server, like http://localhost/prestashop1, http://localhost/prestashop2 etc.

 

Performance of a local server installation really depends on your computer (processor, memory and storage). Using a SSD instead of a HDD really speeds up things.

 

Just let me know when you need more information