Phpmyadmin Problems

[moose6589]

Hey everyone,

 

I just got my account setup (I am trying to move a phpbb forum from my home server to the TCH server). In cPanel, I go to phpmyadmin and attempt to import the .sql backup that I had created with mysql-admin on my computer. However, when I click OK, it gives me an error:

 

SQL query:

 

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

 

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

 

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

 

/*!40101 SET NAMES utf8 */;

 

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

 

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

 

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

 

--

-- Create schema phpbb

--

CREATE DATABASE /*!32312 IF NOT EXISTS*/phpbb;

 

MySQL said: Documentation

#1044 - Access denied for user 'crvgavad'@'localhost' to database 'phpbb'

 

The main problem seems to be that phpmyadmin somehow does not have the access to import the database. Does anyone know how I can solve this problem (or otherwise move my current phpbb forums with posts onto the TCH server)? Thanks!

 

Richard

[telcor]

If you can perform other actions within PHPMyAdmin, such as create tables, execute queries, etc, then likely the problem is a difference between MySQL Server versions. If your original server used MySQL 4.1, and the TCH Server is using MySQL 4.0, then chances are the SQL generated by the export is not compatible with the TCH MySQL server. The portion you posted suggests that is the issue.

 

If you still have access to the original server, try performing another export, using only the simplest criteria (for example, don't use extended or complete inserts, they tend to be buggy). If you don't have that access, clean out from the file everythign that is not an INSERT, CREATE or IF NOT EXISTS. Make certain to backup this file before modifying it however.

[moose6589]

If you can perform other actions within PHPMyAdmin, such as create tables, execute queries, etc, then likely the problem is a difference between MySQL Server versions. If your original server used MySQL 4.1, and the TCH Server is using MySQL 4.0, then chances are the SQL generated by the export is not compatible with the TCH MySQL server. The portion you posted suggests that is the issue.

 

If you still have access to the original server, try performing another export, using only the simplest criteria (for example, don't use extended or complete inserts, they tend to be buggy). If you don't have that access, clean out from the file everythign that is not an INSERT, CREATE or IF NOT EXISTS. Make certain to backup this file before modifying it however.

 

That is a good point. According to cPanel, TCH uses MySQL 4.1.21, whereas my server is running MySQL 5.0.22. I guess the next question would be why TCH hasn't upgraded to MySQL 5?

 

I tried recreating a backup without complete or extended inserts, and I still get the same errors.

 

However, I don't think that is the problem at all (not the biggest problem, at any rate). When I try queries such as creating a new database in phpmyadmin, I also get the same access denied error. From all that I have read so far, this leads me to believe that the password used to login to the MySQL server is incorrect from TCH's end, so phpmyadmin cannot login. This doesn't make total sense either (as I can see the databases created in cPanel), but I believe it is something to do with authentication and passwords. Any other ideas?

 

Edit: Incidentally, there is something else to consider. Is it actually possible to import a database made in MySQL 5 into MySQL 4? If this is not possible, then I think I might just consider creating a new database and forums and starting over from scratch.

Edited September 23, 2006 by moose6589

[telcor]

That is a good point. According to cPanel, TCH uses MySQL 4.1.21, whereas my server is running MySQL 5.0.22. I guess the next question would be why TCH hasn't upgraded to MySQL 5?

 

The corollary: why do they need to run MySQl 5?

 

I tried recreating a backup without complete or extended inserts, and I still get the same errors.

 

However, I don't think that is the problem at all (not the biggest problem, at any rate). When I try queries such as creating a new database in phpmyadmin, I also get the same access denied error. From all that I have read so far, this leads me to believe that the password used to login to the MySQL server is incorrect from TCH's end, so phpmyadmin cannot login. This doesn't make total sense either (as I can see the databases created in cPanel), but I believe it is something to do with authentication and passwords. Any other ideas?

 

Edit: Incidentally, there is something else to consider. Is it actually possible to import a database made in MySQL 5 into MySQL 4? If this is not possible, then I think I might just consider creating a new database and forums and starting over from scratch.

 

MySQL 5 exports should be relatively compatible with MySQL 4.1, as long as any 5.0 specific stuff is removed. Similar with 4.1 -> 4.0, remove the charset info and it's good.

 

PHPMyAdmin in cPanel does not allow you to create databases, you have the use the simplistic form on the MySQL Account Maintenance page in cPanel. Same goes with DROP DATABASE statements.

[moose6589]

The corollary: why do they need to run MySQl 5?

MySQL 5 exports should be relatively compatible with MySQL 4.1, as long as any 5.0 specific stuff is removed. Similar with 4.1 -> 4.0, remove the charset info and it's good.

 

PHPMyAdmin in cPanel does not allow you to create databases, you have the use the simplistic form on the MySQL Account Maintenance page in cPanel. Same goes with DROP DATABASE statements.

 

According to http://news.zdnet.co.uk/software/applicati...39192964,00.htm, MySQL 5 was a rather important release with many fixes and features. It doesn't make any difference to me either way, but I always figured that TCH would try to use the most current versions of software.

 

As for the access denied error..I finally discovered the problem. One, apparently phpmyadmin was recognizing the 'comments' at the beginning of the backup as commands, so I took those out. I also took out the create database command in the beginning since it had already been created. Now, the import works! Thanks for the tips.

[stevevan]

It doesn't make any difference to me either way, but I always figured that TCH would try to use the most current versions of software.

TCH DOES use the most current STABLE versions of software...The most good for the most people. Personally, I'd rather have the rock-solid stability that is TCH's reputation than cutting edge technology that still is working out bugs.

Edited September 23, 2006 by stevevan

[telcor]

TCH DOES use the most current STABLE versions of software...The most good for the most people. Personally, I'd rather have the rock-solid stability that is TCH's reputation than cutting edge technology that still is working out bugs.

 

That's nice, except how does one define stable? If you visit mysql.com and try to download MySQL, you are directed to 5.0, since MySQL the company considers 5.0 to be stable and recommended, with 4.1 labeled as older and 5.1 as the new beta.

 

5.0 does offer many advantages, primarily because the database can actually support ANSI SQL Standards, in other words, MySQL 5.0 can almost make the claim of maintaining data integrity and offer proper support for real relational data sets.

 

Upgrading to 5.0 should not be rushed however as one needs to consider the effects upon customers data. Not a fun thing to do. At least 4.1 -> 5.0 should be smoother than 4.0 -> 4.1.