On 10/29/07, Bryan Tong Minh <bryan.tongminh(a)gmail.com> wrote:
On 10/29/07, Fawad Nazir <fawad.nazir(a)gmail.com>
wrote:
4. How do
I add .sql.gz files to MySQL?
$gnuzip <filename>.sql.gz
$mysql -u (username) -p (db-name) < (filename).sql
Or
mysql -u username -p db-name | gunzip --to-stdout filename.sql
Should be faster and eating up less disk space.
Bryan
Argh, the other way round
gunzip --to-stdout filename.sql | mysql -u username -p db-name