How to backup & restore mySQL database

by frank · October 18, 2015

How to backup and restore.
This works for wordpress for example

To backup :

mysqldump -u root -p"yourRootPass" databaseName | gzip > ~/backup-mysql-`date +%Y-%m-%d,%Hh00`.sql.gz

To restore :

$> gunzip backup-mysql-xxxx-.sql.gz
$> mysql -u root -p"yourRootPass" < backup-mysql-xxx.sql;

Shareooo

You may also like...

• 2

  /usr/bin/ld: cannot find -lbz2

  6 Aug, 2013

• 0

  Where to download old XCode versions on Apple

  7 Jul, 2015

• 0

  How to create a p12 private key and certificate file

  8 Jun, 2016