MySQL Import Help!
12-08-2014, 08:19 AM
(This post was last modified: 12-08-2014, 08:23 AM by dracodennis.)
Hello I was recently running Sentora on CentOS7, but had to downgrade to CentOS 6.6 due to a bug where CentOS7 was breaking bootstrap applications. So I backed up my MySQL databases and the web files, Sentora would not let me back up through the Backup manager, kept getting the "Forbidden" error, but now I am running into the issue of:
Any Ideas would be greatly appritiated.
Thank You,
Dennis
Code:
Error
SQL query:
--
-- Database: `sentora_core`
--
-- --------------------------------------------------------
--
-- Table structure for table `x_accounts`
--
CREATE TABLE IF NOT EXISTS `x_accounts` (
`ac_id_pk` INT( 6 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`ac_user_vc` VARCHAR( 50 ) DEFAULT NULL ,
`ac_pass_vc` VARCHAR( 200 ) DEFAULT NULL ,
`ac_email_vc` VARCHAR( 250 ) DEFAULT NULL ,
`ac_reseller_fk` INT( 6 ) DEFAULT NULL ,
`ac_package_fk` INT( 6 ) DEFAULT NULL ,
`ac_group_fk` INT( 6 ) DEFAULT NULL ,
`ac_usertheme_vc` VARCHAR( 45 ) DEFAULT NULL ,
`ac_usercss_vc` VARCHAR( 45 ) DEFAULT NULL ,
`ac_enabled_in` INT( 1 ) DEFAULT '1',
`ac_lastlogon_ts` INT( 30 ) DEFAULT NULL ,
`ac_notice_tx` TEXT,
`ac_resethash_tx` TEXT,
`ac_passsalt_vc` VARCHAR( 22 ) DEFAULT NULL ,
`ac_catorder_vc` VARCHAR( 255 ) DEFAULT NULL ,
`ac_created_ts` INT( 30 ) DEFAULT NULL ,
`ac_deleted_ts` INT( 30 ) DEFAULT NULL ,
PRIMARY KEY ( `ac_id_pk` )
) ENGINE = INNODB DEFAULT CHARSET = latin1 AUTO_INCREMENT =3;
MySQL said: Documentation
Cron to make backups - No database selected
Any Ideas would be greatly appritiated.
Thank You,
Dennis