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)