On Fri, 5 Apr 2002, Anthony Ritter wrote:
>  Now I have a .txt file of my sql statement.
>  
> > As others have suggested, you can use phpmyadmin to import this file, or 
> > you can just pipe it into the mysql command-line tool on the server once 
> > you've created your database. Look inside the file created by mysqldump 
> > and all will be much clearer.
>  
>  I take that to mean (the ISP's remote server where my website resides).  
>  Right?
>  
>  How can I get the compete mysql statement onto the ISP's server?

If you have shell access on your ISP's server, the quickest way to get
that data into the database there is to copy the file across (using FTP or
scp or whatever you use) and then pipe it straight in. Assuming that the
mysqldump file is called 'data.txt', your database name is 'my_database'
and your database username is 'me', you could use a command like this:

   mysql -p -u me my_database < data.txt

It'll ask for your password and then the data will be in.

If you don't have command-line access, you could use a tool like
phpmyadmin, which your ISP may provide. It has an option to import data 
from a mysqldump file.

Worst comes to worst, you can write a quick PHP script that reads each 
line of the .txt file and sends it to mysql_query. Just skip blank lines 
and comments (lines starting with #).

miguel


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php