• Uncategorized

random things

  • Uncategorized
Home » Posts tagged "database"

Tag: database

ORA-19502, ORA-27072 during RMAN restore (Oracle)

Uncategorized database, dev, oracle2010-01-12gheja 3 Comments

I was trying to load database from an RMAN backup (duplicate database until …), and the restore process died after some time, and gave me the following error messages (I have tried it several times, with different backups, these repeated randomly): ORA-19502: write error on file “/path/to/datafile.dbf”, blockno 1669073 (blocksize=8192) ORA-27072: File I/O error Linux

Read More

I have forgot the password of MySQL’s admin user – how to recover?

Uncategorized database, debian, dev, mysql2009-06-08gheja 0 Comments

If you have accidentaly locked out yourself, or just forgot your password for the admin (root) user of the MySQL, here is a quick-and-dirty solution. First you have to shut down the MySQL server, next you need to start it in safe mode with no priviliges table loaded, update the password to a new one,

Read More

How to repair an SQLite database

Uncategorized database, dev, sqlite2009-03-27gheja 22 Comments

Today I have faced with a crashed SQLite database. Actually, I am not totally sure it was crashed, but the sqlite process had not shut down properly, and (after this) to select anything from it has taken more than an hour, anyway it was damn slow, and has eaten a lot of CPU time, and

Read More

Recent Posts

  • Swap the Subject and description line in Roundcube Webmail mail list
  • Using ssh-rsa public key on Ubuntu 22.04 – no mutual signature algorithm
  • “Operation not supported” – extended attributes, getfattr, setfattr
  • Repairing a broken mp4 video using untrunc – “moov atom not found”
  • systemd-tty-ask hangs

Recent Comments

  • Chris on How to repair an SQLite database
  • Mark dc on How to repair an SQLite database
  • Kimberly on How to repair an SQLite database
  • John Walker on How to repair an SQLite database
  • Jimmy McCrillis on How to repair an SQLite database

Archives

  • April 2025
  • November 2023
  • January 2023
  • April 2022
  • February 2018
  • August 2015
  • July 2015
  • May 2015
  • December 2014
  • July 2013
  • February 2013
  • January 2013
  • December 2012
  • August 2012
  • July 2012
  • May 2012
  • December 2011
  • March 2011
  • November 2010
  • August 2010
  • April 2010
  • February 2010
  • January 2010
  • December 2009
  • October 2009
  • June 2009
  • May 2009
  • April 2009
  • March 2009

Categories

  • Uncategorized

Meta

  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org
Simple East Blog Theme By NavThemes.com
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.Accept Read More
Privacy & Cookies Policy

Necessary Always Enabled