so i asked my host streamline to setup another database as i dont have the privilege under phpmyadmin,,, sucks i know.. so they have done i have this new database thing is the username and password are different to my original connection, the server is still the same. so how would i go about this?? would i need to ask them to change the username and password to the same as my original one and move the new database to the same place, or can i make a multiple connection in php and copy information from table 1 in database 1 to table 1 in database 2, even thought the connection parameters are different (only username and password) not really sure if i can do this.
or should i maybe run a sql statement that copies that table to a text file and then close that connection run the new connection and then run the text file again to create the table and insert into it all the information needed??? has anybody every tried doing this, im not sure if im in the right area but this doesnt seem like a total database question to me.
ive tried the following
CREATE TABLE IF NOT EXISTS $datbase.$newtable SELECT * FROM $database1.userlogin
where $database and $database 1 hold the database names.
i get CREATE COMMAND denied, so im guessing as they wont let me create tables??
is there anyway around this one guys and gals??