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

  • RT @KeziyahL: "Get whatever vaccine you're offered first" is good public health advice, but I still wanted to get "the best" one. So I di… 1 day ago
  • Attempt difficult questions/problems first .. so I guess vaccine shortage is an easy one to tackle .. 2 days ago
  • Meet Rezvani Tank X .. Yours for USD 385K .. twitter.com/mashable/statu… 3 days ago
  • So apparently Mr Zuckerberg uses #Signal ... indiatoday.in/technology/new… 3 days ago
  • RT @paulocoelho: If you are tired, learn how to rest not how to quit 3 days 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 hp 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 serene setup shorcuts sql subversion suse svn technology tips ubuntu update validations virus windows

gRecentPosts

  • Set Default Brightness level – Ubuntu – HP Laptop
  • Transfer Files – Wear OS (Ticwatch) – WiFi – ADB

gCalendar

April 2021
M T W T F S S
 1234
567891011
12131415161718
19202122232425
2627282930  
« Feb    

mysql

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 – 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"

SQL query results into CSV file

You must have fired those select statements tons of times. So you hit a query, get your results and you are done. But what if the next day you felt like going through the results you found the other day. Simple.. hit the query again. But what if the query was complex and you need […]

Read more "SQL query results into CSV file"

Posts navigation

← Older posts
Blog at WordPress.com.
{ problem: 'solved' }
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

 
Loading Comments...
Comment
    ×