You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cloudstack.apache.org by GitBox <gi...@apache.org> on 2021/12/02 15:17:02 UTC

[GitHub] [cloudstack-documentation] GabrielBrascher opened a new pull request #255: Fix mysqldump missing 'Grave Accent'

GabrielBrascher opened a new pull request #255:
URL: https://github.com/apache/cloudstack-documentation/pull/255


   Fix mysqldump command in the ["Database Preparation"](https://docs.cloudstack.apache.org/en/4.16.0.0/upgrading/upgrade/upgrade-4.15.html#database-preparation) section.
   
   Nowadays it is:
   ```
   $ mysqldump -u root -p -R cloud > cloud-backup_`date '+%Y-%m-%d'.sql
   $ mysqldump -u root -p cloud_usage > cloud_usage-backup_`date '+%Y-%m-%d'.sql
   ```
   This won't work as it is missing a grave accent (`) in ``date '+%Y-%m-%d'.`.
   Should be:
   ```
   $ mysqldump -u root -p -R cloud > cloud-backup_`date '+%Y-%m-%d'`.sql
   $ mysqldump -u root -p cloud_usage > cloud_usage-backup_`date '+%Y-%m-%d'`.sql
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@cloudstack.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [cloudstack-documentation] weizhouapache commented on pull request #255: Fix mysqldump missing 'Grave Accent'

Posted by GitBox <gi...@apache.org>.
weizhouapache commented on pull request #255:
URL: https://github.com/apache/cloudstack-documentation/pull/255#issuecomment-984758270


   @GabrielBrascher I know only date is used in old docs. would it be better to use date and time like the following ?
   ```
   $ echo cloud-backup_$(date +%Y-%m-%d-%H%M%S).sql
   cloud-backup_2021-12-02-165439.sql
   
   ```
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@cloudstack.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [cloudstack-documentation] blueorangutan commented on pull request #255: Fix mysqldump missing 'Grave Accent'

Posted by GitBox <gi...@apache.org>.
blueorangutan commented on pull request #255:
URL: https://github.com/apache/cloudstack-documentation/pull/255#issuecomment-984756341


   Doc build preview: http://qa.cloudstack.cloud/docs/WIP-PROOFING/pr/255. (SL-JID 173)


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@cloudstack.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [cloudstack-documentation] blueorangutan commented on pull request #255: Fix mysqldump missing 'Grave Accent'

Posted by GitBox <gi...@apache.org>.
blueorangutan commented on pull request #255:
URL: https://github.com/apache/cloudstack-documentation/pull/255#issuecomment-984778013


   Doc build preview: http://qa.cloudstack.cloud/docs/WIP-PROOFING/pr/255. (SL-JID 174)


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@cloudstack.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [cloudstack-documentation] GabrielBrascher commented on pull request #255: Fix mysqldump missing 'Grave Accent'

Posted by GitBox <gi...@apache.org>.
GabrielBrascher commented on pull request #255:
URL: https://github.com/apache/cloudstack-documentation/pull/255#issuecomment-984748132


   @rhtyd good point, `$(cmd)` looks like a better option indeed.
   I will update the changes, thanks!


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@cloudstack.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [cloudstack-documentation] blueorangutan commented on pull request #255: Fix mysqldump missing 'Grave Accent'

Posted by GitBox <gi...@apache.org>.
blueorangutan commented on pull request #255:
URL: https://github.com/apache/cloudstack-documentation/pull/255#issuecomment-984755472


   @GabrielBrascher a Jenkins job has been kicked to build the document. I'll keep you posted as I make progress.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@cloudstack.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [cloudstack-documentation] blueorangutan commented on pull request #255: Fix mysqldump missing 'Grave Accent'

Posted by GitBox <gi...@apache.org>.
blueorangutan commented on pull request #255:
URL: https://github.com/apache/cloudstack-documentation/pull/255#issuecomment-984726051


   Doc build preview: http://qa.cloudstack.cloud/docs/WIP-PROOFING/pr/255. (SL-JID 172)


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@cloudstack.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [cloudstack-documentation] rhtyd edited a comment on pull request #255: Fix mysqldump missing 'Grave Accent'

Posted by GitBox <gi...@apache.org>.
rhtyd edited a comment on pull request #255:
URL: https://github.com/apache/cloudstack-documentation/pull/255#issuecomment-984741221


   @GabrielBrascher would it be safer to use the `$(cmd)` syntax? Also improves readability over `?


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@cloudstack.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [cloudstack-documentation] rhtyd commented on pull request #255: Fix mysqldump missing 'Grave Accent'

Posted by GitBox <gi...@apache.org>.
rhtyd commented on pull request #255:
URL: https://github.com/apache/cloudstack-documentation/pull/255#issuecomment-984741221


   @GabrielBrascher would it be safer to use the `$(cmd)` syntax? Also improves readability over `\``?


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@cloudstack.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [cloudstack-documentation] GabrielBrascher commented on pull request #255: Fix mysqldump missing 'Grave Accent'

Posted by GitBox <gi...@apache.org>.
GabrielBrascher commented on pull request #255:
URL: https://github.com/apache/cloudstack-documentation/pull/255#issuecomment-984776677


   Updated to @weizhouapache suggestions. 
   
   @blueorangutan docbuild


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@cloudstack.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [cloudstack-documentation] rhtyd merged pull request #255: Fix mysqldump missing 'Grave Accent'

Posted by GitBox <gi...@apache.org>.
rhtyd merged pull request #255:
URL: https://github.com/apache/cloudstack-documentation/pull/255


   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@cloudstack.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [cloudstack-documentation] blueorangutan commented on pull request #255: Fix mysqldump missing 'Grave Accent'

Posted by GitBox <gi...@apache.org>.
blueorangutan commented on pull request #255:
URL: https://github.com/apache/cloudstack-documentation/pull/255#issuecomment-984776996


   @GabrielBrascher a Jenkins job has been kicked to build the document. I'll keep you posted as I make progress.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@cloudstack.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [cloudstack-documentation] GabrielBrascher commented on pull request #255: Fix mysqldump missing 'Grave Accent'

Posted by GitBox <gi...@apache.org>.
GabrielBrascher commented on pull request #255:
URL: https://github.com/apache/cloudstack-documentation/pull/255#issuecomment-984723954


   @blueorangutan docbuild


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@cloudstack.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [cloudstack-documentation] blueorangutan commented on pull request #255: Fix mysqldump missing 'Grave Accent'

Posted by GitBox <gi...@apache.org>.
blueorangutan commented on pull request #255:
URL: https://github.com/apache/cloudstack-documentation/pull/255#issuecomment-984725162


   @GabrielBrascher a Jenkins job has been kicked to build the document. I'll keep you posted as I make progress.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@cloudstack.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [cloudstack-documentation] GabrielBrascher commented on pull request #255: Fix mysqldump missing 'Grave Accent'

Posted by GitBox <gi...@apache.org>.
GabrielBrascher commented on pull request #255:
URL: https://github.com/apache/cloudstack-documentation/pull/255#issuecomment-984765719


   @weizhouapache I assume that as the upgrade is a process that is done in one day it would not be needed, I don't imagine more than one backup at a day at least for the given operaiton.
   
   But it looks like a good "safety" command in case someone backs up the DB before and after the upgrade and ends up overriding the first backup.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@cloudstack.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [cloudstack-documentation] rhtyd commented on pull request #255: Fix mysqldump missing 'Grave Accent'

Posted by GitBox <gi...@apache.org>.
rhtyd commented on pull request #255:
URL: https://github.com/apache/cloudstack-documentation/pull/255#issuecomment-985234552


   Lgtm


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@cloudstack.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [cloudstack-documentation] GabrielBrascher commented on pull request #255: Fix mysqldump missing 'Grave Accent'

Posted by GitBox <gi...@apache.org>.
GabrielBrascher commented on pull request #255:
URL: https://github.com/apache/cloudstack-documentation/pull/255#issuecomment-984754671


   @blueorangutan docbuild


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@cloudstack.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org