If you are not registered or logged in, you may still use these forums but with limited features. Show recent topics
  [Search] Search   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [FAQ]  FAQ 
[Register] Register / 
[Login] Login 
Export/Import ?  XML
Forum Index » Advanced Guestbook Forum
Author Message
ehardman
Newbie

Joined: 19/07/2006 07:34:22
Messages: 4
Offline

I posted this over on the support forum and didnt get any hits so maybe this is where it is suppose to be at, it is under Exporting/Importing subject.

Ok I probably screwed this up, but I want to update my guestbook to a newer version thru C-Panel but they changed something around and it didnt reconize that i already had one installed so it wouldnt do a upgrade. So I exported my database like the instruction above said. I deleted my old guestbook and reinstalled the new version. Now when I go back into my phpmyadmin I follow the directions as said above, but when i click on SQL all it shows is a text box, nothing to browse for a download????

So I chose import and get this message:

Error

SQL query:

-- phpMyAdmin SQL Dump
-- version 2.8.0.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 19, 2006 at 12:04 AM
-- Server version: 4.1.19
-- PHP Version: 4.4.2
--
-- Database: `dwoody_agbook1`
--
-- --------------------------------------------------------
--
-- Table structure for table `book_auth`
--
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` int( 11 ) NOT NULL default '0',
PRIMARY KEY ( `ID` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =2;

MySQL said: Documentation
#1050 - Table 'book_auth' already exists



Hope I didnt mess it up to bad.
ehardman
Newbie

Joined: 19/07/2006 07:34:22
Messages: 4
Offline

Man, I didnt realize I would stump everybody with this one. I usually have gotten help by now.
ehardman
Newbie

Joined: 19/07/2006 07:34:22
Messages: 4
Offline

Still cant figure this out???

Help!!!

Ernie
Carbonize
Master
[Avatar]

Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline

Open up the file and delete all the create table stuff. The error message is pretty self explanatory.

Carbonize
I am not the maker of the Advanced Guestbook

get Lazarus
[Email] [WWW] [Yahoo!] aim icon [MSN] [ICQ]
Auron
Expert
[Avatar]

Joined: 23/06/2003 22:02:17
Messages: 1053
Offline

*cough*

ehardman wrote:...MySQL said: Documentation
#1050 - Table 'book_auth' already exists...


*cough*


Visit my site @ www.ragnaru.com
Adv. Poll Install Guide NOW BACK ONLINE! (And also rather out of date I would of thought)
[Email] [WWW]
Carbonize
Master
[Avatar]

Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline

Mwuahahaha HE LIVES!!!!!!!!

Carbonize
I am not the maker of the Advanced Guestbook

get Lazarus
[Email] [WWW] [Yahoo!] aim icon [MSN] [ICQ]
Auron
Expert
[Avatar]

Joined: 23/06/2003 22:02:17
Messages: 1053
Offline

Carbonize wrote:Mwuahahaha HE LIVES!!!!!!!!


Indeed.

Who?

Visit my site @ www.ragnaru.com
Adv. Poll Install Guide NOW BACK ONLINE! (And also rather out of date I would of thought)
[Email] [WWW]
Carbonize
Master
[Avatar]

Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline

You ya moron.

Carbonize
I am not the maker of the Advanced Guestbook

get Lazarus
[Email] [WWW] [Yahoo!] aim icon [MSN] [ICQ]
Auron
Expert
[Avatar]

Joined: 23/06/2003 22:02:17
Messages: 1053
Offline

Carbonize wrote:You ya moron.


I see...

oi!

Visit my site @ www.ragnaru.com
Adv. Poll Install Guide NOW BACK ONLINE! (And also rather out of date I would of thought)
[Email] [WWW]
 
Forum Index » Advanced Guestbook Forum
Go to:   
Based on the open source JForum