Nov 4, 2009
MySQL Import and Export via terminal / shell
Categories: web-development
Written By: Viktor Dite
Import (Rücksicherung der Datenbank)
You are not able to import large files (>2MB) via PHPMyAdmin. To do so, you have to import your sql file with the mysql client:
mysql -hlocalhost -uuser -ppassword database_name < dump.sql
Export (Datenbanksicherung)
mysqldump -hlocalhost -uuser -ppassword database_name > dump.sql
March 15th, 2010 at 15:42
[...] Alternative: Suchen und Ersetzen im Backup. d.h. Backup der Datenbank erstellen, in dem resultierendem sql Dump dann mittels eines geeigneten Texteditors “Suchen und [...]