How do I load a sql.gz file to my database? (importing)
Many of us use phpmyadmin to utilize any sort of importing and exporting of MySQL databases. But what if there was an easier way and faster solution. You will need SSH access to your VPS or dedicated server box. Its a one liner: zcat /path/to/file.sql.gz | mysql -u ‘root’ -p ‘password’ your_database zcat = decompresses […]