Database Restoration

[hmaddy]

i need to restore one database from one server to new server with new username.

For Eg: Existing database name like cpanelusername1_dbname.sql. i need to restore the content of these database to new server with cpanelusername2_dbname. Is this possible.

 

[RoseHosting]

Yes, it is possible. You can use shell command or phpMyAdmin to import the database.

 

[hmaddy]

Yes, it is possible. You can use shell command or phpMyAdmin to import the database.

its have 2 GB in size, so via phpmyadmin its not possilbe. if you know please share the correct shell commands.

 

[RoseHosting]

You can run the following command via SSH to restore the database:

mysql -u cpanelusername2 -p cpanelusername2_dbname < cpanelusername1_dbname.sql

The MySQL user (cpanelusername2) and database (cpanelusername2_dbname) have to be created before you run the command.