Can't import dreamhost database in other

[rahul23]

I have a site at dreamhost, and i exported my database using phpmyadmin. But i can't import that database in other cpanel host.

Should i have to make any changes, coz dreamhost gives hostname as mysql.sitename.com. Should i have to change it to localhost. Is that is enough ?

Please help me.

Thank you.

rahul23 Reviewed by rahul23 on 8th Feb 2012. Can't import dreamhost database in other I have a site at dreamhost, and i exported my database using phpmyadmin. But i can't import that database in other cpanel host. Should i have to make any changes, coz dreamhost gives hostname as mysql.sitename.com. Should i have to change it to localhost. Is that is enough ? Please help me. Thank you. Rating: 5

[l0calh0st]

What error do you get?
Ask your host to do a cPanel transfer.

[rahul23]

I created a new DB with cpanel, imported my site db into it. Then when i open the site, its showing, install wordpress.

[immu]

rename this "mysql.sitename.com" to "your_desired_db-name.gz" and import
remove the no of Dots in the name

[awaiz007]

Did you change details in config file i.e new db details
hope it works

[Bilal]

You should use MySQL Administrator to export/Import databases. Download it from the link below.

MySQL Administrator Direct Download

Source: http://dev.mysql.com

[rahul23]

i changed details in new config files. mysql.hostname dont didn't occur in database.

I tried another host, export was successful, i can access admin area but not first page. even tried changing htaccess file

[ScopeHosts.Sales]

Which control panel do you at the dreamhost. if its cpanel . ask the new hosting provider to transfer the account for you . By providing your cpanel login details .

[Loonycgb2]

Make sure your database sql is not trying to create a new database.... you prob exported the entire db not just the tables

[ultimatehostings]

Make sure you set the host as localhost.