Posts Tagged 'MySQL'



Build a Sex-On-Legs WebDev Machine

guvnr.com screenshot

Install the ultimate web development toolbox: tweaked Linux Ubuntu with Windows via VirtualBox, Nginx, PHP, MySQL, best Firefox addons, Woopra & much more.

Here's the deal ..

My 2 month old HP Pavillion DV3500 decided to pack up the other day.

Looks like the motherboard, ‘cos I tried another ...

read more →
1

Maintain Unmanaged VPS – Part 9: Reset a Lost MySQL Password

mysql command line code image

So you've gone and locked yourself out of MySQL? Feels a bit like leaving the car keys in the trunk, huh? 😀 Sorry to laugh! But I can, firstly because I've locked my own darned keys in the trunk and, more usefully, ‘cos I'm gonna show you how to get back in.

It's really not so tough. Using ...

read more →
2

Maintain Unmanaged VPS – Part 8: Update (Replace or Delete) MySQL Data

mysql update command image

Change repetitive db data with one single syntax command. Rather than manually find & alter each instance, isolate the lot & update multiple content.

There are some good plugins to do this with platforms like WordPress but, by way of an alternative method, this is handy when you want to swap or lose an identical content string across all the ...

read more →
0

Maintain Unmanaged VPS – Part 7: Reinstate MySQL DBs with Terminal Shell

mysql database import command line image

This guide provides the syntax for uploading data to a MySQL database. For instance, you've changed Linux server, have added a blank database and now want to add your previously backed up data.

Just replace the name of the database, the database username & the password with your chosen options, pasting the code into your terminal.

(Sure, you could use a ...

read more →
0

Maintain Unmanaged VPS – Part 6: Backup a MySQL Database from the Terminal

mysqldump command line code image

This guide shows how to save a MySQL database using a terminal, with a simple syntax command. And faster than using phpMyAdmin, for sure.

Just replace the db name, username and password and paste the code into your terminal.

While this is a handy how-to, probably you'll want ...

read more →
0

Maintain Unmanaged VPS – Part 4: Create or Bin MySQL DBs using the Terminal

mysql create database command line image

This how-to guide maps out two pretty basic but handy MySQL operations, creating and binning a database, using the terminal interface.

Sure, you can do those with, say, phpMyAdmin, but it's way quicker to perform such functions using the command line.

Having logged into MySQL's shell using ...

read more →
6

Set Up Unmanaged VPS (4 Newbies) – Part 8: PHP5, MySQL and Xcache (for Platforms like WordPress)

xcache server caching

Bolt on PHP5 for server-side web applications, Xcache to speed things up and MySQL to handle our databases. And tweak that lot for optimum performance of platforms from WordPress to Drupal.

From the first seven tutorials in the series Set Up Unmanaged VPS (4 Newbies), this Linux box is now quite the tough guy, easier to connect to and use, ...

read more →
28