Want more timely Centmin Mod News Updates?
Become a Member

MariaDB Strange Error from MariaDB

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by leeooing, Oct 25, 2014.

  1. leeooing

    leeooing New Member

    4
    0
    1
    Oct 25, 2014
    Ratings:
    +0
    Local Time:
    11:07 AM
    1.7.3
    5.5
    Dear Everyone,
    I get some error about MariaDB, i tried to search but can not find it. Here i will explain my problem.
    I installed Centmin Mod v1.2.3-eva2000.07 on Vultr 4096 ram.
    1. i created user and database for website 1 run xenforo
    p/s: i worked perfecly
    2. then i created one more user and database for website 2 run xenforo ( move from old server )
    problem is

    some time when i open website 1 but i dont know why website 1 connected with database of web 2
    and opposite as well.
    and more
    if i can run website 1 and can not open website 2 opposite as well
    i really dont know why. Hope you guys can help me out

    Thanks

     
  2. eva2000

    eva2000 Administrator Staff Member

    54,546
    12,221
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,790
    Local Time:
    2:07 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    There's really no way that this could happen if you have 2 separate database names entered respectively in each xenforo config.php file and each web site has it's own Nginx vhost and own web root

    how did you create database user and database ? step 11 of getting started guide has outlined options
     
  3. leeooing

    leeooing New Member

    4
    0
    1
    Oct 25, 2014
    Ratings:
    +0
    Local Time:
    11:07 AM
    1.7.3
    5.5
    @eva2000 , i use command line to create database and user like

    MariaDB [(none)]>
    CREATE DATABASE mydatabase;
    CREATE USER 'mysqlusername'@'localhost' IDENTIFIED BY 'mysqluserpassword';
    GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, LOCK TABLES, CREATE TEMPORARY TABLES ON mydatabase.* TO 'mysqlusername'@'localhost'; FLUSH PRIVILEGES;
    after that i restore my old database to that one with command line
    mysqldump -u root -p mydatabase < /home/nginx/domains/mydomain.com/backup/admin_webold.mysql.sql

    Recently i create a new user and database try to restore again. but i always get this it doesnt load my old datbase
    -- MySQL dump 10.14 Distrib 5.5.40-MariaDB, for Linux (x86_64)
    --
    -- Host: localhost Database: webhostingtalk
    -- ------------------------------------------------------
    -- Server version 5.5.40-MariaDB

    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
    /*!40101 SET NAMES utf8 */;
    /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
    /*!40103 SET TIME_ZONE='+00:00' */;
    /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
    /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
    /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
    /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
    /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

    /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
    /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
    /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
    /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
    /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
    /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
    /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

    -- Dump completed on 2014-10-24 19:46:59
     
  4. eva2000

    eva2000 Administrator Staff Member

    54,546
    12,221
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,790
    Local Time:
    2:07 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    looks like the sql backup file is incomplete or not all data was backed up
     
  5. leeooing

    leeooing New Member

    4
    0
    1
    Oct 25, 2014
    Ratings:
    +0
    Local Time:
    11:07 AM
    1.7.3
    5.5
    Ok then i will try to backup with previous databases. Thanks