I asked this question in a forum last week and finally got a helpful answer. I'm new to databases and I knew how to upload an html file through a typical ftp client but I couldn't get my head around the concept of uploading a MySQL database. I'm using phpMyAdmin to manage MySQL.
BTW, TFM was no help in this instance. If I had understood the language and realized the connection between "upload" and "dump" I might have gotten it. But in my beginner's ignorance I was lost. Here are the steps I received from a kind respondent. (Apparently my version of phpMyAdmin is different because I had to modify these steps slightly but I was able to take my first 'dump' without incident. If this doesn't help, I precisely documented my actual steps and would send you those later - I don't have it here with me). ON YOUR LOCAL MACHINE: Fire up your phpMyAdmin if it's not already running. Select the relevant 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 SERVER: 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. Jim -----Original Message----- From: Rui [mailto:[EMAIL PROTECTED]] Sent: Monday, February 10, 2003 2:32 PM To: [EMAIL PROTECTED] Subject: MySQL: some script I must do First of all, I must thank all the people who tried to help me in the earlier prob. Now I know how to make dump's. The problem now is that I don't know how should I send the database. I tried to make a dump > data.TXT and also tried data.sql. Both were in vain. I must run some kind of script but I don't know what. Tried: \.data.sql I had to put the also the source, but when I pressed Enter key, an error apears "ERROR 1046: No database selected" What's wrong? Thanks. Old message -------------------------------------------------------------------- ------------------- Hy there, I want to put a mysql database on a external server. My ISP told me that I need to make a Dump of the data and then make some kind of script that I couldn't understand. Could anyone explain what I need to do? Thanks a lot, Cya -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
