The Swamp!

Databases

MySQL > 4.x & 5.x > Administration > Syntax > Deleting and Replacing Records within 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:

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...

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.):

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).

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).

More Articles...

The Swamp!

IT Knowledgebase and Technical Support

Databases

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

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

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

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

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