I have some big sqlite3 databases in ~/.mozilla/firefox/profilename Notably places.sqlite (12 MB) and urlclassifier3.sqlite (33 MB). Is it possible to truncate them and wipe out the oldest records in them? Of course I could just wipe them completely, but that's not my goal - I just want to minimize the size of those files while keeping the newest records.
View 2 RepliesI am using SQLite as my database for some portable cross platform applications I am working on with REALBasic as my IDE. I have an old Sybase 8.0 database that I can access via Microsoft Access and thereby extract the data I need from each table.
Now I know I can create .csv files from each table and load them into SQLite using the import tool, but then I can't define the primary key and other field attributes. So the other option is to load each file via SQL.
Now with most SQL editors I can create multiple queries and they will run just fine. But I can't seem to do that with the SQLite interfaces. I can paste multiple queries but I can only run one at a time. And by that I mean I have to click run.
Ummm that's not acceptable since my biggest table contains over 600,000 records. I have the queries all written, that was easy using a simple interface I wrote in Access.
Code:
INSERT INTO tblMeters(recordId,meterId,meterName,meterSerNum,registerSerNum,mxuSerNum,meterType,manufacture,meterModel,readType,groupId,multiplier,rollover,vendorId,xfrmerCode,bldgCode,CATEGORY,energyType,unitOfMeasure,location,access,comments,dateInstalled,dateCalibrate,pipeSizeIn,pipeSizeOut,elecMeterSpecs)
[Code]...
So is there another method I can use? I can't seem to find anything relating to my particular question at the SQLite web site
Unable to delete dupliucate DNS records using bcupdate tool
View 1 Replies View RelatedI know BIND has rndc. Does windows have a utility that allows remote editing of records on MS DNS server FROM LINUX? I've looked at wbem a little but, have not confirmed if it allows adding/editing DNS records.
What about DHCP leases, etc?
I had a major foul-up a couple of days ago, and I now have thousands of bug reports in the abrt applet. I'm trying to delete them individually, but it's taking forever. Is there a way to mass delete these reports to clean things up? I looked at abrt-cli and it has a --delete command, but only does them one at a time, too.
View 2 Replies View Relatedjust when you login in gmail, you click to enter your username and it lists the emails that recently loggedin in this computer, how dyou take it out so computer won't remember it?
View 1 Replies View RelatedMy /var/database/ directory is filled..!
Is there any way to redirect some databases to another directory .
I just found that PMON and SMON are running (i.e., showing in the output of ps -ef | grep -i [o]ra)but when I check MMAN (used for internal database tasks), nothing comes up:
Code:
ps -ef | grep -i [m]man
Is that okay or could there be some problem?
So, what are the essential processes of an Oracle Databse that we must check for their status to make sure that the Oracle Databse is up and running fine? What steps do you usually take to validate an Oracle Databse on a Unix / Linux (Production) Server (specifically immediately after a CR has been worked upon)?
Once upon a time when I started sqlite from the command line I could using the tabbing autocomplete to enter the database name. This has not worked for a while now.
View 1 Replies View RelatedThis query is giving "Unable to open data base" can anybody suggest what's wrong with this query.
sudo echo "SELECT datetime(moz_historyvisits.visit_date/1000000,'unixepoch'), moz_places.url
FROM moz_places, moz_historyvisits
WHERE moz_places.id = moz_historyvisits.place_id;" | sqlite3 moz_places.sqlite, moz_historyvisits.sqlite
Starting mysqld daemon with databases from /var/lib/mysqli m installed mysql-5.0.77-4.el5_5.4
[root@serv ~]# mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[root@serv ~]# /etc/init.d/mysqld stop
[code]....
Input file (already sorted on the key field):
204 Daniel Barton
206 Mary Halston
206 David Coleman
206 Carson Coleman
207 Roland Highsmith
207 Annie Highsmith
209 Connie Ward
Desired output file:
204 Daniel Barton
206 Mary Halston David Coleman Carson Coleman
207 Roland Highsmith Annie Highsmith
209 Connie Ward
I'm using Net::Bluetooth to create an RFCOMM socket on my Linux box. I need for it to register with SDP with a specific UUID. The perl code can be viewed in this link. I am unable to make the connection from a remote device however. This remote device (my Android phone) is able to connect to other RFCOMM devices using this UUID. I would like to troubleshoot the problem, but I can't find a way to browse the LOCAL SDP records of my PC where the Perl script is running (and waiting for incoming BT connections). how to browse the SDP records on the local PC?
View 1 Replies View RelatedI am using awstat for a website. It's working fine. On the webserver I made a new virtual host for the same website with some addition in URL. I made a separate log file for this URL and tried to process it also in awstat but for it's log file awstat is dropping all records.
On webserver log format is same for both logs files. On awstat the config file is same for both logs except the log path line of course .Why awstat isn't able to process the same log format with the same config file what is working for the previous logs
I am having a log file where there is some discontinuous of dates are there but if i go for range of date to find the records, if is some date is missing the result is displaying full file list( Start date to end of file ) How could i restrict the result upto the mentioned date range.
Code:
$cat sample.log
Jan 03 -error yyyy-1234
[code]...
Relational databases usually have their data over in /var/lib/something. Users are in /home (with data in /var/www). How can I apply a single total disk space quota across all of these independent software systems (file systems, RDBMS, etc.)?
P.S. There's a bet going on around me as to just how awesome SU is. Let's see what you've got.
I have been asked to write a program to extract the width and height values from .gif, .jpg and .png files. For .gif I was able to find the values in the header records, but it is not so straight forward for the other two formats.
Does anyone know if there is a Linux utility that will do this for me?
there is a tool, which can check and compare DNS records for me. I'd like to tell it to look at our private subnet, and it for to return records which have missing or different DNS records, than were expected. if it just looked up every record and returned it in a "neat" way, that'd work too.
View 5 Replies View RelatedI have a database (Mysql) with records of our club members. It is quite small only about 300 records. Unfortunately there are gaps in the information and I would like to be able to print out (two records to an A4 sheet) the records in form format so that I can pass these to the members who will fill in any blanks in the record.
If it is not possible to do what I want from the database I can convert the records to a spreadsheet and do it from there.
I'm trying to manipulate a large text file full of records (metadata - one complete record per line). I need to delete every line on which certain words appear - there are five different words, all pretty simple all-caps strings with occasional whitespace. I tried using grep -v, which worked a treat, but only string-by-string. Ideally I'd like to run this as grep -v -f, where the file targeted by the -f contains the strings I need to match in order to delete the lines they're in.
i.e. grep -v -f filecontainingSTRINGS.txt targetfile.txt > outputfile.txt
When I try this, however, I don't get any matches - or more specifically, no changes are made in the output file. It works fine if there's only one string in filecontainingSTRINGS, but it doesn't work if there's more than one (I'm using newline as the delimiter). (Also my machine doesn't recognise /usr/xpg4/bin/grep - no idea what that's all about!)
I have a folder on my desktop that I'm trying to delete but get error message:"Cannot delete firefox-gnome-support_3.5.3+build1+nobinonly_Oubuntu6_amd64,; Cannot find the specified file."Drilling down in the folder there are the following file names:
Top level: Pool
Second level:Main
Third level:f
Fourth level:firefox-3.5
Last level:firefox-gnome-support_3.5.3+build+nobinonly_
Oubuntu6_amd64.I do not use Ubuntu, So how do I get rid of this file?
I want Firefox to delete history after several days. Can I configure it this way?"Remember my browser history for at least..." is not the option which does it, right?
View 11 Replies View RelatedDon't even know where this error comes from, or why, but as the title says - bookmarks are in total lockdown. no error messagessimply no change when I add or delete or move bookmarks.
View 1 Replies View RelatedHow do I empty the cache in Firefox? All I can figure out how to do is delete cookies.
View 3 Replies View RelatedSometimes a site gets a new URL, or simply is discontinued.
I notice this when opening a bookmark of mine.
So I wonder if there is a way to delete the corresponding bookmark entry? Without having to go to bookmark manager?
I am thinking of a pressing a button that does:
Delete any and all bookmarks to this domain.
I have window 7, Ubuntu and Cent Os installed in my system. I was actually trying to change boots options but unfortunatly i lost all boot entries. Is there anyway i can recover all three boot records.
View 7 Replies View RelatedI am trying to install sqlite-python package in my FC11 machine. I couldn't find an rpm to install.
View 2 Replies View RelatedI'm having a bit of trouble with a web server running Fedora 12. Apache works fine, and serves up php content without a hitch. My problem is SQLite -- I thought that it was built into php5, but support is disabled in the repo version. phpinfo shows this as part of the configure command:
Code:
'--without-sqlite' ... '--disable-pdo' ... '--without-sqlite3'
The only solution I've read anywhere is "compile php from source," but I'd like to avoid that if possible, for ease of future upgrades. Is there a way to convince php to use sqlite despite its current state?
Is there a binary available somewhere, even if it's a non-Fedora repo?
View 8 Replies View RelatedBased on Product highlights - openSUSE, it would appear that using sqlite3 in gnucash would be available. However, I do not have an option to save an existing book to the database format, nor is it available when creating a new book - only xml is available. Is there anything special that I need to do to enable the sqlite backend?
View 2 Replies View Related