MySQL Tips

1) Restore DB
a) mysql --user=root --password=root maheshsql_db < "C:\mydbbkp.sql"


2) MYSQL Get all table rows and size of each table in DB
a) SELECT table_schema "Data Base Name", SUM( data_length + index_length) / 1024 / 1024 "Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema ;
b) SELECT TABLE_NAME, table_rows, data_length, index_length, 
round(((data_length + index_length) / 1024 / 1024),2) "Size in MB" FROM information_schema.TABLES WHERE table_schema = "schema_name";
c) SELECT SUM(round(((data_length + index_length) / 1024 / 1024),2)) "Size in MB" FROM information_schema.TABLES WHERE table_schema = "schema_name";


3) Count no of tables in DB
a) SELECT count(*) FROM information_schema.tables WHERE table_schema  = "schema_name";


4)  Can not load from mysql.proc. The table is probably corrupted
a) Run this Command
           a.1) mysql_upgrade 
                 OR
           a.1) mysql_upgrade --user=my_username --password=my_password

5) ERROR 2003 (HY000): Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (10061)
        step 1) Open your my.cnf file OR my.ini   file in mysql/bin folder
         step 2) Comment the bind-address
              #bind-address="127.0.0.1"

Comments

Post a Comment

Popular posts from this blog

AIOMgr: Preparing flush failed with VERR_NOT_SUPPORTED, disabling async flushes

AIOMgr: Preparing flush failed with VERR_NOT_SUPPORTED, disabling async flushes If you get error like this while Installing Windows 8.1 as guest OS using Oracle VirtualBox /VirtualMachine Then check your RAM Allocation for the Guest OS. Example: First time i gave 5120 (5 GB) of RAM for Guest OS. while installing i got the error like this in log file AIOMgr: Preparing flush failed with VERR_NOT_SUPPORTED , disabling async flushes. Now i changed the RAM size to 4096(4 GB) , now the error gone, the guest OS installed successfully. My Suggestion is to set RAM size in EVEN  for this kind of errors.
Read more

Basic CRUD operations using php, mongodb and knockoutjs with validation

Image
1) I used knockout simplegrid for table data with DELETE, EDIT action and pagination support 2) THE CRUD operations are using XHR/AJAX 3) I used Twitter Booststarp Framework. You can Download/Fork from the github.com  basics_of_php_mongodb_knockoutjs Before trying this we need to install PHP, Apache webserver/Any HTTP server and MongoDB second download mongodb.dll file (php mongodb driver) and keep this file extension if you are using windows OS. These are JavaScript files required <!-- Just for debugging purposes. Don't actually copy this line! --> <!--[if lt IE 9]><script src="js/ie8-responsive-file-warning.js"></script><![endif]--> <!-- HTML5 shim and Respond.js IE8 support of HTML5 elements and media queries --> <!--[if lt IE 9]>  <script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>  <script src="https://oss.maxcdn.com/li
Read more

Create Virtual Host in IIS Server

Image
1)  Open Command Prompt using Administrative Rights 2)  Flush the cache of ARP (Address resolution protocol) a) C:\Windows\system32> netsh interface ip delete arpcache b) C:\Windows\system32> arp -a 3)  Open IE (Internet Explorer) a)  Open Internet Options window from settings b)  Click on Connections Tab -> Click on LAN Settings button c)  Uncheck all checkbox but make sure to check the "Bypass proxy server for local address." 4)  Open Hosts file from C:\Windows\System32\drivers\etc Folder (Make sure is it have write permission) It will look like this # localhost name resolution is handled within DNS itself. # 127.0.0.1       localhost # ::1                 localhost Add these lines at bottom of this file (You can add multiple names) 127.0.0.1 mysite.com 127.0.0.1 maheshbokkisam.com 5)  Now check is these virtual host/domain names are working a)  Go to Command Prompt and run this commands 5.a.1)  ping mysite.c
Read more