Navigation

    ML
    • Register
    • Login
    • Search
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    1. Home
    2. Tags
    3. database
    Log in to post

    • R

      Error After Firebird 2.5.9 Update
      IT Discussion • database firebird • • Romualadas  

      14
      1
      Votes
      14
      Posts
      297
      Views

      @Romualadas said in Error After Firebird 2.5.9 Update: @scottalanmiller Tried your link. Results: yum install /tmp/FirebirdSS-2.5.9.rpm Loaded plugins: fastestmirror Examining /tmp/FirebirdSS-2.5.9.rpm: FirebirdSS-2.5.9.27139-0.amd64 Cannot add package /tmp/FirebirdSS-2.5.9.rpm to transaction. Not a compatible architecture: amd64 Error: Nothing to do Server architecture: Kernel and CPU Linux 3.10.0-1062.18.1.el7.x86_64 on x86_64 Looks like their packages are bad at this point. You definitely have the right, matching architecture there. Seems that they are having a lot of problems these days. It's such a niche product, I'd be super wary of every using it in production or any software the depends on it. Using it as an option, sure, but requiring it I'd consider a non-starter. Absolutely no one supports it.
    • ERROR 1366 When Important MySQL Database for WordPress
      IT Discussion • wordpress database mysql mariadb sql rdbms • • scottalanmiller  

      2
      1
      Votes
      2
      Posts
      97
      Views

      M

      I've seen that a lot. When I import Drupal databases, I learnt to use its Backup and Migrate module instead, it works flawlessly. Downside is you need to do clean Drupal installation first, but that basically is just creating blank database and putting brick on enter key.
    • How to Rename a Column in SQLite Database
      IT Discussion • database sql sqlite sqlite3 • • scottalanmiller  

      10
      1
      Votes
      10
      Posts
      193
      Views

      @Pete-S said in How to Rename a Column in SQLite Database: There used to be a lot of databases like SQLite. Often called database engines. dBase was probably one of the first. Later Microsoft Jet engine (aka Microsoft Access) became popular when Visual Basic ruled the world. Basically it's a one user database. You can have more than one user but it's done by multiple users accessing the same database file. Or by having an application on top that accessing the file and shares it out. That thing can be called a "database management system" or any application, really. All databases use database engines. MySQL, for example, isn't a database. It's a database management system. It uses one or more database engines to talk to the files on disk. MyISAM and InnoDB are two database engine options for the MySQL platform. At the end of the day, all databases work like SQlite. You can easily build your own database management system that uses SQlite as the engine and it could work just like MySQL or Oracle or SQL Server. Those are all single users to a file, under the hood. They just have the "multi-access" management built into an extra layer, instead of letting an application handle it. But for most things, you only access a database from a single app anyway, so that extra layer is often unnecessary as it is redundant. Just adds overhead.
    • Intro to NoSQL from MangoCon 2019
      MangoCon • youtube scott alan miller database nosql mangocon 2019 nosql database • • scottalanmiller  

      3
      3
      Votes
      3
      Posts
      139
      Views

      @scottalanmiller I like your 53 mins intros, but that said you cover and reach all the important parts. I wonder what will be deep dive session how long will that video be.
    • UREs Strike InnoDB on MySQL
      IT Discussion • linux storage centos database mysql rdbms centos 6 relational database ure innodb • • scottalanmiller  

      9
      1
      Votes
      9
      Posts
      266
      Views

      @Obsolesce said in UREs Strike InnoDB on MySQL: @scottalanmiller said in UREs Strike InnoDB on MySQL: @Pete-S said in UREs Strike InnoDB on MySQL: Step one is to remove the drives and clone them with dd or recovery tool to a new drive. You could probably recover 99.9% of the data - if you want. As you can guess from all of their previous issues, they don't want to pay for any recovery, they just want it magically fixed for free. They don't own any storage onto which to clone it, either. Then what is the point of any of it? It appears to have zero value to the business. I said that to them.
    • SOLVED PATH Error with TimeScaleDB-Tune on Fedora 30
      IT Discussion • linux fedora database rdbms nosql fedora 30 postgresql timescaledb postgresql 11 • • scottalanmiller  

      15
      0
      Votes
      15
      Posts
      582
      Views

      @dafyre said in PATH Error with TimeScaleDB-Tune on Fedora 30: then why are you even using it? Capacity Planning, for example.
    • Zabbix on CentOS7 - MariaDB or PostgreSQL?
      IT Discussion • linux database mariadb monitoring linux server zabbix postgresql centos7 db • • wrx7m  

      7
      1
      Votes
      7
      Posts
      194
      Views

      I've done both. I tend to like MariaDB / MySQL better because that is what I'm more comfy with.
    • MariaDB Restore Needs Binary Mode for ASCII \0 Error
      IT Discussion • database mysql mariadb • • scottalanmiller  

      1
      0
      Votes
      1
      Posts
      221
      Views

      No one has replied

    • MySQL Database Corruption on InnoDB
      IT Discussion • linux centos database mysql centos 6 innodb • • scottalanmiller  

      3
      0
      Votes
      3
      Posts
      92
      Views

      So, easy fix, the ca_stag2 was a staging DB that was not needed and was not current. The whole thing appears to have corrupted. So I simply "moved" that entire directory to /tmp (just in case I had to put it back) and then MySQL could fire up.
    • G

      Performance Advantages to Splitting Applications from Databases
      IT Discussion • database • • gtech  

      12
      0
      Votes
      12
      Posts
      151
      Views

      @matteo-nunziati said in Performance Advantages to Splitting Applications from Databases: @gtech yeah the only reason is saturation of resources and scaling out. rdbs do not scale out easily while front ends do. And RDBMSs tend to scale better vertically (throwing more RAM and CPU in a box) while app servers tend to scale better horizontally (throwing more, smaller boxes at it.)
    • Database Server vs File Server: What's Different
      IT Discussion • server database file server database server • • scottalanmiller  

      6
      0
      Votes
      6
      Posts
      293
      Views

      @WrCombs said in Database Server vs File Server: What's Different: @scottalanmiller said in Database Server vs File Server: What's Different: @WrCombs said in Database Server vs File Server: What's Different: Is it possible for a File server to run a database server ? how would that be classified at that point ? No, conceptually that would not mean anything. A file server and a database server are discrete concepts. A single operating system can run neither, either, or both. But as servers themselves, they are discrete. I gotcha. It was one of those hypothetical questions What's messy is that technical file servers are a very, very specific form of database server. Because a file server presents a file system over a network. And a file system is a special case database. No one really thinks about this and absolutely no one will talk about file servers this way, but for understanding what is actually happening... file servers are special purpose database servers. And that is very easy to prove. So a file server is a database server, but a database server is not a file server. But file servers are so common, unique, and discrete, we treat them as totally different animals and no one considers the two to even be similar.
    • Microsoft SQL Server FILESTREAM – Giving a bit of structure to your unstructured data
      Starwind • database sql microsoft sql sqlserver • • Oksana  

      1
      2
      Votes
      1
      Posts
      71
      Views

      No one has replied

    • Setting Up a Standard MySQL or MariaDB Database for an Application
      IT Discussion • linux ubuntu centos fedora centos 7 how to database mysql mariadb system administration rhel 7 rdbms dba • • scottalanmiller  

      5
      3
      Votes
      5
      Posts
      351
      Views

      @black3dynamite said in Setting Up a Standard MySQL or MariaDB Database for an Application: @JaredBusch said in Setting Up a Standard MySQL or MariaDB Database for an Application: I like my approach to setting this up. Obviously, install MySQL/MariaDB first as noted above. Then do the following. This all needs done in the same SSH session, but otherwise things are simple. Choose once of these exports for your DB root password. The first one is for you to specify, the second generates a random one and echo's it back to you. # Specify your own password for MariaDB root user export DB_ROOT_PASS="somebigpasswordgoeshere" # Generate a random password for MariaDB root user export DB_ROOT_PASS="$(head /dev/urandom | tr -dc A-Za-z0-9 | head -c 30)" echo "This is your MariaDB root password: $DB_ROOT_PASS" Specify the application database name and application user name # Database user to use for application export DB_USER='yourusername' # Database name to use for application export DB_NAME='yourdatabasename' Generate or specify a random password for the database user # Specify your own password for the application's database user export DB_PASS="somebigpasswordgoeshere" # Generate a random password for the application's database user export DB_PASS="$(head /dev/urandom | tr -dc A-Za-z0-9 | head -c 30)" echo "This is your password for the application user: $DB_PASS" Then create the application database, use, and grant access. mysql -e "CREATE DATABASE $DB_NAME;" mysql -e "CREATE USER '$DB_USER'@'localhost' IDENTIFIED BY '$DB_PASS';" mysql -e "GRANT ALL ON $DB_NAME.* TO '$DB_USER'@'localhost';" mysql -e "FLUSH PRIVILEGES;" Finally, lock down the system without the interactive requirement of mysql_secure_installation # Secure MariaDB (this does what mysql_secure_installation performs without interaction) mysql -e "UPDATE mysql.user SET Password=PASSWORD('$DB_ROOT_PASS') WHERE User='root';" mysql -e "DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost', '127.0.0.1', '::1');" mysql -e "DELETE FROM mysql.user WHERE User='';" # Beginning on some version of MariaDB after Fedora 29 was released, the test DB is no longer there by defualt. mysql -e "DROP DATABASE test;" mysql -e "FLUSH PRIVILEGES;" Your approach makes it easier to use as part of a script. It also generates random passwords, which I prefer.
    • Make an osTicket Database Backup
      IT Discussion • backup database mysql mariadb rdbms osticket mysqldump • • scottalanmiller  

      8
      1
      Votes
      8
      Posts
      926
      Views

      @Dashrender said in Make an osTicket Database Backup: Total DB Admin noob here - so bare with me. Does this include the username/password setup for this DB? or does that need to be maintained separately? i.e. you have to rebuild from this backup - do you just create a brand new SQL user and grant them rights to this DB upon import, then use that new account to give access to the app? In typing out my question I kinda assume the answer is the second bit - you just create a new user and assign them rights. Correct. The user and the database are separate things.
    • J

      Slow MS SQL Queries between Windows 10 VMs and MS SQL 2014 on same host
      IT Discussion • windows 10 hyper-v database windows server 2016 sql rdbms ms sql server ms sql server 2016 • • JasGot  

      27
      2
      Votes
      27
      Posts
      448
      Views

      J

      @pmoncho said in Slow MS SQL Queries between Windows 10 VMs and MS SQL 2014 on same host: @JasGot said in Slow MS SQL Queries between Windows 10 VMs and MS SQL 2014 on same host: Winner Winner, Chicken Dinner. It was MDTC and Windows Firewall. (Which is frustrating, because the firewall is turned off for the domain!) Good job at troubleshooting. I'm wondering what led you down this path versus something related to Networking, hard drives or software drivers? Remembered it from several years ago with another SQL based application. Don't know what made me think of it at 1:30am. But I'm ok with it!
    • Installing MS SQL Server Express on CentOS
      IT Discussion • linux centos centos 7 how to rhel database guide ms sql server ms sql server 2017 linux ms sql server 2017 • • JaredBusch  

      13
      5
      Votes
      13
      Posts
      2604
      Views

      @Emad-R said in Installing MS SQL Server Express on CentOS: Et me guess it is much faster on Linux than on Windows server No idea, but it is one less Windows Server license needed. Also MS SQL Server Express works well for many tasks.
    • NoSQL for IT at MangoCon 2019 Topic
      MangoCon • scott alan miller mangocon database mongodb nosql mangocon 2019 redis scylladb dgraph dba cassandra • • scottalanmiller  

      1
      3
      Votes
      1
      Posts
      196
      Views

      No one has replied

    • J

      Free Veeam for DGraph Linux Restore
      IT Discussion • linux centos backup veeam database disaster recovery nosql dgraph clustered database veeam linux agent • • Jimmy9008  

      76
      2
      Votes
      76
      Posts
      724
      Views

      So, circling back. How is the backup project going?
    • Data Base Management
      IT Discussion • database management view dbfs • • WrCombs  

      49
      1
      Votes
      49
      Posts
      565
      Views

      P

      @dave_c said in Data Base Management: @Pete-S We were not sure they were dBase files. Even Oracle database uses .dbf extension for data files. I understand. You can't be sure until you try but usually you'll know if you're running Oracle because you'll have oracle listener and other services running as well as a completely different folder structure. When you find files that are dbf somewhere, they're usually dBase because you can make a small database inside an application just by importing some libraries. So dBase isn't something that has to be installed on the computer but Oracle is.
    • Looking for an alternative database to MS SQL to process a text file.
      IT Discussion • database mysql mariadb rdbms ms sql server • • magicmarker  

      33
      0
      Votes
      33
      Posts
      694
      Views

      @magicmarker Why dont they create one giant hazardous label to fit all the products, and make it generic as possible. Like this product contains hazardous chemicals. it is not like someone actual reads that small fine print. Another problem solved...
    • MongoDB Major Change to Licensing
      Developer Discussion • open source database licensing mongodb nosql • • scottalanmiller  

      78
      1
      Votes
      78
      Posts
      1606
      Views

      @StorageNinja said in MongoDB Major Change to Licensing: @scottalanmiller said in MongoDB Major Change to Licensing: if you are a SaaS vendor looking at building software that uses MongoDB somewhere, you'd better get a lawyer looking over this license and how it applies to you. This is becoming a bigger issue as the biggest SaaS vendors hide behind this clause more and more with incredibly proprietary forks. They offer very little to no actual core development or contribution and it goes against the previous method of GPL code getting funding. It annoys me, as the legal headaches of contributing internal only use code back will block some companies from using OSS, but I see it both ways. The startups who are doing a lot of the core housekeeping of NOSQL platforms are learning they can't find a business model. This is getting messier and messier. Partially because there are just too any vendors involved. What's amazing, though, is that a move like this took a customer who was very into MongoDB and using it in projects and was literally working with MongoDB's own hosted product and now looking to avoid it like the plague. So at least in this one case, they are likely losing hosted product from this. And gaining nothing. I imagine a lot of customers going through this same process.
    • Working with SQLite on Fedora from Command Line and GUI
      IT Discussion • linux fedora database fedora 28 relational database sqlite sqliteman • • scottalanmiller  

      2
      1
      Votes
      2
      Posts
      462
      Views

      If you want to exit the SQLite command line shell, the command is dot exit... .exit
    • How to back up your SQL Server databases to Azure without a hassle
      Starwind • azure database sql server sql microsoft sql azure backup • • Oksana  

      1
      1
      Votes
      1
      Posts
      273
      Views

      No one has replied

    • Ensure your database high availability with SQL Server AlwaysOn FCIs
      Starwind • vsan database high availability starwind vsan sql always-on • • Oksana  

      1
      1
      Votes
      1
      Posts
      337
      Views

      No one has replied

    • MongoDB Storage Engine Error Detected MMapV1 and wiredTiger
      IT Discussion • database mongodb nosql mongodb 3 mmapv1 wiredtiger • • scottalanmiller  

      3
      0
      Votes
      3
      Posts
      1575
      Views

      @jaredbusch said in MongoDB Storage Engine Error Detected MMapV1 and wiredTiger: @scottalanmiller okay, they totally fucked this up. Yeah, this is some weird stuff.
    • MS SQL Server Best Practice Guide on Scale HC3
      Scale Legion • scale scale hc3 database ms sql server • • scale  

      3
      8
      Votes
      3
      Posts
      649
      Views

      @jaredbusch said in MS SQL Server Best Practice Guide on Scale HC3: You actually get your SMB clients to plan ahead? /gasp! We try!
    • Deploy SQL Server 2016 Basic Availability Groups without Active Directory and ensure High Availability for your mission-critical databases
      Starwind • database high availability starwind blog sql server 2016 basic availability groups bags availability groups sql server always on always on availability groups mission-critical databases sql server 2016 standard edition • • Oksana  

      1
      1
      Votes
      1
      Posts
      463
      Views

      No one has replied

    • PostgreSQL 10.1 Released
      News • database phoronix rdbms postgresql relational database postgresql 10 postgresql 10.1 • • mlnews  

      1
      4
      Votes
      1
      Posts
      531
      Views

      No one has replied

    • Choose wisely: SQL Server Failover Cluster Instances vs. Basic Availability Groups
      Starwind • starwind database disaster recovery high availability sql server ha sql server 2016 mission-critical database basic availability groups failover cluster instances dr bags fci • • Oksana  

      2
      3
      Votes
      2
      Posts
      1944
      Views

      @oksana Still backups are needed
    • Deploy SQL Server 2016 Basic Availability Groups without Active Directory
      Starwind • active directory database sql server starwind blog ad failover cluster sql server 2016 mirroring basic availability groups availability groups database mirroring ag wsfc bag • • Oksana  

      1
      1
      Votes
      1
      Posts
      914
      Views

      No one has replied