https://www.digitalocean.com/community/questions/setup-mysql-on-ubuntu-droplet-getting-error-error-1045-28000-access-denied-for-user-root-localhost-using-password-yes
sudo /etc/init.d/mysql stop
Now start up MySQL in safe mode, so you'll skip the privileges table:
sudo mysqld_safe --skip-grant-tables &
Login with root:
mysql -uroot
And assign the DB that needs to be used:
use mysql;
Now all you have to do is reset your root password of the MySQL user and restart the MySQL service:
update user set password=PASSWORD("root123") where User='root';
flush privileges;
quit and restart MySQL:
quit
sudo /etc/init.d/mysql stop
sudo /etc/init.d/mysql start
====================================================
remove old mysq from YUM command
then
sudo yum localinstall MySQL-embedded-advanced-5.6.24-1.el6.x86_64.rpm
sudo yum localinstall MySQL-test-advanced-5.6.24-1.el6.x86_64.rpm
sudo yum localinstall MySQL-shared-compat-advanced-5.6.24-1.el6.x86_64.rpm
sudo yum localinstall MySQL-shared-advanced-5.6.24-1.el6.x86_64.rpm
sudo yum localinstall MySQL-server-advanced-5.6.24-1.el6.x86_64.rpm
sudo yum localinstall MySQL-client-advanced-5.6.24-1.el6.x86_64.rpm
sudo yum localinstall MySQL-devel-advanced-5.6.24-1.el6.x86_64.rpm
=========================
for NOSQL IN SQL URL IS
https://scriptingmysql.wordpress.com/2014/05/01/use-mysql-to-store-nosql-and-sql-data-in-the-same-database-using-memcached-and-innodb/
================================================================
#mysqldump -u root -proot123 dth_airtel > /data/MysqlBacup/dthairtel/dthairtel_$(date +\%Y-\%m-\%d_\%Hh\%M).sql
#mysqldump -u root -proot123 aircel > /data/MysqlBacup/aircel/aircel_$(date +\%Y-\%m-\%d_\%Hh\%M).sql
#mysqldump -u root -proot123 ondeck > /data/MysqlBacup/ondeck/ondeck_$(date +\%Y-\%m-\%d_\%Hh\%M).sql
#mysqldump -u root -proot123 common_hd > /data/MysqlBacup/common_hd/common_hd_$(date +\%Y-\%m-\%d_\%Hh\%M).sql
#mysqldump -u root -proot123 vid_dth > /data/MysqlBacup/VIDDTH/Videocon_dth_$(date +\%Y-\%m-\%d_\%Hh\%M).sql
#mysqldump -u neo -h172.31.22.58 -padmin123 unified > /data/MysqlBacup/unified/unified_$(date +\%Y-\%m-\%d_\%Hh\%M).sql
mysqldump -u root -hlocalhost -proot123 unified_push |gzip > /home/MysqlBacup/push/unified_push_159server/unified_push_nexG$(date +\%Y-\%m-\%d_\%Hh\%M).sql.gz
mysqldump -u root -hlocalhost -proot123 pushnotification_airtel_hd |gzip > /home/MysqlBacup/push/airtel_hd_push_159/airtel_hd_push$(date +\%Y-\%m-\%d_\%Hh\%M).sql.gz
mysqldump -u root -hlocalhost -proot123 airdth_push |gzip > /home/MysqlBacup/push/airtel_dth_push_159/airdth_push$(date +\%Y-\%m-\%d_\%Hh\%M).sql.gz
mysqldump -u root -hlocalhost -proot123 nokiapush |gzip > /home/MysqlBacup/push/nokiapush_159/nokiapush$(date +\%Y-\%m-\%d_\%Hh\%M).sql.gz
sudo /etc/init.d/mysql stop
Now start up MySQL in safe mode, so you'll skip the privileges table:
sudo mysqld_safe --skip-grant-tables &
Login with root:
mysql -uroot
And assign the DB that needs to be used:
use mysql;
Now all you have to do is reset your root password of the MySQL user and restart the MySQL service:
update user set password=PASSWORD("root123") where User='root';
flush privileges;
quit and restart MySQL:
quit
sudo /etc/init.d/mysql stop
sudo /etc/init.d/mysql start
====================================================
remove old mysq from YUM command
then
sudo yum localinstall MySQL-embedded-advanced-5.6.24-1.el6.x86_64.rpm
sudo yum localinstall MySQL-test-advanced-5.6.24-1.el6.x86_64.rpm
sudo yum localinstall MySQL-shared-compat-advanced-5.6.24-1.el6.x86_64.rpm
sudo yum localinstall MySQL-shared-advanced-5.6.24-1.el6.x86_64.rpm
sudo yum localinstall MySQL-server-advanced-5.6.24-1.el6.x86_64.rpm
sudo yum localinstall MySQL-client-advanced-5.6.24-1.el6.x86_64.rpm
sudo yum localinstall MySQL-devel-advanced-5.6.24-1.el6.x86_64.rpm
=========================
for NOSQL IN SQL URL IS
https://scriptingmysql.wordpress.com/2014/05/01/use-mysql-to-store-nosql-and-sql-data-in-the-same-database-using-memcached-and-innodb/
================================================================
history
1 echo PAESSHSTART;df -P;echo PAESSHEND
2 mysqldump -u root -p unified >/home/MysqlBacup/unified_59/
3 cd /home/MysqlBacup/unified_59
4 rsync -r unified_ev_10jult_15.sql 172.31.22.60:/home/
5 echo PAESSHSTART;df -P;echo PAESSHEND
6 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
7 mysqldump -u root -p unified >/home/MysqlBacup/unified_59/
8 cd /home/MysqlBacup/unified_59
9 rsync -r unified_12JULY.sql 172.31.22.60:/home
10 echo PAESSHSTART;df -P;echo PAESSHEND
11 mysqldump -u root -p unified >/home/MysqlBacup/unified_59/
12 cd /home/MysqlBacup/unified_59
13 rsync -r unified_12JULY.sql 172.31.22.60:/home
14 echo PAESSHSTART;df -P;echo PAESSHEND
15 mysqldump -u root -p unified >/home/MysqlBacup/unified_59/
16 echo PAESSHSTART;df -P;echo PAESSHEND
17 df -h
18 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
19 echo PAESSHSTART;df -P;echo PAESSHEND
20 mysql -u root -p
21 echo PAESSHSTART;df -P;echo PAESSHEND
22 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
23 df -h
24 mysql -u root -p
25 df -h
26 echo PAESSHSTART;df -P;echo PAESSHEND
27 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
28 echo PAESSHSTART;df -P;echo PAESSHEND
29 df -h
30 echo PAESSHSTART;df -P;echo PAESSHEND
31 date
32 echo PAESSHSTART;df -P;echo PAESSHEND
33 netstat -an |grep :3306 |wc -l
34 mysql -u root -p
35 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
36 echo PAESSHSTART;df -P;echo PAESSHEND
37 mysqldump -u root -p unified >/home/MysqlBacup/unified_59/
38 mysql -u root -p
39 echo PAESSHSTART;df -P;echo PAESSHEND
40 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
41 ssh 172.31.22.58
42 echo PAESSHSTART;df -P;echo PAESSHEND
43 mysqldump -u root -p staging >/home/staging_23July_15.sql
44 echo PAESSHSTART;df -P;echo PAESSHEND
45 df -h
46 mysql -u root -p
47 df -h
48 ssh 172.31.22.58
49 echo PAESSHSTART;df -P;echo PAESSHEND
50 df-h
51 df -h
52 echo PAESSHSTART;df -P;echo PAESSHEND
53 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
54 echo PAESSHSTART;df -P;echo PAESSHEND
55 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
56 echo PAESSHSTART;df -P;echo PAESSHEND
57 uname -a
58 echo PAESSHSTART;df -P;echo PAESSHEND
59 mysqldump -u root -p -R >/home/proc1.sql
60 mysqldump -u root -p unified --routines --triggers >/home/proc1.sql
61 mysqldump --routines --no-create-info --no-data --no-create-db --skip-opt unified > >/home/proc1.sql
62 mysqldump --routines --no-create-info --no-data --no-create-db --skip-opt unified > /home/proc1.sql
63 mysqldump -u root -p --routines --no-create-info --no-data --no-create-db --skip-opt unified > /home/proc1.sql
64 echo PAESSHSTART;df -P;echo PAESSHEND
65 df -h
66 echo PAESSHSTART;df -P;echo PAESSHEND
67 mysql -u root -p
68 ps ax |grep mysql
69 service mysql stop
70 service mysql start
71 mysql -u root -p
72 mysqldump -u root -p unified >/home/unified_3aug_15.sql
73 cd /home
74 rsync -r unified_3aug_15.sql 172.31.22.59:/home
75 mysql -u root -p
76 mysqldump -u root -p unified >/home/unified_3aug_15.sql
77 rsync -r unified_3aug_15.sql 172.31.22.58:/home
78 mysql -u root -p
79 rsync -r unified_3aug_15.sql 172.31.22.91:/home
80 mysqldump -u root -p unified tbl_registered_users tbl_registered_users_hd tbl_registered_users_hd_main tbl_registered_users_main tbl_registered_users_sd >/home/uni_tbl_3aug.sql
81 rsunc -r uni_tbl_3aug.sql 172.31.22.58:/home/uni_tbl_
82 rsync -r uni_tbl_3aug.sql 172.31.22.58:/home/uni_tbl_
83 mysql -u root -p
84 echo PAESSHSTART;df -P;echo PAESSHEND
85 sh /usr/syncservice/src/epgsync.
86 echo PAESSHSTART;df -P;echo PAESSHEND
87 cd
88 cd /home/MysqlBacup/unified_59
89 rsync -r 172.31.22.45:/home/mysqlbackup
90 rsync -r unified_592015-08-06_04h01.
91 echo PAESSHSTART;df -P;echo PAESSHEND
92 df -h
93 echo PAESSHSTART;df -P;echo PAESSHEND
94 mysqldump -u root -p --structure unified >/home/unified_structure.sql
95 mysqldump -u root -p --no-data unified >/home/unified_structure.sql
96 echo PAESSHSTART;df -P;echo PAESSHEND
97 crontab -e
98 sh /usr/syncservice/src/epgsync.
99 echo PAESSHSTART;df -P;echo PAESSHEND
100 df -h
101 mysql -u root -p
102 echo PAESSHSTART;df -P;echo PAESSHEND
103 mysql -u root -p
104 echo PAESSHSTART;df -P;echo PAESSHEND
105 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
106 echo PAESSHSTART;df -P;echo PAESSHEND
107 df -h
108 mysql -u root -p
109 echo PAESSHSTART;df -P;echo PAESSHEND
110 mysqldump -u root -p --no-data unified >/home/unified_structure_
111 echo PAESSHSTART;df -P;echo PAESSHEND
112 df -h
113 echo PAESSHSTART;df -P;echo PAESSHEND
114 mysqldump -u root -p unified >/home/MysqlBacup/unified/
115 cd /home/MysqlBacup/unified
116 rsync -r unified_17Aug.sql 172.31.22.58:/home/
117 mysql -u root -p
118 echo PAESSHSTART;df -P;echo PAESSHEND
119 df -h
120 mysqldump -u root -p unified ws_vods ws_subcategory ws_channel ws_category VOD_METADATA VIEW_VOD_MASTER view_vod_detail VIEW_SUBCAT_MASTER view_subcat_detail VIEW_CATEGORY_MASTER view_category_detail version_summary version >/home/unified_table_17Aug_15.
121 cd /home
122 rsync -r unified_table_17Aug_15.sql 172.31.22.58:/home
123 echo PAESSHSTART;df -P;echo PAESSHEND
124 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
125 echo PAESSHSTART;df -P;echo PAESSHEND
126 mysqldump -u root -p unified >/home/unified_19aug.sql
127 cd home
128 cd /home
129 rsync -r unified_19aug.sql 172.31.22.58:/home
130 mysql -u root -p
131 echo PAESSHSTART;df -P;echo PAESSHEND
132 df -h
133 mysqldump -u rooot -p unified >/home/unified_19Aug_15.sql
134 mysqldump -u root -p unified >/home/unified_19Aug.sql
135 cd /home
136 rsync -r unified_19Aug.sql 172.31.22..58:/home
137 rsync -r unified_19Aug.sql 172.31.22.58:/home
138 mysql -u root -p
139 echo PAESSHSTART;df -P;echo PAESSHEND
140 mysql -u root -p
141 echo PAESSHSTART;df -P;echo PAESSHEND
142 mysqldump -u root -p unified >/home/unified_20Aug.sql
143 cd /home
144 rsync -r unified_20Aug.sql -r 172.31.22.58:/home
145 df -h
146 mysql -u root -p
147 echo PAESSHSTART;df -P;echo PAESSHEND
148 df -h
149 echo PAESSHSTART;df -P;echo PAESSHEND
150 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
151 echo PAESSHSTART;df -P;echo PAESSHEND
152 df -h
153 mysql -u root -p
154 df -h
155 echo PAESSHSTART;df -P;echo PAESSHEND
156 ps ax |grep mysql
157 kill -9 4399
158 ps ax |grep mysql
159 echo PAESSHSTART;df -P;echo PAESSHEND
160 mysql -u root -p
161 echo PAESSHSTART;df -P;echo PAESSHEND
162 service mysql stop
163 service mysql start
164 mysqldump -u root -p unified >/home/unified_25Aug_15.sql
165 rsync -r unified_25Aug_15.sql 172.31.22.58:/home/
166 rsync -r /home/unified_25Aug_15.sql 172.31.22.58:/home/
167 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
168 echo PAESSHSTART;df -P;echo PAESSHEND
169 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
170 df -h
171 echo PAESSHSTART;df -P;echo PAESSHEND
172 cat CPUinfo
173 /cat/cpuinfo
174 echo PAESSHSTART;df -P;echo PAESSHEND
175 crontab -e
176 echo PAESSHSTART;df -P;echo PAESSHEND
177 sh /usr/syncservice/src/epgsync.
178 crontab -e
179 echo PAESSHSTART;df -P;echo PAESSHEND
180 sh /usr/syncservice/src/epgsync.
181 ssh 172.31.22.159
182 echo PAESSHSTART;df -P;echo PAESSHEND
183 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
184 df -h
185 show binary logs\G;
186 mysql -u root -p
187 df -h
188 echo PAESSHSTART;df -P;echo PAESSHEND
189 mysqldump -u root -p unified CHANNEL_DETAIL_VIEW CHANNEL_RTSP_DETAILS_VIEW PACKAGE_CHANNEL_MAP_VIEW PACKAGE_MASTER_VIEW VIEW_VOD_MASTER VOD_METADATA ws_vods ws_category ws_channel ws_subcategory >/home/unified_2SEP_
190 mysql -u root -p
191 mysqldump -u root -p unified >/home/unified_2SEP_
192 mysql -u root -p
193 echo PAESSHSTART;df -P;echo PAESSHEND
194 df -h
195 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
196 df -h
197 mysql -u root -p
198 df -h
199 mysql -u root -p
200 df -h
201 echo PAESSHSTART;df -P;echo PAESSHEND
202 df -h
203 free -m
204 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
205 free -m
206 df -h
207 ssh 172.31.22.58
208 echo PAESSHSTART;df -P;echo PAESSHEND
209 mysqldump -u root -p unified PACKAGE_CHANNEL_MAP_VIEW PACKAGE_MASTER_VIEW >/home/unified_2table.sql
210 mysql -u root -p
211 echo PAESSHSTART;df -P;echo PAESSHEND
212 df -h
213 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
214 echo PAESSHSTART;df -P;echo PAESSHEND
215 df -h
216 mysql -u root -p
217 df -h
218 echo PAESSHSTART;df -P;echo PAESSHEND
219 df -h
220 echo PAESSHSTART;df -P;echo PAESSHEND
221 df -h
222 top
223 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
224 top
225 echo PAESSHSTART;df -P;echo PAESSHEND
226 df -h
227 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
228 mysql -u root -p
229 echo PAESSHSTART;df -P;echo PAESSHEND
230 df -h
231 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
232 echo PAESSHSTART;df -P;echo PAESSHEND
233 mysqldump -u root -p unified tbl_registered_users_main >/home/tbl_registered_users_
234 cd home
235 cd /home
236 rsync -r tbl_registered_users_main_
237 echo PAESSHSTART;df -P;echo PAESSHEND
238 df -h
239 mysql -u rooot -p
240 mysql -u root -p
241 df -h
242 echo PAESSHSTART;df -P;echo PAESSHEND
243 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
244 echo PAESSHSTART;df -P;echo PAESSHEND
245 mysql -u root -p
246 echo PAESSHSTART;df -P;echo PAESSHEND
247 mysql -u root -p
248 echo PAESSHSTART;df -P;echo PAESSHEND
249 df -h
250 mysql -u root -p
251 df -h
252 echo PAESSHSTART;df -P;echo PAESSHEND
253 df -h
254 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
255 echo PAESSHSTART;df -P;echo PAESSHEND
256 df -h
257 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
258 echo PAESSHSTART;df -P;echo PAESSHEND
259 df -h
260 mysql -u root -p
261 df -h
262 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
263 echo PAESSHSTART;df -P;echo PAESSHEND
264 mysqldump -u root -p unified >/home/unifed_3oct_15.sql
265 mysql -u root -p
266 cd /home
267 rsync -r unifed_3oct_15.sql 172.31.22.58:/home
268 mysql -u root -p
269 mysqldump -u root -p unified >/home/unified_3oct.sql
270 echo PAESSHSTART;df -P;echo PAESSHEND
271 cd /home
272 rsync -r unified_3oct.sql 172.31.22.58:/home
273 echo PAESSHSTART;df -P;echo PAESSHEND
274 mysql -u root -p
275 echo PAESSHSTART;df -P;echo PAESSHEND
276 mysql -u root -p
277 echo PAESSHSTART;df -P;echo PAESSHEND
278 cat /proc/cpuinfo
279 grep flags /proc/cpuinfo
280 uname -m
281 uname -a
282 echo PAESSHSTART;df -P;echo PAESSHEND
283 df -h
284 mysql -u root -p
285 df -h
286 echo PAESSHSTART;df -P;echo PAESSHEND
287 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
288 echo PAESSHSTART;df -P;echo PAESSHEND
289 mysqldump -u root -p unified >/home/unified_8Oct.sql
290 cd /home
291 rsync -r unified_8Oct.sql 172.31.22.60:/home
292 mysqldump -u root -p unified >/home/unified_8Oct.sql
293 rsync -r unified_8Oct.sql 172.31.22.60:/home
294 mysqldump -u root -p unified >/home/unified_8Oct.sql
295 rsync -r unified_8Oct.sql 172.31.22.60:/home
296 echo PAESSHSTART;df -P;echo PAESSHEND
297 mysql -u root -p
298 echo PAESSHSTART;df -P;echo PAESSHEND
299 df -h
300 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
301 mysql -u root -p
302 df -h
303 echo PAESSHSTART;df -P;echo PAESSHEND
304 df -h
305 echo PAESSHSTART;df -P;echo PAESSHEND
306 mysql -u root -p
307 echo PAESSHSTART;df -P;echo PAESSHEND
308 mysql -u root -p
309 echo PAESSHSTART;df -P;echo PAESSHEND
310 sh usr/syncservice/src/epgsync.
311 crontab -e
312 sh /usr/syncservice/src/epgsync.
313 echo PAESSHSTART;df -P;echo PAESSHEND
314 df -h
315 echo PAESSHSTART;df -P;echo PAESSHEND
316 df -h
317 mysql - u root -p
318 mysql -u root -p
319 df -h
320 echo PAESSHSTART;df -P;echo PAESSHEND
321 df -h
322 mysql - uroot -p
323 mysql -u root -p
324 df -h
325 echo PAESSHSTART;df -P;echo PAESSHEND
326 df -h
327 echo PAESSHSTART;df -P;echo PAESSHEND
328 df -h
329 mysql -u root -p
330 df -h
331 echo PAESSHSTART;df -P;echo PAESSHEND
332 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
333 echo PAESSHSTART;df -P;echo PAESSHEND
334 df -h
335 mysql -u root -p
336 df -h
337 echo PAESSHSTART;df -P;echo PAESSHEND
338 df -h
339 mysqldump -u root -p
340 mysqldump -u root -p unified >/home/MysqlBacup/unified_59/
341 service mysql stop
342 service mysql start
343 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
344 echo PAESSHSTART;df -P;echo PAESSHEND
345 df -h
346 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
347 echo PAESSHSTART;df -P;echo PAESSHEND
348 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
349 df -h
350 mysql -u root -p
351 df -h
352 echo PAESSHSTART;df -P;echo PAESSHEND
353 mysql -u root -p
354 echo PAESSHSTART;df -P;echo PAESSHEND
355 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
356 echo PAESSHSTART;df -P;echo PAESSHEND
357 df -h
358 echo PAESSHSTART;df -P;echo PAESSHEND
359 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
360 echo PAESSHSTART;df -P;echo PAESSHEND
361 df -h
362 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
363 mysql -u root -p
364 df -h
365 echo PAESSHSTART;df -P;echo PAESSHEND
366 df -h
367 echo PAESSHSTART;df -P;echo PAESSHEND
368 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
369 echo PAESSHSTART;df -P;echo PAESSHEND
370 df -h
371 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
372 mysql -u root -p
373 df -h
374 echo PAESSHSTART;df -P;echo PAESSHEND
375 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
376 echo PAESSHSTART;df -P;echo PAESSHEND
377 df -h
378 mysqldump -u root -p unified >/home/MysqlBacup/unified_59/
379 echo PAESSHSTART;df -P;echo PAESSHEND
380 crontab -e
381 echo PAESSHSTART;df -P;echo PAESSHEND
382 sh /usr/syncservice/src/epgsync.
383 echo PAESSHSTART;df -P;echo PAESSHEND
384 df -h
385 mysql -u root -p
386 df -h
387 echo PAESSHSTART;df -P;echo PAESSHEND
388 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
389 echo PAESSHSTART;df -P;echo PAESSHEND
390 crontab -e
391 sh /usr/syncservice/src/epgsync.
392 echo PAESSHSTART;df -P;echo PAESSHEND
393 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
394 df -h
395 mysql -u root -p
396 df -h
397 echo PAESSHSTART;df -P;echo PAESSHEND
398 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
399 echo PAESSHSTART;df -P;echo PAESSHEND
400 df -h
401 mysql -u root -p
402 df -h
403 echo PAESSHSTART;df -P;echo PAESSHEND
404 mysqldump -u root -p --no-data unified > /home/unified_struct_2dec_15.
405 echo PAESSHSTART;df -P;echo PAESSHEND
406 cd /var/lib/mysql
407 tail -f mysql-bin.000472
408 echo PAESSHSTART;df -P;echo PAESSHEND
409 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
410 cd /home/MysqlBacup/unified_59
411 rsync -r unified_592015-12-02_04h01.
412 echo PAESSHSTART;df -P;echo PAESSHEND
413 crontab -e
414 sh /usr/syncservice/src/epgsync.
415 echo PAESSHSTART;df -P;echo PAESSHEND
416 df -h
417 echo PAESSHSTART;df -P;echo PAESSHEND
418 df -h
419 mysql -u root -p
420 df -h
421 echo PAESSHSTART;df -P;echo PAESSHEND
422 df-h
423 df -h
424 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
425 mysql -u root -p
426 df -h
427 echo PAESSHSTART;df -P;echo PAESSHEND
428 df -h
429 mysql -u root -p
430 echo PAESSHSTART;df -P;echo PAESSHEND
431 df -h
432 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
433 echo PAESSHSTART;df -P;echo PAESSHEND
434 df -h
435 mysql -u root -p
436 df -h
437 mysql -u root -p
438 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
439 echo PAESSHSTART;df -P;echo PAESSHEND
440 df -h
441 mysql -u root -p
442 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
443 df -h
444 echo PAESSHSTART;df -P;echo PAESSHEND
445 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
446 df -h
447 echo PAESSHSTART;df -P;echo PAESSHEND
448 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
449 echo PAESSHSTART;df -P;echo PAESSHEND
450 mysql -u root -p
451 echo PAESSHSTART;df -P;echo PAESSHEND
452 df -h
453 mysql -u root -p
454 df -h
455 echo PAESSHSTART;df -P;echo PAESSHEND
456 exit
457 echo PAESSHSTART;df -P;echo PAESSHEND
458 vim .ssh/authorized_keys
459 chmod 600 .ssh/authorized_keys
460 echo PAESSHSTART;df -P;echo PAESSHEND
461 mysql -u root -p
462 echo PAESSHSTART;df -P;echo PAESSHEND
463 mysql -u root -p
464 echo PAESSHSTART;df -P;echo PAESSHEND
465 mysql -u root -p
466 echo PAESSHSTART;df -P;echo PAESSHEND
467 cd /db/
468 ll
469 cd bckup/
470 ll
471 du -sh unified-21-12-2015.sql
472 ll
473 gzip unified-21-12-2015.sql
474 ll
475 echo PAESSHSTART;df -P;echo PAESSHEND
476 df -h
477 cd /db/
478 ll
479 vim /etc/my.cnf
480 cd bckup/
481 ll
482 cd ..
483 cd mysql/
484 ll
485 du -sh unified/
486 cd ..
487 ll
488 mysqldump -u root -p unified > bckup/unified-21-12-2015.sql
489 ll
490 cd bckup/
491 ll
492 du -sh unified-21-12-2015.sql.gz
493 ll
494 du -sh unified-21-12-2015.sql.gz
495 ll
496 du -sh unified-21-12-2015.sql.gz
497 echo PAESSHSTART;df -P;echo PAESSHEND
498 df -h
499 echo PAESSHSTART;df -P;echo PAESSHEND
500 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches
501 "
502 echo PAESSHSTART;df -P;echo PAESSHEND
503 cat /proc/cpuinfo
504 free -m
505 top
506 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
507 echo PAESSHSTART;df -P;echo PAESSHEND
508 df -h
509 crontab -e
510 echo PAESSHSTART;df -P;echo PAESSHEND
511 df -h
512 crontab -e
513 cd /usr/syncservice/src
514 javac EPGSync.java
515 crontab -e
516 sh /usr/syncservice/src/epgsync.
517 df -h
518 echo PAESSHSTART;df -P;echo PAESSHEND
519 df -h
520 echo PAESSHSTART;df -P;echo PAESSHEND
521 mysql -u root -p
522 ifconfig
523 echo PAESSHSTART;df -P;echo PAESSHEND
524 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
525 echo PAESSHSTART;df -P;echo PAESSHEND
526 df -h
527 mysqldump -u root -p unified tbl_registered_users_main tbl_registered_users >/home/tbl_reg_users_28dec_15.
528 mysqldump -u root -p unified tbl_registered_users_main >/home/tbl_reg_users_28dec1_
529 mysql -u root -p
530 echo PAESSHSTART;df -P;echo PAESSHEND
531 df -h
532 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
533 mysql -u root -p
534 echo PAESSHSTART;df -P;echo PAESSHEND
535 df -h
536 echo PAESSHSTART;df -P;echo PAESSHEND
537 ifconfig
538 exit
539 echo PAESSHSTART;df -P;echo PAESSHEND
540 df -h
541 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
542 mysql -u root -p
543 df -h
544 echo PAESSHSTART;df -P;echo PAESSHEND
545 ifconfig
546 exit
547 echo PAESSHSTART;df -P;echo PAESSHEND
548 crontab 0l
549 crontab -l
550 vim /home/MySQLdump.sh
551 df -h
552 cd /home/
553 ll
554 cd MysqlBacup/
555 ll
556 cd aircel/
557 l
558 ll
559 du -sh aircel_2016-01-07_04h00.sql
560 ll
561 cd ..
562 ll
563 cd common_hd/
564 ll
565 du -sh common_hd_2016-01-07_04h00.sql
566 ll
567 df -h
568 cd /
569 ll
570 du -sh *
571 cd var/
572 ll
573 du -sh *
574 cd lib/
575 ll
576 du -sh *
577 cd mysql
578 ll
579 df -h
580 cd /db
581 ll
582 cd bckup/
583 ll
584 cd /home/MysqlBacup/
585 ll
586 cd common_hd/
587 ll
588 echo PAESSHSTART;df -P;echo PAESSHEND
589 df -h
590 cd /home/
591 ll
592 du -sh *
593 cd MysqlBacup/
594 ll
595 du -sh *
596 crontab -
597 crontab -l
598 cat /usr/syncservice/src/epgsync.
599 cat /var/log/filesize.sh
600 tail -f /var/log/mysqld.log
601 vim /etc/my.cnf
602 tail -f /var/log/mysqld.log
603 ll
604 crontab -l
605 vim /home/MySQLdump.sh
606 ll
607 vim ORACLEdump.sh
608 vim /home/MysqlBacup/unified.sql
609 du -sh tbl_registered_users_17Feb.sql
610 vim tbl_registered_users_17Feb.sql
611 ls -ltr
612 du -sh bcup/
613 cd bcup/
614 ll
615 gzip *
616 ll
617 cd ..
618 ll
619 gzip tbl_registered_users_17Feb.sql
620 ll
621 cd aircel/
622 ll
623 gzip *
624 ll
625 cd ..
626 ll
627 cd bcup/
628 ll
629 cd ..
630 ll
631 cd common_hd/
632 ll
633 gzip *
634 cd ..
635 ll
636 cd dthairtel/
637 ll
638 gzip *
639 ll
640 cd ..
641 ll
642 cd ondeck/
643 ll
644 gzip *
645 ll
646 cd ..
647 ll
648 cd unified
649 ll
650 gzip *
651 ll
652 cd ..
653 ll
654 cd unified_59/
655 ll
656 gzip *
657 ll
658 cd ..
659 ll
660 cd VIDDTH/
661 l
662 ll
663 gzip *
664 ll
665 cd ..
666 ll
667 echo PAESSHSTART;df -P;echo PAESSHEND
668 cd /home/MysqlBacup/unified_59
669 rsync -r unified_592016-01-07_04h01.
670 echo PAESSHSTART;df -P;echo PAESSHEND
671 df -h
672 crontab -l
673 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
674 echo PAESSHSTART;df -P;echo PAESSHEND
675 df -h
676 mysql -u root -p
677 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
678 echo PAESSHSTART;df -P;echo PAESSHEND
679 ll
680 cd /
681 ll
682 df -h
683 cd /home/
684 ll
685 cd database/
686 ll
687 cd mysql/
688 ll
689 cd ..
690 ll
691 cd MysqlBacup/
692 ll
693 cd unified
694 ll
695 ls -lr
696 sl -ltr
697 ls -ltr
698 scp unified_2016-01-14_04h00.sql.
699 ifconfig
700 echo PAESSHSTART;df -P;echo PAESSHEND
701 df -h
702 crontab -e
703 ssh 172.31.22.159
704 echo PAESSHSTART;df -P;echo PAESSHEND
705 cd /usr/syncservice/src
706 javac Oracle2sql.java
707 crontab -l
708 crontab -e
709 echo PAESSHSTART;df -P;echo PAESSHEND
710 df -h
711 mysql -u root -p
712 df -h
713 echo PAESSHSTART;df -P;echo PAESSHEND
714 ifconfig
715 df -h
716 cd /
717 ll
718 du -sh *
719 df -h
720 cd /var/
721 l;
722 ll
723 du -sh *
724 cd lib/
725 ll
726 du -sh *
727 cd mysql
728 ll
729 vim /etc/my.cnf
730 mysql -u root -p
731 ls -ltr
732 mysql -u root -p
733 ls -ltr
734 df -h
735 mysql -u root -p
736 ll
737 df -h
738 vim /etc/my.cnf
739 mysql -u root -p
740 echo PAESSHSTART;df -P;echo PAESSHEND
741 df -h
742 mysql -u root -p
743 echo PAESSHSTART;df -P;echo PAESSHEND
744 df -h
745 echo PAESSHSTART;df -P;echo PAESSHEND
746 ifcofnig
747 ifconfig
748 df -h
749 mysql -u root -p
750 df -h
751 cd /db/
752 ll
753 cd bckup/
754 ll
755 cd ..
756 cd mysql/
757 ll
758 pwd
759 vim /etc/my.cnf
760 crontab -l
761 vim /home/MySQLdump.sh
762 cd /home/MysqlBacup/unified
763 ls -ltr
764 gunzip unified_2016-02-04_04h00.sql.
765 ll
766 mysql -u root -p unifiedtest < unified_2016-02-04_04h00.sql
767 echo PAESSHSTART;df -P;echo PAESSHEND
768 cd /usr/syncservice/src
769 javac Oracle2sql.java
770 echo PAESSHSTART;df -P;echo PAESSHEND
771 /etc/init.d/mysql restart
772 /etc/init.d/mysql status
773 mysql -u root -p
774 df -h
775 uptime
776 top -d 2
777 mysql -u root -p
778 echo PAESSHSTART;df -P;echo PAESSHEND
779 cat .ssh/authorized_keys
780 echo PAESSHSTART;df -P;echo PAESSHEND
781 top -d 2
782 echo PAESSHSTART;df -P;echo PAESSHEND
783 ls -ltr
784 mysql -u root -p
785 cd /home/My
786 cd /home/MySQLdump
787 cd /home/MysqlBacup/
788 ll
789 cd unified
790 ls -ltr
791 mysql -u root -p unifiedtest < unified_2016-02-04_04h00.sql
792 echo PAESSHSTART;df -P;echo PAESSHEND
793 ifconfig
794 exit
795 echo PAESSHSTART;df -P;echo PAESSHEND
796 mysql -u root -p
797 echo PAESSHSTART;df -P;echo PAESSHEND
798 mysql -u root -p
799 echo PAESSHSTART;df -P;echo PAESSHEND
800 df -h
801 mysql -u root -p
802 echo PAESSHSTART;df -P;echo PAESSHEND
803 free -m
804 top -d 2
805 cat /proc/cpuinfo
806 df -h
807 cat /etc/redhat-release
808 uname a-
809 uname -a
810 echo PAESSHSTART;df -P;echo PAESSHEND
811 cat .ssh/authorized_keys
812 echo PAESSHSTART;df -P;echo PAESSHEND
813 mysql -u root -p
814 exit
815 echo PAESSHSTART;df -P;echo PAESSHEND
816 crontab -l
817 echo PAESSHSTART;df -P;echo PAESSHEND
818 cat /proc/cpuinfo
819 ssh root@172.31.22.60
820 exit
821 echo PAESSHSTART;df -P;echo PAESSHEND
822 route -n
823 vim /etc/sysconfig/network-
824 exit
825 echo PAESSHSTART;df -P;echo PAESSHEND
826 route -n
827 exit
828 echo PAESSHSTART;df -P;echo PAESSHEND
829 route -n
830 ssh root@172.31.22.60
831 ssh root@172.31.22.160
832 exit
833 echo PAESSHSTART;df -P;echo PAESSHEND
834 df -kh
835 ssh root@172.31.22.60
836 exit
837 echo PAESSHSTART;df -P;echo PAESSHEND
838 crontab -l
839 echo PAESSHSTART;df -P;echo PAESSHEND
840 cd /
841 ll
842 df -h
843 cd /home/
844 ll
845 cd MysqlBacup/
846 l
847 ls -ltr
848 cd common_hd/
849 ls -ltr
850 cd ..
851 ls -ltr
852 cd unified
853 ls -ltr
854 scp unified_2016-03-14_04h00.sql.
855 echo PAESSHSTART;df -P;echo PAESSHEND
856 mysqldump -u root -p unified >/home/unified_15march.sql
857 cd /home
858 rsync -r unified_15march.sql 172.31.22.91:/home
859 echo PAESSHSTART;df -P;echo PAESSHEND
860 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
861 df -h
862 mysql -u root -p
863 df -h
864 echo PAESSHSTART;df -P;echo PAESSHEND
865 crontab -ll
866 crontab -l
867 crontab -e
868 echo PAESSHSTART;df -P;echo PAESSHEND
869 mysql -u root -p unififed
870 mysql -u root -p unified
871 echo PAESSHSTART;df -P;echo PAESSHEND
872 mysql -u root -p unified
873 echo PAESSHSTART;df -P;echo PAESSHEND
874 df -h
875 du -sh *
876 df -h
877 mysql -u root -p
878 df -h
879 echo PAESSHSTART;df -P;echo PAESSHEND
880 mysql -u root -p
881 echo PAESSHSTART;df -P;echo PAESSHEND
882 telnet 172.29.10.105 1521
883 echo PAESSHSTART;df -P;echo PAESSHEND
884 telnet 172.29.10.117 1521
885 telnet 172.29.10.105 1521
886 echo PAESSHSTART;df -P;echo PAESSHEND
887 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
888 echo PAESSHSTART;df -P;echo PAESSHEND
889 df -h
890 mysql -u root -p
891 echo PAESSHSTART;df -P;echo PAESSHEND
892 crontab -l
893 echo PAESSHSTART;df -P;echo PAESSHEND
894 mysql -u root -p
895 echo PAESSHSTART;df -P;echo PAESSHEND
896 crontab -l
897 echo PAESSHSTART;df -P;echo PAESSHEND
898 crontab -e
899 echo PAESSHSTART;df -P;echo PAESSHEND
900 crontab -e
901 sh /usr/syncservice/src/nexg_tv.
902 echo PAESSHSTART;df -P;echo PAESSHEND
903 crontab -e
904 crontab -l
905 sh /usr/syncservice/src/nexg_tv.
906 echo PAESSHSTART;df -P;echo PAESSHEND
907 mysql -u root -p
908 echo PAESSHSTART;df -P;echo PAESSHEND
909 cd /usr/syncservice/src
910 javac Oracle2sql.java
911 javac Oracle2sql_vod_dect.java
912 df -h
913 mysql -u root -p
914 df -h
915 java -classpath .:/usr/syncservice/src/mysql-
916 service memcached relaod
917 service memcached reload
918 service memcache reload
919 echo PAESSHSTART;df -P;echo PAESSHEND
920 ps -wef |grep java|grep -v grep
921 echo PAESSHSTART;df -P;echo PAESSHEND
922 crontab -l
923 crontab -e
924 crontab -l
925 echo PAESSHSTART;df -P;echo PAESSHEND
926 crontab -l
927 echo PAESSHSTART;df -P;echo PAESSHEND
928 mysql -u root -p
929 echo PAESSHSTART;df -P;echo PAESSHEND
930 df -h
931 top
932 mysql -u root -p
933 date
934 mysql -u root -p
935 echo PAESSHSTART;df -P;echo PAESSHEND
936 crontab -e
937 echo PAESSHSTART;df -P;echo PAESSHEND
938 top
939 sh /usr/syncservice/src/nexg_tv.
940 echo PAESSHSTART;df -P;echo PAESSHEND
941 crontab -l
942 crontab -e
943 echo PAESSHSTART;df -P;echo PAESSHEND
944 df -h
945 du -sh*
946 df -h
947 echo PAESSHSTART;df -P;echo PAESSHEND
948 crontab -e
949 echo PAESSHSTART;df -P;echo PAESSHEND
950 crontab -e
951 crontab -l
952 echo PAESSHSTART;df -P;echo PAESSHEND
953 df -h
954 mysqldump -u root -p --no-data unified>unifiedstructuredump.
955 mysql -u root -p
956 echo PAESSHSTART;df -P;echo PAESSHEND
957 cd /usr/syncservice/src
958 javac Oracle2sqlAnalytics.java
959 crontab -l
960 crontab -e
961 echo PAESSHSTART;df -P;echo PAESSHEND
962 crontab -l
963 ps -wef |grep nexg_tv.run
964 ps -wef |grep nexg_tv.run |grep -v grep
965 sh /usr/syncservice/src/nexg_tv.
966 echo PAESSHSTART;df -P;echo PAESSHEND
967 rpm -qa |grep MySQL
968 ifcofnig
969 ifconifg
970 ifconfig
971 rpm -qa |grep MySQL
972 mysql -u root -p
973 cat /etc/resolv.conf
974 cd /var/log/mysql
975 ls -ltr
976 echo PAESSHSTART;df -P;echo PAESSHEND
977 cd /db/
978 ll
979 du -sh mysqlbak/
980 cd /root/tools/
981 ll
982 vim /etc/my.cnf
983 du -sh /db/mysql/
984 df -h
985 cp -prv /db/mysql /db/mysqlbak
986 cd
987 rpm -qa |grep mysql
988 rpm -qa |grep MySQL
989 /etc/init.d/mysql stop
990 rpm -e MySQL-server-advanced MySQL-shared-advanced MySQL-embedded-advanced MySQL-test-advanced MySQL-client-advanced MySQL-devel-advanced
991 rpm -qa |grep MySQL
992 cd tools/
993 ll
994 rpm -Uvn *
995 rpm -Uvh *
996 /etc/init.d/mysql start
997 msyql -u root -p
998 mysql -u root -p
999 echo PAESSHSTART;df -P;echo PAESSHEND
1000 history
[root@INDB-0-2 ~]# history
1 echo PAESSHSTART;df -P;echo PAESSHEND
2 mysqldump -u root -p unified >/home/MysqlBacup/unified_59/
3 cd /home/MysqlBacup/unified_59
4 rsync -r unified_ev_10jult_15.sql 172.31.22.60:/home/
5 echo PAESSHSTART;df -P;echo PAESSHEND
6 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
7 mysqldump -u root -p unified >/home/MysqlBacup/unified_59/
8 cd /home/MysqlBacup/unified_59
9 rsync -r unified_12JULY.sql 172.31.22.60:/home
10 echo PAESSHSTART;df -P;echo PAESSHEND
11 mysqldump -u root -p unified >/home/MysqlBacup/unified_59/
12 cd /home/MysqlBacup/unified_59
13 rsync -r unified_12JULY.sql 172.31.22.60:/home
14 echo PAESSHSTART;df -P;echo PAESSHEND
15 mysqldump -u root -p unified >/home/MysqlBacup/unified_59/
16 echo PAESSHSTART;df -P;echo PAESSHEND
17 df -h
18 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
19 echo PAESSHSTART;df -P;echo PAESSHEND
20 mysql -u root -p
21 echo PAESSHSTART;df -P;echo PAESSHEND
22 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
23 df -h
24 mysql -u root -p
25 df -h
26 echo PAESSHSTART;df -P;echo PAESSHEND
27 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
28 echo PAESSHSTART;df -P;echo PAESSHEND
29 df -h
30 echo PAESSHSTART;df -P;echo PAESSHEND
31 date
32 echo PAESSHSTART;df -P;echo PAESSHEND
33 netstat -an |grep :3306 |wc -l
34 mysql -u root -p
35 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
36 echo PAESSHSTART;df -P;echo PAESSHEND
37 mysqldump -u root -p unified >/home/MysqlBacup/unified_59/
38 mysql -u root -p
39 echo PAESSHSTART;df -P;echo PAESSHEND
40 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
41 ssh 172.31.22.58
42 echo PAESSHSTART;df -P;echo PAESSHEND
43 mysqldump -u root -p staging >/home/staging_23July_15.sql
44 echo PAESSHSTART;df -P;echo PAESSHEND
45 df -h
46 mysql -u root -p
47 df -h
48 ssh 172.31.22.58
49 echo PAESSHSTART;df -P;echo PAESSHEND
50 df-h
51 df -h
52 echo PAESSHSTART;df -P;echo PAESSHEND
53 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
54 echo PAESSHSTART;df -P;echo PAESSHEND
55 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
56 echo PAESSHSTART;df -P;echo PAESSHEND
57 uname -a
58 echo PAESSHSTART;df -P;echo PAESSHEND
59 mysqldump -u root -p -R >/home/proc1.sql
60 mysqldump -u root -p unified --routines --triggers >/home/proc1.sql
61 mysqldump --routines --no-create-info --no-data --no-create-db --skip-opt unified > >/home/proc1.sql
62 mysqldump --routines --no-create-info --no-data --no-create-db --skip-opt unified > /home/proc1.sql
63 mysqldump -u root -p --routines --no-create-info --no-data --no-create-db --skip-opt unified > /home/proc1.sql
64 echo PAESSHSTART;df -P;echo PAESSHEND
65 df -h
66 echo PAESSHSTART;df -P;echo PAESSHEND
67 mysql -u root -p
68 ps ax |grep mysql
69 service mysql stop
70 service mysql start
71 mysql -u root -p
72 mysqldump -u root -p unified >/home/unified_3aug_15.sql
73 cd /home
74 rsync -r unified_3aug_15.sql 172.31.22.59:/home
75 mysql -u root -p
76 mysqldump -u root -p unified >/home/unified_3aug_15.sql
77 rsync -r unified_3aug_15.sql 172.31.22.58:/home
78 mysql -u root -p
79 rsync -r unified_3aug_15.sql 172.31.22.91:/home
80 mysqldump -u root -p unified tbl_registered_users tbl_registered_users_hd tbl_registered_users_hd_main tbl_registered_users_main tbl_registered_users_sd >/home/uni_tbl_3aug.sql
81 rsunc -r uni_tbl_3aug.sql 172.31.22.58:/home/uni_tbl_
82 rsync -r uni_tbl_3aug.sql 172.31.22.58:/home/uni_tbl_
83 mysql -u root -p
84 echo PAESSHSTART;df -P;echo PAESSHEND
85 sh /usr/syncservice/src/epgsync.
86 echo PAESSHSTART;df -P;echo PAESSHEND
87 cd
88 cd /home/MysqlBacup/unified_59
89 rsync -r 172.31.22.45:/home/mysqlbackup
90 rsync -r unified_592015-08-06_04h01.
91 echo PAESSHSTART;df -P;echo PAESSHEND
92 df -h
93 echo PAESSHSTART;df -P;echo PAESSHEND
94 mysqldump -u root -p --structure unified >/home/unified_structure.sql
95 mysqldump -u root -p --no-data unified >/home/unified_structure.sql
96 echo PAESSHSTART;df -P;echo PAESSHEND
97 crontab -e
98 sh /usr/syncservice/src/epgsync.
99 echo PAESSHSTART;df -P;echo PAESSHEND
100 df -h
101 mysql -u root -p
102 echo PAESSHSTART;df -P;echo PAESSHEND
103 mysql -u root -p
104 echo PAESSHSTART;df -P;echo PAESSHEND
105 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
106 echo PAESSHSTART;df -P;echo PAESSHEND
107 df -h
108 mysql -u root -p
109 echo PAESSHSTART;df -P;echo PAESSHEND
110 mysqldump -u root -p --no-data unified >/home/unified_structure_
111 echo PAESSHSTART;df -P;echo PAESSHEND
112 df -h
113 echo PAESSHSTART;df -P;echo PAESSHEND
114 mysqldump -u root -p unified >/home/MysqlBacup/unified/
115 cd /home/MysqlBacup/unified
116 rsync -r unified_17Aug.sql 172.31.22.58:/home/
117 mysql -u root -p
118 echo PAESSHSTART;df -P;echo PAESSHEND
119 df -h
120 mysqldump -u root -p unified ws_vods ws_subcategory ws_channel ws_category VOD_METADATA VIEW_VOD_MASTER view_vod_detail VIEW_SUBCAT_MASTER view_subcat_detail VIEW_CATEGORY_MASTER view_category_detail version_summary version >/home/unified_table_17Aug_15.
121 cd /home
122 rsync -r unified_table_17Aug_15.sql 172.31.22.58:/home
123 echo PAESSHSTART;df -P;echo PAESSHEND
124 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
125 echo PAESSHSTART;df -P;echo PAESSHEND
126 mysqldump -u root -p unified >/home/unified_19aug.sql
127 cd home
128 cd /home
129 rsync -r unified_19aug.sql 172.31.22.58:/home
130 mysql -u root -p
131 echo PAESSHSTART;df -P;echo PAESSHEND
132 df -h
133 mysqldump -u rooot -p unified >/home/unified_19Aug_15.sql
134 mysqldump -u root -p unified >/home/unified_19Aug.sql
135 cd /home
136 rsync -r unified_19Aug.sql 172.31.22..58:/home
137 rsync -r unified_19Aug.sql 172.31.22.58:/home
138 mysql -u root -p
139 echo PAESSHSTART;df -P;echo PAESSHEND
140 mysql -u root -p
141 echo PAESSHSTART;df -P;echo PAESSHEND
142 mysqldump -u root -p unified >/home/unified_20Aug.sql
143 cd /home
144 rsync -r unified_20Aug.sql -r 172.31.22.58:/home
145 df -h
146 mysql -u root -p
147 echo PAESSHSTART;df -P;echo PAESSHEND
148 df -h
149 echo PAESSHSTART;df -P;echo PAESSHEND
150 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
151 echo PAESSHSTART;df -P;echo PAESSHEND
152 df -h
153 mysql -u root -p
154 df -h
155 echo PAESSHSTART;df -P;echo PAESSHEND
156 ps ax |grep mysql
157 kill -9 4399
158 ps ax |grep mysql
159 echo PAESSHSTART;df -P;echo PAESSHEND
160 mysql -u root -p
161 echo PAESSHSTART;df -P;echo PAESSHEND
162 service mysql stop
163 service mysql start
164 mysqldump -u root -p unified >/home/unified_25Aug_15.sql
165 rsync -r unified_25Aug_15.sql 172.31.22.58:/home/
166 rsync -r /home/unified_25Aug_15.sql 172.31.22.58:/home/
167 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
168 echo PAESSHSTART;df -P;echo PAESSHEND
169 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
170 df -h
171 echo PAESSHSTART;df -P;echo PAESSHEND
172 cat CPUinfo
173 /cat/cpuinfo
174 echo PAESSHSTART;df -P;echo PAESSHEND
175 crontab -e
176 echo PAESSHSTART;df -P;echo PAESSHEND
177 sh /usr/syncservice/src/epgsync.
178 crontab -e
179 echo PAESSHSTART;df -P;echo PAESSHEND
180 sh /usr/syncservice/src/epgsync.
181 ssh 172.31.22.159
182 echo PAESSHSTART;df -P;echo PAESSHEND
183 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
184 df -h
185 show binary logs\G;
186 mysql -u root -p
187 df -h
188 echo PAESSHSTART;df -P;echo PAESSHEND
189 mysqldump -u root -p unified CHANNEL_DETAIL_VIEW CHANNEL_RTSP_DETAILS_VIEW PACKAGE_CHANNEL_MAP_VIEW PACKAGE_MASTER_VIEW VIEW_VOD_MASTER VOD_METADATA ws_vods ws_category ws_channel ws_subcategory >/home/unified_2SEP_
190 mysql -u root -p
191 mysqldump -u root -p unified >/home/unified_2SEP_
192 mysql -u root -p
193 echo PAESSHSTART;df -P;echo PAESSHEND
194 df -h
195 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
196 df -h
197 mysql -u root -p
198 df -h
199 mysql -u root -p
200 df -h
201 echo PAESSHSTART;df -P;echo PAESSHEND
202 df -h
203 free -m
204 sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
205 free -m
206 df -h
207 ssh 172.31.22.58
208 echo PAESSHSTART;df -P;echo PAESSHEND
209 mysqldump -u root -p unified PACKAGE_CHANNEL_MAP_VIEW PACKAGE_MASTER_VIEW >/home/unified_2table.sql
210 mysql -u root -p
211 echo PAESSHSTART;df -P;echo PAESSHEND
212 df
---------------------------------------------------------------------------------------------------------------------
mysqldump
#mysqldump -u root -proot123 aircel > /data/MysqlBacup/aircel/aircel_$(date +\%Y-\%m-\%d_\%Hh\%M).sql
#mysqldump -u root -proot123 ondeck > /data/MysqlBacup/ondeck/ondeck_$(date +\%Y-\%m-\%d_\%Hh\%M).sql
#mysqldump -u root -proot123 common_hd > /data/MysqlBacup/common_hd/common_hd_$(date +\%Y-\%m-\%d_\%Hh\%M).sql
#mysqldump -u root -proot123 vid_dth > /data/MysqlBacup/VIDDTH/Videocon_dth_$(date +\%Y-\%m-\%d_\%Hh\%M).sql
#mysqldump -u neo -h172.31.22.58 -padmin123 unified > /data/MysqlBacup/unified/unified_$(date +\%Y-\%m-\%d_\%Hh\%M).sql
mysqldump -u root -hlocalhost -proot123 unified_push |gzip > /home/MysqlBacup/push/unified_push_159server/unified_push_nexG$(date +\%Y-\%m-\%d_\%Hh\%M).sql.gz
mysqldump -u root -hlocalhost -proot123 pushnotification_airtel_hd |gzip > /home/MysqlBacup/push/airtel_hd_push_159/airtel_hd_push$(date +\%Y-\%m-\%d_\%Hh\%M).sql.gz
mysqldump -u root -hlocalhost -proot123 airdth_push |gzip > /home/MysqlBacup/push/airtel_dth_push_159/airdth_push$(date +\%Y-\%m-\%d_\%Hh\%M).sql.gz
mysqldump -u root -hlocalhost -proot123 nokiapush |gzip > /home/MysqlBacup/push/nokiapush_159/nokiapush$(date +\%Y-\%m-\%d_\%Hh\%M).sql.gz
No comments:
Post a Comment