Web Hosting Talk : Web Hosting Main Forums : Programming Discussion : Issue importing database

[JamieN]

I have read various posts about using phpMyAdmin to export and import databases from one host to another. The import seems to run, and I get this message: Your SQL-query has been executed successfully.

However, I still see "No databases" on the left. I click on the Databases link under MySQL, and it says "no databases."

I have exported the database without compression and in a zipped format. I even tried just typing a query to create the database but no luck.

I am probably missing something very basic. Any ideas?

Thanks

[Burhan]

Perhaps your user doesn't have rights to create a database?

Try creating a database first "manually" (through cpanel or through your shell).

[fraudgate]

You will need to create a database before you import the data. The data you are trying to import are database tables, not a database. The MySQL database actually holds the tables you are trying to import.

[JamieN]

I can create a database in cpanel 6 on the mySQL screen, and the message states that "xxx" database was created with the name that I specified. However, when I go back to the MySQL screen, the database name has changed: my cpanel user id is appended to the beginning of the database name, and the underscore in the database name has been removed. Because I am trying to move a database from another server, I would like to use the name that was used, so I don't have to update the entire site with a new database name.

I also tried using phpMyAdmin to create the database, but I get error 1044 stating that I do not have the access to create the database.

I have seen multiple posts about using SSH, but since I have not used it before, I am apprehensive about using it on a live site.

These questions are quite basic, so if you can refer me to some good documentation, that would be great. The cpanel and phpMyAdmin docs do not address my question.

[CreativeLogic]

you will have to use ssh to create this database. CPanel will always put your username there.

[JamieN]

I have read multiple posts about mySQL commands to create the database, but I don't know anything beyond getting the SSH window to open. So back to seeing if I can get phpMyAdmin to do what I need.

I have been able to create a sample database and import tables/data into that database using cPanel's phpMyAdmin. Since I don't want cPanel to add my cPanel user id to the beginning of the database name, will I be able to control the database name by installing my own copy of phpMyAdmin on the site?

I did try installing phpMyAdmin, but I don't understand the values that I am to change as specified by the documentation: host, user, password and authentication mode. I tried using my cpanel id and password, but it did not work.

[Karthick]

In cPanel, I think only root has power to create untagged databases / usernames, though you can have a go at the following:

host in most cases is just localhost. user and password depends on what you have created through cpanel.

In SSH try:

mysql -u user.name -p create database.name

I just tried creating untagged database in phpmyadmin and it returns a permission denied error.

If you are restoring a large sql backup through phpmyadmin you will find there is a 2M limit, (it can be changed in php.ini). To get around this you just upload the SQL file to your root folder and then run this in SSH:

mysql -u user.name -p database.name < backup.sql