Latest posts for the topic "Help moving Guestbook and Forum mySQL databases"

Help moving Guestbook and Forum mySQL databases

Anonymous — GMT

[color="indigo"]I just moved from one server to another and I need some help moving my databases. I did export them before I moved, and I have them saved as .sql files. I'm not having any luck uploading them now that the move has been complete using the PHPadmin section of my hosting CPanel.

Any suggestions or has someone done this before?

Thanks for all help.[/color]

Jam'n — GMT

Do you get an error?
Normally it should work.
The only problem could be that the file is to big and you will have to cut in parts and upload it in sessions

NHS — GMT

[color="indigo"]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.[/color]

Jam'n — GMT

You will need to make a database with the same name as you had before, choose it and then use the tab "SQL" to import the file

NHS — GMT

[color="indigo"]OK I did that... this is the error message I got.[/color]

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

[color="indigo"]Thank you for your help so far, what do I now?[/color]

Jam'n — GMT

Hi,

Did you make only a databe or did you also make the tables.
Because he say's

#1050 - Table 'book_auth' already exists

NHS — GMT

[color="indigo"]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.[/color]

[color="red"]----- Original Message -----
From:
To:
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[/color]

[color="indigo"]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![/color]

Jam'n — GMT

Did you configure “config.inc.php”?

[code] /* database settings */

$GB_DB["dbName"] = "";
$GB_DB["host"] = "localhost";
$GB_DB["user"] = "root";
$GB_DB["pass"] = ""; [/code]

These are your SQL settings

Because it says:

Error Number: 1045 Access denied for user: 'northern_agbook1@localhost' (Using password: YES)

So maybe you made an typo.

Did you configure “config.inc.php”

NHS — GMT

Where can I do this? Thanks!

Anonymous — GMT

you can find the file in the admin directory.