Database Archives - VIONBLOG

MySQL

<img width="300" height="300" alt="MySQL" loading="lazy" data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" sizes="(max-width: 300px) 100vw, 300px" data-src="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif" class="card-img-top shadow-sm wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="300" height="300" alt="MySQL" loading="lazy" data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" sizes="(max-width: 300px) 100vw, 300px" data-src="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif" class="card-img-top shadow-sm wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="300" height="300" alt="MySQL" loading="lazy" data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" sizes="(max-width: 300px) 100vw, 300px" data-src="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif" class="card-img-top shadow-sm wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="300" height="300" alt="MySQL" loading="lazy" data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" sizes="(max-width: 300px) 100vw, 300px" data-src="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif" class="card-img-top shadow-sm wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="300" height="300" src="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif" class="card-img-top shadow-sm wp-post-image" alt="MySQL" loading="lazy" srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" sizes="(max-width: 300px) 100vw, 300px" />

Setup MySQL Master-Slave Replication on Ubuntu with Existing Data

By Nikola Stojanoski Posted on December 1, 2019

MySQL

<img width="300" height="300" alt="MySQL" loading="lazy" data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" sizes="(max-width: 300px) 100vw, 300px" data-src="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif" class="card-img-top shadow-sm wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="300" height="300" alt="MySQL" loading="lazy" data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" sizes="(max-width: 300px) 100vw, 300px" data-src="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif" class="card-img-top shadow-sm wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="300" height="300" alt="MySQL" loading="lazy" data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" sizes="(max-width: 300px) 100vw, 300px" data-src="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif" class="card-img-top shadow-sm wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="300" height="300" alt="MySQL" loading="lazy" data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" sizes="(max-width: 300px) 100vw, 300px" data-src="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif" class="card-img-top shadow-sm wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="300" height="300" src="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif" class="card-img-top shadow-sm wp-post-image" alt="MySQL" loading="lazy" srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" sizes="(max-width: 300px) 100vw, 300px" />

MySQL Maintenance Tasks

By Nikola Stojanoski Posted on August 15, 2018

MySQL

<img width="300" height="300" alt="MySQL" loading="lazy" data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" sizes="(max-width: 300px) 100vw, 300px" data-src="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif" class="card-img-top shadow-sm wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="300" height="300" alt="MySQL" loading="lazy" data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" sizes="(max-width: 300px) 100vw, 300px" data-src="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif" class="card-img-top shadow-sm wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="300" height="300" alt="MySQL" loading="lazy" data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" sizes="(max-width: 300px) 100vw, 300px" data-src="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif" class="card-img-top shadow-sm wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="300" height="300" alt="MySQL" loading="lazy" data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" sizes="(max-width: 300px) 100vw, 300px" data-src="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif" class="card-img-top shadow-sm wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="300" height="300" src="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif" class="card-img-top shadow-sm wp-post-image" alt="MySQL" loading="lazy" srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" sizes="(max-width: 300px) 100vw, 300px" />

MySQL Backup and Restore

By Nikola Stojanoski Posted on November 7, 2014

MySQL

<img width="300" height="300" alt="MySQL" loading="lazy" data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" sizes="(max-width: 300px) 100vw, 300px" data-src="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif" class="card-img-top shadow-sm wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="300" height="300" alt="MySQL" loading="lazy" data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" sizes="(max-width: 300px) 100vw, 300px" data-src="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif" class="card-img-top shadow-sm wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="300" height="300" alt="MySQL" loading="lazy" data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" sizes="(max-width: 300px) 100vw, 300px" data-src="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif" class="card-img-top shadow-sm wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="300" height="300" alt="MySQL" loading="lazy" data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" sizes="(max-width: 300px) 100vw, 300px" data-src="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif" class="card-img-top shadow-sm wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="300" height="300" src="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif" class="card-img-top shadow-sm wp-post-image" alt="MySQL" loading="lazy" srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" sizes="(max-width: 300px) 100vw, 300px" />

MySQL Tuning Scripts

By Nikola Stojanoski Posted on July 21, 2013

openerp7 barman

OpenERP Backup and Point-in-time Recovery

By Nikola Stojanoski Posted on April 22, 2013

PHP OCI8

Oracle Instant Client and PHP OCI8 on Debian Squeeze

By Nikola Stojanoski Posted on December 25, 2012

MySQL

<img width="300" height="300" alt="MySQL" loading="lazy" data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" sizes="(max-width: 300px) 100vw, 300px" data-src="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif" class="card-img-top shadow-sm wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="300" height="300" alt="MySQL" loading="lazy" data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" sizes="(max-width: 300px) 100vw, 300px" data-src="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif" class="card-img-top shadow-sm wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="300" height="300" alt="MySQL" loading="lazy" data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" sizes="(max-width: 300px) 100vw, 300px" data-src="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif" class="card-img-top shadow-sm wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="300" height="300" alt="MySQL" loading="lazy" data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" sizes="(max-width: 300px) 100vw, 300px" data-src="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif" class="card-img-top shadow-sm wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="300" height="300" src="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif" class="card-img-top shadow-sm wp-post-image" alt="MySQL" loading="lazy" srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" sizes="(max-width: 300px) 100vw, 300px" />

skip-name-resolve to speed up MySQL and avoid problems

By Nikola Stojanoski Posted on September 18, 2012

MySQL

<img width="300" height="300" alt="MySQL" loading="lazy" data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" sizes="(max-width: 300px) 100vw, 300px" data-src="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif" class="card-img-top shadow-sm wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="300" height="300" alt="MySQL" loading="lazy" data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" sizes="(max-width: 300px) 100vw, 300px" data-src="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif" class="card-img-top shadow-sm wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="300" height="300" alt="MySQL" loading="lazy" data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" sizes="(max-width: 300px) 100vw, 300px" data-src="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif" class="card-img-top shadow-sm wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="300" height="300" alt="MySQL" loading="lazy" data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" sizes="(max-width: 300px) 100vw, 300px" data-src="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif" class="card-img-top shadow-sm wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="300" height="300" src="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif" class="card-img-top shadow-sm wp-post-image" alt="MySQL" loading="lazy" srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" sizes="(max-width: 300px) 100vw, 300px" />

MySQL Full-Text Search with Multiple words

By Nikola Stojanoski Posted on September 17, 2012