LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 07-12-2005, 10:20 AM   #1
KimVette
Senior Member
 
Registered: Dec 2004
Location: Lee, NH
Distribution: OpenSUSE, CentOS, RHEL
Posts: 1,794

Rep: Reputation: 46
How to Umount single MySQL database


In SQL Server on Window$ one can unmount a single MySQL database (this is NOT the same as dropping a database) or bring it offline. This is valuable for testing and staging environments, and even production environments.

How can the same be done in MySQL? Can an individual database be unmounted or be brought offline, without having to actually DROP the database and re-create it?
 
Old 07-13-2005, 03:45 AM   #2
ricstirato
Member
 
Registered: Jan 2004
Location: Gießen, Germany
Distribution: Xubuntu 12.04, Mythbuntu, Ubuntu Server 12.04
Posts: 174

Rep: Reputation: 24
AFAIK there is no such possibility in MySQL (at least 4.x).

You might try to revoke all permissions on that database and later grant them again.


regards
ric.
 
Old 07-13-2005, 12:55 PM   #3
KimVette
Senior Member
 
Registered: Dec 2004
Location: Lee, NH
Distribution: OpenSUSE, CentOS, RHEL
Posts: 1,794

Original Poster
Rep: Reputation: 46
Quote:
Originally posted by ricstirato

You might try to revoke all permissions on that database and later grant them again.
Thanks, Ric. That's one of the things I am trying to avoid. I'm surprised MySQL made it to version 4.x and in all that time they never saw the need or usefulness of being able to lock a database.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to read a single sequential record from MySQL? VorlonInfoTech Linux - Software 1 11-17-2004 10:08 PM
Writing an app that uses a mysql database without installing mysql server? QtCoder Programming 4 08-09-2004 02:43 PM
MySQL - command - create user/single database dmedici Linux - Software 3 06-21-2004 03:17 PM
MYSQL help - mysql database missing eloviyandhi Linux - Software 1 03-20-2004 09:20 PM
mysql database huno Linux - General 8 02-11-2003 08:15 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 12:29 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration