If you have shell or telnet access to your web server, you can backup your MySQL data by using the mysqldump command. This command connects to the MySQL server and creates an SQL dump file. The dump file contains the SQL statements necessary to re-create the database. Here is the proper syntax:

$ mysqldump –opt -u [uname] -p[pass] [dbname] > [backupfile.sql]

* [uname] Your database username
* [pass] The password for your database (note there is no space between -p and the password)
* [dbname] The name of your database
* [backupfile.sql] The filename for your database backup
* [--opt] The mysqldump option

For example, to backup a database named ‘Tutorials’ with the username ‘root’ and with no password to a file tut_backup.sql, you should accomplish this command:

$ mysqldump -u root -p Tutorials > tut_backup.sql

This command will backup the ‘Tutorials’ database into a file called tut_backup.sql which will contain all the SQL statements needed to re-create the database.

With mysqldump command you can specify certain tables of your database you want to backup. For example, to back up only php_tutorials and asp_tutorials tables from the ‘Tutorials’ database accomplish the command below. Each table name has to be separated by space.

$ mysqldump -u root -p Tutorials php_tutorials asp_tutorials > tut_backup.sql

Sometimes it is necessary to back up more that one database at once. In this case you can use the –database option followed by the list of databases you would like to backup. Each database name has to be separated by space.

$ mysqldump -u root -p –databases Tutorials Articles Comments > content_backup.sql

If you want to back up all the databases in the server at one time you should use the –all-databases option. It tells MySQL to dump all the databases it has in storage.

$ mysqldump -u root -p –all-databases > alldb_backup.sql

The mysqldump command has also some other useful options:

–add-drop-table: Tells MySQL to add a DROP TABLE statement before each CREATE TABLE in the dump.

–no-data: Dumps only the database structure, not the contents.

–add-locks: Adds the LOCK TABLES and UNLOCK TABLES statements you can see in the dump file.

The mysqldump command has advantages and disadvantages. The advantages of using mysqldump are that it is simple to use and it takes care of table locking issues for you. The disadvantage is that the command locks tables. If the size of your tables is very big mysqldump can lock out users for a long period of time.

Back up your MySQL Database with Compress

If your mysql database is very big, you might want to compress the output of mysqldump. Just use the mysql backup command below and pipe the output to gzip, then you will get the output as gzip file.

$ mysqldump -u [uname] -p[pass] [dbname] | gzip -9 > [backupfile.sql.gz]

If you want to extract the .gz file, use the command below:

$ gunzip [backupfile.sql.gz]

Restoring your MySQL Database

Above we backup the Tutorials database into tut_backup.sql file. To re-create the Tutorials database you should follow two steps:

* Create an appropriately named database on the target machine
* Load the file using the mysql command:

$ mysql -u [uname] -p[pass] [db_to_restore] < [backupfile.sql]

Have a look how you can restore your tut_backup.sql file to the Tutorials database.

$ mysql -u root -p Tutorials < tut_backup.sql

To restore compressed backup files you can do the following:

gunzip < [backupfile.sql.gz] | mysql -u [uname] -p[pass] [dbname]

If you need to restore a database that already exists, you’ll need to use mysqlimport command. The syntax for mysqlimport is as follows:
mysqlimport -u [uname] -p[pass] [dbname] [backupfile.sql]

Theo: clientcentral.info

Retrieve the mod_security binary for your platform. You can find detailed information here , but below are the key steps assuming you’re running a Centos 5.3 VPS.

1. Validate the packages by installing the GPG key:

rpm –import http://www.jasonlitka.com/media/RPM-GPG-KEY-jlitka

2. Add the following to your ‘/etc/sysconfig/rhn/sources’ file:

yum utterramblings http://www.jasonlitka.com/media/EL5/$ARCH

3. Type:

nano -w /etc/yum.repos.d/utterramblings.repo

… and then paste the following into the editor:

