Advertisement
Guest User

Untitled

a guest
Sep 26th, 2016
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.49 KB | None | 0 0
  1. Datenbank zurückspielen:
  2. mysql -h 127.0.0.3 -u databaseuser -p databasename < dump.sql
  3. mysql -h 127.0.0.3 -u db415637_261 -p db415637_261 < leo-backups/confidea-neu/confidea-neu-backup-2014-05-14-13-31.sql
  4.  
  5. Datenbank sichern:
  6. mysqldump --opt -h 127.0.0.3 -u datenbankuser -phier_das_pw_direkt_dran datenbankname > datenbank.sql
  7.  
  8. Neue, leere Datenbank erstellen:
  9. Collation: utf8_general_ci
  10.  
  11. Datenbank duplizieren:
  12. mysqldump --opt -u user1 -ppassword1 olddatabase | mysql -u user2 -ppassword2 newdatabase
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement