moose6589

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.

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.

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

Thanks for the clear instructions! Everything's working fine now.

Hi, I am currently using Coppermine for my image gallery, and right now I'm trying to install a hack that will allow me to sort pictures by the date the picture was taken on rather than on the upload date. The hack itself can be found at http://coppermine.sourceforge.net/board/in...hp?topic=9360.0 However, the first step of the hack is really confusing me. It says to alter the picture table and add a ptime after ctime that is an int. Then, there is a box of code...but then it doesn't look a lot like code in a way. >ALTER TABLE `{$CONFIG['TABLE_PICTURES']}` ADD `ptime` INT NOT NULL AFTER `ctime`; I tried to go into phpMyAdmin to change things. I have found the ctime value under the properties of the picture table cpg132_pictures. So, how do I add a ptime under it? What am I supposed to do? I am utterly confused by phpMyAdmin and this person's instructions. Thanks for reading.

Thanks, that really helped! I opened up port 2082 after a bit of exploring in Zonealarm, and now everything works just fine.

Hi, This is my first time setting up a website, and so far, everything seems to be great! However, I've found that Zonealarm is blocking the port necessary to run CPanel, so I cannot access CPanel while Zonealarm is on. I've tried adding my website to the list of trusted sites, but that hasn't done anything. Once I shutdown Zonealarm, everything works fine. Does anyone know how to unblock the port in Zonealarm? Thanks! -Richard