Hello,

I have just tried to Export and then Import the sql file with phpMyAdmin and received the message below after trying to import the database :

Error

SQL query:

-- Table structure for table `oc_t_admin`
--

CREATE TABLE `oc_t_admin` (
  `pk_i_id` int(10) UNSIGNED NOT NULL,
  `s_name` varchar(100) NOT NULL,
  `s_username` varchar(40) NOT NULL,
  `s_password` char(60) NOT NULL,
  `s_email` varchar(100) DEFAULT NULL,
  `s_secret` varchar(40) DEFAULT NULL,
  `b_moderator` tinyint(1) NOT NULL DEFAULT 0,
  `s_moderator_access` varchar(1000) DEFAULT NULL,
  `i_login_fails` int(3) DEFAULT 0,
  `dt_login_fail_date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
MySQL said: Documentation

#1050 - Table 'oc_t_admin' already exists


------------------------------------------------------------------------------------------
Also trying to import data from Osclass tools, received the following message:

"There was a problem importing data to the database"



Please what could be wrong?

Thank you ...

You have reason in message:

#1050 - Table 'oc_t_admin' already exists

If you export and want to import, make sure that database where you want to import is empty, or at least no tables on that prefix.