We Talk Coding

Uploading mysql databases in cpanel?

I did a full backup on my old host which stored all my html and mysql documents. The mysql files are stored as .sql files. On the new host, in the backup section of cpanel it has a spot to upload databases. I keep trying to upload these .sql files and it says "Restoring database" after it uploads and that's it. I reload my cpanel page and it never shows the databases I uploaded. Then I figured i might have to manually create the databases and THEN upload them, but it never uploads them. The database always appears as empty. The sql files are not empty. Any ideas? I have created the database and added the same user to it as it was in the old web site. Same username, password and database name. And it doesn't upload

Public Comments

  1. You need to first create a database in cpanel and assign a user to it, before you can upload the database files.
  2. jnheid is right but most hosts will let you upload the backup from your previous host and will set it up for you to be exactly as it was on that other host. send them a ticket/request they should be able to do it for you. GiorgosK http://geoland.org
Powered by Yahoo! Answers