Tag Info

New answers tagged

0

Well I'll answer myself: you can call the database whatever you want and select any username, but then don't forget to update the changes in appropriate files for each application you use with postgresql. For example for Metasploit: /usr/local/share/metasploit-framework/config/database.yml Still don't know where are the database connection data for Snort ...


0

You are missing a semicolon (;) after the query?


0

In the Ubuntu repositories there is an application called Converter of XBase / FoxPro tables to PostgreSQL (pgdbf). PgDBF converts XBase databases, particularly FoxPro tables with memo files, into a format that PostgreSQL can directly import. You would also need to install Object-relational SQL database (postgresql) from the Ubuntu Software Center. Ubuntu ...


0

If I was in your case I would create a new database and import all the data into it. Then debug the codes and see if the issue can be reproduced. Also a /decompile switch can help in the matter. All what you need is a backup, then open notepad and create a one line .bat/.cmd line with the following: "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" ...


0

Sorry, no. You can't even recover the database partially because it is not even recognized by Microsoft Access. Some options: You can try a third party software to attempt a recovery of the file Use a free software such as Recuva to recover the file that delete Use your old backup and reconstruct from there.


1

Performance is very much depend of the type of work load you want to do. Even for a database server, it very much depends on the query you do. Unfortunately Quad Core i7 doesn't mean very much, as there are several different generations of chips under the i7 branding. In general, I found the benchmark results on phoronix-test-suite informative in getting ...


0

2003 works well, but there are a few bugs in it which sometimes mess things up beyond repair. I'm not really sure of the error you suggest, but this might fix it: First I have found that frequent backups help greatly. Then when something goes wrong with a form I simply delete it (or rename it to " (bad)") and then recreate it by opening both the current ...


1

From MS's article "How to troubleshoot a Msg 823 error in SQL Server": The 823 error message usually indicates that there is a problem with underlying storage system or the hardware or a driver that is in the path of the I/O request. You can encounter this error when there are inconsistencies in the file system or if the database file is damaged. So ...


2

Your example with firstnames and lastnames is interesting. What does it add to the picture? What value does it have to put firstnames in a separate table? If you take all people with firstname "Marc", what do you have then? Does it mean anything? What if you take all people with lastname "Smith" - do they all belong to one family or clan or race or ...


1

In response to your yes or no question, yes. Some structures are better off denormalized to an appropriate degree. What's appropriate? It depends, of course. In your particular example, the answer proposed by AEonEX is correct not because of denormalization, but because these names are properly attributes of the entities they name. It can be appropriate ...


0

There is no need for tables firstnames and lastnames. Instead store the firstname and lastname in officers and prisoners instead of firstnames_id and lastnames_id. CREATE TABLE `encounters` ( `id` INT NOT NULL, `encounterdate` DATETIME NULL, `officers_id` INT NOT NULL, `prisoners_id` INT NOT NULL, PRIMARY KEY (`id`) ); CREATE TABLE `officers` ( ...


1

You would need to setup a second “host only adapter” within the VirtualBox host virtual machine configuration and on the CentOS guest virtual machine itself that would allow you to connect to your main host OS machine from the guest OS (CentOS) via the “router” address of that “host only adapter.” For example, in the instructions I posted here the main ...


0

I used a combo of EndNote (citation software where I could keep all notes on reading in a searchable/sortable way and automate all citation and bibliography) and Scrivener (database writing software that exports easily to word, where I could keep all composition, notes, and fieldnotes in a searchable, sortable way, and it works with EndNote).


0

If that file doesn't have any specified encoding, you might want to import it as such. If the target is a dedicated database, in case of PostgreSQL, you may create it without enforcing any encoding. As a SQL command: CREATE DATABASE dbname encoding 'SQL_ASCII' lc_collate= 'C' lc_ctype='C' template=template0; Tables created inside that database ...


0

I don't know anything about MAMP, but when I see that something else is using a port that I want to use, I can find out which process it is by doing netstat -napl | grep <portno> as root. This will list the process that is listening on that port. You can then use that information to figure out what is getting in the way.



Top 50 recent answers are included