2 questions

[manoogim]

hello. i opened a free account on x10hosting to test a proof-of-concept for my webapp and now i need to upload mysql database .i understand free accounts do not have remote mysql access, so my challenge right now is how to upload mysql db from localhost to starka at x10hosting. it is important to import not just the table structures, but the relationships and indexes also, and refrence data. guess one way would be to dump locally into text files, but then WHAT? how does starka database import that - is it via telnet or via ssh ? i doubt that i have telnet access... please advise how can i upload my database.
(2) my webapp requires me to rewrite urls, so in the apache config for my virtual domain we will need to have RewriteModule On and AllowOverride All. since this is not configurable via .httaccess, will it be possible to do it in apache's file httpd. conf. thank you. melissa

 

[adamparkzer]

hello. i opened a free account on x10hosting to test a proof-of-concept for my webapp and now i need to upload mysql database .i understand free accounts do not have remote mysql access, so my challenge right now is how to upload mysql db from localhost to starka at x10hosting. it is important to import not just the table structures, but the relationships and indexes also, and refrence data. guess one way would be to dump locally into text files, but then WHAT? how does starka database import that - is it via telnet or via ssh ? i doubt that i have telnet access... please advise how can i upload my database.
(2) my webapp requires me to rewrite urls, so in the apache config for my virtual domain we will need to have RewriteModule On and AllowOverride All. since this is not configurable via .httaccess, will it be possible to do it in apache's file httpd. conf. thank you. melissa

For your first question, I can't give you a 100% confident answer (and hopefully someone else that sees this thread can), but I know that in your cPanel, there is a feature called MyPHPAdmin that you can use to manage and modify your databases. I'm sure there is some sort of uploading feature in there somewhere.

As for your second question, RewriteModule is already turned on. Rewriting URLs can be managed with rewrite conditions within your .htaccess file. There is no further configuration necessary.

 

[xav0989]

For your first question, I can't give you a 100% confident answer (and hopefully someone else that sees this thread can), but I know that in your cPanel, there is a feature called MyPHPAdmin that you can use to manage and modify your databases. I'm sure there is some sort of uploading feature in there somewhere.

When you select import tables, you input a file on your local computer. Keep in mind that you cannot create databases through phpmyadmin, but through cPanel only. You can also directly execute the SQL by pasting the SQL into the SQL tab.

As for your second question, RewriteModule is already turned on. Rewriting URLs can be managed with rewrite conditions within your .htaccess file. There is no further configuration necessary.

The RewriteModule is activated on all servers. However, you still need tostart the RewriteEngine. Simple add this line to the top of your htaccess file:

RewriteEngine On