Copying database with php

@salimSep 26.2007

Hi all

I am here again hoping to get some sought of help for the issue i ran into.

Is it possible to create a database by copying from an existing db by running a php script?

thnx and regds
salim

to post a comment

PHP

@bokehSep 26.2007 — #Yes!

@salimauthorSep 26.2007 — #please brief how to do it

@bokehSep 26.2007 — #You need to properly detail what you are trying to do.

@salimauthorSep 26.2007 — #I am having a database called mydb.when the user runs a php page i want another database to be created same as the 'mydb'.user will enter the database name in a text box he wants to create.so new database will be created with that name.

@salimauthorOct 04.2007 — #I am a lil late to post this.

I am posting this so that someday some one may find it usefull?

<?php

$localhost = "your_host";

$username = "user_name";

$password = "password";

$database = "database_name";//of which dump is to be created.

$backupFile = $database . date("Y-m-d-H-i-s") . '.sql';

$command = "mysqldump --opt -h $localhost -u $username $database > $backupFile";

system($command);

chmod($backupFile,0777);

//write the code here to connect to your database

$database_new = "my_new_database";//put the name of the database you want to create

$sql = 'CREATE DATABASE '.$database_new;//create new database

//now restore the dump to the newly created database.

$command_new = "mysql -h $localhost -u $username $database_new < $backupFile";

system($command_new);

?>

Copying database with php

5 Comments(s) _↴

Also in #PHP _↴

Success!

Social

Version

Copying database with php

5 Comments(s) ↴

Also in #PHP ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

5 Comments(s) _↴

Also in #PHP _↴