Dump table and database to a file in MySQL

For DB Backup : -

mysqldump -d -h HOST -u USER -p PASSWORD DBNAME > dumpfile.sql

For Table Backup : -

mysqldump -d -h HOST -u USER -p PASSWORD DBNAME TABLENAME > table.sql

For Only Table Structure :-

mysqldump -d -h HOST -u USER -p PASSWORD DBNAME TABLENAME  –no-data > table.sql

You Can Restore Dump as Below : -

mysql > source /path/SQLfile

How to enable swap on Red Hat Linux

Before formatting swap partition please disable that partition.To do that

step1:

#fdisk -l

  Device Boot      Start         End      Blocks   Id  System
/dev/sda1   *           1          13      104391   83  Linux
/dev/sda2              14         535     4192965   82  Linux swap / Solaris
/dev/sda3             536       30401   239898645   83  Linux

step2:

#swapoff /dev/sda2 (your /etc/fstab entry for swap).

step3:

Create Swap signature on that partition.to do that,

#mkswap -v1 /dev/sda2

step3:

Enable swap partition,

#swapon /dev/sda2

step4:

Check the status of swap partition.

#swapon -s

Filename                Type        Size    Used    Priority
/dev/sda2                               partition    4192956    0    -2

Increasing upload size in PHP and MySQL

PHP.ini

You need to change the following bits of code in your PHP.ini file:

upload_max_filesize = 16M
max_execution_time = 120
max_input_time = 120
memory_limit = 64M

my.cnf

We're adding just one bit of code to the file:

max_allowed_packet=16M

If you are looking to compress a file or folder

To create compress backup

tar -cvzf home.tar.gz home/

For extracting compressed backup

tar -xvzf home.tar.gz home/

Zip Files & Folder

To zip a Folder:

zip -9 -r <zip file> <folder name>

To zip a single file:

zip -9 <zip file> <filename>

About Me

Hi,

I am Dhiraj Rokade, Working as a System Administrator. Providing IT solutions such as customised system development, web design and development, SMS Gateway & VAS consultation.