I have a problem. Due to poor service- I decided to move my site to another host. Before doing so- I did a full backup which saved to my desktop and in .tar.gz format. I also backed up mySQL as well as phpMyAdmin.

How do I make all those files appear on my new host? Both hosts use cPanel.

How can I make sure each folder and file in that folder is backed up and ready to restore with the new host?

Bottom line is- I can t get my site to work. It is still down and has been for days.

Which of the following or other is best for creating online games and interactive sites? Java- Flash- or Javascript/php/MySql/xhtml or others? I have a very limited experience of progamming in C and Visual Basic etc- but I want to program online applications. What is the most concise- powerful and easy to maintain? Many thanks if you can help me!! :)

I just took an online tutorial on everything I need to know about SQL. I opened up a hosting account at GoDaddy and signed up for a MYSQL database. I know how to do the actual scripting to make the table- I just don t know where to start. Where do I put the code to make the table?

Also- I have read something about http://localhost/

- is this an easier way for me to access SQL? Can you explain more about this?

I am making a CMS for my website- and only know html- css- and javascript...so I am having a little trouble with this PHP/SQL stuff! Any help would be greatly appreciated :)

Thanks-
Jessica
OK so I know how to WRITE the code to create the table. But- WHERE do I put the code. I ve logged in to MYSQL database on GoDaddy- now what???

MY website is developed using .net and mysql as the database. So provide support for this combination.
does bluehost.com support website developed using .net and my sql. If not who else support this combination.

Hi All-
I need to implement "Friend of a Friend" problem with minimal costs using either MySQL or PHP/MySQL. I wonder if there is an implementation that would just allow to solve this problem with minimal costs
The description is as below:-

I want to build a "social network" extension and try to find the best way to implement a Friend of a Friend connection path. (Facebook has something like that I think)

e.g. We both have the same friend- but don t know each other. The algorithm should give me a path from me- over our same friend to you. (Me - Friend - You)

But it should also find connections- that have a bigger distance- e.g. (Me - Friend1 - Friend2 - Friend3 - You) but not exceeding this situation - (Me - Friend1 - Friend2 - Friend3 - Friend4 - You)

I stored user relations in database as I (user_id|friend_id = me|friend and friend|me)

Any help would be really grateful

I m used to doing them in SQLServer- but I ve had no luck getting them to work in MySql.

Basically- I want to do something like:
select @Matches = count(*) from Table;
if(@Matches>0) then
update Table set Row1 = @Param;
else
insert into Table (Row1) values @Param;

If there s a different construct that If-Then-Else in MySql that lets you do this- that would be fine too.