Search
Login / Signup
Who's On?
We have 1 guest online
Donate

Thank you for your donation.



Databases

MySQL > 4.x & 5.x > Administration > Syntax > Deleting and Replacing Records within databases

Databases

Quite normally, you may want to delete some records from within your MySQL database(s).

Or, you may wish you replace records in one MySQL database table, with records from a similarly structured, different database table, or even within the same record.

Here's how you do those things:

Read more...

 

MySQL > Administration > Syntax > Intra-database exporting and Importing via SQL Editor

Databases
Ever wonder how to do a quick and efficient import of a bunch of records from one table into another table? Well, this article explains how to do this in just one command. And it works with any MySQL 4.x and 5.x database.

Here's how...

Read more...

 

MySQL > Administration > Commands > Making A Binary Backup of your MySQL Databases

Databases
Sure, MySQL has a great mysqldump feature which makes live dynamic backups. Of course, if your system isn't set up with mysqldump, or if it's not working for some other reason, well, there is another quick-fix solution that really works, by making a binary backup of your mysql databases directory.

Here's how to do it in just 3 steps (yup. really.):

Read more...

 

MySQL > Administration > Commands > Manually Replacing the Admin Password.

Databases
Generally speaking, this problem should be avoided. You should always keep good track of your root password and admin password. Of course, stuff happens. And when bad stuff hits the fan, there does exist a way you can reset your admin password without having to be able to hack into the Pentagon.

Here's how you replace your admin password in MySQL 4.x or 5.x, in just 4 Easy Steps! (yes, really).

Read more...

 

MySQL > Administration > Commands > Manually Replacing a Broken Database.

Databases
It may occur that one or more of your MySQL 4.x or 5.x databases gets messed up, corrupt, broken, or otherwise unusable.

Should that occur, there is a quick way to replace the bad version with a working copy. (Of course you DO backup your databases, right?)

So here's the way to do that, in just 7 steps. (Yes, really).

Read more...

 
More Articles...

The Swamp! Is an IT Knowledgebase & Technical Support resource, consisting of Technical Support articles and a large IT Knowledgebase for free Access