This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm whether you accept or reject these cookies being set.

A cookie will be stored in your browser regardless of choice to prevent you being asked this question again. You will be able to change your cookie settings at any time using the link in the footer.

MySQL Import Help!
#1
MySQL Import Help!
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:

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
Reply
Thanks given by:
#2
RE: MySQL Import Help!
add

use sentora_core

to the SQL.

M B
No support using PM (Auto adding to IGNORE list!), use the forum. 
How to ask
Freelance AWS Certified Architect & SysOps// DevOps

10$ free to start your VPS
Reply
Thanks given by:


Possibly Related Threads…
Thread Author Replies Views Last Post
import data error nguoiveday 1 3 ,205 10-24-2021, 07:23 AM
Last Post: TGates
Import zpanel settings problem pgh2011 0 2 ,235 12-30-2020, 07:08 PM
Last Post: pgh2011
MySQL Database user prefix MosleyCale 1 4 ,865 10-17-2020, 09:11 PM
Last Post: Ron-e

Forum Jump:


Users browsing this thread: 1 Guest(s)