Author |
Message |
19/07/2006 21:55:27
|
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.
|
|
29/07/2006 06:25:02
|
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.
|
|
23/08/2006 20:08:05
|
ehardman
Newbie
Joined: 19/07/2006 07:34:22
Messages: 4
Offline
|
Still cant figure this out???
Help!!!
Ernie
|
|
23/08/2006 22:35:42
|
Carbonize
Master
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 |
|
23/08/2006 23:05:18
|
Auron
Expert
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) |
|
23/08/2006 23:21:08
|
Carbonize
Master
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 |
|
24/08/2006 00:20:37
|
Auron
Expert
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) |
|
24/08/2006 07:35:36
|
Carbonize
Master
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 |
|
24/08/2006 12:24:36
|
Auron
Expert
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) |
|
|