Thanks to antville.org
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:

code.google.com

www.red-gate.com

www.devart.com

... 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 -

wget percona.com/get/pt-show-grants;
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.

/!9999
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.

wget percona.com/get/pt-show-grants

chmod 777 pt-show-grants

./pt-show-grants

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


Install percona extra backup tool innobackupex

Steps to install innobackupex on Ubuntu:

$ apt-key adv --keyserver keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A

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

deb repo.percona.com precise main
deb-src repo.percona.com 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

BACKUP

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

RESTORE

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:
wget launchpadlibrarian.net

Running:
sh tuning-primer.sh

... 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
Status
Youre not logged in ... Login
Menu
... Home
... Tags

Search
Calendar
January 2020
SunMonTueWedThuFriSat
1234
567891011
12131415161718
19202122232425
262728293031
December
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 sattamatka3.net (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