Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
mysqlbackup [2015/11/02 10:06]
yassine chaouche
mysqlbackup [2019/04/08 12:56] (current)
yassine chaouche
Line 7: Line 7:
 <code> mysqldump -uuser -ppassword database > dumpfile </code> <code> mysqldump -uuser -ppassword database > dumpfile </code>
  
-Restore +Restore 
  
 <code> mysql -uuser -ppassword < dumpfile </code> <code> mysql -uuser -ppassword < dumpfile </code>
 +
 +Restore to another database : create an empty database (CREATE DATABASE database_name), then 
 +<code> mysql -uuser -ppassword -D other_database < dumpfile </code>
  
 ---- ----
  
 contact : [[http://twitter.com/ychaouche|@ychaouche]] yacinechaouche at yahoocom contact : [[http://twitter.com/ychaouche|@ychaouche]] yacinechaouche at yahoocom

QR Code
QR Code mysqlbackup (generated for current page)