Import, Export und Entleeren Datenbank unter SSH

mysqldump -h localhost -uBenutzer -pPassword Datenbank_Name > xxx.sql

mysql –default-character-set=latin1 -h localhost -uBenutzer -pPassword Datenbank_Name < xxx.sql

//–default-character-set wichtig beim Umlautproblem. Versuch hier latin1 o. utf8

mysqldump -h localhost -uBenutzer -pPassword –add-drop-table –no-data Datenbank_Name | grep ^DROP | sed -e ‘s/DROP TABLE IF EXISTS/TRUNCATE TABLE/g’ | mysql -h -uBenutzer -pPassword Datenbank_Name

Leave a Reply

Your email address will not be published. Required fields are marked *

× 5 = thirty five

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>