I'm trying learn how to write a script to linux zip a file to a .gz file type. Someone emailed me the following syntax but it doesn't work and I'm lost. What I'm trying to do is take one of my existing *.sql files and make a *.gz file out of it so it's smaller.
exec("tar --directory=$save_dir -czf ". $save_dir . $dbname . "-" . $date . "_sql.tar.gz $dbname-$date.sql");
Thanks for any help...
pr0gr4mm3r posted this at 00:29 — 23rd September 2007.
He has: 825 posts
Joined: Sep 2006
Since you are using the exec() function, I'm assuming that you are running that in PHP. If you are just running it in a shell, you don't need the exec() function.
The basic way to run the command would be...
<?phptar -czvf file.sql file.sql.tgz
?>
Change the file name accordingly, and stick it into the exec() function if needed. Also, if you are running the command in a different directory than the files, be sure to provide the relative path along with the file.
frank727 posted this at 05:03 — 23rd September 2007.
They have: 12 posts
Joined: Jun 2007
I'm running it in a PHP script. I'll give your syntax a shot and see how it works.
Thanks...
frank727 posted this at 05:30 — 23rd September 2007.
They have: 12 posts
Joined: Jun 2007
I put the full path in
exec("tar -czvf /var/www/backup/wx.sql /var/www/backup/wx.sql.tgz");
but it still doesn't work. The wx.sql files is about 4800kb and after the statement is run their is only the wx.sql file (no .tgz file) and it's about 45k. I looked inside the file and it's unreadable so it must be tgz format but surely it can't compress a 4800kb file down to 45kb? But there is still no .tgz file.
pr0gr4mm3r posted this at 13:30 — 23rd September 2007.
He has: 825 posts
Joined: Sep 2006
The files are reversed. You specify the compressed file first. Sorry, that was my fault.
SQL files do actually compress quite a bit because have the the file has phrases like "INSERT INTO table_name", etc.
frank727 posted this at 14:03 — 23rd September 2007.
They have: 12 posts
Joined: Jun 2007
I think that did it. I got the .tgz file created and it's size seems about right at 631kb. To check it, how do I un tgz it back into it's .sql state?
The .sql file changed size too: went from 4800kb to 622kb - I thought the source file would not be changed?
frank727 posted this at 14:45 — 23rd September 2007.
They have: 12 posts
Joined: Jun 2007
I got it figured out and working now. The source file is ok. I extracted the source from the tgz and did a file compare and it's a perfect copy of the source.
Thanks for your help...