Category: MySQL Articles
BACK
Jan 8 2014 8:00 PM JAN 8 2014 8:00 PM

Dumping a mysql database that is on a different hostmysqldump

MySQL | Unix | Ubuntu | Linux | Terminal

Basically had an issue with phpmyadin and needed to get a decent dump of someones database. Problem is they setup restrictions on ip addresses so I had to be a bit creative. Most my normal tools such as SQL pro could not connect around all this (At lease to my best effort.)

  

mysqldump -h mysql.yourserver.com -u mysql_user -p database_name table_name

Read More
Sep 11 2013 2:49 PM SEP 11 2013 2:49 PM

Transfer a MySQL Dump to another server and install it.All in one line!

MySQL | Unix | Ubuntu

Thanks to a collegue of mine we were tasked with making a process to transfer files from one site to another in the event of a fail over. This happened to do the trick...

 

mysqldump -u root -pPASSWORD FS TABLE1 TABLE2 | ssh  'cat | mysql -u root -pPASSWORD FS'

Source: Timothy Boronczyk


Read More
Aug 15 2013 5:00 PM AUG 15 2013 5:00 PM

SitesCurrent list of sites

Javascript | CSS | PHP | HTML | MySQL | Wordpress | Windows

Here is an list of sites I have done in the last 6+ months.

These sites I basically will cut up the designs and make into workable sites.

Primarly these are all wedding industry...


Read More
Mar 13 2013 7:00 PM MAR 13 2013 7:00 PM

Working ProjectsCleaning up...

Javascript | CSS | PHP | HTML | HTML5 | MySQL | Wordpress | JQuery

It happens... You get busy, articles and writing and everything in between gets left in the dust. Projects are left unfinished and seemingly you can never get the dust off them.

So here it goes I am slowly going to try and clean off the dust off some of the many projects I once started and left semi-unfinished to nearly unfinished.

I roughly have about 15 projects in general. 2-3 which are never ending and the others could be "finishable." All of which that can be "completed" it would be sweet to finish them this year. Though even that may not be easily done.


Read More
Mar 6 2013 5:00 PM MAR 6 2013 5:00 PM

The Bridal StylePinterest Wedding Site

Javascript | CSS | PHP | HTML | HTML5 | MySQL | Custom Frame Work | JQuery

The Bridal Style
www.thebridalstyle.com

  • Maintain
  • Cloud server setup
  • Custom Smarty Framework
  • Added custom banner tracking. (View Time, Clicks...)
  • Social Plugin for blogs and HTML websites.
  • Wordpress blog
  • Vendor Guide
  • Converted Image system to dynamic file structure.

Read More
Jul 30 2012 8:04 AM JUL 30 2012 8:04 AM

Multi Site CMS(Ware) CMS 1.0

PHP | MySQL | Websites

I have been developing my own CMS for roughly 2 years now. And only now starting to see the benefits of it. I haven't spoken much on what it is capable of but figured it was time to talk about one of the neat features it has!

Multi-Site handling. Sure WordPress recently has this functionality in it it. But my CMS has the ability to work on multiple pieces of content (articles, dancesteps, movies, and more.) All in one page. In a lot of ways you could consider it the GMail of CMS's. 


Read More
Apr 18 2012 12:00 PM APR 18 2012 12:00 PM

INSERT WHERE NOT EXISTSMySQL INSERT IF ROW DOES NOT EXIST

MySQL

Recently I needed to create a patch for a project and we have references in our database for wizards. These wizards exist in each folder, but cannot have more than one at a time in each folder. Currently the table does not have a unique key so I could not use:

INSERT IGNORE

 

Because of this I resorted to the following:

INSERT INTO tblName (reportName, folderId) 
SELECT 'Wizard', 1 FROM tblName2 WHERE NOT EXISTS 
(SELECT 1 FROM tblName2 WHERE reportName='Wizard' AND folderId = 1) LIMIT 1;

Hope it helps someone...


Read More
Sep 29 2011 11:27 PM SEP 29 2011 11:27 PM

LAMP Stack InstallSetting up a LAMP environment.

Apache | PHP | MySQL | Ubuntu

Recently I got curious and adventurous into setting up a Virtual Environment on my Mac's VMware Fusion with Ubuntu, Apache, MySQL and PHP. As a Web Developer I often find little need to be a Sysadmin and spend WAY more time developing. It may come as a shocker but its often not a required effort to need to have the knowledge now days of how to setup the environment I work in! An analogy behind this is a mechanic doesn't necessarily build cars, but rather fixes them. While they may understand the details behind it they may have never put a car together from start to finish, but if they had to they could...

So I figured I would post a little bit about what I did to get it going. Because this was my first run of doing this it took a little longer than it should have. But now that I have gone through it I could probably do it as fast as my machine can download.


Read More
Sep 12 2011 5:35 PM SEP 12 2011 5:35 PM

CachingRecent Additions to the Site

JQuery | Javascript | PHP | MySQL

Lately I have had "caching" on the brain and have been working on a decent way of caching.

