Page 1 of 1

Beginner - uploading MySQL to my web host

Posted: Thu Feb 06, 2003 1:00 pm
by LandRuler
I'm sure this must be the most basic of operations and as such is probably covered in a basic primer somewhere. But after much searching, I haven't found an answer.

I'm a beginner with PHP and MySQL. I have no experience with other server-side scripting or databases. All I've ever done is upload HTML pages to my webhost through the ftp client built into Dreamweaver.

I'm using Win98, Apache, PHP4, MySQL 3.23. My web host provides a PHPMyAdmin GUI for management.

My question:

In the simplest terms, what are the steps to upload a fully developed MySQL database with multiple tables from my development machine to my webhost?

Thank you very kindly for your patience.

you have to

Posted: Thu Feb 06, 2003 3:41 pm
by AVATAr
The steps are

1) Make a DUMP of your database in a text file (if you use phpMyAdmin, its very easy) -> it generate a text file with all the sql statements you need

2) Open PhpMyAdmin in your server and upload your DUMP file and run it

Its very simple...

Posted: Thu Feb 06, 2003 3:45 pm
by davro
Well if you have phpmyadmin at hand then personally i would.

LOCAL
Fire up your phpmyadmin if its not already running
Select the relevent database on the left navigation this should show 'View dump (schema) of database'
Select the tab 'Export' on the right
Check option box 'Structure and data' if required
Then check 'Save as file' press 'Go' and you should be prompted to download an sql dump file.

REMOTE
Open up a browser session pointing towards your remote phpmyadmin.
Create a database for your tables and data to be placed into.
Then select this database using the left navigation.
Select the tab 'SQL' on the right
Now you should see a 'Browse ...' button press this and select the local dump file something.sql
Press go and the sql file should handle the rest for you.

Hope helped davro.

uploading MySQL to web host

Posted: Fri Feb 07, 2003 4:43 pm
by LandRuler
Thanks to both of you, that's just what I needed. The manual talked about "dump" and I thought that might be it. But it wasn't clear enough to make me sure that was the answer nor was it clear enough about the exact steps. Sounds pretty simple now. If it doesn't work, I'll be back. :wink:

Jim