Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 newbie question about SQL connections

Author  Topic 

imasouthpaw
Starting Member

1 Post

Posted - 2008-01-15 : 12:03:31
Sorry if this question has been answered a million times before.

I have just recently finished making a site that using PHP and SQL and I have been making the connection to the database using XAMPP.

Now, the database itself is made up of .MYD .FRM and .MYI files.

We already have a domain name and a server that supports mySQL.

I would like to know how I go about translating this to an actual appache server. Will it be alright just to upload the .MYD .FRM and .MYI files or will I need to recreate the database in say, MS access.

This is the sytax i've been using to connect to the database with XAMPP on my computer.

$dbhost = "localhost";
$dbuser = "root";
$dbpassword = "";
$dbdatabase = "test";

$config_basedir = "http://localhost/";
$db = mysql_connect($dbhost, $dbuser, $dbpassword);
mysql_select_db($dbdatabase, $db);


I'm wondering what I'll have to change/add in order to connect to the database on a live server. Possibly change the $dbhost value to the URL of the database?

Not sure, any help would be greatly appreciated, thanks!

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-01-20 : 21:10:07
But this is MSSQL fourm.
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-01-21 : 09:12:29
www.connectionstrings.com

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -