Database Creation 
Author: Michael I.Hi,
I have a questions about the required databases that we need to manually create on our web hosting server.
I have 2 databases:
1) Login Users
2) Orders
Do I need to create any more databases?
The problem is that in my development environment, the amount of stock I have is clearly being shown in the front-end GUI. However, when I go live to the internet, it says there is no stock. Obviously, this means it is not reading from the database where this stock amount is stored. Is this correct? Is the stock stored in the database?
Does my external web hosting provider need to link to my development mode database, or do I need to have a stock database also created on my web hosting provider.
In fact, how many databases do I need to manually create on my web hosting server?
There is very little documentation about this.
Your assistance would be appreciated.
Michael.
Hello Michael,
If you want to use the MySQL database with WebSite X5, you should create at least one of them on your production server.
Then set the database data at step 4 of WebSite X5 and set that database as the storage for the e-Commerce cart.
Once you do that, WebSite X5 will create all the needed database tables when they are requested the first time (i.e. when the first order is set).
The same procedure is valid for the Automatic Users Registration.
To check if your MySQL database connection is working, you may want to access the admin area of your site and check the site test page.
Keep me up to date.
Thank you
Author
HI Claudia,
Is there any particular name the database needs to be called on the Production Server.
Will this be the same name as on the Development Server?
On the Development Server I have stock, on the Production Server there is not stock.
Screenshot attached.
The website test says ""PASS" for the database settings, however, the production server can't seem to read the amount of stock available. Do I need to import the stock?
Michael.
Hi Michael,
WebSite X5 does not require any particular database name. You can pick the one you prefer.
If the production database has a different name than the dev one, you should update your WSX5 project accordingly before exporting the site to the production server.
You also need to import the stock database from dev to production once the export has been completed, because WSX5 won't export it again to production since it was exported before to the dev server.
Keep me up to date.
Thank you
Hi Website X5,
I wish you have a step by step and easy to understand procedure on how to integrate databases. I have been trying to do my websites since I bought my first software with you because I thought it is good for novices like me. I have in fact upgraded to website x5 Prof 12 as this is your best, but still I am nowhere building my sites properly. Now I have cancelled my hosting and decided to find another way I can build my website. I know you may not care because I have sent a queries and never had any answer, but I will think twice buying any upgrade in the future unless you could give me an exact procedure on how to make an ecommerce store built with website x5 prof 12 integrates properly with website hosting provider. I hope you understand my frustrations and why I am writing this. As of the moment I am trying to find another alternative.
I know there are others who bought your software that has the same questions on their minds about this.
If you care about your customer, please give me your comment or help on this.
Regards,
W Barnwell
Video tutorials are needed. Please look into creating this for the new release of x5 v13.
Do you know? I had the same problem, and when I got a litle help it all seems fine.
The first thing to do, is to set your database information in Data Managment in ste 4.
You should find your username and the other data you need in your webhosting.
Call the base whatever you wish. I have the same name in description that in the serverfolder with write accsess.
If you have the producktlist set up from earlier, its probebly set up with htpml, so you ned to go to each pages properties in step 2 and under the expert section ther you change it to php.
And then you check your url in step 1. Your url should be like this: http://www.mysite.xx
Hope it was this you was looking for.
I've trubled a litle myself, but Claudio help me on the right way and then it wasn't so differculty at all, but now my sites functioning perfektly.
Don't juse to much time too think about your database, cause if you just have the main thing as the name you've given it, database name, host name, username and the password - you can let the program take care of the rest when you send your site to your hosting.
I have my site at one.com, and there I found what I needed in the PHP section.