how to post MYSQL data to web server

bearky · #1 06-Jul-2004, 00:03

hello,

i now decide to post my webpage to web server. can i know which folder should i post the MYSQL data to? i am now using PHP/MYSQL as my server techology.i succeed to view the interface, but the problem now is it prompted the error that it can't connect to mysql. can i knwo how to activate mysql server?..

previously i use apache as my local server, i jsut need to key in command:"grant insert,delete ...." into apache\mysql\bin\mysql, how about in the web server?

thanks ..

JdS · #2 06-Jul-2004, 11:44

You don't normally "activate" the mysql server. If you're (your website) hosted on a remote server, the mysql server is already running (if it's included in your hosting plan). You just have to connect to it...

If you have shell access then you can run the usual mysql commands to restore your SQL batch file. To do that easily, let's assume you have already uploaded your SQL batch file (let's say it's named backup.sql) to: \home\bearky\sql\backup.sql. Now assume, you have already created a new database named bearky_db and registered the username: bearky_user with the password: yTrg76RE to access this database.

In shell you just type:

Code:

mysql -ubearky_user -pyTrg76RE bearky_db < /home/bearky/sql/backup.sql

bearky · #3 07-Jul-2004, 22:52

dear sir,

can i know wat is SQL batch file and how to upload it? can i know the sql folder(that u metioned)is created myself or already exist in remote server. for ur knowledge, my remote server only has html and logs. inside html has cgi-local and usage. so where should i insert the MYSQL data? i have one database named as solutions and username:kyhow ,password:11.

wat is mean by shell access? since the the content of remote server is not the same with apache, so i found quite difficult to connect them.very sorry for interrupt u!!!

JdS · #4 08-Jul-2004, 05:28

The following snippet is an example of what a SQL batch file may contain:

Code:

#
# Table structure for table `queue`
#

DROP TABLE IF EXISTS `queue`;
CREATE TABLE `queue` (
  `host_id` smallint(5) unsigned NOT NULL default '0',
  `path_id` smallint(5) unsigned NOT NULL default '0',
  `query_id` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`host_id`,`path_id`,`query_id`)
) TYPE=MyISAM;

#
# Dumping data for table `queue`
#

INSERT INTO `queue` (`host_id`, `path_id`, `query_id`) VALUES (3, 1, 1),
(5, 1, 1);

You upload it just like you would a normal .HTML file to your remote server.

The /sql folder in my example is a folder you can create yourself on your remote server. You can create and name it anything you want actually...

(Secure) shell access gives you direct access to the file system of your web site or web server, enabling you to execute command-line instructions. Something like the Windows Command Prompt on your Windows PC...

bearky · #5 09-Jul-2004, 00:57

dear sir,

can i know where is the shell, is it in the remote server? what is the file name for the shell u mentioned? how to access the shell? very sorry for interrupt u since i am quite new to the remote server setting.

i have email service in my webpage. previously i just need to change smtp setting in php.ini. But i couldn't find any php.ini in the remote server. can u help me where to set the smtp setting?

thanks...

JdS · #6 12-Jul-2004, 08:37

All these questions you ask should be answered by your web host. They will usually tell you how to connect to your server, either via SSH / Telnet. Again the smtp setting in your remote server is managed by your web host. Ask them for the details.

bearky · #7 13-Jul-2004, 06:08

sir, thanks for ur helps.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
[CONTEST?]Data Structure Test	dsmith	C Programming Language	2	06-Jun-2004 16:13
Grouping data from MySQL with PHP - Newbie question.	giobbi	MySQL / PHP Forum	12	27-Feb-2004 01:34
· Windows 2003 Server Reseller Special: Unlimited Domains/2 GB Space/for $19.99	contactsonia	Web Hosting Advertisements & Offers	0	09-Jan-2004 06:46
can mysql run on a separate server?	zabell	MySQL / PHP Forum	6	06-Jun-2003 14:32