26
votes
Setup a Docker container to work with a local database
There are three ways:
Use the --net=host option. This network mode essentially means that the container has direct access to localhost and you can now access localhost:3306. Here's the command
...
- 554
24
votes
How to export mysql schema from phpmyadmin?
Select your database or table.
Select the Export tab.
Below Export method, select Custom.
Below Tables, check the appropriate Structure boxes.
Here's a screenshot:
- 339
10
votes
Accepted
What embedded database format is used by this Chrome extension?
It’s LevelDB, a key-value store.
You can use NodeJS and levelup to access the data:
var levelup = require("levelup");
var db = levelup("path/to/directory");
db.createReadStream().on("data", data =&...
- 59k
8
votes
Where can I find H2 JDBC driver?
Any downloaded .jar file in the Jar File section on Downloads page is the JDBC driver itself, e.g.: h2-1.4.188.jar
- 181
7
votes
Accepted
Where does the Lazarus Chrome extension store its database?
The Lazarus website can be found in the wayback machine, and the FAQ says the database is an SQLite database in one of the following directories:
Windows 7: C:\Users\{username}\AppData\Local\Google\...
- 273
7
votes
Accepted
Find out database type from files
You could open that file with some binary/hex editor, and than try to investigate wich DB type is it. Google litle bit around, start with list of file signature, and than see some more specific ...
- 96
7
votes
Accepted
Creating a SQL Server Compact Edition database file in Microsoft Visual Studio 2017
Creating a SQL Server Compact Edition database file in Microsoft Visual Studio 2017
Microsoft is dropping support for SDF files with Visual Studio
It appears Microsoft deprecated SQL Server Compact ...
6
votes
"FATAL: lock file "postmaster.pid" already exists"
HARD REBOOT INSTRUCTIONS
I had this same issue after a hard reboot. After checking the postmaster.pid file's pid, I noticed I had no process running. I didn't want to hard delete the .pid file, ...
- 61
6
votes
Excel: How to connect to a sqlserver localDB
What a gratuitous P.I.T.A !
I was able to make it work by using the "Data Connection Wizard" following these steps....
Select "Other/Advanced" from Data connection Wizard, then hit "next". I thought ...
- 953
5
votes
How do I repair a corrupted Firefox places.sqlite database?
This process described on MDN helped me resolve an issue where new pages I visited were not recorded in browser history. I did not have a places.sqlite.corrupt (or places.sqlite-corrupt) file, but ...
- 238
5
votes
Accepted
How to calculate number of possible records in Redis per 32GB of memory?
Assuming that you have 32GB of Memory allocated to Redis and other memory available to your system resources, you can calculate the number of entries you can store. However, keep in mind that this is ...
- 14.8k
5
votes
Accepted
ODBC Data Source Driver 'Does Not Exist' After Updating to Windows 10
It is likely that I uninstalled the MS database drivers when I uninstalled the older version of Office (and not related to the recent Windows update) and the new one must not come with the drivers as ...
- 191
5
votes
#126 - Incorrect key file for table '.\mysql\db.MYI'; try to repair it
Exactly the same happened to me, I tried the following query and it worked:
USE mysql;
CHECK TABLE db;
If it returns db is corrupt, then repair it using
REPAIR TABLE db;
CHECK TABLE db;
You should ...
- 51
5
votes
InfluxDB failed to start as a service
I found the problem:
[dadmin@localhost dashboard]$ sudo tail /var/log/messages
May 11 16:21:41 localhost influxd: [I] 2017-05-11T14:21:41Z Using data dir: /dashboard/influxdb/data service=store
May ...
- 121
5
votes
Accepted
Database server for web browser
I am assuming they must have a database server the same way a web application has a database server.
What is the basis for that assumption? Web browsers and web applications are different things and ...
- 416k
4
votes
Accepted
How to remove or fix the date stamps of specific messages in Skype?
Based on the article
Editing Skype history / messages / database,
use this procedure :
Download SQLite Database Browser
While Skype is closed, open its database at
C:\Users\<Windows-user-name>\...
- 446k
4
votes
How to read key3.db and logins.json in plain-text?
What I did on Linux:
Grab nss source package for your distro.
Unpack, patch and configure.
Go to nss/cmd/pwdecrypt subdirectory
Build pwdecrypt tool.
I used the following command line to build the ...
- 1,133
4
votes
Accepted
Is the format/schema of the Apple Music “Library.musicdb” used in macOS Catalina documented anywhere?
There's a framework called iTunesLibrary that can read Music.app's database - just tested this on macOS Catalina - but it's an Objective-C one.
You may be able to use it via PyObjC, but it will only ...
- 156
4
votes
Accepted
How to drop a table using mouse and context menu or main menu on DBeaver?
The delete functionality is hidden by default, but it is there when using the Advanced connection view.
You can enter the view by right clicking on the connection you're using and changing Connection ...
4
votes
Turn .sql file into a table
This is a MySQL dump file. You can run it against a MySQL or MariaDB database. Both applications are available for the Mac.
Install either MySQL or MariaDB.
If you are familiar with the terminal, you ...
- 151
3
votes
What happened to WinFS?
Hal Berenson, the General Manager of what would become WinFS wrote an excellent four-part blog series after Bill Gates disclosed in 2013 that his biggest regret from his time at Microsoft was the ...
3
votes
Accepted
Split data in half evenly by adding column with value: 1 or 2 based on specific cell value - excel
Set D1 to 1, set D2 to
=IF(A1=A2, D1, 3-D1)
and drag/fill down. This says:
if the StudentID on the previous row equals the StudentID on the current row,
then this is a secondary row for this ...
- 21.3k
3
votes
Remote copy of LMDB
You could try using rsync to do the copy. It says it deals with sparse files. Something like
rsync --rsh=ssh --archive --sparse lmdb user@remotehost:~/lmdb_copy
As an aside, and some insight into ...
- 216
3
votes
What embedded database format is used by this Chrome extension?
The files are in LevelDB format developed by Google and the code is hosted on GitHub.
Potentially you can use leveldb-json utility to export the data by pointing to the .indexeddb.leveldb folder, ...
- 24.3k
3
votes
SQL : Restrict view of tables in database
Yes you can, like this:
GRANT [Permission] ON [SchemaName].[TableName] to [UserName]
Where [Permission] is SELECT, UPDATE, DELETE, or INSERT. You can also use DENY instead of GRANT to take ...
- 4,443
3
votes
Excel: How to create multiple records from a single record
This will suffice for your example. You will need to modify a bit to match the real database.
Example Data
Company | Address | City | State | ZIP | Phone | GM | EmailGM | PD | EmailPD | SM | ...
- 1,704
3
votes
How to read key3.db and logins.json in plain-text?
To list the Firefox or Thunderbird logins with passwords, you can use this firepwd Python script.
To install it on a Debian/Ubuntu system:
wget https://github.com/lclevy/firepwd/archive/master.zip
...
- 3,346
3
votes
Setup a Docker container to work with a local database
As of Docker v18.03+ you can use the host.docker.internal hostname to connect to your Docker host.
This is for development purpose and will not work in a production
environment outside of Docker ...
3
votes
Accepted
Link to Skyward Database to MS SQL Server
Confirm you have access to authenticate
Based on your screen shot showing the use of Integrated Authentication and it failing, you will want to confirm the account which you are signed on as and ...
Only top scored, non community-wiki answers of a minimum length are eligible