[utterramblings]
name=Jason’s Utter Ramblings Repo
baseurl=http://www.jasonlitka.com/media/EL$releasever/$basearch/
enabled=1
gpgcheck=1
gpgkey=http://www.jasonlitka.com/media/RPM-GPG-KEY-jlitka

4. Update your yum repository by typing yum update and accepting the update. This might take a bit of time depending on when you did your last update.

5. Install modsecurity by typing: yum install mod_security

6. Restart the Apache webserver: service httpd restart.

That’s it!

Note that a default ruleset is included and activated during the installation. If you want to edit the configuration, the following can be useful:

/etc/httpd/conf.d: all files in this directory are loaded during Apache startup
/etc/httpd/conf.d/mod_security.conf: default configuration loading the mod_security module and the default rule set
/etc/httpd/modsecurity.d: default rule set

Theo: clientcentral.info

1. Set up the .ssh directories
The default key directory is “~/.ssh”. Create this directory in both the server and in your current home directory on the client machine and chmod it so that only the users have access to it.

# mkdir ~/.ssh
# chmod 0700 ~/.ssh

2. Create the keypair on the client machine:

# ssh-keygen

3 Copy the public key to the server:
# scp -P 8888 ~/.ssh/id_rsa.pub root@1.2.3.4:~/.ssh/authorized_keys

(Assuming your IP is 1.2.3.4 and you changed the default port from 22 to 8888. You can change the ssh port on the server by editing the file /etc/ssh/sshd_config and changing the parameter Port.)

4. Make sure that you chmod both keys so that only the respective users have access to them. Issue the following command on both the server and the client machine:

# chmod 0600 ~/.ssh/*

5. If you are using Mac OSX, edit the file ~/.ssh/config in and add the following line: IdentityFile ~/.ssh/id_rsa

6. Disallow login with passwords by editing the file /etc/ssh/sshd_config and setting PasswordAuthentication to no. Restart the SSH service:
> service sshd restart

7. That’s it! You can try it by using the following command from the client:
> ssh root@1.2.3.4 -p 8888

theo clientcentral.info

Đầu tiên upload file backup data lên có dạng Sql.gz ví dụ vinashares.sql.gz chẳng hạn lên thư mục web của mình.

Sau đó ta SSH vào máy chủ và sử dụng các lệnh sau:

cd /<duong dan thu muc chua data>

sử dụng lệnh gunzip để giải nén file backup ra được file sql (hoặc nếu thích thì up file sql đỡ phải dụng lệnh này =)) )

gunzip vinashares.sql.gz

Ok như vậy là ta đã có file sql giải nén ra. Đừng dùng lệnh cd chạy đi đâu nhé cứ đứng yên ở đó và sài lệnh sau:

mysql -h localhost -u [ten user_database] -p[password_user_database] [tên_database] < tên_data.sql

Sau đó thì ngồi nhâm nhi cốc cafe ^^.

Chúc các bạn thành công.

Apache Address already in use: make_sock: could not bind to port 80 error and solution

Lọ mọ mãi mới phát hiện ra.

puty vào server rồi làm như sau:

+ Tắt dịch vụ apache:

killall -9 httpd

+ Sau đó khởi động lại là ok

service httpd restart

Chúc bạn thành công !

1.Remove filter from IIS manager:
IIS >> Web Sites >>Properties >>ISAPI filters
2.Disable that filter in Web Server Extensions.
3.Restart IIS

Tận hưởng thành quả nào. Truy cập Plesk bình thường.

Chúc các bạn thành công.

https://www.buycpanel.com/changeip.php

If you get Invalid License File
when you login to cpanel/WHM update your cpanel license file by:

Login to
shell

and run the command below

/usr/local/cpanel/cpkeyclt

nguon: http://mswebnetwork.net/

1. Download the package 

wget http://www.configserver.com/free/csf.tgz

2. Untar it

3. Run the Install script.

