2014-01-08, 05:04 PM
Our forum has been down for quite some time. Unfortunately our club's resident PHP guru is no longer available.
I'm trying to import an SQL backup file and I'm getting the following:
----------------------------------------------------------------------------
SQL query:
-- MyBB Database Backup
-- Generated: 12th February 2013 at 23:32
-- -------------------------------------
CREATE TABLE
KEY
) ENGINE = MYISAM DEFAULT CHARSET = utf8;
MySQL said: Documentation
#1050 - Table 'mybb_adminlog' already exists
------------------------------------------------------------------------------------
I'm following instructions for myphp for backing up and restoring the SQL database doing an "import'.
My ISP says the database is empty but I can see all the data is there with my FTP client. Really don't know what I'm doing ..
The problem is that we can't log in to the forum at all and just get a blank page ( no errors etc, just a white screen)
Here is something someone posted several months back trying to help.
Login to your cPanel.
Fire up PhpMyAdmin
Navigate inside your database (by choosing from the left column).
Drop all the available tables.
Click Import (at the top).
Choose your old database file and upload.
It will rebuild all the tables as per your old database.
What is meant by the 4th line "Drop all the available tables" ?? how do I do that?
Thanks ..
I'm trying to import an SQL backup file and I'm getting the following:
----------------------------------------------------------------------------
SQL query:
-- MyBB Database Backup
-- Generated: 12th February 2013 at 23:32
-- -------------------------------------
CREATE TABLE
mybb_adminlog
(uid
INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',ipaddress
VARCHAR( 50 ) NOT NULL DEFAULT '',dateline
BIGINT( 30 ) NOT NULL DEFAULT '0',module
VARCHAR( 50 ) NOT NULL DEFAULT '',action
VARCHAR( 50 ) NOT NULL DEFAULT '',data
TEXT NOT NULL ,KEY
module
( module
, action
)) ENGINE = MYISAM DEFAULT CHARSET = utf8;
MySQL said: Documentation
#1050 - Table 'mybb_adminlog' already exists
------------------------------------------------------------------------------------
I'm following instructions for myphp for backing up and restoring the SQL database doing an "import'.
My ISP says the database is empty but I can see all the data is there with my FTP client. Really don't know what I'm doing ..

The problem is that we can't log in to the forum at all and just get a blank page ( no errors etc, just a white screen)
Here is something someone posted several months back trying to help.
Login to your cPanel.
Fire up PhpMyAdmin
Navigate inside your database (by choosing from the left column).
Drop all the available tables.
Click Import (at the top).
Choose your old database file and upload.
It will rebuild all the tables as per your old database.
What is meant by the 4th line "Drop all the available tables" ?? how do I do that?
Thanks ..