How to give the mysql database to the remote serv

[Anon]

I have write a program .And there are a few codes about php worked for mysql database
in the program.But the database is created by the command of mysql . Note: the database is not created by the functions of php. Now I want this program running at a remote server which is in INTERNET, instead of
my own computer.How to give the mysql database to the remote server?

[Anon]

On your computer, dump the database

(from command line)
mysqldump -uuser -ppassword database_name > file_name.sql

Then, log into remote server, upload the file_name.sql, and type the following on the command line in the directory where you uploaded the .sql file:

mysql -uuser -ppassword database_name < file_name.sql

This is assuming the database is already created on the remote server, you're just adding the tables. If it's not created, log into mysql and issue the command create database database_name; If it's not your server, you usually don't have permissions to do this, though. Ask your system administrator to create the database for you.

Hope that helps.

---John Holmes...