Skip to content

{ problem: 'solved' }

Let's talk tech and solve problems ..

  • Home
  • About Me

gSearch

gCategories

  • databases
  • html/css
  • iPhone
  • javascript
  • linux
  • mac
  • my space
  • places
  • rails
  • ruby
  • subversion
  • technology
  • uncategorized
  • whats hot
  • windows

gQuotes

Writing code a computer can understand is SCIENCE. Writing code other programmers can understand is an ART.
@rithmetic is being @ble to calculate upto 20 without taking off your shoes.
Start with yourself before you go ahead and try to change the world.
Once you make up your mind, don't listen to anyone (including yourself).

gTweets

  • Casual! Amazing! twitter.com/vulture/status… 3 days ago
  • How OTT platforms, quite a few stand-up comics are making gaalis the norm .. has become the in-thing .. twitter.com/shahid_siddiqu… 1 week ago
  • @AboutIndia @captainarora @AjayKamalakaran No vaccine is 100% safe. Even if it was the vaccine, they won't report i… twitter.com/i/web/status/1… 1 week ago
  • Transfer Files - Wear OS - WiFi - ADB - #Ticwatch and other #smartwatches #wearos gauravsohoni.wordpress.com/2021/01/18/tra… 1 week ago
  • So #MagSafe is coming back and Useless #Touchbar is going away .. #apple #macbook updates .. Not sure if all this w… twitter.com/i/web/status/1… 1 week ago

gTagCloud

amd antivirus apache apple arrays backup capistrano 3 configuration console cors cron css csv database deployment enhancements explain features fedora find functioncall hashes homebrew Hot html indexing installation Intel iPhone irb javascript jquery js kernel leopard linux linuz localhost log mac merge methods migrations mysql name nature opensuse operating system os osx processors query rails rake reinstall ror ruby ruby on rails ruby rails secureboot select serene setup shorcuts sql subversion suse svn technology tips ubuntu update validations virus windows

gRecentPosts

  • Transfer Files – Wear OS (Ticwatch) – WiFi – ADB
  • Ender 3 Pro – Firmware upgrade using Raspberry Pi

gCalendar

January 2021
M T W T F S S
 123
45678910
11121314151617
18192021222324
25262728293031
« Aug    

databases

All about Databases

MySQL – Backup and Restore All Databases

I recently used this to backup and restore all the databases in one single file. This works for small sized databases very well and is a quick and easy way to backup and restore all local databases. Very useful for testing and quick restore. Issue this command at the command prompt. mysqldump -u <username> -p […]

Read more "MySQL – Backup and Restore All Databases"

List MySQL Views

In case you wanted to list all views in your database, you could use the following mysql statement SHOW FULL TABLES WHERE Table_type = ‘VIEW’

Read more "List MySQL Views"

MySQL + Gem – MySQLCompat Error Solution

I have not been able to put this post up for quite some time now. Actually this has to do with mysql gem installation issue on Mac OSX 10.6 (or later).  Initially there were issues with mysql gem installationl. Once it got installed and I ran my app, I got the not so famous “uninitialized […]

Read more "MySQL + Gem – MySQLCompat Error Solution"

MySQL – Temporarily disable Foreign Key Checks or Constraints

Databases are all about saving data. With DBMS and RDBMS, the entire data became relational and all the records became related to each other as in the real world. So came into existence the concepts of primary keys, foreign keys, foreign key constraints and whole bunch of other terms like composite keys, referential integrity, indexes […]

Read more "MySQL – Temporarily disable Foreign Key Checks or Constraints"

Posts navigation

← Older posts
Create a free website or blog at WordPress.com.
{ problem: 'solved' }
Create a free website or blog at WordPress.com.
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
Cancel