Download Podcast at: iTunes - https://podcasts.apple.com/us/podcast/eli-the-computer-guy/id1526481218 Podbean - https://etcg.podbean.com Spotify - https://open.spotify.com/show/00FRz8g7OkNZdR4WJpTZwr ... https://www.youtube.com/watch?v=U3IcauA5-Ko

Find code and diagrams at: https://www.EliTheComputerGuy.com ... https://www.youtube.com/watch?v=QTUzfshfOJw

Find code and diagrams at: https://www.EliTheComputerGuy.com Backing up tables and databases is very useful when you are learning to update records so that you can recover quickly when you do something wrong. create table if not exists newTable like oldTable; – Copies schema of old table to new table (columns, data types, etc). IF NOT EXISTS makes sure you do not overwrite a table you already created. insert newTable select * from oldTable; – copies all records from old table into new table LINUX SHELL mysqldump -u username -p database /location/dump.sql – backsup database to location specified with name specified. Make sure you have WRITE permission to the folder you point to LINUX SHELL mysqladmin -u username -p create newDatabase – creates database from linux shell LINUX SHELL mysql -u username -p newDatabase /location/dump.sql – restores database from file to new database ... https://www.youtube.com/watch?v=bcEo85ndRfo

Be My FRIEND at MeWe: https://mewe.com/i/elithecomputerguy Download Podcast at: iTunes - https://podcasts.apple.com/us/podcast/eli-the-computer-guy/id1526481218 Podbean - https://etcg.podbean.com Spotify - https://open.spotify.com/show/00FRz8g7OkNZdR4WJpTZwr ... https://www.youtube.com/watch?v=IptfSh7F8jA