Hi

I have created my first website on my PC using windows 2000, PHP with a backend MYSQL database, which will be read only on the web.

I am now trying to put the web site live on my new hosting account on a linux box, but I don't know where the dbase I created on my local PC should be placed.

I have tried looking in the SQL and PHP manuals over the last couple of days but without any success.

I have the pages working but the php code to access the dbase results in the error message 'unable to select dbase'. I assume I have placed my dbase in the wrong location.

Can anyone help, as I am nearly dragging my hair out?

Cheers
Andy

You'll need to dump the MySQL database with something like phpMyAdmin on the Windows machine and then import it with phpMyAdmin on the destination machine.

You'll also need to have created the MySQL database on the destination machine.

--Shaun

Thanks Shaun,

You have helped me a great deal here.

I now understand the technique I need to get the database there.

I was thinking after I had created by dbase on the server I could just copy the files in my data group across to the server, which I now understand is not the case.

Thank you again for your help,

Andy

I have multiple MySQL servers that I maintain. I found this great site to manage MySQL databases. You can move, edit, create, drop , etc.

http://www.anse.de/mysqlfront/

Check it out. It's a windows based app and it works great. Make sure you have a user account that can log in remotely.

You will be all set.

Any questions feel free to ask

John

if that doesnt work just get a free one from www.portlandsql.com there pretty reliable its only just started so it doesnt have to many members

Hi John,

That was excellent advise.

Mysqlfront is just what I have been looking for.

I installed the application on my PC, dumped my dbase structure and content from my PC and uploaded it to my web server, within an hour.

Now as I know what to do the dbase copies will take me minutes.

I would highly recommend this product for copying dbases.

Thanks again for all your help,

Andy

No Prob Andy,

I have learned alot of SQL querys from that app. I put entries in all of my DB's to be able to log in remotely and manage all my DB's


John