I need immediate help!!

[solconsult]

Dear readers,

I need help on how to upload database to the server. I am using PHP and MySQL. I have created the database using PhpMyaAdmin. Assume that my website is www.solomon-page.com.

Some body told me to install PhpMyAdmin on the server. The server is not with me and it is in USA. But I am in Africa.

So can you help me?

Thank you

[adrian_quah]

solconsult,

i suggest u get in touch with the server provider (host) in the USA as stated. get their email, contact them.

As for phpmyadmin, u can upload the entire phpmyadmin into a new folder there...though i'm certain the server provider would not allow this as it will pose security issues.

u can ask them 2 allow u to post ut mysql tables...and all u need is to email them the tables which can be found in the 'data' folder of ur MYSQL installation folder..choose the tables and database u want, and email them...

[scoppc]

Well, easiest way (probably) without the need to email any MYSQL tables' files to your provider will be to back up all of your databases (as well as its contents) and restore em in your web server (in the US).

To back em up, use MYSQLDUMP.
If you are using WINDOWS OS, use MSDOS and go to mysql/bin folder and type this:

mysqldump -u user -p database > backup.sql

Take the file and upload it to the web server.
Remotely access the web server through the command line and restore the database by typing the following command

mysql -u user -p database < backup.sql

HTH.