migcosta

#https://stackoverflow.com/a/26384329/4970584
#for a quick solution
mysqldump --skip-comments --skip-extended-insert -d --no-data -u root -p dbName1 | sed 's/ AUTO_INCREMENT=[0-9]*\b//'>file1.sql
mysqldump --skip-comments --skip-extended-insert -d --no-data -u root -p dbName2 | sed 's/ AUTO_INCREMENT=[0-9]*\b//'>file2.sql
diff file1.sql file2.sql

#for a more complex solution use https://github.com/dlevsha/compalex

migcosta

<!--[if (gte mso 9)|(IE)]>
<center>
  <table>
    <tr>
      <td width="600">
        <![endif]-->
        <div style="max-width: 600px; margin: 0 auto;">
          <p>This text will be centered and constrained to 600 pixels even on Outlook which does not support max-width CSS</p>
        </div>
        <!--[if mso]>

migcosta

<!--[if (gte mso 9)|(IE)]>
<center style=" background-color:red">
 <table>
   <tr>
     <td width="280">
<![endif]-->
 <div style="max-width:180px; margin:0 auto; background-color:blue">
   <p>this will create a 280px on outlook/IE and a 180px on the other</p>
 </div>
<!--[if (gte mso 9)|(IE)]>

migcosta

#to find your virtual hosts location on apache On (CentOS,Fedora, RHEL)

#1 - Find the httpd location
find / -name "httpd"

#2 - Dump the hosts 
httpd -S
#(-S stands for: "synonym for -t -D DUMP_VHOSTS -D DUMP_RUN_CFG" )

migcosta

<IfModule mod_rewrite.c>
    #redirect local folder to remote folder on a different server
    RedirectMatch  "^/[local-folder-name]/(.*)"  "https://[remote-domain]/[remote-folder-name]/$1"
</IfModule>

migcosta

#find php versions installer
locate bin/php

migcosta

        Options Indexes FollowSymLinks MultiViews
        AllowOverride All
        Order allow,deny
        allow from all

migcosta

Source
https://virtualboxes.org/doc/installing-guest-additions-on-debian/

Login as root;
Update your APT database with apt-get update;
Install the latest security updates with apt-get upgrade;
Install required packages with apt-get install build-essential module-assistant;
Configure your system for building kernel modules by running m-a prepare;
Click on Install Guest Additions… from the Devices menu, then run mount /media/cdrom.
Run sh /media/cdrom/VBoxLinuxAdditions.run, and follow the instructions on screen.

migcosta

1 - turn off the VM
2 - add the shared folder with the auto mount option: folder name repos (on the VM it will be sf_repos)
3 - turn on the machine
4 - find the shared folder location: mount | grep vbox
5 - find the user id and the group id for that you whant to use:
    id -u username
    id -g username
6 - create a container folder on www: /var/www/remote
7 - edit ftabs: nano /etc/fstab
8 - add:*

migcosta

<?php 
/**
* I faced a strange issue while migrating a magento 2.3 from a server to another.
* some of the product images where in a uppercase folder on the server and on a lowercase on the db
* the fix was to create links...
*/
//get the folders list from [magento root]/apps/magento/htdocs/pub/media/catalog/product
$folders = ["A","B","C","d","e","f","G","h","i","J","k","l","M","n","o","P","r","s","T","u","V","w","y"];

foreach( $folders as $folder )