What
A quick note as I had difficulty finding a clear answer on this. I need a cron job setup where the permissions for a database user is required to do a backup (reading and copying data from a LIVE database) to a copy of the database (inaccessible via other users).

How?
I want to list 2 methods here. One to create a .sql file of the backup but another to copy the contents to a copy of the database accessible only by root and and this database "backuper" user. For both methods, I grant the following to the user doing the backup on the database I want a backup of:
GRANT SELECT, LOCK TABLES, EVENT, INDEX, REFERENCES, TRIGGER, SHOW VIEW ON 'my_live_db'.* TO 'mybackupuser'@'localhost' IDENTIFIED BY 'mybackupuser';

 I've been told of two ways of running a downloaded .RUN file.

Note: Bear in mind that the following is all case-sensitive.

Through the terminal server

  1. Download the .RUN file to your desktop
  2. Open a terminal by going to Application > Accessories > Terminal
  3. Type 'CD Desktop' to go to your desktop folder
  4. Type 'LS' just to check the .RUN file is in this one
  5. Type 'sudo sh nameoffile.run'

Through the Gnome GUI

  1. Right-click on the file you downloaded
  2. Select 'Properties'
  3. Select the 'Permissions' tab
  4. Tick the 'Execute' checkbox

Conclusion

The solution using the terminal worked for me but the second one using Gnome didn't.


1. If someone wants to use Ubuntu as a home media pc connected to a
tv, there is the problem of overscan; consumer tv's crop off the
border around the image. How does Ubuntu intend to officially solve
this? Right now LinuxMCE has it's own method for doing this so the
LMCE UI is never cropped off, but when the user switches back to
Ubuntu's gnome desktop, the top nav bar is cut off if he's using a
normal tv and not a pc monitor. I'd like to have 1 screen adjustment
tool that correctly adjusts both the lmce desktop and the main ubuntu
desktop, so even when using the Ubuntu desktop on a TV, the top nav
isn't cropped.  Any ideas?


Related Articles

Joes Revolver Map

Joes Word Cloud

zoho   windows   following   license   database   name   server   user   parameter   joomla   need   used   added   would   first   program   page   search   work   value   script   could   system   date   error   table   using   file   google   note   time   uploaded   display   select   solution   find   list   content   files   copy   version   source   site   where   mysql   report   website   html   data   code   JoelLipman.Com

Accreditation

Badge - Certified Zoho Creator Associate
Badge - Certified Zoho Creator Associate
© 2021 Joel Lipman .com. All Rights Reserved.