Marco,
Saturday, February 23, 2002, 3:59:20 AM, you wrote:
MB> Hello, I am a beginning MySQL and PHP user. I will run a MySQL database on a
MB> remote hosting server, and I have only limited access to the database at
MB> that server. I want to populate my database off-line at my home machine, and
MB> then upload the whole thing (100s of lengthy entries) to the server. But I
MB> don't have direct access there. So I suppose I'll have to do something like
MB> exporting my data to a text file, upload the text file to the root of my
MB> domain at the server and re-create the database from there. I don't think I
MB> can run any tool on the server; I work with .php files there.
MB> So my question is: how would people normally go about this task. Would I
MB> need to write a script for in- and export of data, or would there perhaps be
MB> a handy tool that takes this out of my hands?
mysqldump will help you, see at:
http://www.mysql.com/doc/m/y/mysqldump.html
Look at SELECT ... INTO OUTFILE info in the manual:
http://www.mysql.com/doc/S/E/SELECT.html
MB> Thanks, Marco Bleeker, Amsterdam
--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