Thats it! wait until the script ends!

4. Remove APF or IPTables Firewall

If you have any existing IP tables firewall remove them using uninstall scripts located at /etc/csf. In this case i was running APF firewall and BFD in my server so i have to remove it.

5. Start the Firewall in Testing Mode

Start the firewall with the following command.

If you are running a VPS plan, then you might get the error like this

“iptables LKM ip_tables missing so this firewall cannot function unless you enable MONOLITHIC_KERNEL in /etc/csf/csf.conf
Error: aborted, at line 156″

To fix:
Open the /etc/csf/csf.conf and look for a line MONOLITHIC_KERNEL = “0″ and change to MONOLITHIC_KERNEL = “1″

Thats all! Now restart the firewall.

7. Specify which ports you want to allow.

It is very important to check the firewall on which ports to open and close all remaining port numbers. Open the /etc/csf/csf.conf and edit the following line with port numbers

21 => FTP
22 => SSH
23 => Telnet
25 => SMTP Mail Transfer
43 => WHOIS service
53 => name server (DNS)
80 => HTTP (Web server)
110 => POP protocol (for email)
443 => HTTP Secure (SSL for https:// )
995 => POP over SSL/TLS
9999 => Urchin
3306 = > MysQL Server
2082 => CPANEL Default
2083 => CPANEL – Secure/SSL
2086 => CPANEL WHM
2087 => CPANEL WHM – Secure/SSL
2095 => cpanel webmail
2096 => cpanel webmail – secure/SSL
Plesk Control Panel => 8443
DirectAdmin Control Panel => 2222
Webmin Control Panel => 10000

6. Disable the Testing Mode and Start the Firewall

Remember by default the firewall is running in testing mode. You might want to disable the firewall running in testing mode.

In Cpanel

If you have successfully installed the CSF firewall, then you will find this CSF Security & Firewall option within cpanel WHM at the bottom of the menu. Just click on the link and you can also edit the firewall settings inside Cpanel, which is very easy to do.

Config Files

/etc/csf/csf.conf CSF Firewall configuration file
/etc/csf/csf.allow => Config file to allow IPs
/etc/csf/csf.deny => Config file to deny IPs
/etc/csf/ => Alert files with TXT extension are stored within this directory

Final Steps

1. Check the status of firewall inside cpanel
2. Harden the firewall security by performing the system security check. To do this go to Cpanel WHM > CSF Firewall & Security > Check System Security. There it will list WARNINGS based on your server.

Frequently Asked Questions

1. How do i know whether the firewall is running or not?

Just login to Cpanel WHM > Config Security & Firewall > Status: Running

Another good idea is to check and see which ports have been opened and closed by firewall.

To look for open ports, just use the following commands in linux and observe which ports are open.

2. How do i Remove the CSF Firewall

Just run the uninstall script located at /etc/csf/ directory

If you encounter the error

“MySQL is running but PID file could not be found”

you have to create the directory

var/run/mysql

#mkdir /var/run/mysql

then create the file mysqld.pid

#touch mysqld.pid

and change its owner

#chown mysql:mysql mysqld.pid

this should solve the problem.

Useful Hidden cPanel Commands

Have you ever locked yourself out of your server while making some iptables changes? What about when you change your SSH port and then forget what you set it to? These are both fairly common support requests that we receive at slhost. Fortunately, in many cases this is something our customer’s can fix on their end as long as they are using cPanel as their control panel.

cPanel comes with a number of ‘hidden’ autofix commands that allow for administrators to fix common problems simply be logging into WHM and going to a special URL. Two of the most useful ones I’ve seen are flushing iptables and restarting SSH in “safe mode” (basically the default settings and port).

Restart SSH in safe mode: http://mydomain.com:2086/scripts2/doautofixer?autofix=safesshrestart

Flushingiptables rules: http://mydomain.com:2086/scripts2/doautofixer?autofix=iptablesflush