I am hosted on Winh开发者_JAVA百科ost.com. They support both PHP and ASP.NET. I have a PHP User Management script and the instructions are as follows:
Step 1 : Login to your web hosting account and create a database and inport the database.sql file.
Step 2: Open config.php with notepad and change the settings to your database details.
Step 3: Upload all the files to your web server.
The propblem I am having is that I have successfully created a database in my control panel on @WinHost, BUT There is no option that lets me "import" the *.sql file that is mentioned in Step 1.
Does anybody know how I can get around this/import it?
I have searched all over Winhost support pages and can't find any help.
If you have a "run query" interface, take the text from database.sql and put them in there, then click "execute query". Or similar language, I don't know what Winhost does.
The How to migrate from your local SQL 2005 database to a WinHost SQL 2008 database page has a section titled Running the SQL script against our SQL 2008 servers. I think that may be what you are after. It explains how you can log in to the control panel, open a command prompt, and run sqlcmd
to import a SQL script.
精彩评论