Category: Web Design

Site Migration Risks (URL Change)

standingtechUncategorized / Web DesignLeave a comment

https://support.google.com/webmasters/answer/34437 https://support.google.com/webmasters/topic/6033102?hl=en&ref_topic=6029673 https://support.google.com/webmasters/answer/6033049?hl=en&ref_topic=6033084&visit_id=637156175388140145-3776646314&rd=1 https://www.searchviu.com/en/website-relaunch-seo-checklist/#awareness https://searchengineland.com/site-migration-seo-checklist-dont-lose-traffic-286880 https://www.geekytech.co.uk/website-migration-redesign-seo-checklist/ https://www.searchenginejournal.com/changing-url-structure/325249/#close https://moz.com/community/q/will-changing-a-url-negatively-affect-ranking https://moz.com/blog/should-i-change-my-urls-for-seo

Automatically Backup MySQL Databases on Windows

standingtechDatabase / Security / Web DesignLeave a comment

MySQL Command for backup all databases: mysqldump -uUSERNAME -pPASSWORD –all-databases > “D:/File_NAME_%date:~-4,4%-%date:~-10,2%-%date:~-7,2%-%time:~0,2%_%time:~3,2%_%time:~6,2%.sql” Example: Consider MySQL username = root and password = 123456 mysqldump -uroot -p123456 –all-databases > “D:/mysql_backup_%date:~-4,4%-%date:~-10,2%-%date:~-7,2%-%time:~0,2%_%time:~3,2%_%time:~6,2%.sql” The result will be a file name (mysql_backup_2017-10-21-20_29_54.sql) containing all databases. MySQL Command for one database databases: mysqldump -uroot -p123456 –databases mydatabasename > “D:/mysql_backup_%date:~-4,4%-%date:~-10,2%-%date:~-7,2%-%time:~0,2%_%time:~3,2%_%time:~6,2%.sql” We replaced –all-databases…