★ wanayoo — archive 1999 http://www.devshed.com/Server_Side/MySQL/Intro/comments.html/c3205/Nouvelle recherche | Portail wanayoo

Developer Shed
Thursday, 08.17.2000  
One of the fastest SQL (Structured Query Language) database servers currently on the market is the MySQL server, developed by <A HREF=/old?u=http%3A%2F%2Fwww.devshed.com%2FServer_Side%2FMySQL%2FIntro%2Fcomments.html%2Fc3205%2F%26quot%3Bhttp%3A%2Fwww.tcx.se%26quot%3B%26gt%3BT.c.X.&y=1999 DataKonsultAB</A>. MySQL, available for download at <A HREF=/old?u=http%3A%2F%2Fwww.devshed.com%2FServer_Side%2FMySQL%2FIntro%2Fcomments.html%2Fc3205%2F%26quot%3Bhttp%3A%2Fwww.mysql.com%26quot%3B%26gt%3Bhttp%3A%2Fwww.mysql.com%26lt%3B%2FA%26gt%3B%2C&y=1999 offers the data base programmer with an array of options and capabilities rarely seen in other database servers. What's more, MySQL is free of charge for those wishing to use it for private and commercial use.

HOME > SERVER SIDE > MYSQL > ARTICLE > COMMENTS    PHP SOURCE

Power Search
Free Newsletter:


Client Side
DHTML
Flash
Graphics
JavaScript
XML

Server Side
Administration
JServ
MySQL
Perl
PHP
Python
Roxen
Zend
Zope

Tools
HTML Editors
Graphic Editors
FTP Programs

Dev Talk
Forums
Mailing List
Book Samples
Brain Dump
Developer News
Feedback

ClipScripts
Add script
Edit script

Other Stuff
DevShed RDF
Propaganda!


Advertise
on DevShed
.
Beginning MySQL Tutorial
One of the fastest SQL (Structured Query Language) database servers currently on the market is the MySQL server, developed by T.c.X. DataKonsultAB. MySQL, available for download at http://www.mysql.com, offers the data base programmer with an array of options and capabilities rarely seen in other database servers. What's more, MySQL is free of charge for those wishing to use it for private and commercial use.

Name: Jonnay
Subject: Re: Roll back
Date: 02-19-2000 10:18PM

its true. MySQL Doesn't provide roll backs. However, backing up mysql is dirt easy. All the databases, and tables are right on the filesystem. I've done plenty of backups and restores just by copying files off the filesystem. There's also a dump utility if you don't have root (and therefore can't go muckin around in the db on a filesystem level). Also, I've been toying with the idea of a kludge that would provide some kind of transactions. The MYSQL logs are very thick n chunky with info, including querys.. and you can also tell it to log update querys. Its a (relatively) painless operation to grep out yer querys, double check to see that its "all good". Your already half way there to making fudged-transactions go. (but it is still a kludge).


Other posts in this thread:
 Top
 • Roll back  Morgan  12-27-1999 10:10PM 
       • Re: Roll back  Aligeris  01-10-2000 09:28PM 
             • Re: Roll back  Morgan  01-10-2000 10:09PM 
                   • Re: Roll back  Aligeris  01-10-2000 11:11PM 
       • Re: Roll back  Jonnay  02-19-2000 10:18PM 
             • Re: Roll back  Rajiv Khaneja  07-15-2000 04:53PM 


Reply to this post:
Name:

Preview Comment.
Notify me of replies to this message.
Email:
Subject:
Tip: Put any source code between [code][/code] tags to increase readability


Visit the MySQL Forum!

New On DevShed:
• MySQL Developer Contests PostgreSQL Benchmarks
• PHP 101 (part 3) - Chocolate Fudge And Time Machines
• MaxSQL Announced
•  PHP 101 (Part 2) - Shakespeare's Rose
• PHP 101 (Part 1) - Secret Agent Man
• The Search For The Perfect Web Host
• Perl 101 (Part 5) - Sub-Zero Code
•  Submit Your News..

Hot Forum Topics:
• Credit Cards
• Backing-up in Netscape
• Want help from advanced PHP users
• making mysql timestamp look friendly
• display performance
• display performance


Adsmart Network ad
Copyright © 1997-2000 ngenuity. All rights reserved. Privacy Policy.