Thanks to
compare mysql schema

And here is poor man's schema compare using good old diff command...

mysqldump nasik1 --no-data > nasik1.sql

mysqldump -h1.2.3.4 murtizapur --no-data > murtizapur.sql

diff murtizapur.sql nasik1.sql --side-by-side --suppress-common-lines | grep -v ENGINE | grep -v BTREE > to_study.txt

Or use one of the packages:

... Link (0 comments) ... Comment

Rank mysql records using variables

SET @rank = 0, @prev_val = NULL;

SELECT rank, correct FROM (
SELECT @rank := IF(@prev_val=correct,@rank,@rank+1) AS rank,
@prev_val := correct AS correct, uid
FROM quiz_user ORDER BY correct DESC
)as result WHERE uid=xxxxxxxxxxxx

... Link (0 comments) ... Comment

backup mysql users

It is easy to backup mysql users -

perl pt-show-grants

... Link (8 comments) ... Comment

mysql and shell command

date -d"-1 day ago" +'%b%d'

equals to

mysql -Bse"select date_format(date(date_add(now() , interval 1 day)),'%b%d')"

... Link (22 comments) ... Comment

Preserving comments in Stored Procedure

You can write multi line comments in a stored procedure by following mysql to think that it is a version specific code.

Multi line comment, retained by mysql
not executed till it reaches the mysql version 9999 :))

... Link (5 comments) ... Comment

percona utility

We can re-create mysql users using the percona utility.


chmod 777 pt-show-grants


... Link (0 comments) ... Comment

Install percona extra backup tool innobackupex

Steps to install innobackupex on Ubuntu:

$ apt-key adv --keyserver --recv-keys 1C4CBDCDCD2EFD2A

Add this to /etc/apt/sources.list, replacing VERSION precise with the name of your distribution:

deb precise main
deb-src precise main

Remember to update the local cache:
$ apt-get update

Now you can install Percona XtraBackup with:
$ apt-get install percona-xtrabackup

... Link (0 comments) ... Comment

Backup mysql data using innobackup


innobackupex --user=USERNAME --password=PASSWORD --no-timestamp /data/backups/new_backup <--(PATH OF BACKUP)
innobackupex --apply-log /data/backups/new_backup


service mysql stop
mkdir /tmp/mysql
mv /var/lib/mysql/* /tmp/mysql/
innobackupex --copy-back /data/backups/new_backup <--(PATH OF BACKUP WHERE IS STORED)
chown -R mysql: /var/lib/mysql
service mysql start

... Link (0 comments) ... Comment

Tuning MySQL

Getting the shell script:


... Link (1 comment) ... Comment

download Enterprise backup

1) Access My Oracle Support.
2) Click on Patches & Updates navigation tab near the top of the screen.
3) In the Patch Search section, click on the Product or Family (Advanced Search) link
4) Type MySQL Enterprise Backup into the Product drop down list
5) select the latest release
6) Click the Search button.

... Link (0 comments) ... Comment

Online for 6364 days
Last modified: 1/26/20 2:24 PM
Youre not logged in ... Login
... Home
... Tags

January 2020
Recent updates
while loop This is
a sample shell script while loop while read mydb do echo...
by shantanuo (1/26/20 2:24 PM)
compare mysql schema And here
is poor man's schema compare using good old diff command......
by shantanuo (1/26/20 1:49 PM)
Selecting from error log grep
"error" error_log |awk -F[ {'print $4'} \ | sort |...
by shantanuo (1/26/20 12:40 PM)
Rank mysql records using variables
SET @rank = 0, @prev_val = NULL; SELECT rank, correct...
by shantanuo (1/26/20 11:45 AM)
Thanks for sharing this!!
commercial roofing huntsville al
by Mazikeen (1/24/20 6:37 PM)
Sophie Chciałbym więcej o tym
przeczytać. Szybka, jaka literatura ma studiować? texas colleges and universities
by panistefanin (1/24/20 3:45 PM)
Jack Lovely information thank you
very much decanters
by decanter2020 (1/24/20 1:20 PM)
I like it I like
that logic. interior painting
by LisaCook (1/23/20 10:11 PM)
Love it I like this!
Thanks for posting roll off canister
by LaurenHill (1/23/20 10:05 PM)
Thanks for the heads up!
Thank you for sharing this. Our website
by mozaic (1/23/20 2:32 PM)
Thank you for sharing
a really great piece of information. bubble shooter
by longjumper (1/21/20 11:05 AM)
Thanks Thanks for sharing these.
Sam H - Interior Painter Scaumburg Il
by Samh2019 (1/21/20 10:14 AM)
Fencing in Guildford thanks for
the information Fencing in Guildford Fencing in Surrey
by Dubs (1/20/20 9:26 PM)
satta matka matka boss satta
matka Visit our site for more information
by (1/20/20 7:52 PM)
Beebeetravvel Thanks for sharing your
valuable information. we are a tour & travel agency with...
by coolexusa (1/20/20 2:27 PM)
Access Control System Dubai Fingerprintdubai
Company is providing many types of Services like , card...
by coolexusa (1/20/20 12:19 PM)
Air Duct Cleaning This type
of Duct cleaning Miami is absolutely not a must have...
by coolexusa (1/20/20 11:26 AM)
Carpet Cleaning Oxford and Surrounding
Areas Interesting read. Carpet cleaning in Oxford and surrounding areas
by Murray Whelehan (1/19/20 8:18 PM)
Antares AutoTune Crack License
Key With Keygen ( MAC ) A Antares AutoTune Pro Crack...
by ijicrackgh (1/19/20 9:50 AM)
Waves Tune Real-Time Crack (Latest)
Free Download 2020! Visit my site and free crack full...
by ijicrackgh (1/19/20 9:45 AM)
Advanced SystemCare Registry Repair And
Cleaner If you are like many people, you have shut...
by GeraldRob (1/19/20 6:42 AM)
Shell Command One of the
best articles I have ever read. Thank you for sharing...
by Harrison William (1/19/20 1:11 AM)
Hola buenas thank
you for sharing information, i like your blog creditos rapidos con asnef
by polcelery (1/19/20 12:25 AM)
Is it Worth Investing in
an Asbestos Survey? If you suspect that asbestos is present...
by GeraldRob (1/18/20 6:52 PM)
Spyhunte 5 Full Version Spyhunter
is best antivirus pogrom software which enable to remove virus...
by zcracked (1/18/20 9:41 AM)

RSS feed

Made with Antville
Helma Object Publisher