Questions tagged [database]
The database tag has no usage guidance.
37
questions
0
votes
0answers
12 views
MariaDB cannot reset lost root password according to usual process
I'm preparing a local copy of MariaDB on OS X (already works fine with one local dev site) for a data dump and forgot my root password (stupid I know).
But the usual reset password fails like this:
$...
1
vote
0answers
68 views
Missing Messages from chat.db
Hi so I can't currently create a minimum reproducible example but I am missing texts that I know I sent and appear in the search on the iMessage app but aren't in chat.db
My python code below
import ...
5
votes
2answers
1k views
Is there a MariaDB server package for Macos?
My team is switching from MySQL (which has downloadable packages for MacOS) to MariaDB and I'd like to switch on my Mac as well.
When going to MariaDB's download page, I only see packages for Windows ...
0
votes
0answers
60 views
Converting .accdb to sqlite on a mac - open to using terminal or homebrew
How would you convert a Microsoft Access database .accdb to SQLite on a Mac? (High Sierra)
0
votes
0answers
190 views
AppleScript Database Events, SQL query
I'm discovering Database Events and I created a script to store data daily:
tell application "Database Events"
tell database "Stats"
set theRecord to make new record with properties {name:...
2
votes
0answers
27 views
Any solution for a DBMS App on iPhone?
I have been trying to find an application to create a database (preferably sqlite) And I would like to create relational databases and query, however, I haven’t found any on the App Store to enable me ...
14
votes
1answer
7k views
What and how does macOS Mojave implement to restrict applications access to personal data?
As well as many of the other features talked about during macOS Mojave's release like dark mode and the addition of new apps like Home, another key feature of macOS Mojave seems to be it's heightened ...
1
vote
0answers
316 views
Trouble Connecting to SQL Anywhere through ODBC
I'm trying to connect to a SQL Anywhere database through an an ODBC connection on my Mac (running High Sierra).
I downloaded and installed the SQL Anywhere 17 Developer edition. Installed it ...
2
votes
1answer
100 views
Upgrade path for CouchDB 1.x to 2.x on macOS?
I recently downloaded Apache CouchDB 2.1 installer for macOS from the official website. I already had CouchDB 1.7 installed via Homebrew Cask.
After installing CouchDB 2.1, I started observing some ...
2
votes
1answer
138 views
Console log is telling me that database is locked for many apps. How do I unlock?
I'm trying to diagnose a MacMini that is painfully slow to start up.
I already check the filesystem (fsck) and the disk (Disk Warrior).
I am running High Sierra.
My Mac is fine once it's up and ...
0
votes
2answers
284 views
How to Backup Apple Mail Gmail database to External Hard drive?
from quite some time I am using Apple Mail signed in with my Gmail Account. I have almost 20K emails and I need to clean up my Gmail account, make separate folders and categorize them. But before that,...
4
votes
1answer
470 views
Why are my Photos library database/metadata files being modified even when I'm not using the Photos app?
OS: MacOS 10.12.3 (16D32)
Hardware: MacBook Pro (13-inch, Mid 2012)
I currently use Dropbox to sync, among other things, my Photos library on my laptop*. The Dropbox widget notifies me when ...
0
votes
1answer
34 views
Application refused to start because of local storage
I am using application TopTracker on my MBP
My Mac have frozen and i have forced it to restart.
Unfortunatelly, when i'm trying to restart the App, i have this error :
Failed to read from local ...
0
votes
0answers
106 views
“Database” report writer for Numbers?
I serve on the Board of a Baroque Orchestra and have begun helping them get organized. The management of the orchestra does not have extensive technical skills so I've endeavored to help provide them ...
3
votes
1answer
277 views
How can I open a System 9 FileMaker document in OS X 10.9?
I need to print some FileMaker pages that I created in System 9 (MacOS 9). Is there any free OS X 10.9 software that will open those files?
1
vote
1answer
14k views
mysql: command not found [duplicate]
How do I use MySQL from the CLI? When I use the terminal, I get:
Darrens-MacBook-Pro:~ thufir$
Darrens-MacBook-Pro:~ thufir$ mysql
-bash: mysql: command not found
Darrens-MacBook-Pro:~ thufir$
As ...
1
vote
2answers
534 views
How do I install and run MySQL?
I installed MySQL:
but MySQL certainly isn't on the path when I open a terminal, nor do I see it in applications, as I seem to recall Windows handles MySQL.
0
votes
0answers
701 views
Create a local MS SQL Database on OSX Yosemite
I need to do some tests on a MS SQL (not MySQL) database. But without the burden of having to open a hosting account, create a remote database, connect to it, and remotely insert a million records.
I ...
1
vote
1answer
2k views
Using modified SMS database with iOS
I've been trying to remove a specific text from my iPhone's SMS database. The text is too long (tens of thousands of characters long, if not more) and is causing iOS to crash whenever I view the ...
0
votes
1answer
234 views
Outlook MEGA database
I am the administrator of 10-15 computers, most of them Macs. One iMac Intel Dual Core, 3 GB of RAM (more than 3 y old) is running Outlook 2011 as an email client.
The problem is the Mac becomes ...
1
vote
1answer
1k views
Create a Database Environment Mac OS/SQL Developer
Hi I am very new to all of this.
I am trying to prototype an function on my local machine. I am using SQLDeveloper and trying to understand what I would need to do to create a database locally. I'm ...
7
votes
4answers
5k views
Dates format in Message's chat.db
I'm working on improving my iMessages backup-script. /Users/Kyro/Library/Messages/chat.db has a table message with all the messages an some dates.
Any idea what's the date format ? I first thought ...
1
vote
0answers
1k views
Working on a MS Access file with ODBC connection on OSX
I need to open an accdb file on my MacBook Pro (OSX 10.8.5). This file uses an ODBC data source connection. So I guess my questions are:
How do I setup a new ODBC data source connection on a Mac?
...
0
votes
1answer
1k views
Database app, accessible from Mac, iPad and Web
I feel very out of my depth with this query, but not being able to do it isn't really an option so I am going to have to learn how one way or another.
I have been tasked with building an application /...
2
votes
3answers
2k views
Rebuild SystemUIServer's database
I'm not completely sure what happened, but in Console I get the following errors repeating endlessly every few minutes:
28/07/2013 12:32:10.009 SystemUIServer[304]: Unknown error finalizing or ...
0
votes
1answer
149 views
Index of files to backup
I'm looking for something similar to http://www.indexyourfiles.com/ for the mac.
What I want to do is create a backup of my file index which is portable and can be searched through even if you don't ...
0
votes
1answer
126 views
Work database with visual interface
I need a app that can help me work on a database with visual aid, I don't need it to be in a specific language, is only that I can see the workflow to better understand all the links between tables
0
votes
0answers
2k views
Outlook for Mac “Your database could not be rebuilt [-47]”
Recently, whenever I open Outlook, it tells me that my the database needs to be rebuilt. I attempted to and received an error the first time. I deleted the database file located in Documents/...
16
votes
10answers
89k views
Is there a good SQL Diagram Editor/Drawing Mac App Tool?
Does anyone know a comprehensive Mac app to create SQL Diagramms?
I think http://ondras.zarovi.cz/sql/demo/ is quite good, but it's a little bit too basic.
I would like to create the database schema, ...
2
votes
1answer
639 views
Is there a GUI viewer of databases created by Database Events?
I wrote a simple AppleScript that saves data to a Database Events database. I see the database (DBEV file) in my ~/Documents/Databases folder, and I am wondering if there is a simple graphical utility ...
1
vote
1answer
440 views
Where is “Contact” information stored within iOS4
I have a problem in iOS4.0.1 on my 3GS where not all contacts I have saved show up in the "Contacts" app or tab within "Phone". However, when I enter names in a new text message contact field, they ...
3
votes
3answers
9k views
How to stop xampp mysql server?
I just installed xampp on my mac os x. When I tried start mysql it displays a message that mysql is already running on this computer. In order to start mysql stop first mysql. I tried following ways ...
4
votes
1answer
191 views
Applescripting ODBC
Is it possible to interact with an ODBC connection within AppleScript? Or must one break out into another process (e.g. Python, Perl, etc)?
4
votes
3answers
4k views
What Database programs/tools are included with OS X?
Many years ago I believe Apple included a copy of Hypercard with it's OS. That's before my time, and I have never used it.
But, I do have occasional requirements for very simple databases. I am not ...
2
votes
5answers
2k views
iPad app for collecting door-to-door survey information?
I need to be able to develop a custom form so I can have workers go door to door and collect survey information. Think census workers, but geared towards the upcoming election.
While I could develop ...
5
votes
4answers
7k views
What Mac apps are capable of managing SQL Server databases?
I'm looking for a Mac app that has capabilities similar to Microsoft SQL Server Enterprise Manager.
The app should be capable of the following:
Create and administer SQL Server databases, objects, ...
14
votes
0answers
36k views
Is there a relational database with GUI for Mac similar to Microsoft Access or the like? [duplicate]
I need a desktop database that will have a need for extensive 1-many, many-1, and many to many relationships.
I've built this kind of app with Microsoft Access, which I don't love, but does combine ...
