How to transfer an existing MySQL database?

After you have finished transferring your files, you need to transfer your existing MYSQL database. To do so, you need to create a new one within your account with us and then import the data from the existing database.

To create a new database, go to the cPanel of your UniqueVPS account and navigate to MySQL Databases. First, create the database from the Create New Database option. Then, create the new user in the Add New User field. Do not forget to Add User To Database with ALL PRIVILEGES.

Next, you need to import the old database into the new one.
To do so, go to the cPanel > phpMyAdmin. Select the database you have just created from the list on the left and then click on the Import option in the toolbox on the top of the page. Upload the database backup from where you have saved it, wait until the upload is completed and you are all set!

*Note: Make sure you have done all the needed adjustments to your configuration file, so that it can work with the new database.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

What is php.ini?

Php.ini is one of the essential configuration files in PHP. When PHP starts, this is the file it...

Do you have any setup or hidden fees?

UniqueVPS does not charge any additional or hidden fees. All web hosting solutions, extra...

How many subdomains can I create with UniqueVPS?

You are free to create as many subdomains as you wish and install different site-building...

What is a subdomain?

A subdomain is a domain name that is part of a main domain. It might be a separate website with...

How to access the phpPgAdmin to manage my PostgreSQL?

Accessing phpPgAdmin is very straightforward. It is neatly located in every customers’ cPanel but...

Powered by WHMCompleteSolution