Mysqldump Unix commands

-

 export all Databases

 

NOT A ROOT USER

mysqldump –all-databases> database.sql

 

mysqldump –all-databases -uuser -ppassword> database.sql

 

mysqldump –all-databases –skip-lock-tables -u user-ppassword > Sept2018database.sql

Comments

Post a Comment

Popular posts from this blog

How to fix pgDump dbeaver ?

-
Image
  DBeaver Configuration : Postgres and MacOs 1 . Install postgres 2. Find path to pg_dump /Applications/Postgres.app/Contents/Versions/latest/bin 3. configure client (Dbeaver) to add hidden files -> command + shift + G paste  /Applications/Postgres.app/Contents/Versions/latest/bin and select the folder 4. Voila !
Read more

How to fix – DBeaver Native client is not specified for connection ?

-
Image
  Native client is not specified for connection Download Mysql or Postgres or (appropriate database ) Server Do the step of DBEAVER client configuration Find bib files for mysql – open terminal and execute followin command which mysql --> /usr/local/bin/mysql if using a mac to allocate mysql server bin files location command + shift + G Paste the path in there such as /usr/local/mysql-5.7.28-macos10.14-x86_64/bin/ Voila you can enjoy most amazing feature of DBeaver  !
Read more