PHP Unzipper – Extract Zip, Rar Archives or filezilla

The Unzipper is a PHP script that extracts .zip, .rar or .gz archives on webservers.It detects .zip/.rar/.gz archives and let you choose which one to extract (if there are multiple archives available). It also supports creating Zip archives.– It is useful if you not have access to a File-Manager, and you want to upload a lot of […]

Continue Reading

How do I import an SQL file using the command line in MySQL?

mysql -u username -p database_name < file.sqlCheck MySQL Options. Note-1: It is better to use the full path of the SQL file file.sql. Note-2: Use -R and –triggers to keep the routines and triggers of original database. They are not copied by default. Note-3 You may have to create the (empty) database from mysql if […]

Continue Reading

How to empty a MySQL database via SSH or phpMyAdmin

There are two ways to empty a MySQL database: via phpMyAdmin and SSH. NOTE 1: By default, SSH access is disabled on all our shared servers. If you need SSH to be enabled, contact our Hosting support via Live Chat or submit a ticket to the Hosting Support department. NOTE 2: We recommend making a backup of your database before proceeding with any changes. […]

Continue Reading