So far I have found that caching is obviously faster and in XML format makes it really easy to iterate through in Object format.

My methods so far are

  1. Checking a database table for current cached item information.
  2. If it has an expiration date or does not exist the feed needs to be cached.
  3. If needs to be cached - Caching will grab the feed via curl, fopen, or file_get_contents()
  4. Feed will then be stored in a file in a specific directory on the server. 
  5. Database will either be updated or inserted with feed information.

Read More
Sep 4 2011 9:00 PM SEP 4 2011 9:00 PM

Auto PaginatePaginate with and without Javascript

JQuery | HTML | Javascript | PHP | MySQL

Recently I did a post about website loading. Which had me thinking... Paginiation! Its a lovely device that allows you to not have to display all the content on the same page. There are so many forms of pagination and pagination theories. One of which is a newer method called. "Auto Pagination." It is seen on many sites such as local pages on google and several others.

It basically detects the "windows" scroll and once a certain position on the page has been achieved it loads more content into the page. Some other neat useages of this window scroll is on mashable.com when reading an article if you scroll far enough down it will display the next article on the list. But this is about pagination...


Read More
Aug 25 2011 9:43 AM AUG 25 2011 9:43 AM

MySQL Optimization10 Things to Optimize MySQL.

MySQL

Recently I was given a great link that gives ten great ways to optimize MySQL. With its may open ended methods that leave you crossed which direction to go. I found this article extremely helpful.

20Bits By Jesse Farmer


Read More
Aug 22 2011 9:00 AM AUG 22 2011 9:00 AM

Shaunware CMS V1PHP Content Management Systems

Custom Frame Work | JQuery | CSS | HTML | Javascript | PHP | MySQL

Shaunware is ran on its very own content management system (CMS). It uses PHP/PHP5, MySQL, Javascript (Jquery), CSS/CSS3, HTML/HTML5 and more.

Here is a small list of features:

  • Unlimited number of sites to hook into.
  • Targeting content / tagging content to pages/tags.
  • Unlimited varations of content types. Ex: Articles, Banners, and more...
  • Records impressions and clicks on specific content types.
  • Email Campaigns - Send HTML emails to a list of registered members.
  • User/Member Handling - Allows extensive registration details for membership base sites.
  • Read more...

Read More
Aug 14 2011 2:00 PM AUG 14 2011 2:00 PM

Hacking the WebXSS Attacks | SQL Injections | DDOS Attacks

Javascript | PHP | MySQL | Hacking

Hacking seems to be a common occurance now days. While it seems to be a somewhat complicated process in reality it is mostly simple hacks that result in tremeduous damage, costs, and lose of data.

Two Types of Web Hacks

XSS and SQL Injections. There are obviously more such as DDOS attacks, but those are short term.

What are they?

XSS is simply inserting Javascript into a page. An example of this is a simple alert.

<script>alert("Hi!");</script>

SQL Injections are a wider range of possibilities. They allow you to delete an entire database, to outputting important information. Or even logging in as an adminstrator.


Read More
Aug 7 2011 1:00 PM AUG 7 2011 1:00 PM

New Site!

CSS | HTML | Javascript | PHP | JQuery | HTML5 | MySQL | Custom Frame Work | Categories | Tutorials | Games | Movies | Imagemagick | XML | Unix

Finally I have recreated my website. It is using a content system I created from the ground up. I will be writing more on this system in the future. A small list of features this system can do:

  • Manage Multiple Sites in one.
  • Member Registration
  • Banners
  • Page Control / SEO
  • And so much more...

Read More
Apr 20 2011 2:00 PM APR 20 2011 2:00 PM

Dance InformaDance News Website

CSS | HTML | Javascript | PHP | MySQL | Reviews | Linux | Custom Frame Work | Terminal

Dance Informa
aus.danceinforma.com
usa.danceinforma.com

  • Custom Frame Work
  • CMS that controls both sites.
  • Banner System
  • Email Campaigns
  • Content Types to breakup page types.
  • Membership System

Read More
Feb 1 2011 1:00 PM FEB 1 2011 1:00 PM

Scenic RentalsVacation Rental Website

Javascript | PHP | MySQL

Scenic Rentals
www.scenicrentals.com

  • Autocomplete for homepage search.
  • Query to search database for autocomplete results.
  • Created resulting search page query that lists out search results.

Read More
Jan 13 2011 1:00 PM JAN 13 2011 1:00 PM

Sugar Snap PhotographyPhotography Website

Custom Frame Work | JQuery | Wordpress | Imagemagick | Javascript | PHP | MySQL | HTML5

Sugar Snap Photography
www.sugarsnapin.com

  • Custom Gallery System with CMS.
  • Previewing Gallery for customers.
  • Front page uses JQuery Gallery from: http://tympanus.net
  • Tons of JQuery affects and plugins.
  • Blog is powered by Wordpress
  • Utilizes Font Face for fancy font changes.
  • Branding done by Marco Suarez

Read More

Tweets

Social Media

Categories