Database import in Cpanel 11

A

andreyknure

New member
Hello guys! The situation is the following - I have some databases on local host and now I am going to upload website to hosting! My friend provided me with some place on his hosting account and now I am going to test a website! Could you please explain how should I act with my ready databases if I have Cpanel 11 installed? I don't wish to rewrite them again and just would like to move them from local host to hosting!
 
The situation is the following I used phpmyadmin 2.11.5 on localhost when creating databases, but I have phpmyadmin 2.11.6 installed on my hosting account. I am planning to upload databases to hosting really soon and I have some questions about uploading databases to hosting. Can phpmyadmin version difference cause any problems when importing databases to hosting account?
 
Nope i dont think it will cause error, if you are moving from higher version to lower surely it wont work

Yesterday we had same problem with plesk control panel 9 edition, we tried to move 320 small sites from reseller account to this but failed, the whole thing went mess
 
The phpmyadmin versions will not cause any issue, make sure that you are uploading to the mysql server with a compatible version as well.
 
The version of phpmyadmin wouldn't be an issue as it's core function is just to serve as a ui for mysql databases. Most upgrades to phpmyadmin are just bug fixes or improvements to the interface.

What you would ultimately need to make sure of is that the mysql server on your localhost is within the same version of mysql on the server. Also, make sure that you do not have any CREATE DATABASE or USE lines in the sql file. You would create the database under cpanel> mysql databases and the database you select in phpmyadmin will automatically be the database that the sql data is imported to.
 
That is right, compare the versions of mysql on any servers, when you are set for a website transfer, this is is very important for database driven sites.
 
The version difference wouldn't be that much of an issue nowadays. You can always run mysql_upgrade after the db file is imported. I have yet to see a major problem when it came down to this. However, there is always that concern that you need to have with major upgrades.
 
This is normal work you can upload the db and can upgrade the db inside the SQL database as said its the easiest way but in windows related panel this is giving errors
 
You must log in or register to reply here.

Supporters

Back
Top