Yes, you should be able to use MYSQL, but not all third party plugins support MYSQL so there will be limitations. If it is a small site I would suggest just using SQL CE. Link to install requirements below.
I use webmatrix with SQL CE in my local. But the hosting server only have MSSQL 2014 OR MYSQL5, I don't know how I can deploy my local SQL CE to the server? If I use MSSQL 2014, then every import action will charge $5 which I can not afford.
Migrating DB changes from one instance of Umbraco to another is always a bit clunky unless you use Courier or uSync (be careful with this one).
I have never heard of a hosting provider charging for imports, which I am assuming you mean restores? There are lots of other hosting providers that you can restore as much as you need at no charge. I use SmarterASP and have had no issues with restores or using SQL CE. Unless the hosting company is actually doing the restore for you as a service instead of you doing it yourself.
But all you should need to do for SQL CE is to upload it to the site. The SQL CE DB is in the App_Data folder so if you FTP/Deploy the site to the host then everything should just work.
CE SQL is an embedded database, which is just a file so you should simply be able to just upload your local website to your server and have things work.
But if you're going to build a bigger site I recommend that you consider using MSSQL since there a situations where CE SQL can loose data for some reason. See this issue for more information http://issues.umbraco.org/issue/U4-4621
Can I use MYSQL with current version Umbraco? need help!!
Can I still use MYSQL with Umbraco 7?
Any body will know the answer? need help!!!
Yes, you should be able to use MYSQL, but not all third party plugins support MYSQL so there will be limitations. If it is a small site I would suggest just using SQL CE. Link to install requirements below.
System Requirements - Hosting
Thanks for the help.
I use webmatrix with SQL CE in my local. But the hosting server only have MSSQL 2014 OR MYSQL5, I don't know how I can deploy my local SQL CE to the server? If I use MSSQL 2014, then every import action will charge $5 which I can not afford.
Migrating DB changes from one instance of Umbraco to another is always a bit clunky unless you use Courier or uSync (be careful with this one).
I have never heard of a hosting provider charging for imports, which I am assuming you mean restores? There are lots of other hosting providers that you can restore as much as you need at no charge. I use SmarterASP and have had no issues with restores or using SQL CE. Unless the hosting company is actually doing the restore for you as a service instead of you doing it yourself.
But all you should need to do for SQL CE is to upload it to the site. The SQL CE DB is in the App_Data folder so if you FTP/Deploy the site to the host then everything should just work.
Thanks so much. This helps me understand.
Hi Ceci and weclome to our :)
CE SQL is an embedded database, which is just a file so you should simply be able to just upload your local website to your server and have things work.
But if you're going to build a bigger site I recommend that you consider using MSSQL since there a situations where CE SQL can loose data for some reason. See this issue for more information http://issues.umbraco.org/issue/U4-4621
Hope this makes any sense :)
/Jan
You are excellent. So much for your help. I just start with Umbraco and thanks for the encouragement help.
is working on a reply...