database delete / database import

[wooolF[RM]]

]Hi, I have a database (old one) that I want to drop from MySQl server with this php file :

PHP Code:

<?
system ("mysql -h hosthere -u loginhere --password=passhere -e "drop database databasenamehere"; phpinfo();
?>

^^^doesn't work... anyone got any idea?

after that I need to import a backed up database to this place with this php file :

PHP Code:

<?
system ("mysql -h hosthere -u loginhere --password=passhere databasenamehere < dump.sql");
phpinfo();
?>

^^ works just fine...


Can anybody can me with script that drop the whole database at once? Thanx

[wooolF[RM]]

]very helpfull community...

I found a script...

PHP Code:

<?
mysql_connect("hostname","username","password");
$query = "DROP DATABASE databasenamehere";
$result = mysql_query($query);
phpinfo();
?>

but now damn import script doesn't work... darn! :/

[wooolF[RM]]

]still noone?

I need import script that works......

[Admin]

Have you tried creating the database first, before importing into it?

[wooolF[RM]]

well... that's actually the problem...
as U have seen from delete script, I have just dropped database...

Now I can't import any data as database doesn't exist... And I really don't know how to create one. I know it's easy for all of u to say go to google or MySQL hp and look there. But I think for some of u are much more easier to give 3-4 lines script.

Please help. Thanx

[Admin]

mysql_query("CREATE DATABASE databasename");

[wooolF[RM]]

]so something like:

PHP Code:

<?
mysql_connect("hostname","username","password");
mysql_query("CREATE DATABASE databasename");
$result = mysql_query($query);
phpinfo();
?>

and then I should run this script :

PHP Code:

<?
system ("mysql -h hosthere -u loginhere --password=passhere databasenamehere < dump.sql");
phpinfo();
?>

and I'm done? :supwink:

[Admin]

Remove

$result = mysql_query($query);
phpinfo();

from the first code, and remove the call to phpinfo() from the second.

[wooolF[RM]]

]who's your daddy?! FireFly is! LOL

Thanx a lot! Everything works! GJ!

[Admin]

I have a son?