Import MySql


#1

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?


#2

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?


#3

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

mysqldump -hswql.mydomain.com -uUSER -pPASSWORD db1 | mysql -hsql2.mydomain.com -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

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


#4

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