Messages posted by: ehardman

Still cant figure this out???

Help!!!

Ernie

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

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.

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 test 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.