MySQL – Backup, Restore, Copy Tables and Databases from Techmirrors.org
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
sourceTechmirrors
Read More:
