Messages posted by: NHS

Where can I do this?

Thanks!

When I moved to my new host, I had set up the guestbook in the control panel, thinking I could just upload the database and it would overwrite the current database information.

I went back, deleted the guestbook through Cpanel, then went and ONLY set up the database through mySQL and then tried to upload the guestbook.

It worked! Now however, when someone clicks on my guestbook link, I get this email.

----- Original Message -----
From: <northern_agbook1@localhost>
To: <admin@northernhorsesource.com>
Sent: Saturday, April 24, 2004 10:29 AM
Subject: Guestbook - Error

MySQL Error : Connection Error
Error Number: 1045 Access denied for user: 'northern_agbook1@localhost' (Using password: YES)
Date : Sat, April 24, 2004 14:29:25
IP : 65.110.40.170
Browser :
Referer :
PHP Version : 4.3.5
OS : Linux
Server : Apache/1.3.29 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.3.5 FrontPage/5.0.2.2634 mod_ssl/2.8.16 OpenSSL/0.9.7a
Server Name : www.northernhorsesource.com

So any more suggestions about what I can do? I really appreciate all your help as this is all so new to me, I'm still learning!

OK I did that... this is the error message I got.

Error

SQL-query :

CREATE TABLE `book_auth` (

`ID` smallint( 5 ) NOT NULL AUTO_INCREMENT ,
`username` varchar( 60 ) NOT NULL default '',
`password` varchar( 60 ) NOT NULL default '',
`session` varchar( 32 ) NOT NULL default '',
`LAST_VISIT` timestamp( 14 ) NOT NULL ,
PRIMARY KEY ( `ID` )
) TYPE = MYISAM AUTO_INCREMENT =2

MySQL said:

#1050 - Table 'book_auth' already exists

Thank you for your help so far, what do I now?

No as I haven't even gotten that far. I'm trying to find where I can or should import the database so I can set up my Guestbook and my Forum from the old site. I used PHPadmin to export it, and I can't find where to import it now in PHPadmin.

Thank you for any help you can offer.