22. June 2010 · 79 comments · Categories: Linux

A Simple Database Backup:

You can use mysqldump to create a simple backup of your database using the following syntax.

mysqldump -u [username] -p [password] [databasename] > [backupfile.sql]

  • [username] – this is your database username
  • [password] – this is the password for your database
  • [databasename] – the name of your database
  • [backupfile.sql] – the file to which the backup should be written.

The resultant dump file will contain all the SQL statements needed to create the table and populate the table in a new database server. To backup your database ‘Data’ with the username ‘pensacola’ and password ‘password’ to a file customdata.sql, you would issue the command:

[pensacola@pensacola-tech ~]#mysqldump -u pensacola -p password Data > customdata.sql

Import your data into your database:

[pensacola@pensacola-tech ~]# mysqldump -u pensacola -p password Data < customdata.sql

Backup of Mysql database using phpMyAdmin:


It is assumed that you have phpMyAdmin installed since a lot of web service providers use it.

  • Open phpMyAdmin.
  • Click Export in the Menu to get to where you can backup you MySql database. Image showing the export menu.
  • Make sure that you have selected to export your entire database, and not just one table. There should be as many tables in the export list as showing under the database name.
  • Select”SQL”-> for output format, Check “Structure” and “Add AUTO_INCREMENT” value. Check “Enclose table and field name with backquotes”. Check “DATA”, check use “hexadecimal for binary field”. Export type set to “INSERT”.
  • Check “Save as file”, do not change the file name, use compression if you want. Then click “GO” to download the backup file.


Restoring a backup of a MySql database with phpMyAdmin:

  • To restore a database, you click the SQL tab.
  • On the “SQL”-page , unclick the show query here again.
  • Browse to your backup of the database.
  • Click Go.

AutoMySQLBackup

There is a script to take daily, weekly and monthly backups of your MySQL databases using mysqldump. You can download this script from here. This can be run using the following:

[pensacola@pensacola-tech ~]#sh automysqlbackup.sh.2.5

This is a very simple way for server administrator …

If you find AutoMySQLBackup valuable please make a donation at:

09. June 2010 · 2 comments · Categories: Linux

Here is a step by step on how to set up shared folders for accessing Windows folders in a Linux guest. VirtualBox Shared Folders on inactive virtual machines are configured through the Settings dialog. This dialog is accessed by selecting the desired virtual machine from the list and clicking the Settings button in the toolbar. Once the settings dialog is displayed, click on the Shared Folders entry to display something like this:

To add a new shared folder, click on the add folder button (the top button containing an icon of a folder with a green plus sign) and select a folder on the host system to be shared with the selected guest. To browse for a specific folder, click the down arrow in the Folder Path text box and select Other… from the drop down menu. Once a suitable folder has been selected, enter a name for the share in the Folder Name field. If the guest operating system is to be denied write access to the folder, ensure that the Read-only check box is selected before clicking the OK button to create the share. Once the shared folder has been configured, start the virtual machine to access the folder.

Shared folders may be configured on a running virtual machine by selecting the Devices->Shared Folders.. menu of the virtual machine window. It will be something like this:

Add a new shared folder by clicking on the add folder button (the top button containing an icon of a folder with a green plus sign) and select a folder on the host system to be shared with the selected guest.

Shared Folders are accessed on Linux guests by mounting the folder at a suitable mount point using the mount command. This can either be an existing directory, or a new directory may be created specifically for this purpose. Use this command: sudo mount -t vboxsf share ~/host

E.g

[pensacola@pensacola-tech ~]#sudo mkdir /media/shared_folder

[pensacola@pensacola-tech ~]#sudo mount -t vboxsf shared_folder /media/shared_folder

The files are now accessible in /media/shared_folder.

Plug in the USB-Serial Port adaptor to one of your USB port, wait for a couple of second, then run:

[pensacola@pensacola-tech ~]#dmesg

The output should be something like this:

usb 2.0: new full speed USB device using uhci_and address 2

usb 2.0: configuration #1 chosen from 1 choice

Then unplug the device and type:

[pensacola@pensacola-tech ~]#lsusb

The output should be similar to this:

Bus 003 Device 001: ID 0000:0000

Bus 002 Device 007: ID 03f0:4f11 Hewlett-Packard

Bus 002 Device 006: ID 05e3:1205

Bus 002 Device 004: ID 15d9:0a33

Plug in the USB-Serial Port converter back, and run “lsusb” again, and you will see
an additional line, like this:

Bus 003 Device 001: ID 0000:0000

Bus 002 Device 007: ID 03f0:4f11 Hewlett-Packard

Bus 001 Device 002: ID 4348:5523 — — — the additional line

Bus 002 Device 006: ID 05e3:1205

Bus 002 Device 004: ID 15d9:0a33

At this point we have the vendor id and the product id of the USB-Serial Port converter, this will enable us to load the linux kernel module “usbserial” to activate the device.
[pensacola@pensacola-tech ~]#sudo modprobe usbserial vendor=0x4348 product=0x5523

After that run again:

[pensacola@pensacola-tech ~]#dmesg

… the output:

usbserial_generic 2.0:1.0: generic converter detected

usb 2.0: generic converter now attached to ttyUSB0

usbcore: registered new interface driver usbserial_generic

Now, the new serial port device is mapped to /dev/ttyUSB0.

Note:  You can instruct Ubuntu to load this module automatically by include the line :  “usbserial vendor=0×4348 product=0×5523 inside “/etc/modules” file.

Here is a simple way to backup your svn repository. Use the following command:

svnadmin dump /repository_path/project > /backup_path/project_backup

 You can test if this is okay by creating a test repository and importing the backup
file to the new test repository.

svnadmin create /repository_path/project1
svnadmin load /repository_path/project1 < /project_backup/project

 After that you cand remove it.

rm -rf /repository_path/project1

 In the end you can create a zip copy to the backup file project_backup
to project_backup.zip.

zip -r project_backup.zip project_backup
01. June 2010 · 2 comments · Categories: Linux

Under the WP admin option menu, WordPress lists four choices for permalink structure:

  1. Default: http://pensacola-tech.com/pensacola/?=123
  2. Date and name based: http://pensacola-tech.com/pensacola/2010/05/10/sample-post/
  3. Numeric: http://pensacola-tech.com/pensacola/archives/123
  4. Custom: /%year%/%monthnum%/%day%/%postname%

Note: The “default” option is to not use permalinks.

There are 2 htaccess rules for all WordPress permalinks:

1. If WordPress is installed in the root directory:

# BEGIN WordPress
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]
</IfModule>
# END WordPress

2. If WordPress is installed in a subdirectory called "pensacola"


# BEGIN WordPress
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /pensacola/
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /pensacola/index.php [L]
</IfModule>
# END WordPress

That's it... :)Enjoy!

css.php