Beginner - uploading MySQL to my web host

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
LandRuler
Forum Newbie
Posts: 4
Joined: Mon Feb 03, 2003 3:28 pm
Location: Tulsa USA

Beginner - uploading MySQL to my web host

Post 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.
User avatar
AVATAr
Forum Regular
Posts: 524
Joined: Tue Jul 16, 2002 4:19 pm
Location: Uruguay -- Montevideo
Contact:

you have to

Post 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...
davro
Forum Newbie
Posts: 8
Joined: Fri Nov 01, 2002 6:54 am

Post 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.
LandRuler
Forum Newbie
Posts: 4
Joined: Mon Feb 03, 2003 3:28 pm
Location: Tulsa USA

uploading MySQL to web host

Post 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
Post Reply