Yes, this is an upload of a local file.  I'm not sure if there is a way to
run the sql command inside the file if it's sitting on the server.  Keep in
mind that you may run into size upload restrictions (i.e. files larger than
2 megs, or whatever your webhost has set it to).  If that's the case, you
can separate out the sql commands from the file into separate files.  

-----Original Message-----
From: Todd Cary [mailto:[EMAIL PROTECTED] 
Sent: Sunday, November 06, 2005 8:43 AM
Subject: Re: [PHP-DB] Using PHP to import a DB

Robert -

I installed phpmyadmin on the shared server, however I am not sure of 
the command to run the sql file, mybackup.sql, that was created on the 
dedicated server with mysqldump.

The docs as best as I can read them indicate that all I need to type 
into the "Run SQL query" text box is the name of the file 
("/tmp/mybackup.sql"), however that produces an error.

Maybe the problem is that I FTP'd the file to the shared server and it 
should be on my local computer??

What have I overlooked?


Robbert van Andel wrote:
> You could run a system command from the web browser to import the text
> If you have access to PHPmyAdmin, you could use it to then import the
> Or finally, you should be able to read the contents of the file into a
> variable (if it's small enough) and then run the query using mysql_query.
> My personal preference is phpmyadmin.  It's a very good database interface
> and can be retrieved from
> Robbert van Andel 
> -----Original Message-----
> From: Todd Cary [mailto:[EMAIL PROTECTED] 
> Sent: Saturday, November 05, 2005 4:02 PM
> To:
> Cc: Chris Herron
> Subject: [PHP-DB] Using PHP to import a DB
> My client switched from a dedicated server to a shared server, so I 
> cannot use the command line to import a DB that was produced with 
> mysqldump.  Can I duplicate "mysql -u user -p db < /tmp/mydb" with php?
> Any suggestions are greatly appreciated....
> Todd

PHP Database Mailing List (
To unsubscribe, visit:

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to