script to import mysqldump file?

[garyed]

I am now trying to find a script to import a mysql dump file of a complete database.

If I do this in a Linux terminal it works fine.

mysql -h host -u user -p password  database < dumpfile.sql

Is it possible to put this command or something that will do the same thing in a php script? 

 

 

[nicholasstephan]

you can do the same thing using phpMyAdmin (www.phpmyadmin.net).

[Mchl]

<?php
`mysql -h host -u user -p password  database < dumpfile.sql`

 

PHP has to have appropriate privileges though.

[andrewgauger]

I dont think there is a space between -p and password.

 

-ppassword if your password is password.  Threw me for a loop for a long time.

[garyed]

<?php
`mysql -h host -u user -p password  database < dumpfile.sql`

 

PHP has to have appropriate privileges though.

 

Wow, thanks that worked perfectly!

Now I can upload & import my databases from my home server to my web server with that simple script.

To be safe I'll delete the php file from the web server when I'm done & just  edit it on my home server. 

 

By the way does encasing a command in those ``(tildes) or whatever they're called make it act as though it was typed in a terminal because when I tried the exec() command it didn't work but those things sure did.   

 

 

 

 

[Mchl]

http://php.net/manual/en/language.operators.execution.php