use php to copy table & rename the database.

[Anon]

hi,
1.) after i create database using
my_sql_pconnect("loclhost","123","123");
my_sql_create_db("my_db");

then how can i copy all tables from one db to this newly created db(my_db) and at the same time delete the content from the tables in this newly created db using php..

2.) how can i rename the db name without changing any tables under this db using php??

thanks for the help..
frm
patrilia 🙂

[Anon]

Is there a reason you can't use the command line? Easiest and quickest way is to use mysqldump.

mysqldump -u <user> -p -d <database_name> >> db_struct.txt

-u is the user option, tell it what user to log in as. -p tells it to prompt for a password. -d tells it not to dump the data, just table structures.

mysqladmin -u <user> -p create <new_database>

this is pretty straight forward, just creates the new database.

cat db_struct.txt | mysql -u <user> -p <new_database>

now we cat the file we created in step one and pipe it to mysql, still asking for a username and password and specifying the new database name. Hope that helps!

Chris King