Re: 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? Todd Robbert van Andel wrote:

You could run a system command from the web browser to import the text file. If you have access to PHPmyAdmin, you could use it to then import the file. 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 http://www.phpmyadmin.net/home_page/ Robbert van Andel -----Original Message----- From: Todd Cary [mailto:todd@aristesoftware.com] Sent: Saturday, November 05, 2005 4:02 PM To: php-db@lists.php.net 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