Import MySql


i have two mysql database

db1 and db2

i want to move my db1 to db2

1] i export my db1 in zip
2] open zip
3] go to my db2 mysql phpMyAdmin place and browser my db1.sql and press go.
4] it said denied.

what should i adjust in order to transfer my db1 to db2?


Look at the first few lines in the SQL file. You will probably have a USE command? Remove that if you are in PHPmyAdmin and using only one DB. Or change it to your database name. That should work?


The other option is from telnet do a mysqldump piped into a mysql command. for example:

mysqldump -uUSER -pPASSWORD db1 | mysql -uUSER -pPASSWORD db2

This also works, as I have recently found, if you are migrating from one host to another if you can access your SQL database remotely.

-Jason - Home Page
MP3Mystic - Personal Streaming Music server.
(Neither of these sites are still hosted at dreamhost)


i change the first few thing, but it still denied. can you tell me exactly what i need to change