MySQL Database Backup Using CLI

 Backup MySQL using terminal

mysqldump -u [user name] –p [password] [options] [database_name]  > [dumpfilename.sql]

mysqldump -v -u appuser–p  mydb > mydbbackup.sql

Comments

Post a Comment

Popular posts from this blog

python-docx | docx | No module named 'exceptions'

If the project is using docx as a reference and installed docx package instead of the   python-docx it will lead to following error ModuleNotFoundError: No module named 'exceptions' To fix this error install python-docx and remove docx. pip install python-docx  To install python-docx package Official Documentation available here: https://pypi.org/project/python-docx/ pip uninstall docx To remove installed docx package
Read more

Fixing TortoiseSVN icons overlay in Windows 10

Image
TortoiseSVN icons overlay (Shell icon overlay) may disappear after installing a software which uses same type of icon overlays like OneDrive, Dropbox. Editing the order of overlay icon entries in windows registry can fix the problem. These screen shorts are from a windows 10 desktop with OneDrive and Dropbox. Step 1. Start Registry editor using run window Step 2. Backup registry to disk. Step 3. Go to following location in registry HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\ShellIconOverlayIdentifiers Step 4 . Rename entries Expanding ShellIconOverlayIdentifiers tree lists all overlay icon entries. Here tortoisesvn icon is displayed after other items (Dropbox). Rename tortoise overlay icon entries by adding more white spaces as a prefix. Items before editing In above example, names sorted in ascending order. Adding white spaces at the beginning of the text will change the order of the entries after a restart. Step 5. Restart and...
Read more

MySQL 8 User creation and grant privileges

Environment MySQL Version: 8.0.21 OS: CentOS 7 Minimal install 64bit MySQL User MySQL user can be created using by the following command in MySQL console CREATE USER 'user1'@'localhost' IDENTIFIED BY 'password1'; If the application connects to MySQL service from a specific IP address application server IP address can be specified in create user statement. CREATE USER 'user1'@'192.168.1.1' IDENTIFIED BY 'password1'; If MySQL needs to connect from different sources using a single username and password. Wildcard(%) can be used instead of an IP address. CREATE USER 'user1'@'%' IDENTIFIED BY 'password1'; % is a wildcard - It can be used as  '%.domain.com' or '%.123.123.123'  To grant privileges to a database, the user must create a database.  Following command granting privileges to a database with name 'school' GRANT ALL ON school.* TO 'user1'@'192.168.1.1'; For localhost connect...
Read more