phpMyAdmin issues

[bluestrobe]

I was given a test account by a web host reseller to try out before I moved my web site. The interface is cPanel, MySQl v5.0.27-standard, phpMyAdmin v2.11.0. My current web server, which is hosted at my house, has phpMyAdmin 2.10.1, MySQL v5.0.45-community-nt.

The test database is a SMF message board with a size of 2.5MB. It is has users "Root" and "Rjade" currently on my server. On my server I am signed in as user root@localhost for the moment. I did a direct export of the database to board.sql and tried to upload it to the new host logged in automatically as rjade@localhost. Right away I got denied for lack of permissions to upload a database. My reseller sent a ticket to the host and got the following reply:

They cannot create the database via phpMyAdmin. They will need to create the database via the Manage MySQL option in cPanel and then import the contents of that database backup into the new database.

and we got this second letter from another tech.

You are trying to create the database "board" which is not allowed for the user rjade. Database should be in the format username_db. So edit the sql file such that db name is rjade_board and then import the database.

So this is what I did:

1. Export database from original server with root and rjade as users with full privileges (board.sql).
2. Create database with MySQL named "board" which defaults to rjade_board due to the new host.
3. Add user "rjade" to the empty database as a user with full privileges which defaults to "rjade_rjade" due to the host.
4. Open phpMyAdmin and select the empty DB "rjade_board" in the left column.
5. Rename "board.sql" to rjade_board.sql"
6. Select "import" and select the DB "rjade_board.sql" to upload.


and I get:

#1007 - Can't create database 'rjade_board'; database exists

I took the out steps to just upload the rjade_board.sql directly to the host with no other databases on the host and get the following error.

#1044 - Access denied for user 'rjade'@'localhost' to database 'rjade_board'

In the past, I was able to upload and download databases without restrictions on other hosts but I can't even upload to this host without jumping through flaming hoops. I'm not good with databases and my experience with phpMyAdmin is importing, exporting, and adding/deleting users and permissions. Any suggestions?

 

[wwswimming]

the forums at phpBB might to be useful.

http://www.phpbb.com/community/

 

[troytime]

i could be wrong, but i think typically mysql databases are managed with pure sql

if you create the db and db user, and set the permissions (in cpanel), then you just need to create the tables

i don't have any experience with moving db files (other than using access databases about 8 years ago)

 

[bluestrobe]

Originally posted by: wwswimming
the forums at phpBB might to be useful.

http://www.phpbb.com/community/

This is strictly a database and phpMyAdmin issue, I couldn't upload ANY test database.

 

[bluestrobe]

Originally posted by: troytime
i could be wrong, but i think typically mysql databases are managed with pure sql

if you create the db and db user, and set the permissions (in cpanel), then you just need to create the tables

i don't have any experience with moving db files (other than using access databases about 8 years ago)

I have no experience at importing tables by hand and really don't want to with over 70 tables and 2.5MB of information. I would figure that uploading a simple DB file would be a lot easier than this.

 

[bluestrobe]

I got it, thanks for the ideas.