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:
Reply to this post:
|
 |
Visit the MySQL Forum!
New On DevShed:
Hot Forum Topics:
|