Hi

Ive built a site that is going to connect to a Mysql database,the database is elsewhere with a diffrerent company,the thing is its my first time setting up something like this,ive downloaded thier latest MySql dump file but i have no clue what im supposed to do with it or where its supposed to go,as well as thier database i have my own 20mb MySql db as part of my hosting package,does this dump file go into my db? Any advice at all will be greatly appreciated.

Thanks
Audioz

Have a look inside the dump file (open it up in your favourite text editor).
It is just a bunch of SQL commands that have the effect of constructing the right database and filling it with the right contents.

This shell sequence:

promt# mysql -u user -p < dumpfile.sql

ought to run those commands on your db.

CHECK FIRST that none of the table names in the dump file clash with tables you already have, or else they will be overwritten. In fact if you can set up another database and use that it will be safer.

Hi 0beron

Thank you very much for your reply,i think im correct in believing that this dump file can be used with my empty 20mb database that i have,as of yet im still unsure as to how i set things up,but i guess its just a matter of time and learning the basics with this,please correct me if im picking things up wrong,im just very new to website building,6 months ago i hadnt done anything website based,but since then ive learned about html,CSS etc.
Where would i put the shell sequence that you provided?
Please excuse my lack of knowledge on this subject,i can imagine its possibly very basic stuff for many users here.

Thanks so far

Audioz

Sorry - I was assuming that you have shell (ie command line) access to your webhost. If this is not the case, you are probably best off mailing it to the server admins and asking them to do it for you.

Does your server have phpMyAdmin available? Cos you can probably do it from there as well. If you want instructions on how to do this then just post back and someone will be happy to answer.

Thanks Oberon

Il contact the hosting company and see if phpMyAdmin is available to me,i see nothing obvious to me in my account.

Thanks again

Audioz